A1 Alkuperäisartikkeli tieteellisessä aikakauslehdessä
The Effects of Database Complexity on SQL Query Formulation (2020)

Taipalus, Toni (2020). The Effects of Database Complexity on SQL Query Formulation. Journal of Systems and Software, 165, 110576. DOI: 10.1016/j.jss.2020.110576

JYU-tekijät tai -toimittajat

Julkaisun tiedot

Julkaisun kaikki tekijät tai toimittajat: Taipalus, Toni

Lehti tai sarja: Journal of Systems and Software

ISSN: 0164-1212

eISSN: 1873-1228

Julkaisuvuosi: 2020

Volyymi: 165

Artikkelinumero: 110576

Kustantaja: Elsevier

Julkaisumaa: Yhdysvallat (USA)

Julkaisun kieli: englanti

DOI: https://doi.org/10.1016/j.jss.2020.110576

Avoin saatavuus: Julkaisukanava ei ole avoin

Julkaisu on rinnakkaistallennettu (JYX): https://jyx.jyu.fi/handle/123456789/68483


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 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.

YSO-asiasanat: kyselykielet; SQL; tietokannat; kompleksisuus; koulutus; oppiminen

Vapaat asiasanat: structured query language (SQL); database; database complexity; education; student learning

Liittyvät organisaatiot

OKM-raportointi: Kyllä

Raportointivuosi: 2020

Alustava JUFO-taso: 3

Viimeisin päivitys 2020-18-08 klo 13:04