Auto-Query - A simple natural language to SQL query generator for an e-learning platform
- Resource Type
- Conference
- Authors
- Parikh, Parth; Chatterjee, Oishik; Jain, Muskan; Harsh, Aman; Shahani, Gaurav; Biswas, Rathin; Arya, Kavi
- Source
- 2022 IEEE Global Engineering Education Conference (EDUCON) Global Engineering Education Conference (EDUCON), 2022 IEEE. :936-940 Mar, 2022
- Subject
- Bioengineering
Computing and Processing
Engineering Profession
General Topics for Engineers
Robotics and Control Systems
Signal Processing and Analysis
Structured Query Language
Electronic learning
Databases
Natural languages
Syntactics
User experience
Real-time systems
SQL
Query-less data
SQL in Education
No syntax SQL
easy SQL
- Language
- ISSN
- 2165-9567
Despite its difficulties, SQL is an essential tool for the users in an educational organisation who need quick and easy access to data to gauge the reception of their learning content by their students and potentially improve their content depending on the insights. To get these insights, the course instructors need real-time access to the database and also need to have relevant SQL knowledge to operate the database to retrieve the required data. The study explores ways to mitigate the difficulties of SQL by developing an application that takes natural language questions that the course instructors have and convert them into SQL queries using a sequence-to-sequence model that show them the data they asked for on a dashboard. The study found that there was a drastic reduction in the time it took for the users of the e-learning platform to get the data from the database without waiting for support from the database administrators. This in turn empowered the educators to study the data and get insights into the reception and working of the course and make suitable changes if necessary which might enhance the user experience for their students.