An Alternative For Database Queries:Auto Query Forms

Modern databases contains very huge amount of data. Also the databases have exists various complex relationships among them. These databases contains over thousands of relations and their entities. Existing query forms are unable to generate queries dynamically as per the user requirements. Alternative Query Form which takes input in the form of human understandable language and converts it into appropriate SQL query and the query will be fired on relational database to fetch the appropriate data. It is very easy and convenient to ask questions to database in natural language especially to the non-technical users who do not understand the database query language such as SQL. Our system will provide easy access to complex databases using NLP which perform lexicon processing, query formulation, and dynamic generation of SQL queries which can be easily reused or modified.

[1]  Liang Tang,et al.  Dynamic Query Forms for Database Queries , 2014, IEEE Transactions on Knowledge and Data Engineering.

[2]  Joseph M. Hellerstein,et al.  Improving data quality with dynamic forms , 2009, 2009 International Conference on Information and Communication Technologies and Development (ICTD).

[3]  Michael McGill,et al.  Introduction to Modern Information Retrieval , 1983 .