.png){kind=icon}
返回
The effects of database complexity on SQL query formulation
.png){kind=icon}
OA
AI
DOI：10.1016/j.jss.2020.110576.png)
.png){kind=icon}
.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
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 more interesting and useful, as these databases more accurately mimic databases students are likely to encounter in their future work environments. However, using even the most engaging database can be counterproductive to learning, if a student is not able to formulate correct queries due to the complexity of the database schema. Scientific evidence on the effects of database complexity on student's query formulation is limited, and with queries from 744 students against three databases of varying logical complexity, we set out to study how database complexity affects the success rates in query formulation. The success rates against a simple database were significantly higher than against a semi-complex and a complex database, which indicates that it is easier for students to write SQL queries against simpler databases. This suggests, at least in the scale of our exercise databases, that educators should also consider the negative effects of more realistic databases, even though they have been shown to increase student engagement. (C) 2020 Elsevier Inc. All rights reserved.
Keyword:
Structured query language (SQL)
Database
Database complexity
Education
Student learning
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
4.1
论文数:
5.5K
被引数:
8.4K
机构
引用论文
分享收藏分享收藏Relative contribution of porcine reproductive and respiratory syndrome virus open reading frames 2–4 to the induction of protective immunity.png)
VaccineOAAI
VaccineIF0
OAAI分享收藏分享收藏
查看更多内容