Home // ALLDATA 2017, The Third International Conference on Big Data, Small Data, Linked Data and Open Data // View article

Automated Generation of SQL Queries that Feature Specified SQL Constructs

Authors:
Venkat Gudivada
Kamyar Arbabifard
Dhana Rao

Keywords: Context-Free Grammar, SQL Query Generation, Grammar Graph, Question Generation

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

Pages: 9 to 13

Copyright: Copyright (c) IARIA, 2017

Publication date: April 23, 2017

Published in: conference

ISSN: 2519-8386

ISBN: 978-1-61208-552-4

Location: Venice, Italy

Dates: from April 23, 2017 to April 27, 2017