An Intelligent Interface for relational databases

In the present computing world, most new-generation database applications demand intelligent interface to enhance efficient interactions between database and the users. The most accessible interfaces for databases must be intelligent and able to understand natural language expressions. In this paper mapping of natural language queries to SQL is discussed. We propose a general architecture for an intelligent database interface and also a real implementation of such a system which can be connected to any database. One of the main characteristics of this interface is domain-independence, which means that this interface can be used with any database. Another characteristic of this system is ease of configuration. The intelligent interface employs semantic matching technique to convert natural language query to SQL using dictionary and set of production rules. The dictionary consists of semantics sets for tables and columns. The shaped query is executed and the results are presented to the user. This interface was first tested using Supplier-Parts database and secondly with Northwind database of SQL server 7.0. KeywordsDatabases; Structured Query Language (SQL); intelligent interface; Intelligent Database System (IDBS), Flexible Querying; Intelligent Layer; Domain Independent Interface.

[1]  Elisa Bertino,et al.  Intelligent Database Systems , 2000 .

[2]  Joaquín Pérez Ortega,et al.  A Domain Independent Natural Language Interface to Databases Capable of Processing Complex Queries , 2005, MICAI.

[3]  Sanjay Silakari,et al.  Design of Intelligent layer for flexible querying in databases , 2009, ArXiv.

[4]  Michael L. Brodie.  Future Intelligent Information Systems: AI and Database Technologies Working Together , 1988, AAAI.

[5]  Henry A. Kautz,et al.  Towards a theory of natural language interfaces to databases , 2003, IUI '03.

[6]  João C. O. Matias,et al.  Edite - A Natural Language Interface to Databases A new dimension for an old approach , 1997 .

[7]  Tim Johnson,et al.  Natural Language Computing: The Commercial Applications , 1984, The Knowledge Engineering Review.

[8]  Timothy W. Finin,et al.  The Intelligent Database Interface: Integrating AI and Database Systems , 1990, AAAI.

[9]  Joseph Weizenbaum,et al.  ELIZA—a computer program for the study of natural language communication between man and machine , 1966, CACM.

[10]  Joaquín Pérez Ortega,et al.  Issues in Translating from Natural Language to SQL in a Domain-Independent Natural Language Interface to Databases , 2006, MICAI.

[11]  Peter Thanisch,et al.  Natural language interfaces to databases – an introduction , 1995, Natural Language Engineering.

[12]  Peter Thanisch,et al.  MASQUE/SQL: an efficient and portable natural language query interface for relational databases , 1993 .

[13]  Dietmar Wolfram.  Applications of SQL for Informetric Data Processing , 2013 .

[14]  Zongmin Ma,et al.  Intelligent Databases: Technologies and Applications , 2006 .