research-article

A query simulation system to illustrate database query execution

Authors:

Brett Allenstein,

Joline MorrisonAuthors Info & Claims

ACM SIGCSE Bulletin, Volume 40, Issue 1

Pages 493 - 497

https://doi.org/10.1145/1352322.1352301

Published: 12 March 2008 Publication History

Abstract

The underlying processes that enable database query execution are fundamental to understanding database management systems. However, these processes are complex and can be difficult to explain and illustrate. To address this problem, we have developed a Java-based query simulation system that enables students to visualize the steps involved in processing DML queries. We performed a field experiment to evaluate the system, and the results suggest that the system improves student comprehension of the query execution process.

References

[1]

Abbey, M., Corey, M., and Abramson, I.; Oracle 8i: A Beginner's Guide, Oracle Press, 1999.

Digital Library

[2]

Dietrich, S., Urban, S., Kyriakides, I.; JDBC Demonstration Courseware Using Servlets and Java Server Pages. Proceedings of the 33rd SIGCSE Technical Symposium on Computer Science Education, 34, 1 (Feb. 2002), 266--270.

Digital Library

[3]

Fleming, N.D. & Mills, C. Not Another Inventory, Rather a Catalyst for Reflection. To Improve the Academy, 11, (1992) 137--155.

[4]

Guimaraes, M., The Kennesaw Database Courseware, Journal of Computing Sciences in Colleges, 21, 3 (Feb. 2006).

Digital Library

[5]

Hansen, S. R., Narayanan, N. H., and Hegarty, M., Designing Educationally Effective Algorithm Visualizations: Embedding Analogies and Animations in Hypermedia. Journal of Visual Languages and Computing, 13(2):291--317, Academic Press, 2002.

[6]

Kolb. D. A. and Fry, R., Toward an Applied Theory of Experiential Learning, in C. Cooper (Ed.), Theories of Group Process, London: John Wiley (1975).

[7]

Loney, K., and Koch, G., Oracle 9i: The Complete Reference, Oracle Press, 2002.

Digital Library

[8]

Mayer, R. E., & Gallini, J. K., When is an Illustration Worth Ten Thousand Words? J. of Ed. Psych. 82(4), 715--726 (1990).

[9]

Naps, T. L., Rößling, G., Almstrum, V., Dann, W., Fleischer, R., Hundhausen, C., Korhonen, A., Malmi, L., McNally, M., Rodger, S., and Velazquez-Iturbide, J. Á.; Exploring the Role of Visualization and Engagement in Computer Science Education. SIGCSE Bulletin 35, 2 (June 2003), 131--152.

Digital Library

[10]

Ollerenshaw, A., Aidman, E., and Kidd, G. (1997), Is an Illustration Always Worth Ten Thousand Words? Effects of Prior Knowledge, Learning Style, and Multimedia Illustrations on Text Comprehension. Int. J. of Instructional Media 24, 3, p. 227--238.

[11]

Oracle DBMS; http://www.oracle.com.

[12]

Sadik, S., Orlowska, M., Sadiq, W., Lin J.; SQLator: an On-line SQL Learning Workbench, Proceedings of the 9th Conference on Innovation and Technology in Computer Science Education, 36, 3 (June. 2004), 223--227.

Digital Library

[13]

Sciore, E.; SimpleDB: A Simple Java-Based Multi-User System for Teaching Database Internals, Proceedings of the 28th SIGCSE Technical Symposium on Computer Science Education, 39, 1 (Mar. 2007), 561--565.

Digital Library

[14]

Schroeder, C., New Students - New Learning Styles, http://www.virtualschool.edu/mon/Academia/KierseyLearningStyles.html.

[15]

Taylor, H.A., Renshaw, C.E., and Choi, E.J.; The Effect of Multiple Formats on Understanding Complex Visual Displays., J. of Geosci. Ed., 52, 2 (March 2004), 115--121.

Cited By

Taipalus T(2023)Query Execution Plans and Semantic Errors: Usability and Educational OpportunitiesExtended Abstracts of the 2023 CHI Conference on Human Factors in Computing Systems10.1145/3544549.3585794(1-6)Online publication date: 19-Apr-2023
https://dl.acm.org/doi/10.1145/3544549.3585794
Obaido GAde-Ibijola AVadapalli H(2018)Generating SQL Queries from Visual SpecificationsICT Education10.1007/978-3-030-05813-5_21(315-330)Online publication date: 31-Dec-2018
https://doi.org/10.1007/978-3-030-05813-5_21
Cembalo MDe Santis AFerraro Petrillo UGoda BSobiesk EConnolly R(2011)SAVIProceedings of the 2011 conference on Information technology education10.1145/2047594.2047641(165-170)Online publication date: 20-Oct-2011
https://dl.acm.org/doi/10.1145/2047594.2047641
Show More Cited By

Index Terms

A query simulation system to illustrate database query execution
1. Applied computing
  1. Education
    1. Computer-assisted instruction
2. Information systems
  1. Data management systems
    1. Database administration
      1. Data dictionaries

Recommendations

A query simulation system to illustrate database query execution
SIGCSE '08: Proceedings of the 39th SIGCSE technical symposium on Computer science education

The underlying processes that enable database query execution are fundamental to understanding database management systems. However, these processes are complex and can be difficult to explain and illustrate. To address this problem, we have developed a ...
View-based query containment
PODS '03: Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

Query containment is the problem of checking whether for all databases the answer to a query is a subset of the answer to a second query. In several data management tasks, such as data integration, mobile computing, etc., the data of interest are only ...
Query Folding
ICDE '96: Proceedings of the Twelfth International Conference on Data Engineering

Query folding refers to the activity of determining if and how a query can be answered using a given set of resources, which might be materialized views, cached results of previous queries, or queries answerable by other databases. We investigate query ...

Comments

Information & Contributors

Information

Published In

cover image ACM SIGCSE Bulletin

ACM SIGCSE Bulletin Volume 40, Issue 1

SIGCSE 08

March 2008

549 pages

ISSN:0097-8418

DOI:10.1145/1352322

Issue’s Table of Contents

SIGCSE '08: Proceedings of the 39th SIGCSE technical symposium on Computer science education
March 2008
606 pages
ISBN:9781595937995
DOI:10.1145/1352135
General Chairs:
J. D. Dougherty
Haverford College
,
Susan Rodger
Duke University
,
Program Chairs:
Sue Fitzgerald
Metropolitan State University
,
Mark Guzdial
Georgia Institute of Technology

Copyright © 2008 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 12 March 2008

Published in SIGCSE Volume 40, Issue 1

Check for updates

Author Tags

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
452
Total Downloads

Downloads (Last 12 months)7
Downloads (Last 6 weeks)0

Reflects downloads up to 25 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Taipalus T(2023)Query Execution Plans and Semantic Errors: Usability and Educational OpportunitiesExtended Abstracts of the 2023 CHI Conference on Human Factors in Computing Systems10.1145/3544549.3585794(1-6)Online publication date: 19-Apr-2023
https://dl.acm.org/doi/10.1145/3544549.3585794
Obaido GAde-Ibijola AVadapalli H(2018)Generating SQL Queries from Visual SpecificationsICT Education10.1007/978-3-030-05813-5_21(315-330)Online publication date: 31-Dec-2018
https://doi.org/10.1007/978-3-030-05813-5_21
Cembalo MDe Santis AFerraro Petrillo UGoda BSobiesk EConnolly R(2011)SAVIProceedings of the 2011 conference on Information technology education10.1145/2047594.2047641(165-170)Online publication date: 20-Oct-2011
https://dl.acm.org/doi/10.1145/2047594.2047641
Taipalus TSeppänen V(2020)SQL EducationACM Transactions on Computing Education10.1145/339837720:3(1-33)Online publication date: 7-Aug-2020
https://dl.acm.org/doi/10.1145/3398377
Kang JYu QHolden ELiu XGoda BZilora SGrispos GBogaard D(2019)Complementing Course Contents Between IT/CSProceedings of the 20th Annual SIG Conference on Information Technology Education10.1145/3349266.3351414(10-15)Online publication date: 26-Sep-2019
https://dl.acm.org/doi/10.1145/3349266.3351414
Fee SLombardi T(2017)Adapting Problem-Based Learning to Database Courses in the Digital AgeDeconstructing the Education-Industrial Complex in the Digital Age10.4018/978-1-5225-2101-3.ch007(116-133)Online publication date: 2017
https://doi.org/10.4018/978-1-5225-2101-3.ch007
Rodriguez-Cerezo DGómez-Albarrán MSierra-Rodríguez JCarter JUtting IClear A(2013)Interactive educational simulations for promoting the comprehension of basic compiler construction conceptsProceedings of the 18th ACM conference on Innovation and technology in computer science education10.1145/2462476.2462498(28-33)Online publication date: 1-Jul-2013
https://dl.acm.org/doi/10.1145/2462476.2462498
Cembalo MDe Santis AFerraro Petrillo UGoda BSobiesk EConnolly R(2011)SAVIProceedings of the 2011 conference on Information technology education10.1145/2047594.2047641(165-170)Online publication date: 20-Oct-2011
https://dl.acm.org/doi/10.1145/2047594.2047641
Neil CIrazabal JDe Vincenzi MPons C(2010)Graphical Query Mechanism for Historical Data Warehouse within MDDProceedings of the 2010 XXIX International Conference of the Chilean Computer Science Society10.1109/SCCC.2010.49(183-192)Online publication date: 15-Nov-2010
https://dl.acm.org/doi/10.1109/SCCC.2010.49
Moss K(2010)DataBase teaching toolsIEEE EDUCON 2010 Conference10.1109/EDUCON.2010.5492432(1881-1890)Online publication date: Apr-2010
https://doi.org/10.1109/EDUCON.2010.5492432
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Issue’s Table of Contents