Indonesian Text Translator into Database Structured Query Language with Multi Parameters using Natural Language Processing
Galih Hermawan*, Ihsan Faturohman, Nendi Isharmawan
Department of Informatics Engineering, Faculty of Engineering and Computer Science, Universitas Komputer Indonesia
Jl. Dipati Ukur No. 112-116, Bandung 40132, Indonesia
*galih.hermawan[at]email.unikom.ac.id
Abstract
In this paper, we present the results of our research on SQL (Structured Query Language) Translator in Indonesian which aims to measure how accurate the designed system in understanding query sentences in Indonesian into SQL query languages. The methods used include pre-processing sentences, stemming, identifying keywords, until the final evaluation of sentences. We prepared 18 sentences divided into several categories as test data. The test results show that the system successfully evaluates all sentences with a total accuracy of 72.22% to 83.87%. Accuracy values were obtained by comparing similarities between system generated queries and key answers query. In general, the system has been able to translate most of the Indonesian sentences into SQL queries.
Keywords: database query; natural language processing; information extraction; information retrieval; structured query language
Topic: Electrical and Computer Engineering