Generating SQL Command Syntax Using MySQL Based on Typing Command Sentence

Inform

View Publication Info
 
 
Field Value
 
Title Generating SQL Command Syntax Using MySQL Based on Typing Command Sentence
 
Creator Indriyono, Bonifacius Vicky
Pratama, Zudha
 
Description Information retrieval system is a system that is widely used to retrieve information. This research will discuss how the system finds back the information stored in database tables. Tables in the database are arranged to store all forms of data entered by database users so that later the stored data can be used again. Re-accessing the database's information must go through a mechanism known as a database management system (DBMS). One of the most widely used DBMS is MySQL. By using a DBMS, information and data can be manipulated according to user needs. Data manipulation in the database is done in a special language, namely SQL (Structure Query Language). Mastery of SQL commands is an obligation for database users so that the manipulated data can produce the required information. However, many database users still do not understand how the actual SQL command syntax manages and manipulates data into information. This is, of course, very risky if the solution is not immediately sought because it will hinder the process of retrieving information from the data stored in the database. For this problem to be resolved, it is necessary to design a system that can help database users translate their wishes into SQL command syntax. This paper will discuss how a command in Indonesian can be translated into SQL command syntax. The method used to solve this research problem is rule-based. There are two stages in the main process: the pre-processing stage, which consists of a word tokenization process, and a translation stage, including a keyword grouping process. This keyword grouping process consists of the keyword group analysis phase, table and column analysis, identification of SQL commands, and mapping of SQL commands. From all stages that have been passed and testing of 7 scenarios with ten (10) commands for each scenario, the accuracy is 81.42%. The inaccuracy in the testing process is more a problem of displaying data from two or more tables, for example, using the join table command. This problem can be addressed by adding new rules for the use of table joins.
 
Publisher Universitas Dr. Soetomo
 
Date 2021-01-31
 
Type info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
 
Format application/pdf
application/pdf
application/pdf
application/pdf
 
Identifier https://ejournal.unitomo.ac.id/index.php/inform/article/view/3305
10.25139/inform.v6i1.3305
 
Source Inform : Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi; Vol 6 No 1 (2021); 1-7
2581-0367
2502-3470
 
Language eng
 
Relation https://ejournal.unitomo.ac.id/index.php/inform/article/view/3305/pdf
https://ejournal.unitomo.ac.id/index.php/inform/article/view/3305/1884
https://ejournal.unitomo.ac.id/index.php/inform/article/view/3305/1885
https://ejournal.unitomo.ac.id/index.php/inform/article/view/3305/1886
10.25139/inform.v6i1.3305.g1471
10.25139/inform.v6i1.3305.g1884
10.25139/inform.v6i1.3305.g1885
10.25139/inform.v6i1.3305.g1886
 
Rights Copyright (c) 2021 Inform: Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi
http://creativecommons.org/licenses/by-sa/4.0
 

Contact Us

The PKP Index is an initiative of the Public Knowledge Project.

For PKP Publishing Services please use the PKP|PS contact form.

For support with PKP software we encourage users to consult our wiki for documentation and search our support forums.

For any other correspondence feel free to contact us using the PKP contact form.

Find Us

Twitter

Copyright © 2015-2018 Simon Fraser University Library