NATURAL LANGUAGE INTERFACE TO DATABASE (NLIDB) FOR IMPLICIT TIME NOUNS

Accessing databases using Structured Query Language (SQL) queries is a complex language that not everyone can use. Therefore, it takes a way of accessing data in a database that is easier and more general. Accessing this data can be done using Natural Language Interface to Databases or NLIDB. Cur...

Full description

Saved in:
Bibliographic Details
Main Author: Naufal, Iqbal
Format: Final Project
Language:Indonesia
Online Access:https://digilib.itb.ac.id/gdl/view/78177
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Institut Teknologi Bandung
Language: Indonesia
Description
Summary:Accessing databases using Structured Query Language (SQL) queries is a complex language that not everyone can use. Therefore, it takes a way of accessing data in a database that is easier and more general. Accessing this data can be done using Natural Language Interface to Databases or NLIDB. Currently, the NLIDB system can translate Indonesian into SQL queries containing temporal aspects developed by Poetra in 2019. However, due to the high complexity of the Indonesian language this NLIDB system can only accept explicit time nouns and cannot accept queries without temporal aspects. Therefore, an NLIDB system is needed that can accept queries containing implicit time nouns and queries that do not contain temporal aspects. The NLIDB system created can identify implicit time nouns using Regular Expression or Regex. Once identified, the implicit time nouns are converted into explicit time nouns that match the time reference in the context of the query given by the user. With the development done, the NLIDB system can translate all categories of implicit time nouns derived from the analysis results and display the SQL query results obtained.