Natural Language Interface to Database Using Modified Co-occurrence Matrix Technique

Authors(1) :-V. Thulasinath

Today, database is considered as one of the major source of information. Data stored in database can be accessed by using SQL queries, Those who are expert in SQL language can access information from database but non-technical user cannot retrieve data from database such as MySQL and oracle, Everyone is not able to write SQL queries as they may not be aware of the structure of the database, So this has led to the improvement of interface s to Database System. This is useful for non-expert users to query relational databases in their natural language. However, this project accepts a query entered in natural language (i.e., English) for accessing/retrieving database. This statement will be verified syntactically and then produces equivalent statement in Structured Query Language (SQL). Finally SQL statement will be executed by query executor to produce desired information from database. In proposed system we focused on design and implementation of a system using modified word co-occurrence matrix method which will provide access to database using queries in English language. As a result intelligent natural language interfaces to databases to be developed.

Authors and Affiliations

V. Thulasinath
M.Tech, CSE Department, JNTU College of Engineering Anantapur, Andhra Pradesh, India

Information retrieval; Natural language interface; Natural language processing; Structured Query Language (SQL); Word co-occurrence matrix technique.

  1. Singh, H., & Seehan, D. Providing Inferential Capability to Natural Language Database Interface. Assistant Professor: Department of Computer Science Punjabi University Akali Phoola Singh Neighbourhood Campus, Dehla Seehan (Sangrur), Punjab, India   `
  2. Nihalani, N. (2010). An Intelligent Interface for relational databases. human-computer interaction, 6, 7.
  3. Tang, L. R. (2008). Using machine learning approach for natural language interfaces for databases: Application of advanced techniques in inductive logic programming. Journal of Computer Science, Informatics and Electrical Engineering, 2(1).
  4. Silberschatz, A., Korth, H. F., & Sudarshan, S. (1997). Database system concepts (Vol. 4). New York: McGraw-Hill.
  5. Seidman, C., & Smith, P. (2003). MySQL: The complete reference. McGraw-Hill, Inc..
  6. https://w3schools.com
  7. https://developers.google.com/chart

Publication Details

Published in : Volume 2 | Issue 5 | September-October 2017
Date of Publication : 2017-10-31
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 436-440
Manuscript Number : CSEIT172577
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

V. Thulasinath, "Natural Language Interface to Database Using Modified Co-occurrence Matrix Technique ", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 5, pp.436-440, September-October-2017.
Journal URL : http://ijsrcseit.com/CSEIT172577

Article Preview

Follow Us

Contact Us