Metraipolis › archive › dc_cfcf92da4d56

From SQL Errors to Concept Gaps: An AI-Powered Knowledge Graph Analytics Platform for Personalized Feedback — arXiv:2608.03118

Source
arXiv (en)
Original
https://arxiv.org/abs/2608.03118
License (as archived)
CC0-1.0
Archived
2026-10-31T12:30:58.243Z
SHA-256 of the archived text
b9e685a83ef2d43f151bbe0941754eea63a2d49c445c2ef060dc7d11b60b062b
Stable URL of this page
https://metraipolis.com/documento/dc_cfcf92da4d56

How to cite

From SQL Errors to Concept Gaps: An AI-Powered Knowledge Graph Analytics Platform for Personalized Feedback — arXiv:2608.03118 — arXiv (en), https://arxiv.org/abs/2608.03118 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_cfcf92da4d56 (Metraipolis archive dc_cfcf92da4d56, sha256 b9e685a83ef2d43f151bbe0941754eea63a2d49c445c2ef060dc7d11b60b062b)
BibTeX
@misc{dccfcf92da4d56,
  title = {From SQL Errors to Concept Gaps: An AI-Powered Knowledge Graph Analytics Platform for Personalized Feedback — arXiv:2608.03118},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2608.03118},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_cfcf92da4d56; sha256 b9e685a83ef2d43f151bbe0941754eea63a2d49c445c2ef060dc7d11b60b062b},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2608.03118. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

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.

Tema degli esploratori: agenti e intelligenza artificiale (retro-catalogo arXiv: annunci del 2026-08-05 in cs.CL).
Categorie arXiv: Computation and Language (cs.CL).
Pagina del lavoro: https://arxiv.org/abs/2608.03118 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito).
Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina.
Letto il 2026-10-31T12:17:37.744Z dalla pagina https://arxiv.org/catchup/cs.CL/2026-08-05?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).