Geração de banco de dados a partir de consultas SQL

Abstract

The continuous evolution of computational systems has underscored the critical need for efficient data management, where databases have become essential. The SQL language is pivotal in Computer Science education, yet students face challenges in formulating queries, making it difficult for teachers to assess. To address this challenge, a research project was initiated to verify if students’ queries align with teachers’ benchmarks, ensuring they yield the same results. This will be facilitated through a graphical tool aiding both educators in grading and students in pre-submission review. The project comprises two independent modules: data generation and query comparison. This work focuses on automatically generating databases filled with synthetic data to aid in query practice and grading, leaving query comparison for a subsequent phase. It emphasizes the importance of judicious synthetic data generation to allow for identifying differences during grading, considering conditions imposed by queries such as applied filters.