Generating SQL Command Syntax Using MySQL Based on Typing Command Sentence

  • Information System, College of Informatics and Computer Management (STMIK) Kadiri http://orcid.org/0000-0001-8805-9047
  • Information System, College of Informatics and Computer Management (STMIK) Kadiri
https://doi.org/10.25139/inform.v6i1.3305
Abstract views: 518 , PDF downloads: 251
Turnitin downloads: 0
Ethical Statement downloads: 0
Copyright Transfer Agreement downloads: 0
Keywords: Database, DBMS, MySQL, SQL, Command Sentence

Abstract

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.

References

[1] Suhartati and Y.D. Atma, "Simple Query Optimization for Query Speeds on a Database Server", METIK Journal, Vol. 1 No. 1, p. 14-17, Jun. 2017.
[2] T. Connolly, Database Systems A Practical Approach to Design, Implementation, and Management Fifth Edition. Boston : Pearson Education, 2010.
[3] E. Tungadi, "Form Generator Utilizing MySQL Metadata", National Seminar on Communication and Informatics (SNKI), p. 77-80, Jun. 2015.
[4] K.C. Laudon and J.P. Laudon, Management Information Systems : Managing the Digital Firm, 11th Edition. New Jersey: Prentice Hall. 2010.
[5] I. Warman and R. Ramdaniansyah, "Comparative Analysis of Query Database Management System (DBMS) Performance Between Mysql 5.7.16 And Mariadb 10.1", TEKNOIF Journal, Vol. 6 No. 1, p. 32-41, Apr. 2018.
[6] H. Yuliansyah, "Designing Mysql Database Replication With Security Mechanisms Using SSL Encryption", Journal of Informatics, Vol. 8 No. 1, p. 826-836, Jan. 2014.
[7] V. Natali and P. Alfadian, "Specific Domain Analysis and Design Language for Data Generator on Relational Database", JUMANJI Journal, Vol. 3 No. 1, p. 64-73, Aprl. 2019.
[8] R. Pamungkas, "Query Optimization in My Sql Database Using an Index", Research: Journal of Computer, information systems, & technology management, Vol. 1 No. 2, p. 27-31, Apr. 2018.
[9] J. Sinuraya, "Data Search Methods Using Hash Join Query and Nested Join Query", Journal of Teknovasi, Vol. 4 No. 1, p. 42-50, Apr. 2017.
[10] M. Fikry, et al. "Generating Web Forms Based on SQL Metadata and W3C specifications", CoreIT Journal, Vol. 3 No. 2, p. 63-68, Dec. 2017.
[11] A.K. Jaiswal, "SQL Query Generator for Natural Language", International Journal of Research In Science & Engineering, Vol. 3 No. 2, p. 190-196, March. 2017.
[12] S.A. Khalek and S. Khurshid, "Automated SQL Query Generation for Systematic Testing of Database Engines", ASE 2010 : The 25th IEEE/ACM International Conference on Automated Software Engineering, p. 329-332, Sept. 2010.
[13] Sugiyono, Educational Research Methods with Quantitative Approaches, Qualitative, and R & D. Bandung : Alfabeta. 2013.
[14] D.J. Hodgetts and E.E. Stolte," Case‐based Research in Community and Social Psychology: Introduction to the Special Issue", Journal of Community & Applied Social Psychology, Vol. 22 No. 5, p. 379-389, Aug. 2012
[15] S. Arikunto, Research Procedure A practical approach. Jakarta: Rineka Cipta. 2010.
[16] K.K. Purnamasari and I.S. Suwardi, "Rule-based Part of Speech Tagger for Indonesian Language", in Proc. IOP Conf. Series: Materials Science and Engineering, 2018, Vol. 407, p. 1-4.