Show simple item record

dc.contributor.authorTaipalus, Toni
dc.contributor.authorGrahn, Hilkka
dc.contributor.authorGhanbari, Hadi
dc.date.accessioned2021-07-15T09:26:19Z
dc.date.available2021-07-15T09:26:19Z
dc.date.issued2021
dc.identifier.citationTaipalus, T., Grahn, H., & Ghanbari, H. (2021). Error messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence. <i>Journal of Systems and Software</i>, <i>181</i>, Article 111034. <a href="https://doi.org/10.1016/j.jss.2021.111034" target="_blank">https://doi.org/10.1016/j.jss.2021.111034</a>
dc.identifier.otherCONVID_98997951
dc.identifier.urihttps://jyx.jyu.fi/handle/123456789/77155
dc.description.abstractThe 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 well as for many other data management tasks. During system development and maintenance, software developers use a considerable amount of time to interpret compiler error messages. The quality of these error messages has been demonstrated to affect software development effectiveness, and correctly formulating queries and fixing them when needed is an important task for many software developers. In this study, we set out to investigate how participants () experienced the qualities of error messages of four popular DBMSs in terms of error message effectiveness, perceived usefulness for finding and fixing errors, and error recovery confidence. Our results show differences between the DBMSs by three of the four metrics, and indicate a discrepancy between objective effectiveness and subjective usefulness. The results suggest that although error messages have perceived differences in terms of usefulness for finding and fixing errors, these differences may not necessarily result in differences in query fixing success rates.en
dc.format.mimetypeapplication/pdf
dc.language.isoeng
dc.publisherElsevier BV
dc.relation.ispartofseriesJournal of Systems and Software
dc.rightsCC BY 4.0
dc.titleError messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence
dc.typearticle
dc.identifier.urnURN:NBN:fi:jyu-202107154330
dc.contributor.laitosInformaatioteknologian tiedekuntafi
dc.contributor.laitosFaculty of Information Technologyen
dc.contributor.oppiaineKognitiotiedefi
dc.contributor.oppiaineCognitive Scienceen
dc.type.urihttp://purl.org/eprint/type/JournalArticle
dc.type.coarhttp://purl.org/coar/resource_type/c_2df8fbb1
dc.description.reviewstatuspeerReviewed
dc.relation.issn0164-1212
dc.relation.volume181
dc.type.versionpublishedVersion
dc.rights.copyright© 2021 The Author(s). Published by Elsevier Inc.
dc.rights.accesslevelopenAccessfi
dc.subject.ysovirheet
dc.subject.ysotietokannat
dc.subject.ysohallintajärjestelmät
dc.subject.ysoSQL
dc.subject.ysokyselykielet
dc.subject.ysovirhetilanteet
dc.subject.ysoohjelmistokehitys
dc.format.contentfulltext
jyx.subject.urihttp://www.yso.fi/onto/yso/p148
jyx.subject.urihttp://www.yso.fi/onto/yso/p3056
jyx.subject.urihttp://www.yso.fi/onto/yso/p16975
jyx.subject.urihttp://www.yso.fi/onto/yso/p2669
jyx.subject.urihttp://www.yso.fi/onto/yso/p163
jyx.subject.urihttp://www.yso.fi/onto/yso/p5692
jyx.subject.urihttp://www.yso.fi/onto/yso/p21530
dc.rights.urlhttps://creativecommons.org/licenses/by/4.0/
dc.relation.doi10.1016/j.jss.2021.111034
dc.type.okmA1


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record

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