Show simple item record

dc.contributor.authorTaipalus, Toni
dc.date.accessioned2020-12-08T08:00:02Z
dc.date.available2020-12-08T08:00:02Z
dc.date.issued2020
dc.identifier.citationTaipalus, T. (2020). Explaining Causes Behind SQL Query Formulation Errors. In <i>FIE 2020 : Proceedings of the 50th IEEE Frontiers in Education Conference</i>. IEEE. Conference proceedings : Frontiers in Education Conference. <a href="https://doi.org/10.1109/FIE44824.2020.9274114" target="_blank">https://doi.org/10.1109/FIE44824.2020.9274114</a>
dc.identifier.otherCONVID_47287879
dc.identifier.urihttps://jyx.jyu.fi/handle/123456789/73017
dc.description.abstractThis 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 teaching SQL. more effectively. However, studies on what kind of errors novices struggle with are relatively scarce when compared to, for example, programming languages. Although committing errors is a crucial part in learning, some errors are relatively easy to fix, and their commonness is not necessarily an indication of their difficulty. Other errors, however, halt the learning process, and are never fixed by the query writer. Using a previously established error taxonomy and queries from four cohorts with a total of 987 students, we set out to identify common errors which students are unable to correct, i.e., errors that are likely to cause query formulation failures. Our results indicate that on a general level, logical errors are the most common cause for query formulation failures, while syntax and semantic errors are usually fixed by query writers. Although query concepts, for example, expressions, joins and grouping, have a strong influence on what types of errors are committed, some errors are common regardless of query concepts. Specifically, our results indicate that missing expressions, extraneous or omitted grouping columns, incorrect comparison operators, missing joins, and missing ordering columns are the most common errors that novices are unable to fix. Based on the results, we speculate on the reasons behind the most common persistent errors using previously identified cognitive explanations. Finally, we present that solutions for mitigating the causes behind query formulation errors are already available. In order to more effectively teach query formulation, educators should emphasize natural language patterns, query planning, and increasingly ambiguous exercises.en
dc.format.mimetypeapplication/pdf
dc.languageeng
dc.language.isoeng
dc.publisherIEEE
dc.relation.ispartofFIE 2020 : Proceedings of the 50th IEEE Frontiers in Education Conference
dc.relation.ispartofseriesConference proceedings : Frontiers in Education Conference
dc.rightsIn Copyright
dc.subject.otherStructured Query Language (SQL)
dc.subject.otherdatabase
dc.subject.othererror
dc.subject.othereducation
dc.subject.othernovice
dc.titleExplaining Causes Behind SQL Query Formulation Errors
dc.typeconferenceObject
dc.identifier.urnURN:NBN:fi:jyu-202012086963
dc.contributor.laitosInformaatioteknologian tiedekuntafi
dc.contributor.laitosFaculty of Information Technologyen
dc.contributor.oppiaineTietojärjestelmätiedefi
dc.contributor.oppiaineInformation Systems Scienceen
dc.type.urihttp://purl.org/eprint/type/ConferencePaper
dc.relation.isbn978-1-7281-8962-8
dc.description.reviewstatuspeerReviewed
dc.relation.issn1539-4565
dc.type.versionacceptedVersion
dc.rights.copyright© 2020 IEEE
dc.rights.accesslevelopenAccessfi
dc.relation.conferenceFrontiers in Education Conference
dc.subject.ysooppiminen
dc.subject.ysovirheet
dc.subject.ysokyselykielet
dc.subject.ysoohjelmointikielet
dc.subject.ysokoulutus
dc.subject.ysoSQL
dc.format.contentfulltext
jyx.subject.urihttp://www.yso.fi/onto/yso/p2945
jyx.subject.urihttp://www.yso.fi/onto/yso/p148
jyx.subject.urihttp://www.yso.fi/onto/yso/p163
jyx.subject.urihttp://www.yso.fi/onto/yso/p162
jyx.subject.urihttp://www.yso.fi/onto/yso/p84
jyx.subject.urihttp://www.yso.fi/onto/yso/p2669
dc.rights.urlhttp://rightsstatements.org/page/InC/1.0/?language=en
dc.relation.doi10.1109/FIE44824.2020.9274114


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record

In Copyright
Except where otherwise noted, this item's license is described as In Copyright