Translating controlled natural language query into SQL query using pattern matching technique

Database is a prime source of information. This information is accessed by a common man who is not able to write complex SQL query. Enabling common users to query databases using natural language and retrieve information from them has been a promising research area. A system is proposed to retrieve data from the database using Hindi language. Our system uses morphological analyzer and word group analyzer to extract the keyword from input Hindi query. Then it uses pattern matching technique to find the type of keyword. Also, it uses the controlled Hindi language interface and suggested query feature to reduce ambiguity and time for entering the Hindi query.

[1]  Gary G. Hendrix,et al.  Developing a natural language interface to complex data , 1977, TODS.

[2]  H. V. Jagadish,et al.  NaLIX: A generic natural language search environment for XML data , 2007, TODS.

[3]  M. Ahmed,et al.  Intelligent natural language query processor , 1989, Fourth IEEE Region 10 International Conference TENCON.

[4]  John D. Burger,et al.  Problems in Natural-Language Interface to DBMS With Examples From EUFID , 1983, ANLP.

[5]  E. F. Codd,et al.  Seven Steps to Rendezvous with the Casual User , 1974, IFIP Working Conference Data Base Management.

[6]  Akshar Bharati,et al.  Natural language processing : a Paninian perspective , 1996 .

[7]  Jyoti Pareek,et al.  NLKBIDB - Natural language and keyword based interface to database , 2013, 2013 International Conference on Advances in Computing, Communications and Informatics (ICACCI).

[8]  Frederick B. Thompson,et al.  ASK is transportable in half a dozen ways , 1985, TOIS.

[9]  Weiwei Sun,et al.  A lightweight Chinese semantic dependency parsing model based on sentence compression , 2010, Proceedings of the 6th International Conference on Natural Language Processing and Knowledge Engineering(NLPKE-2010).

[10]  A. Shingala,et al.  Enhancing the relevance of information retrieval by querying the database in natural form , 2013, 2013 International Conference on Intelligent Systems and Signal Processing (ISSP).

[11]  Gang Zhou,et al.  A knowledge-based tutoring system for SQL programming , 1994, Proceedings Sixth International Conference on Tools with Artificial Intelligence. TAI 94.

[12]  Tadeusz Dobrowiecki,et al.  Rapid prototyping of application-oriented natural language interfaces , 2010, Proceedings of the ITI 2010, 32nd International Conference on Information Technology Interfaces.

[13]  Richard M. Stern,et al.  Sentence parsing with weak grammatical constraints , 1987, ICASSP '87. IEEE International Conference on Acoustics, Speech, and Signal Processing.

[14]  Remko J. H. Scha,et al.  Philips question-answering system PHLIQA1 , 1977, SGAR.

[15]  Xiaofei Zhang,et al.  Part-of-speech tagger based on maximum entropy model , 2009, 2009 2nd IEEE International Conference on Computer Science and Information Technology.

[16]  Zhiping Zheng,et al.  AnswerBus question answering system , 2002 .

[17]  Philip Resnik.  Access to Multiple Underlying Systems in Janus , 1989 .

[18]  Douglas E. Appelt,et al.  TEAM: An Experiment in the Design of Transportable Natural-Language Interfaces , 1987, Artif. Intell..

[19]  P. Chahal,et al.  Ranking of web documents using semantic similarity , 2013, 2013 International Conference on Information Systems and Computer Networks.

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

[21]  David H. D. Warren,et al.  An Efficient Easily Adaptable System for Interpreting Natural Language Queries , 1982, CL.

[22]  Brendan S. Gillon.  Review of Natural language processing: a Paninian perspective by Akshar Bharati, Vineet Chaitanya, and Rajeev Sangal. Prentice-Hall of India 1995. , 1995 .