Intelligent query processing in temporal database using efficient context free grammar

Abstract

Now a day's interaction with computer become essential, efficient processing, storing and retrieving of data from database will play very important role in the database application. To access the database the user should have a strong knowledge in SQL commands and procedures. The conventional database will give only current data but not past or future data. In this paper we propose an Intelligent Query Processing (IQP) for temporal databases. This will facilitate the novice user to interact temporal database in their native language (English), without using any SQL command or procedures. The main purpose of IQP is for an English sentence to be interpreted by the computer and appropriate action taken. Asking questions to databases in natural language is a very convenient and easy method of data access. 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. This paper proposes the architecture for translating English Query into SQL using efficient context free grammar. This system has been implemented using Java that can be used in any operating system and has been tested with data from the industry domain.