Natural Language Interface to Database (NLIDB) for Query with Temporal Aspect

NLIDB (Natural Language Interface to Database) was developed to simplify database access using natural language. In previous studies, NLIDB has been developed which can translate natural languages into several languages, including in Indonesian language. However, there are types of queries that cannot be handled by the system, one of them is a query with a temporal aspect. In this study, we propose a method of translating sentences in Indonesian language that have temporal aspects into SQL queries. The process of translating sentence is performed by identifying the input sentence and parsing the sentence into a parsed tree with PC- PATR as the syntax parser. The parsed tree is analyzed and mapped into parts of SQL. Then, an object search is performed to the ontology that is built from the database to get classes, attributes, operators, and values based on tokens in parts of SQL. Finally, the results of the previous process are organized into SQL queries. The NLIDB application built in this study was successful in translating imperative sentences with temporal aspects in Indonesian language into SQL queries for current state, time slice, sequenced and non-sequenced queries.