Heuristics-based sql query generation engine
| dc.contributor.author | Sugandhika, C | |
| dc.contributor.author | Ahangama, S | |
| dc.contributor.editor | Ganegoda, GU | |
| dc.contributor.editor | Mahadewa, KT | |
| dc.date.accessioned | 2022-11-10T04:34:44Z | |
| dc.date.available | 2022-11-10T04:34:44Z | |
| dc.date.issued | 2021-12 | |
| dc.description.abstract | A database is one of the prime media to store data. Most of the time, relational databases are preferred over other databases due to their ability to represent complex relationships between data. Languages like Structured Query Language (SQL) are used to retrieve data stored in relational databases. Information stored in these databases is often accessed by naïve users who do not possess high competencies in technical database querying. Therefore, Natural Language Interfaces to Databases (NLIDB) are being developed to translate natural language into SQL queries and retrieve the corresponding database results. This paper proposes a novel NLIDB called SQL Query Generation Engine which has been developed using a heuristics-based approach. The system was tested with more than 200 natural language queries and has shown an overall accuracy of 93%. | en_US |
| dc.identifier.citation | C. Sugandhika and S. Ahangama, "Heuristics-Based SQL Query Generation Engine," 2021 6th International Conference on Information Technology Research (ICITR), 2021, pp. 1-7, doi: 10.1109/ICITR54349.2021.9657317. | en_US |
| dc.identifier.conference | 6th International Conference in Information Technology Research 2021 | en_US |
| dc.identifier.department | Information Technology Research Unit, Faculty of Information Technology, University of Moratuwa. | en_US |
| dc.identifier.doi | doi: 10.1109/ICITR54349.2021.9657317 | en_US |
| dc.identifier.faculty | IT | en_US |
| dc.identifier.place | Moratuwa, Sri Lanka | en_US |
| dc.identifier.proceeding | Proceedings of the 6th International Conference in Information Technology Research 2021 | en_US |
| dc.identifier.uri | http://dl.lib.uom.lk/handle/123/19465 | |
| dc.identifier.year | 2021 | en_US |
| dc.language.iso | en | en_US |
| dc.publisher | Faculty of Information Technology, University of Moratuwa. | en_US |
| dc.relation.uri | https://ieeexplore.ieee.org/document/9657317 | en_US |
| dc.subject | Heuristics-based approach | en_US |
| dc.subject | Naïve users | en_US |
| dc.subject | Natural language query | en_US |
| dc.subject | NLIDB | en_US |
| dc.subject | NLP | en_US |
| dc.subject | relational database | en_US |
| dc.subject | SQL | en_US |
| dc.title | Heuristics-based sql query generation engine | en_US |
| dc.type | Conference-Full-text | en_US |