ScholarLens Back to search
2010•Unpublished venueRequires access

Implementation of Relational Algebra Interpreter Using Another Query Language

Ratnesh Litoriya, Anshu Ranjan

Open publisher page 2 citations

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.

About this research paper

What this paper is about

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.

Why it matters

OpenAlex reports 2 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Computer science, Codd's theorem, Relational algebra, SQL, Programming language, Relational database, Conjunctive query, Relational calculus

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Implementation of Relational Algebra Interpreter Using Another Query Language — Research Paper | ScholarLens