Automated Generation of SQL Queries that Feature Specified SQL Concepts. Gudivada, V., Arbabifard, K., & Rao, D. In Proceedings of the $3^{\text{rd}}$ International Conference on Big Data, Small Data, Linked Data and Open Data (ALLDATA 2017), pages 9–13, Venice, Italy, april, 2017. IARIA.
abstract   bibtex   
SQL is an ISO standard language for querying relational databases. SQL queries are deceptively simple to write, but writing semantically correct queries requires a good understanding of the data model and SQL constructs. Often, this is a challenging task for beginners. Automatic generation of SQL queries that feature specified SQL constructs is useful for both informal self-testing and formal assessment. In this work-in-progress paper, we describe the automated question generation problem in a broader context, provide an overview of the current approaches, and discuss our approach to automatic generation of SQL queries. Our approach is based on the notion of grammar graph. We illustrate the approach using an arithmetic expression grammar and generalize this approach to SQL query generation.
@inproceedings{Gudivada2017RCa,
    Author = {V. Gudivada and K. Arbabifard and D. Rao},
    Title = {Automated Generation of SQL Queries that Feature Specified SQL Concepts},
    Booktitle = {Proceedings of the $3^{\text{rd}}$ International Conference on Big Data, Small Data, Linked Data and Open Data (ALLDATA 2017)},
    Publisher = {IARIA},
    Month = april,
    Address = {Venice, Italy},
    Year = {2017},
    Pages = {9--13},
    abstract = {SQL is an ISO standard language for querying relational databases. SQL queries are deceptively simple to write, but writing semantically correct queries requires a good understanding of the data model and SQL constructs. Often, this is a challenging task for beginners. Automatic generation of SQL queries that feature specified SQL constructs is useful for both informal self-testing and formal assessment. In this work-in-progress paper, we describe the automated question generation problem in a broader context, provide an overview of the current approaches, and discuss our approach to automatic generation of SQL queries. Our approach is based on the notion of grammar graph. We illustrate the approach using an arithmetic expression grammar and generalize this approach to SQL query generation.},
}

Downloads: 0