The Effects of Database Complexity on SQL Query Formulation
Taipalus, T. (2020). The Effects of Database Complexity on SQL Query Formulation. Journal of Systems and Software, 165, Article 110576. https://doi.org/10.1016/j.jss.2020.110576
Published inJournal of Systems and Software
Embargoed until: 2022-08-01Request copy from author
© 2020 Elsevier
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. ...
Publication in research information system
MetadataShow full item record
Additional information about fundingThis research did not receive any specific grant from funding agencies in the public, commercial, or not-for-profit sectors.
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 ...
Error messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence Taipalus, Toni; Grahn, Hilkka; Ghanbari, Hadi (Elsevier BV, 2021)The database and the database management system (DBMS) are two of the main components of any information system. Structured Query Language (SQL) is the most popular query language for retrieving data from the database, as ...
A modified niche model for generating food webs with stage-structured consumers : The stabilizing effects of life-history stages on complex food webs Nonaka, Etsuko; Kuparinen, Anna (John Wiley & Sons, 2021)1. Almost all organisms grow in size during their lifetime and switch diets, trophic positions, and interacting partners as they grow. Such ontogenetic development introduces life-history stages and flows of biomass between ...
The Effectiveness of Internet-based Multimedia Assisted Language Learning (IB-MALL) in Improving Students’ English Proficiency under Sino-foreigner Cooperative Education Context From Students’ Perspectives Liu, Qirui (2019)This empirical study is intended to explore the effectiveness of Internet-based Multimedia Assisted Language Learning (IB-MALL) under the Sino-foreign cooperative education context from students’ perspectives in China. ...
Wang, Ruijie; Wang, Meng; Liu, Jun; Cochez, Michael; Decker, Stefan (Springer, 2020)In order to facilitate the accesses of general users to knowledge graphs, an increasing effort is being exerted to construct graph-structured queries of given natural language questions. At the core of the construction is ...