NewSQL Database Management System Compiler Errors : Effectiveness and Usefulness
Taipalus, T., & Grahn, H. (2022). NewSQL Database Management System Compiler Errors : Effectiveness and Usefulness. International Journal of Human-Computer Interaction, Early online. https://doi.org/10.1080/10447318.2022.2108648
Published in
International Journal of Human-Computer InteractionDate
2022Discipline
Computing Education ResearchKognitiotiedeTutkintokoulutusComputing Education ResearchCognitive ScienceDegree EducationCopyright
© 2022 The Author(s). Published with license by Taylor & Francis Group, LLC
Modern database management is often faced with a high number of concurrent end-users, and the need for database distribution to ensure fault tolerance and high throughput. To flexibly address these challenges, many modern database management systems (DBMS) provide highly automated and effortless, i.e., highly usable database distribution, deployment, and maintenance. However, the usability considerations are yet to extend from the aforementioned DBMS features to query language compilers. In this study, based on participant answers (N = 157), we compare the error message qualities of four modern DBMSs (CockroachDB, SingleStore, NuoDB, and VoltDB) using one objective and three subjective metrics. Our results show that some of the DBMSs provide the users with more useful error messages, even though many of these error messages violate even the most basic usability guidelines. These results (i) are applicable in further developing the usability aspects of query language compilers, (ii) provide a timely effort of bridging the gap between human-computer interaction and query language compilers, and (iii) offer suggestions on teaching novices, who require emphasized support in query formulation.
...
Publisher
Taylor & FrancisISSN Search the Publication Forum
1044-7318Keywords
Publication in research information system
https://converis.jyu.fi/converis/portal/detail/Publication/151683485
Metadata
Show full item recordCollections
Additional information about funding
This research did not receive any specific grant from funding agencies in the public, commercial, or not-for-profit sectors.License
Related items
Showing items with similar title or keywords.
-
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 ... -
Building Blocks Towards More Effective SQL Error Messages
Taipalus, Toni; Grahn, Hilkka (ACM, 2024)Reading and interpreting error messages are significant aspects of a software developer's work. Despite the importance and prevalence of error messages, especially for novices, SQL compiler error messages from various ... -
Engaging Databases for Data Systems Education
Taipalus, Toni; Miedema, Daphne; Aivaloglou, Efthimia (ACM, 2023) -
The Effects of Database Complexity on SQL Query Formulation
Taipalus, Toni (Elsevier, 2020)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 ... -
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 ...