ANTI-TERRORIST VEHICLE
java,embedded c,8051 family
ANDROID BASED HOME AUTOMATION
android,java,embedded c,89x51 chip,webba
GSM based E-Notice Board Wireless Communicati
embedded c,89x51 microcontroller
Domestic Servers
android application,mysql server
Eskin-care
joomla,mysql server,cloud server
Location Based Advertisement Services in Andr
java,android,php,joomla
Farm Mitra
android application,bootstrap,mysql serv
ADVANCED OFFICE AUTOMATION SYSTEM USING GSM A
java,embedded c,89x51 family chip
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 :-
