The week's pick
Reseach Article
Rule based Domain Specific Semantic Analysis for Natural Language Interface for Database
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 164 - Number 11 |
| Year of Publication: 2017 |
| Authors: Probin Anand, Zuber Farooqui |
10.5120/ijca2017913502
|
Probin Anand, Zuber Farooqui . Rule based Domain Specific Semantic Analysis for Natural Language Interface for Database. International Journal of Computer Applications. 164, 11 ( Apr 2017), 21-28. DOI=10.5120/ijca2017913502
Abstract
A database is defined as collection of information that is organized to access, manage, and update data easily and efficiently. All our data is stored in a database and there are multiple ways to interact with the database to access our data. A user needs some technical knowledge to extract data from the database. They need to use SQL for data definition, data manipulation, or data control. However, most of the users who need to extract data from a database are not technical experts. Therefore, there is a huge communication gap between the database and its core user. With the evolution of NLP a user can now talk to their database in their natural language without having to learn the language of the database. The communication gap between the user and the database has started to vanish with this amazing capability. In this paper, I will show you how to develop an effective and simple interface for a non-technical user to interact with their database in their natural language. I have chosen English as the user's natural language as it's the most commonly used language in the world.
References
- Mrs. Neelu Nihalani, Dr. Sanjay Silakari and Dr. Mahesh Motwani, (2011) “Natural Language Interface for Database: A Brief Review”, IJCSI International Journal of Computer Science Issues, vol. 8, no. 2, pp. 600-608.
- R. Ahmad, M. A. Khan, and R. Ali (2009). “Efficient transformation of a natural language query to SQL for Urdu”. In Proceedings of the Conference on Language & Technology, page p53.
- A. R. Akula, R. Sangal, and R. Mamidi (2013). “A novel approach towards incorporating context processing capabilities in NLIDB system”. In Proceedings of the 6th International Joint Conference on Natural Language Processing (IJCNLP), pages 1216–1222.
- I. Androutsopoulos(1992). “Interfacing a natural language front-end to a relational database”. Master’s thesis, Cite seer.
- I. Androutsopoulos, G. Ritchie, and P. Thanisch (1993). “Masque/sql-a client and portable natural language query interface for relational databases”. Database technical paper, Department of AI, University of Edinburgh.
- Katz, B., et al., (2002). Omnibase: Uniform access to heterogeneous data for question answering. In Proceedings of the 7th International Workshop on Applications of Natural Language to Information Systems (NLDB 2002).
- Minock, M., (2005). A Phrasal Approach to Natural Language Interfaces over Databases, proceedings of the International Conference on Applications of Natural Language to Information Systems (NLDB), pages 333-336.
- Rao. G., et al., 2010. Natural language query processing using semantic grammar, International Journal on Computer Science and Engineering (IJCSE),Vol. 02, No. 02, 219-223
- Siasar djahantighi. F., et al., 2008. Using Natural Language Processing in Order to Create SQL Queries, Proceedings of the International Conference on Computer and Communication Engineering 2008, Kuala Lumpur, Malaysia
- Thompson, C.W., Pazandak, P., Tennant, H.R., .2005. Talk to your semantic web. IEEE Internet Computing 9(6), 75–78
- Woods, W. A.,. 1973. Progress in natural language understanding: An application to LUNAR geology. AFIPS Natl. Computer. Conj: Expo.. Conference Proc. 42, 441-450.
- I. Androutsopoulos, G. D. Ritchie, and P. Thanisch. 1995. “Natural language interfaces to databases-an introduction”. arXiv preprint cmp-lg/9503016,
- Gauri. R., et al., 2010. Natural Language Query Processing Semantic Grammar. (IJCSE) International Journal on Computer Science and Engineering Vol. 02, No. 02, 2010, 219-223. http://www.enggjournals.com/ijcse/doc/IJCSE10-02-02-20.pdf
- Hendrix. G. G., et al.,. 1978. Developing a natural language interface to complex data, in ACM Transactions on database systems, 3(2), pp. 105- 147,
- Huangi, et al.,. 2008. A Natural Language database Interface based on probabilistic context free grammar. IEEE International workshop on Semantic Computing and Systems.
- Karande, N. D., and Patil, G. A.,. 2009, Natural Language Database Interface for Selection of Data Using Grammar and Parsing, World Academy of Science, Engineering and Technology.
- Rukshan Alexander, Rukshan Prashanthi, and Mahesan Sinnatham. 2013. “Natural Language Web Interface for Database”. Proceedings of the Third International Symposium, SEUSL: 6-7, Oluvil, Sri Lanka.
- John Lafferty, Andrew McCallum, and Fernando Pereira. 2001. “Conditional random fields: Probabilistic models for segmenting and labeling sequence data”. Proceedings of the Eighteenth International Conference on Machine Learning, pages 282–289
- H. Dalianis and E. Hovy 1996. “Aggregation in natural language generation”. Springer.
- A.-M. Popescu, O. Etzioni, and H. Kautz.. 2003. “Towards a theory of natural language interfaces to databases”. Proceedings of the 8th international conference on Intelligent user interfaces, pages 149–157. ACM,.
- X. Meng and S. Wang. Nchiql. 2001: The chinese natural language interface to databases. In Database and Expert Systems Applications, pages 145–154. Springer,.
- N. Bertomeu, H. Uszkoreit, A. Frank, H.-U. Krieger, and B. Jorg. 2006. “Contextual phenomena and thematic ¨ relations in database a dialogues: results from a wizard-of-oz experiment”. Proceedings of the Interactive Question Answering Workshop at HLT-NAACL 2006, pages 1–8. Association for Computational Linguistics.
Index Terms
Keywords