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
Julkaistu sarjassa
ACM Transactions on Computing EducationPäivämäärä
2018Tekijänoikeudet
© 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.
Julkaisija
Association for Computing MachineryISSN Hae Julkaisufoorumista
1946-6226Asiasanat
Julkaisu tutkimustietojärjestelmässä
https://converis.jyu.fi/converis/portal/detail/Publication/28213373
Metadata
Näytä kaikki kuvailutiedotKokoelmat
Lisenssi
Samankaltainen aineisto
Näytetään aineistoja, joilla on samankaltainen nimeke tai asiasanat.
-
Explaining Causes Behind SQL Query Formulation Errors
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. ... -
Using human-values as a guide for understanding worthy design directions in augmented reality
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 ... -
Framework for SQL Error Message Design : A Data-Driven Approach
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 ... -
Fashion Technology : What Are the Limits of Emerging Technological Design Thinking?
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 ...
Ellei toisin mainittu, julkisesti saatavilla olevia JYX-metatietoja (poislukien tiivistelmät) saa vapaasti uudelleenkäyttää CC0-lisenssillä.