A query simulation system to illustrate database query execution

Authors:
Brett Allenstein;Andrew Yost;Paul Wagner;Joline Morrison
Affiliations:
Skyline Technologies, Green Bay, WI, USA;University of WIsconsin-Eau Claire, Eau Claire, WI, USA;University of WIsconsin-Eau Claire, Eau Claire, WI, USA;University of WIsconsin-Eau Claire, Eau Claire, WI, USA
Venue:
Proceedings of the 39th SIGCSE technical symposium on Computer science education
Year:
2008

Citing 7
Cited 6

Oracle8i: A Beginner's Guide

Oracle8i: A Beginner's Guide
JDBC demonstration courseware using Servlets and Java Server Pages

SIGCSE '02 Proceedings of the 33rd SIGCSE technical symposium on Computer science education
Exploring the role of visualization and engagement in computer science education

Working group reports from ITiCSE on Innovation and technology in computer science education
Oracle9i: The Complete Reference

Oracle9i: The Complete Reference
SQLator: an online SQL learning workbench

Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education
The Kennesaw Database Courseware (KDC): strong points, weak points, and experience using it in a classroom environment

Journal of Computing Sciences in Colleges
SimpleDB: a simple java-based multiuser syst for teaching database internals

Proceedings of the 38th SIGCSE technical symposium on Computer science education

Animated database courseware: using animations to extend conceptual understanding of database concepts

Journal of Computing Sciences in Colleges
SimulPh.D.: A Physical Design Simulator Tool

DEXA '09 Proceedings of the 20th International Conference on Database and Expert Systems Applications
Work in progress - lessons-constructor-analyzer paradigm (LCA) and the animated database courseware (ADbC)

FIE'09 Proceedings of the 39th IEEE international conference on Frontiers in education conference
SAVI: a new system for advanced SQL visualization

Proceedings of the 2011 conference on Information technology education
Interactive educational simulations for promoting the comprehension of basic compiler construction concepts

Proceedings of the 18th ACM conference on Innovation and technology in computer science education
Serious games in tertiary education: A case study concerning the comprehension of basic concepts in computer language implementation courses

Computers in Human Behavior

Quantified Score

Hi-index	0.00

Visualization

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.