Title :
Implementation of Relational Algebra Interpreter Using Another Query Language
Author :
Litoriya, Ratnesh ; Ranjan, Anshu
Author_Institution :
Comput. Sci. & Eng., Jaypee Inst. of Eng. & Technol., Guna, India
Abstract :
Relational database systems have succeeded commercially because of their straightforwardness and well-built theoretical foundation. This paper ¿Implementation of Relational Algebra Interpreter using another query language¿ has been designed, implemented and tested in such a way so that queries written in relational algebra can be compiled into SQL and executed on a relational database system. The implementation takes a relational algebra statement as input, does syntactic and lexical parsing on it. In the event of an error in the syntax of the expression it will forward the error to user. If the syntax is correct the relational algebra expression is converted into a SQL statement and executed on an RDBMS. This application can serve as a basis learning Relational Algebra for students as well as for different class of users, as they will be given immediate feedbacks about their queries.
Keywords :
SQL; error analysis; program interpreters; relational algebra; relational databases; RDBMS; SQL; lexical parsing; query language; relational algebra interpreter; relational database systems; syntactic parsing; Algebra; Computer science; Data engineering; Database languages; Database systems; Information science; Memory; Program processors; Relational databases; System testing; Relational Algebra; interpreter; parser; structured query language;
Conference_Titel :
Data Storage and Data Engineering (DSDE), 2010 International Conference on
Conference_Location :
Bangalore
Print_ISBN :
978-1-4244-5678-9
DOI :
10.1109/DSDE.2010.33