A query simulation system to illustrate database query execution

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 enable...

Full description

Bibliographic Details
Published in:ACM SIGCSE Bulletin
Main Authors: Allenstein, Brett, Yost, Andrew, Wagner, Paul, Morrison, Joline
Format: Article in Journal/Newspaper
Language:English
Published: Association for Computing Machinery (ACM) 2008
Subjects:
DML
Online Access:http://dx.doi.org/10.1145/1352322.1352301
https://dl.acm.org/doi/pdf/10.1145/1352322.1352301
Description
Summary: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.