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

Authors

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

Keywords:

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

Abstract

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.

References

  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

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2017-10-31

Issue

Volume 2, Issue 5, September-October-2017

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
V. Thulasinath, " Natural Language Interface to Database Using Modified Co-occurrence Matrix Technique , IInternational 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.