@inproceedings{f6a46726f7ef4f4f82a8c5207d64814d,
title = "Building Blocks Towards More Effective SQL Error Messages",
abstract = "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 relational database management systems have seen limited development since their inception. This lack of progress may stem from the fact that it is not well-understood what constitutes an effective error message. With data from 568 participants across three student cohorts, we investigate whether novel SQL error message design guidelines can explain success in fixing SQL syntax errors. The results indicate that some of the guidelines indeed serve as building blocks toward more effective SQL error messages for novices. However, error messages that adhered to certain guidelines showed inconclusive or negative results. These findings can be applied to iterate on SQL error messages in SQL learning environments or SQL compilers.",
keywords = "compiler, computing education, database, database management system, error, error message, error message design, human-computer interaction, novice, relational database, SQL",
author = "Toni Taipalus and Hilkka Grahn",
note = "Publisher Copyright: {\textcopyright} 2024 Owner/Author.; Innovation and Technology in Computer Science Education ; Conference date: 08-07-2024 Through 10-07-2024",
year = "2024",
month = jul,
day = "3",
doi = "10.1145/3649217.3653552",
language = "English",
series = "Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE",
publisher = "ACM",
pages = "241--247",
booktitle = "ITiCSE 2024 - Proceedings of the 2024 Conference Innovation and Technology in Computer Science Education",
address = "United States",
}