ABSTRACT
A core component of a database systems course at the undergraduate level is the design and implementation of the query optimizer in an rdbms. The query optimization process produces aquery execution plan (qep ), which represents an execution strategy for an sql query. Unfortunately, in practice, it is often difficult for a student to comprehend a query execution strategy by perusing its qep, hindering her learning process. In this demonstration, we present a novel system called neuron that facilitates natural language interaction with qep s to enhance its understanding. neuron accepts an sql query (which may include joins, aggregation, nesting, among other things) as input, executes it, and generates a simplified natural language description (both in text and voice form) of the execution strategy deployed by the underlying rdbms. Furthermore, it facilitates understanding of various features related to a qep through anatural language question answering (nlqa ) framework. We advocate that such tool, world's first of its kind, can greatly enhance students' learning of the query optimization topic.
- . Basik, et al. DBPal: A Learned NL-Interface for Databases. In SIGMOD, 2018.Google Scholar
- . Kokkalis, P. Vagenas, A. Zervakis, A. Simitsis, G. Koutrika, Y. E. Ioannidis. Logos: A System for Translating Queries into Narratives. In SIGMOD, 2012. Google ScholarDigital Library
- . Li, H. V. Jagadish. NaLIR: An Interactive Natural Language Interface for Querying Relational Databases. In SIGMOD, 2014. Google ScholarDigital Library
- . Li, H. V. Jagadish. Constructing an Interactive Natural Language Interface for Relational Databases. PVLDB, 8(1), 2014. Google ScholarDigital Library
- . Liu, et al. NEURON: Query Optimization Meets Natural LanguageProcessing For Augmenting Database Education. https://arxiv.org/pdf/1805.05670.pdf.Google Scholar
- .-M. Popescu, O. Etzioni, H. A. Kautz. Towards a Theory of Natural Language Interfaces to Databases. In IUI, 2003. Google ScholarDigital Library
- . Saha, A. Floratou, et al.ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores. PVLDB, 9(12), 2016.Google Scholar
Index Terms
- NEURON: Query Execution Plan Meets Natural Language Processing For Augmenting DB Education
Recommendations
ARENA: Alternative Relational Query Plan Exploration for Database Education
SIGMOD '23: Companion of the 2023 International Conference on Management of DataA key learning goal of learners taking a database systems course is to understand how SQL queries are processed in an RDBMS in practice. To this end, comprehension of different alternative query plans (AQPs) that may be considered during the selection ...
Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans
SIGMOD '21: Proceedings of the 2021 International Conference on Management of DataThe database systems course is offered as part of an undergraduate computer science degree program in many major universities. A key learning goal of learners taking such a course is to understand how sql queries are processed in a rdbms in practice. ...
LANTERN: Boredom-conscious Natural Language Description Generation of Query Execution Plans for Database Education
SIGMOD '22: Proceedings of the 2022 International Conference on Management of DataThe database systems course in an undergraduate computer science degree program is gaining increasing importance due to the continuous supply of database-related jobs as well as the rise of Data Science. A key learning goal of learners taking such a ...
Comments