.png){kind=icon}
返回
Framework for SQL Error Message Design: A Data-Driven Approach
.png){kind=icon}
OA
AI
DOI：10.1145/3607180.png)
.png){kind=icon}
原文求助.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
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 are the ones who benefit the most from effective error messages. Furthermore, the usability aspects of Structured Query Language (SQL) error messages have not received much scientific attention. In this mixed-methods study, we coded a total of 128 error messages from eight database management systems (DBMS), and using data from 311 participants, analysed 4,796 queries using regression analysis to find out if and how acknowledged error message qualities explain SQL syntax error fixing success rates. Additionally, we performed a conventional content analysis on 1,505 suggestions on how to improve SQL error messages, and based on the analysis, formulated a framework consisting of nine guidelines for SQL error message design. The results indicate that general error message qualities do not necessarily explain query fixing success in the context of SQL syntax errors and that even some novel NewSQL systems fail to account for basic error message design guidelines. The error message design framework and examples of its practical applications shown in this study are applicable in educational contexts as well as by DBMS vendors in understanding novice perspectives in error message design.
Keyword:
Structured Query Language
SQL
compiler
error message
database management system
human-computer interaction
human factor
usability
readability
期刊
A
IF:
6.2
论文数:
1.2K
被引数:
3.4K
机构
引用论文
.png){kind=icon}
Changing Invisible Landscapes – Financial Reform of Health and Care Systems: Ten Issues to ConsiderOAAI
OAAI分享收藏Effect of lasalocid or salinomycin administration on performance and immunity following coccidia vaccination of commercial broilers施用lasalocid或盐霉素对商业肉鸡接种球虫后性能和免疫力的影响
OAAI
OAAI分享收藏分享收藏
查看更多内容