project on sql query processor using nlp
DESCRIPTION
presentation of SQL Query processor using NLPTRANSCRIPT
![Page 1: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/1.jpg)
Project On SQL QUERY PROCESSOR USING NLP
Name:Prasanna BallalRoll No.: 1307
![Page 2: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/2.jpg)
Company Profile
![Page 3: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/3.jpg)
Company Profile
• Name: Omniscient Softwares Pvt. Ltd.• Address: Omniscient Software Pvt. Ltd., 501 Business Avenue, above Cosmos
Bank, Lane No. 6, off. North Main Road, Koregaon Park, Pune-411001, India.
• Omniscient is a software services company with deep domain and technology experience in the Financial Technology business. Its engagements involve high-availability enterprise class applications for some of the largest Global Financial Institutions.
• Omniscient has been a pioneer at adopting some of the leading Rich UI Development (RUI) Frameworks and Technologies like ExtJS, GWT, Flex, and JSP across various product re-engineering projects. Our primary experience has been in replacing the legacy-UI layer with a contemporary Rich-UI layer built on Web 2.0 technologies and continuing to leverage on the server-side business logic assets of the application.
![Page 4: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/4.jpg)
Need for the system
![Page 5: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/5.jpg)
Need for the system• The development of system is required to ease the naive user to search a
database by using a natural language such as English.
• To search a database a user has to learn the SQL which is sometimes difficult for the end user .
• To reduce the efforts of the end user to query a database.
![Page 6: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/6.jpg)
Scope of work
![Page 7: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/7.jpg)
Scope of work
The scope of the proposed system is as follows:
1) To work with any RDBMS one should know the syntax of the commands of that particular database software (Microsoft SQL, Oracle, etc.).
2) Here the Natural language processing is done on English i.e. the input statements have to be in English.
3) Input from the user is taken in the form of Questions like wh- form like what, who, where.
![Page 8: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/8.jpg)
Operating Environment
![Page 9: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/9.jpg)
Operating Environment
Software Requirements:
1. JDK 1.5 or above
2. IDE for the development of Java Code
3. Operating system : Windows XP or above
4. Database – SQL SERVER 2000 or ACCESS
![Page 10: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/10.jpg)
Operating Environment
Hardware Requirements:
1. 1 GB Hard Disk space
2. 512 MB RAM
3. 1GHz or above processor
4. VGA Display Adapter – with higher resolution
![Page 11: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/11.jpg)
Technology Used
![Page 12: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/12.jpg)
Technology Used
J2SE (Java 2 Standard Edition) is used for the development of the project.
Serialized Objects / Serialization - Database in Java
Project database needs are handled in java.
1. First step is to use data structures like Vectors and Lists. These come under Java Collections API
![Page 13: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/13.jpg)
Technology Used
• E.g. a class Student to hold all the student information. Now theseclasses need to be pre-compiled and called within Java application aslibraries. This is called as a Java Class Library
C. Now class objects cannot be saved to hard drive directly. We needto convert these objects to bytes so that they can be saved to harddrive. To do this we must use a concept called as Serialization.Basically it is a concept where in objects are converted to bytestreams so that they can be saved to hard drive or sent via internetand vice versa. The reverse process is called as deSerialization.
D. Finally to save these bytes to hard drive or to send them vianetwork we need Java I/O.
![Page 14: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/14.jpg)
Introduction To System
![Page 15: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/15.jpg)
Introduction To SystemKeword Management:• This phase contains declaring the notations used by the end user for a
particular SQL term.
Example 1 :
SQL term: select can have the following notations used by the user:
1)Show
2)Give
3)Display
4)provide and many more.
![Page 16: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/16.jpg)
Introduction To System
Example 2:
SQL Term: ‘ < ‘ (less than) can have the following notations :
1)less
2)lessthan
3)less than
4)lesser
5)lower and many more
The application becomes more and more efficient as we manage the more and more keywords and assign the user notations to them.
![Page 17: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/17.jpg)
Introduction To System
Alias Management:• This phase contains declaring the alias names used by the user
for the tables in the database.
Example 1:
Database Table Name: Employee user can use following notations for this:
1)emp
2)emps
3)employis(spelling mistake)
![Page 18: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/18.jpg)
Introduction To System
Example 2:
Database Table Name: Customer user can use the following notations for this:
1)cust
2)customar
3)custmer
The application becomes more and more efficient as we manage the more and more alias for the user notations.
![Page 19: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/19.jpg)
Introduction To System
• For the system to be more efficient the administrator of the system has to manage the large number of keywords and the alias used for the tables by the user.
• As the system is used more and more the administrator can add more and more keywords and alias so the system becomes more robust and can generate result for the more general queries of the user.
![Page 20: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/20.jpg)
Diagrams
1. Algorithm
2. Data Flow Diagram
3. USE case diagram
![Page 21: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/21.jpg)
Algorithm
![Page 22: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/22.jpg)
DFD Level 0
USER LOGIN
DATA SQL QUERY
QUERY
PROCESSOR
QUERY IN DATABASE
NATURAL LANGUAGE RESULT
![Page 23: Project on SQL Query Processor Using NLP](https://reader033.vdocuments.us/reader033/viewer/2022061112/54570dadb1af9f7a1c8b4eab/html5/thumbnails/23.jpg)
Thank You