Smart Interface

Project Title

Smart Interface

Project Area of Specialization Artificial IntelligenceProject Summary

Smart Interface is a web-based application that facilitates the non-professional user to interact with database using natural language instead of Database Query Language. User will be able to INSERT, SELECT, UPDATE, MIN, MAX, on any unknown tables of any database using inner joins.The system will b generic for every database using NLP.

The  system includes two modules: natural language processor or linguistic module and database module. This system processes the user's request in Natural English language. The request should be domain specific. The query in natural language is then translated into equivalent SQL statement and finally SQL statement will be executed to perform desired function on the database. User will be able to access Database using Natural Language (English). There will be no need of SQL syntax from user end. Both non-technical and technical people can use it. There will be no predefined constraint regarding the selection of the words, but it should be domain specific and tables name of database should be proper nouns.

Project Objectives

To interact with database, one should have technical knowledge of database. Our system aims to facilitate non technical user to extract and manipulate data from database without taking help of DB developer in natural language(English).

Project Implementation Method

The  system includes two modules: natural language processor or linguistic module and database module. This system processes the user's request in Natural English language.The query in natural language is then translated into equivalent SQL statement and finally SQL statement will be executed to perform desired function on the database. User will be able to access Database using Natural Language (English). There will be no predefined constraint regarding the selection of the words.Tables and Column names of database should be proper nouns.

Benefits of the Project

The smart interface aims to enable users to interact with databases on the basis of natural language which is innovative.The current system is made up of  static forms and static queries.It has a learning phase.Our system aims to reduce that learning phase and making interaction with database more natural,easy ans innovative.

Technical Details of Final Deliverable

FR # 1	The system shall a­llow the user to input Natural Language Query.
FR # 2	The system shall generate SQL Query.
FR # 3 FR # 4	System shall be able to store and retrieve data. System shall be able to store and retrieve data using inner joins.
FR # 5	The user shall be able to execute the SQL Query.
FR # 6	The system shall able to fetch the records from Database

FR # 1

FR # 2

FR # 3

FR # 4

FR # 5

FR # 6

Final Deliverable of the Project Software SystemType of Industry IT Technologies Artificial Intelligence(AI)Sustainable Development Goals Industry, Innovation and InfrastructureRequired Resources

Elapsed time in (days or weeks or month or quarter) since start of the project	Milestone	Deliverable
Month 1	SRS submission	SRS report
Month 2	website development	online website
Month 3	Generic Database import and configurations	User Portal
Month 4	Natural Language Module development and integration	working FYP
Month 5	Testing on different databases	Improved Accuracy