Chrome Extension
WeChat Mini Program
Use on ChatGLM

Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans

International Conference on Management of Data(2021)

Cited 20|Views380
No score
Abstract
The 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. Since a query execution plan (QEP) describes the execution steps of a query, learners can acquire the understanding by perusing the QEPS generated by a RDBMS. Unfortunately, in practice, it is often daunting for a learner to comprehend these QEPS containing vendor-specific implementation details, hindering her learning process. In this paper, we present a novel, end-to-end, generic system called LANTERN that generates a natural language description of a QEP to facilitate understanding of the query execution steps. It takes as input an SQL query and its QEP, and generates a natural language description of the execution strategy deployed by the underlying RDBMS. Specifically, it deploys a declarative framework called POOL that enables subject matter experts to efficiently create and maintain natural language descriptions of physical operators used in QEPS. A rule-based framework called RULE-LANTERN is proposed that exploits POOL to generate natural language descriptions of QEPS. Despite the high accuracy of RULE-LANTERN, our engagement with learners reveal that, consistent with existing psychology theories, perusing such rule-based descriptions lead to boredom due to repetitive statements across different QEPS. To address this issue, we present a novel deep learning-based language generation framework called NEURAL-LANTERN that infuses language variability in the generated description by exploiting a set of paraphrasing tools and word embedding. Our experimental study with real learners shows the effectiveness of LANTERN in facilitating comprehension of QEPS.
More
Translated text
Key words
enhancing database education,query execution plans,natural language generation
AI Read Science
Must-Reading Tree
Example
Generate MRT to find the research sequence of this paper
Chat Paper
Summary is being generated by the instructions you defined