Smart Interface
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
Project Title
Smart Interface
Project Area of Specialization
Project 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 allow 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
Type of Industry
Technologies
Sustainable Development Goals
Required 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 |
If you need this project, please contact me on contact@adikhanofficial.com
Justice at your door
As the world increasingly progresses towards a technology-driven environment, the legal se...
Design and Development of a Generic multipupse Biomedical IoT Device
This project develops a medical device for multi-purpose use in healthcare. Important comp...
Motorcycle Ambulance
Road accidents are very common in developing countries especially in Pakistan and the situ...
Drug Scan
Most of the patients takes medicines as prescribed by Doctors without knowing its side eff...
Crime Tracker
While browsing facebook groups we found a group where people of Karachi reported their los...