Automatic Generation of SQL Queries. Do, Q.; Agrawal, R.; Rao, D.; and Gudivada, V. In The Proceedings of the $121^{st}$ ASEE Annual Conference & Exposition, pages 1 – 11, June, 2014. ASEE.
abstract   bibtex   
Structured Query Language (SQL) is an ANSI and ISO standard declarative query language for querying and manipulating relational databases. It is easy to write SQL queries but very difficult to validate them. Often students conclude that a SQL query is correct simply because the query compiles, executes, and fetches data. Therefore, it is crucial that SQL assessment tasks are carefully designed and implemented to ensure a deep learning experience for students. In this paper, we propose an approach to automatically generate SQL queries for assessing students' SQL learning. SQL concepts are modeled using RDFS. The user can select SQL concepts to be included in an assessment and our approach will generate appropriate queries. The proposed approach is generic and is database metadata driven. A Web-based prototype system is developed to illustrate the effectiveness of the proposed approach.
@inproceedings{Do2014RC,
    Author = {Q. Do and R. Agrawal and D. Rao and V. Gudivada},
    Booktitle = {The Proceedings of the $121^{st}$ ASEE Annual Conference \& Exposition},
    Pages = {1 -- 11},
    Publisher = {ASEE},
    Month = jun,
    Title = {Automatic Generation of SQL Queries},
    Year = {2014},
    abstract = {Structured Query Language (SQL) is an ANSI and ISO standard declarative query language for querying and manipulating relational databases. It is easy to write SQL queries but very difficult to validate them. Often students conclude that a SQL query is correct simply because the query compiles, executes, and fetches data. Therefore, it is crucial that SQL assessment tasks are carefully designed and implemented to ensure a deep learning experience for students. In this paper, we propose an approach to automatically generate SQL queries for assessing students' SQL learning. SQL concepts are modeled using RDFS. The user can select SQL concepts to be included in an assessment and our approach will generate appropriate queries. The proposed approach is generic and is database metadata driven. A Web-based prototype system is developed to illustrate the effectiveness of the proposed approach.},
}
Downloads: 0