Show simple item record

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.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.uri http://dl.lib.uom.lk/handle/123/19465
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.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
dc.identifier.faculty IT en_US
dc.identifier.department Information Technology Research Unit, Faculty of Information Technology, University of Moratuwa. en_US
dc.identifier.year 2021 en_US
dc.identifier.conference 6th International Conference in Information Technology Research 2021 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.doi doi: 10.1109/ICITR54349.2021.9657317 en_US


Files in this item

This item appears in the following Collection(s)

  • ICITR - 2021 [39]
    International Conference on Information Technology Research (ICITR)

Show simple item record