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 ...
Reflections on the human role in AI policy formulations : how do national AI strategies view people? Salo-Pöntinen, Henrikki; Saariluoma, Pertti (Springer Science and Business Media LLC, 2022)Purpose There is no artificial intelligence (AI) without people. People design and develop AI; they modify and use it and they have to reorganize the ways they have carried out tasks in their work and everyday life. ...
Rousi, Rebekah (Association for Computing Machinery (ACM), 2016)Augmented reality is a fast developing field, which will no doubt gain strong footing in the area of social media in the near future. Recently, Google Glass placed AR towards the top of the technological hype curve in ...
Saariluoma, Pertti; Alanen, Hanna-Kaisa; Rousi, Rebekah (Springer, 2021)Designing intelligent technologies is a multidisciplinary process. From this perspective, fashion has continued to be an under explored dimension of technology design. While there persistently are connections between the ...
Taipalus, Toni; Grahn, Hilkka (Association for Computing Machinery (ACM), 2023)Software developers use a significant amount of time reading and interpreting error messages. However, error messages have often been based on either anecdotal evidence or expert opinion, disregarding novices, who arguably ...