NL2SQL UNTUK CHATBOT DENGAN SEMANTIC PARSING MENGGUNAKAN METODE BERBASIS ATURAN

KURNIAWAN, ADI and Abdiansah, Abdiansah and Utami, Alvi Syahrini (2022) NL2SQL UNTUK CHATBOT DENGAN SEMANTIC PARSING MENGGUNAKAN METODE BERBASIS ATURAN. Undergraduate thesis, Sriwijaya University.

[thumbnail of RAMA_55201_09021181823168.pdf] Text
RAMA_55201_09021181823168.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (4MB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_TURNITIN.pdf] Text
RAMA_55201_09021181823168_TURNITIN.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (6MB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_01_front_ref.pdf]
Preview
 Text
RAMA_55201_09021181823168_0001108401_0022127804_01_front_ref.pdf - Accepted Version
Available under License Creative Commons Public Domain Dedication.
Download (2MB) | Preview
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_02.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_02.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (316kB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_03.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_03.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (546kB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_04.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_04.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (1MB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_05.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_05.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (806kB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_06.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_06.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (118kB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_07_ref.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_07_ref.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (185kB) | Request a copy
[thumbnail of RAMA_55201_09021181823168_0001108401_0022127804_08_lamp.pdf] Text
RAMA_55201_09021181823168_0001108401_0022127804_08_lamp.pdf - Accepted Version
Restricted to Repository staff only
Available under License Creative Commons Public Domain Dedication.
Download (304kB) | Request a copy

Abstract

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.

Item Type: Thesis (Undergraduate)
Uncontrolled Keywords: Chatbot, Natural Language to Structured Query Language, NL2SQL, Berbasis Aturan
Subjects: Q Science > QA Mathematics > QA75-76.95 Calculating machines > QA76 Computer software
Q Science > QA Mathematics > QA75-76.95 Calculating machines > QA76.76.I58.A3115 Computer science. Computers. Intelligent agents (Computer software)
Q Science > QA Mathematics > QA8.9-QA10.3 Computer science. Artificial intelligence. Computational complexity. Data structures (Computer scienc. Mathematical Logic and Formal Languages
Divisions: 09-Faculty of Computer Science > 55201-Informatics (S1)
Depositing User: Adi Kurniawan
Date Deposited: 04 Jan 2023 01:54
Last Modified: 04 Jan 2023 01:54
URI: http://repository.unsri.ac.id/id/eprint/85250

Actions (login required)

View Item View Item