KUERI STOK BARANG PADA E-COMMERCE CHATBOT BERBASIS TEXT-TO- SQL

PRADANA, ANDREAN and Abdiansah, Abdiansah and Satria, Hadipurnawan (2023) KUERI STOK BARANG PADA E-COMMERCE CHATBOT BERBASIS TEXT-TO- SQL. Undergraduate thesis, Sriwijaya University.

	Text RAMA_55201_09021381924150.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_TURNITIN.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (3MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_01_front_ref.pdf - Accepted Version Available under License Creative Commons Public Domain Dedication. Download (1MB)
	Text RAMA_55201_09021381924150_0001108401_0018048003_02.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (119kB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_03.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_04.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_05.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_06.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_06_ref.pdf - Bibliography Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy
	Text RAMA_55201_09021381924150_0001108401_0018048003_07_lamp.pdf - Accepted Version Restricted to Repository staff only Available under License Creative Commons Public Domain Dedication. Download (1MB) | Request a copy

Abstract

The use of a database as a data storage medium is very important, especially for e-commerce owners in storing information about the products they sell. Besides being used to store data, the use of databases makes it easier to search and process data, overcome data redundancy, maintain data consistency, and the costs incurred are quite cheap. In its use, one needs to write the right query so that it can be understood by the computer. Usually, such queries are written in the form of Structured Query Language (SQL). However, the problem arises that for people who do not have an IT background, this can be a problem as they may not be familiar with SQL and database structures. Therefore, the question arises how a non-IT person can use a database without the need to learn SQL and its structure. In this study, research will be conducted on the conversion of text or natural language into SQL, so that people who do not have an IT background can use the database without the need to learn SQL and its structure. Therefore, this research will develop a Text-to-SQL system on a chatbot that can facilitate access to interact with the database. The system works by converting natural language into SQL queries. The method used to convert natural language into SQL queries is Semantic Parsing. This method allows computers to understand the meaning and structure of sentences in natural language and convert them into SQL commands that can be understood by the database. In this study, the use of the Semantic Parsing method in building a Text-to-SQL system achieved a good accuracy rate of 81%.

Item Type:	Thesis (Undergraduate)
Uncontrolled Keywords:	E-commerce, Chatbot, Text-to-SQL, Semantic Parsing
Subjects:	T Technology > T Technology (General) > T1-995 Technology (General)
Divisions:	09-Faculty of Computer Science > 55201-Informatics (S1)
Depositing User:	Andrean Pradana
Date Deposited:	28 Jul 2023 07:04
Last Modified:	28 Jul 2023 07:04
URI:	http://repository.unsri.ac.id/id/eprint/123010

Actions (login required)

View Item