.png){kind=icon}
返回
Errors and Complications in SQL Query Formulation
.png){kind=icon}
OA
AI
DOI：10.1145/3231712.png)
.png){kind=icon}
.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature, present a class of logical errors that has not been studied in detail, and review and complement these findings by analyzing over 33,000 SQL queries submitted by students. Our analysis verifies error findings presented in previous literature and reveals new types of errors, namely logical errors recurring in similar manners among different students. We present a listing of fundamental SQL query concepts we have identified and based our exercises on, a categorization of different errors and complications, and an operational model for designing SQL exercises.
Keyword:
Human factors
languages
standardization
errors
exercise design
query languages
SQL
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
A
IF:
6.8
论文数:
542
被引数:
508
机构
引用论文
.png){kind=icon}
Effect of lasalocid or salinomycin administration on performance and immunity following coccidia vaccination of commercial broilers施用lasalocid或盐霉素对商业肉鸡接种球虫后性能和免疫力的影响OAAI
OAAI分享收藏
查看更多内容