Open AccessIndonesian Text Translator into Database Structured Query Language with Multi Parameters using Natural Language Processing
Author(s) -
Galih Hermawan,
I. Faturohman,
N. Isharmawan
Publication year - 2019
Publication title -
iop conference series. materials science and engineering
Language(s) - English
Resource type - Journals
eISSN - 1757-899X
pISSN - 1757-8981
DOI - 10.1088/1757-899x/662/2/022095
Subject(s) - computer science , indonesian , query by example , sql , natural language processing , query language , information retrieval , query expansion , artificial intelligence , database , web search query , linguistics , search engine , philosophy
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 systems generated queries and key answers query. In general, the system has been able to translate most of the Indonesian sentences into SQL queries.