• HOME
• PRODUCTS
• CS PROJECTS
• EC/EE PROJECTS
• ORDER A PROJECT
• SUGGEST A PROJECT
• SUBMIT STUDENT FORM
• ABOUT US
• CONTACT US
• Log In
  Username:
  
  
  Password:
  
  
  

• Products Section
• Modems
  • Gsm modems
  • Gps modems
• Rfid readers
  • Rfid readers
  • Rfid cards
• Jammers
  • Mobile jammers
• Sensors
  • Gas sensors
  • Fingerprint sensor
  • Touch screen sensors
  • Pir sensors
• Wireless modules
• Robotics
  • Motors
• Main Menu
• Home
• Products
• CS Projects
• EC/EE Projects
• Order Project
• Suggest Project
• About Us
• Contact Us

• Home >
• AP121

Human(English) Language Based SQL Query Processing using sematic grammers

Project Platform : JAVA SQL

Languages Used : JAVA

Project Cost : 12000

Description

Nowadays interaction with computer is essential, effective process and also the storing and retrieving of data from database will play vital role in the database application. To access the Database the user should have a strong knowledge in SQL command and procedures. But this is not possible for all users. So in this we present Human Language Query Processing for Temporal Database. This will help the novice user to interact Temporal Database in their Native language (English), without using any SQL command or procedures. The conventional Database will give only current data not past or future data. But the Temporal data will support for past, present and future data. In temporal data we used third axis as time interval, which support both Transaction time as well valid time. The valid time is the actual or real world time at which the data is valid. The main aim of this system is that the human language is interpreted with Temporal Database and to produce appropriate results. This system is implemented in Java which can be used in any platform.

The general goal for most computational linguists is to instill the computer with the ability to understand and generate natural language so that eventually people can address their computers through text as though they were addressing another person.

Purpose of the System :

The main purpose of the system is to design and develop a system that can understand the  Natural Language English and can convert the natural language into data base queries. The queries are executed in the DBMS and the response will be in the Natural Language.

This project has the following modules:

• GUI
• Analyzer Module
• Parser Module
• Query Builder Module

GUI :

             Designing the front end or the user interface where the user will enter the query in Natural language.

Analyzer Module:

                This module takes the query in the natural language and looks for the synonyms for all words in the natural language query entered. The  words in query are then replaced by key words.

Parser Module:

                Analyzer module supplies keys to the Parser module. In this module we are  concerned with grouping tokens into larger syntactic classes such as expressions,  statements and procedure.

Query Builder Module:

                 In query builder module after parsing, it will construct the SQL query  based on the data available. It is the one which is responsible for retrieving the data from database depending upon the query supplied.

SnapShots :-