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 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. Categories and Subject Descriptors H.2.7 [Information Systems]: Database Management Systems Query processing; K.3.1 [Computer Uses in Education]: Computer Assisted Instruction. General Terms: None.

• Type: Journal
• Year: 2008
• Where: SIGCSE
• Authors: Brett Allenstein, Andrew Yost, Paul Wagner, Joline Morrison
• Keywords: Database Management Systems, Database Query Execution, Education, Query Execution, SIGCSE 2008