Student's Learning Challenges with Relational, Document, and Graph Query Languages
Student's Learning Challenges with Relational, Document, and Graph Query Languages
复制标题
学生在关系、文档和图形查询语言方面的学习挑战
DOI：
10.1145/3596673.3596976
复制
发表时间：
2023
期刊：
影响因子：
--
通讯作者：
Alawini, Abdussalam
中科院分区：
文献类型：
--
作者：
Alkhabaz, Ridha;Li, Zepei;Yang, Sophia;Alawini, Abdussalam
随着对数据库管理技能的需求不断增长，对数据库模型及其相应查询语言的教育需求也越来越大。然而，解决新手学习者在数据库系统中使用查询语言时遇到的困难的研究仍然有限。在这项研究中，我们检查了462名学生在2022年秋季学期提交的超过357215个家庭作业问题，涵盖了SQL，MongoDB和Neo4j查询语言的概念。我们通过按概念分解最常见的语法错误进行的分析证实了以前的研究，并证明了某些数据操作对不同数据库系统的学生构成了挑战。具体来说，我们发现聚合操作和Join操作对学生来说特别困难，这与之前的SQL教育研究一致。因此，我们建议教师考虑将视觉和作业，使学生能够建立不同的数据库模型的心理模型。
As the need for database management skills continues to grow, there is an increasing demand for education on database models and their corresponding query languages. However, the body of research addressing the difficulties encountered by novice learners when working with query languages in database systems is still limited. In this study, we examined over 357215 submissions from 462 students' homework problems during the Fall 2022 semester covering concepts in SQL, MongoDB, and Neo4j query languages. Our analysis through breaking down the most common syntax errors by concept confirms previous research and demonstrates that certain data operations pose challenges to students across different database systems. Specifically, we found that aggregation operations and Join operations were particularly difficult for students, which aligns with prior SQL education research. Therefore, we suggest that instructors consider incorporating visuals and assignments that enable students to build mental models for different database models.