Specialized SQL Dataset Development and Annotation for Personalized LLM-Based Learning
摘要
This paper presents a comprehensive methodology for developing and annotating specialized SQL query datasets designed for fine-tuning large language models (LLMs) for their application in personalized education systems. A five-stage algorithm for creating pedagogically-oriented datasets is proposed, including selection of educationally relevant content, development of a multidimensional annotation scheme with pedagogical metadata integration, expert annotation with inter-expert validation, iterative refinement and data finalization. Special attention is paid to principles for creating annotations that support the tasks of SQL contextual understanding, generating explanations of decision logic, automated code validation, and adaptive feedback. The methodology is validated on a case study of the sql_bi_b_db dataset (3010 records) created based on a tutorial, achieving high inter-expert agreement (κ = 0.87–0.92). The results demonstrate the critical significance of quality annotation for improving the effectiveness of LLMs in educational applications and building intelligent personalized SQL learning systems. #COMESYSO1120