Text
NL2SQL UNTUK CHATBOT DENGAN SEMANTIC PARSING MENGGUNAKAN METODE BERBASIS ATURAN
Structured Query Language (SQL) is a command language that allows users to access information in the database. Ordinary people generally do not know how to perform SQL queries in a database. A chatbot is a computer program developed to be able to interact with users via text or voice. In this study, a chatbot was created to assist and facilitate users in the Natural Language to Structured Query Language (NL2SQL) process to search for information in an Academic Information System database with semantic parsing using a rule-based method that accepts input in the form of interrogative sentences or sentences. order. In the Natural Language to Structured Query Language (NL2SQL) process, several problems arise, namely input problems with unique parameters to the knowledge base. Slow searching or translation processes, which make Natural Language to Structured Query Language (NL2SQL) inefficient, problems The problem will be solved by using a semantic parsing approach using a rule-based method that is proven to be efficient in solving problems such as the Natural Language to Structured Query Language (NL2SQL) process. The results showed that the semantic parsing method using the rule-based method succeeded in obtaining an accuracy rate of 96.72% by using 122 test data in the form of question or command data about the Academic Information System of the Department of Informatics, Sriwijaya University in Indonesian, and the average execution time 50.68 millisecond or 0.05 second
Inventory Code | Barcode | Call Number | Location | Status |
---|---|---|---|---|
2207005311 | T85250 | T852502022 | Central Library (Referens) | Available but not for loan - Not for Loan |
No other version available