Errors and Complications in SQL Query Formulation
Taipalus, T., Siponen, M., & Vartiainen, T. (2018). Errors and Complications in SQL Query Formulation. ACM Transactions on Computing Education, 18(3), Article 15. https://doi.org/10.1145/3231712
Published inACM Transactions on Computing Education
© 2018 ACM
SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature, present a class of logical errors which has not been studied in detail and review and complement these findings by analyzing over 33,000 SQL queries submitted by students. Our analysis verifies error findings presented in previous literature and reveals new types of errors, namely logical errors recurring in similar manners among different students. We present a listing of fundamental SQL query concepts we have identified and based our exercises on, a categorization of different errors and complications and an operational model for designing SQL exercises.
PublisherAssociation for Computing Machinery
Publication in research information system
MetadataShow full item record
Showing items with similar title or keywords.
Taipalus, Toni (IEEE, 2020)This Full Research Paper presents the most prominent query formulation errors in Structured Query Language (SQL), and maps these errors to their cognitive explanations. Understanding query formulation errors is a key to ...
Nevala, Kalevi (University of Jyväskylä, 2005)Tuoko kognitiotiede uuden näkökulman insinöörien suunnittelun ja ajattelun tutkimiseen? Insinöörien ajatteluprosessien parempi ymmärtäminen on DI Kalevi Nevalan tutkimuksen teema. Sen kautta hän etsi uutta tapaa todellisten ...
Taipalus, Toni (Elsevier, 2020)In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises ...
Taipalus, Toni; Perälä, Piia (Association for Computing Machinery, 2019)In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured ...
Error messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence Taipalus, Toni; Grahn, Hilkka; Ghanbari, Hadi (Elsevier BV, 2021)The database and the database management system (DBMS) are two of the main components of any information system. Structured Query Language (SQL) is the most popular query language for retrieving data from the database, as ...