fbpx Natural Language Interface to Relational Database (NLI-RDB) Through Object Relational Mapping (ORM) |ARAB AMERICAN UNIVERSITY
Contact information for Technical Support and Student Assistance ... Click here

Natural Language Interface to Relational Database (NLI-RDB) Through Object Relational Mapping (ORM)

Chapter Number: 
6
Authors: 
Abdullah Alghamdi
Majdi Owda
Keeley Crockett
Pages From: 
449
To: 
464
Book Title: 
Advances in Computational Intelligence Systems
Editor(s): 
Plamen Angelov Alexander
Gegov Chrisina
Jayne Qiang Shen
Publisher: 
Springer
Edition: 
1
Date: 
Wednesday, September 7, 2016
Abstract: 
This paper proposes a novel approach for building a Natural Language Interface to a Relational Database (NLI-RDB) using Conversational Agent (CA), Information Extraction (IE) and Object Relational Mapping (ORM) framework. The CA will help in disambiguating the user’s queries and guiding the user interaction. IE will play an important role in named entities extraction in order to map Natural Language queries into database queries. The ORM framework i.e. the Hibernate framework resolves the impedance mismatch between the Object Oriented Paradigms (OOP) and Relational Databases (RDBs) i.e. OOP concepts differ from RDB concepts, thus it reduces the complexity in generating SQL statements. Also, by utilizing ORM framework, the RDBs entities are mapped into real world objects, which bring the RDBs a step closer to the user. In addition, the ORM framework simplify the interaction between OOP and RDBs. The developed NLI-RDB system allows the user to interact with objects directly in natural language and through navigation, rather than by using SQL statements. This direct interaction tends to be easier and more acceptable for humans whom are nor technically orientated and have no SQL knowledge. The NLI-RDB system also offers friendly and interactive user interface in order to refine the query generated automatically. The NLI-RDB system has been evaluated by a group of participants through a combination of qualitative and quantitative measures. The experimental results show good performance of the prototype and excellent user’s satisfaction.