用知识图谱把学生SQL错误和概念漏洞对应起来,让反馈更精准。
From SQL Errors to Concept Gaps: An AI-Powered Knowledge Graph Analytics Platform for Personalized Feedback

- 构建课程概念图谱,将代码错误映射到具体知识点
- 95.7%的概念节点被专家评为有效,63.8%的关联三元组完全正确
- 适合教育技术研究者和数据库课程教学改进者
本文提出一个基于AI的知识图谱平台,将学生在数据库课程中编写SQL时出现的错误与背后的认知空白联系起来。学习结构化查询语言(SQL)的学生常因概念性误解产生语义错误,而非语法错误;例如将NATURAL JOIN误用于本应使用显式子查询的场景,反映出对JOIN、GROUP BY和HAVING等概念理解的混淆。现有自动评分系统只能判断结果正确与否,无法揭示错误背后的概念根源。尽管教育知识图谱研究已证明其在课程分析与个性化学习中的价值,但尚未应用于诊断SQL学习中的误解。本平台通过从教学材料中自动提取课程概念及关系,借助图数据库将这些概念与学生提交记录关联,并在概念层面进行错误分类。我们在两所大学的两门数据库课程上评估该平台,分别使用真实学生提交和模拟数据,结合五名专家的评估以及大模型作为裁判的自动化测试。结果显示,95.7%的节点被评为至少部分有效,63.8%的三元组被判定为完全正确。专家反馈表明生成的图谱与教师认知模型一致,将错误映射至课程概念能提供可操作的诊断信息;对学生学习效果的影响尚待后续研究。
原文摘要 · Abstract (English)
This innovative practice full paper describes an AI-powered knowledge graph platform that connects SQL errors to conceptual gaps in undergraduate and graduate database systems courses. Students learning Structured Query Language (SQL) frequently struggle with semantic errors that reflect conceptual misunderstandings rather than syntax mistakes. A query may execute yet return incorrect results due to gaps spanning related concepts; misusing NATURAL JOIN in place of an explicit subquery reflects intertwined misunderstandings of JOIN, GROUP BY, and HAVING. Autograding systems detect correctness but provide surface-level feedback without connecting errors to the conceptual structure of the course. Educational knowledge graph research has shown the value of structured concept representations for curriculum analysis and adaptive learning, but these approaches have not been applied to diagnosing SQL misconceptions from student submissions. We present a platform that automatically extracts course concepts and relations from instructional materials, links them to student submission traces through a graph database, and classifies errors at the concept level. We evaluate the platform across two database systems courses at two universities, one using real student submissions and one using simulated submissions, through an expert study with five participants and an automated evaluation using an LLM as a judge. Results show that 95.7% of extracted nodes were rated as at least somewhat valid and 63.8% of triplets were rated fully correct. Expert feedback confirmed that the generated graphs align with instructor mental models and that mapping errors to course concepts provides actionable diagnostic insight; evaluating impact on student learning remains future work.
Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。