RESEARCH-ARTICLE

Journal of Computing Sciences in Colleges

Learning from database performance benchmarks



    
Authors:

Jennifer Ortiz,

Suzanne W. Dietrich,

Mahesh B. Chaudhari Authors Info & Affiliations

Journal of Computing Sciences in Colleges, Volume 27, Issue 4

• April 2012 • pp 151–158

Published: 01 April 2012

 1  133










18











 Get Access



Abstract
This paper illustrates an approach to incorporate performance benchmarks in a database course to introduce
students to scalable test data and query performance. The realistic TPC-H benchmark enterprise forms the basis of
class exercises and homework assignments that reinforce SQL query reading and writing skills. The integration of
the benchmark supports the fundamental learning objectives of the course and exposes students to additional
concepts used in industry.

References
1. Adams, E. S., Granger, M., Goelman, D., and Ricardo C., Managing the introductory database course: what goes in and
what comes out? SIGCSE Bull, 36, 1(Mar. 2004), 497--498, 2004.
2. Anderson, R., Jafar, M., and Abdullat, A., Teaching scalability issues in large scale database application development,
Information Systems Education Journal, 5, 28 (Sept. 2007), 1--14, 2007.
3. Burleson Consulting, Rewrite SQL Subqueries as Outer Joins, 2004, http://www.dbaoracle.com/oracle_tips_subq_rewrite.htm, retrieved January 3, 2012.

Feedback

Show All References

Index Terms (auto-classified)

Journal of Computing Sciences in Colleges



Learning from database performance benchmarks

Applied computing

Enterprise computing

Information systems

Data management systems

Database management system engines

Database query processing

Query languages

Social and professional topics

Professional topics

Theory and algorithms for application
domains

Computing education

Database theory

Computing education programs

Database query processing and
optimization (theory)

Computer science education

Comments

Feedback

Theory of computation



DL Comment Policy
Comments should be relevant to the contents of this article, (sign in required).

0 Comments
t Tweet

🔒 Disqus' Privacy Policy

Journal of Computing Sciences in Colleges



Sort by Newest

f Share

Nothing in this discussion yet.

⚠ Do Not Sell My Data

View Issue’s Table of Contents

Categories

About

Journals

About ACM Digital Library

Magazines

Subscription Information

Books

Author Guidelines

Proceedings

Using ACM Digital Library

SIGs

All Holdings within the ACM Digital Library

Conferences

ACM Computing Classification System

Collections
People

Join

Connect

Join ACM



Contact

Join SIGs



Facebook

Subscribe to Publications



Twitter

Institutions and Libraries



Linkedin

The ACM Digital Library is published by the Association for Computing Machinery. Copyright © 2021 ACM, Inc.
Terms of Usage

Feedback

Privacy Policy

Code of Ethics