Indian Journal of Science and Technology

Open Access Open Access  Restricted Access Subscription Access

Intelligent Query Processing in Temporal Database Using Efficient Context Free Grammar


Affiliations
1 Karpagam University, Coimbatore, Tamil Nadu-641021, India
2 Hindusthan Institute of Technology, Coimbatore, Tamil Nadu-641032, India
 

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.

Keywords

Intelligent Query Processing, Temporal Database Context Free Grammar
User

  • Abraham T and Roddick JF (1999) Survey of spatiotemporal databases. GeoIn-formatica. 3(1), 61–99.

  • Androutsopoulos I, Ritchie G and Thanisch P Masque/sql (1993) A client and portable natural language query interface for relational databases. Database technical paper, Department of AI, University of Edinburgh.

  • Gauri Rao, ChanchelAgarwal, SnehalChaudry, NikithaKulkarni and Patel SH (2010) Natural language query processing using semantic grammar. Int. J. Comput. Sci. Eng. Vol 02 No 02 219-223.

  • Gauri Rao and Patel SH (2009) Natural language query processing. Int. J. Comput. Appl. Eng. & Technol. & Sci. Vol 6 No. 2 495-505.

  • HuangiGuiaogZangi and PhilipC-Y Sheu (2008) A natural language database Interface based on probabilistic context free grammar. IEEE Intl. Workshop on Sematic Comput. & Sys. 155-162.

  • Jaymin Patel (2003) Department of computing, Imperial college, University of London M. Eng. Temporal database Sys. Individual Project on 18th June.

  • Piero Andrea Bonatti Elisa Bertino and Elena Ferrari Trbac (2001) A temporal role-based access control model. ACM Trans. Information & Sys. Security. 4(3), 191–223.

  • Ramasubramanian P and Kannan A (2004) Temporal event matching approach based natural query processing in temporal databases. Int. J. Information Technol. 10(1), 88-100.

  • Tansel, Cliord, ShashiGadia, and Richard Snodgrass (1993) Temporal databases: Theory, Design and Implementation. Database Sys. & Appli. Series. Benjamin/Cummings, Redwood City, CA, 2nd ed. 633- 640.

  • Tsz Cheng S and Gadia SK (2002) Member IEEE Computer Society The Event Matching Language for Querying Temporal Data. IEEE Trans. Knowledge & Data Engg. 14(5), 1119–1125.

  • VijayalakshmiAtluri and Avigdor Gal (2002) An authorization model for temporal and derived data: Securing information portals. ACM Trans. Information & Sys. Security. 5(1), 62–94.

  • Winiwarter W and Ismail Khalil Ibrahim (2000) A multilingual natural language interface for ecommerce applications. Ph.D. thesis, University of Vienna, Austria. ACM 26(11):832-843


Abstract Views: 404

PDF Views: 123




  • Intelligent Query Processing in Temporal Database Using Efficient Context Free Grammar

Abstract Views: 404  |  PDF Views: 123

Authors

K. Murugan
Karpagam University, Coimbatore, Tamil Nadu-641021, India
T. Ravichandran
Hindusthan Institute of Technology, Coimbatore, Tamil Nadu-641032, India

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.

Keywords


Intelligent Query Processing, Temporal Database Context Free Grammar

References





DOI: https://doi.org/10.17485/ijst%2F2012%2Fv5i6%2F30481