Show simple item record

dc.contributor.authorTaipalus, Toni
dc.date.accessioned2020-04-07T08:41:20Z
dc.date.available2020-04-07T08:41:20Z
dc.date.issued2020
dc.identifier.citationTaipalus, T. (2020). The Effects of Database Complexity on SQL Query Formulation. <i>Journal of Systems and Software</i>, <i>165</i>, Article 110576. <a href="https://doi.org/10.1016/j.jss.2020.110576" target="_blank">https://doi.org/10.1016/j.jss.2020.110576</a>
dc.identifier.otherCONVID_35103586
dc.identifier.urihttps://jyx.jyu.fi/handle/123456789/68483
dc.description.abstractIn 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 more interesting and useful, as these databases more accurately mimic databases students are likely to encounter in their future work environments. However, using even the most engaging database can be counterproductive to learning, if a student is not able to formulate correct queries due to the complexity of the database schema. Scientific evidence on the effects of database complexity on student’s query formulation is limited, and with queries from 744 students against three databases of varying logical complexity, we set out to study how database complexity affects the success rates in query formulation. The success rates against a simple database were significantly higher than against a semi-complex and a complex database, which indicates that it is easier for students to write SQL queries against simpler databases. This suggests, at least in the scale of our exercise databases, that educators should also consider the negative effects of more realistic databases, even though they have been shown to increase student engagement.en
dc.format.mimetypeapplication/pdf
dc.languageeng
dc.language.isoeng
dc.publisherElsevier
dc.relation.ispartofseriesJournal of Systems and Software
dc.rightsCC BY-NC-ND 4.0
dc.subject.otherstructured query language (SQL)
dc.subject.otherdatabase
dc.subject.otherdatabase complexity
dc.subject.othereducation
dc.subject.otherstudent learning
dc.titleThe Effects of Database Complexity on SQL Query Formulation
dc.typearticle
dc.identifier.urnURN:NBN:fi:jyu-202004072698
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/JournalArticle
dc.description.reviewstatuspeerReviewed
dc.relation.issn0164-1212
dc.relation.volume165
dc.type.versionacceptedVersion
dc.rights.copyright© 2020 Elsevier
dc.rights.accesslevelopenAccessfi
dc.subject.ysokoulutus
dc.subject.ysokompleksisuus
dc.subject.ysoSQL
dc.subject.ysooppiminen
dc.subject.ysotietokannat
dc.subject.ysokyselykielet
dc.format.contentfulltext
jyx.subject.urihttp://www.yso.fi/onto/yso/p84
jyx.subject.urihttp://www.yso.fi/onto/yso/p6340
jyx.subject.urihttp://www.yso.fi/onto/yso/p2669
jyx.subject.urihttp://www.yso.fi/onto/yso/p2945
jyx.subject.urihttp://www.yso.fi/onto/yso/p3056
jyx.subject.urihttp://www.yso.fi/onto/yso/p163
dc.rights.urlhttps://creativecommons.org/licenses/by-nc-nd/4.0/
dc.relation.doi10.1016/j.jss.2020.110576
jyx.fundinginformationThis research did not receive any specific grant from funding agencies in the public, commercial, or not-for-profit sectors.


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record

CC BY-NC-ND 4.0
Except where otherwise noted, this item's license is described as CC BY-NC-ND 4.0