Using Context Free Grammars to Generate SQL Questions
Year: 2024
Type: dissertation
Abstract: This paper showcases the limitations of current SQL practice approaches, both in server architecture and implementation. The technical project works towards resolving these limitations by providing a fully client-sided website to help students practice SQL. By providing a client only architecture rather than the traditional server-client approach, queries are guaranteed to be sandboxed, and the necessity for reliable WiFi becomes nearly nonexistent. This is in part an extension of the SQL Injection platform first presented in 2019 [1], with more focus on practicing SQL queries than SQL injection attacks. Such practice involves basic keywords, including WHERE, HAVING, and GROUP BY as well as aggregates. This approach implements modified context free grammars for constructing questions and example answers, including variables for aggregates and GROUP BY.
Source: Libra
DOI: 10.18130/akcx-j052
Author: Jared Conway
Institution: University of Virginia
Language: English
Subfield: Computer Science Applications
Field: Computer Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W6887948680
Cites:
Cited by:
Related to: