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
Wind Power Forecasting Through Supervised Machine Learning Techniques
We will forecast the wind speed in long and short terms time horizons. We will use the sup...
E-doctor
my project is E-doctor, which is software based (android and IOS). patients use that softw...
E Banking
E-Banking is web-based Banking. Now a day due to emerging global economy, e-commerceand e-...
IoT Based Mobile Application for detecting and monitoring hazardous ga...
The Basic need of this product for those industries/homes where people are working wi...
IOT based Garbage monitoring system
Nowadays, there are tons of flats and apartments which have been built in the rapid urbani...