Implementation of Relational Algebra Interpreter using another query language

被引:1
|
作者
Litoriya, Ratnesh [1 ]
Ranjan, Anshu [2 ]
机构
[1] Jaypee Inst Engn & Technol, Comp Sci & Engn, Guna, India
[2] Univ Florida, Comp Informat Sci & Engn, Gainesville, FL USA
关键词
Relational Algebra; structured query language; parser; interpreter;
D O I
10.1109/DSDE.2010.33
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:24 / 28
页数:5
相关论文
共 50 条
  • [31] PSQL: A query language for probabilistic relational data
    Dey, Debabrata
    Sarkar, Sumit
    Data and Knowledge Engineering, 1998, 28 (01): : 107 - 120
  • [32] ALGEBRA AND QUERY LANGUAGE FOR A HISTORICAL DATA MODEL
    SARDA, NL
    COMPUTER JOURNAL, 1990, 33 (01): : 11 - 18
  • [33] TIME-BASED OPERATORS FOR RELATIONAL ALGEBRA QUERY LANGUAGES
    BASSIOUNI, MA
    LLEWELLYN, MJ
    MUKHERJEE, A
    COMPUTER LANGUAGES, 1993, 19 (04): : 261 - 276
  • [34] PROCEDURAL AND NON-PROCEDURAL QUERY LANGUAGES REVISITED - A COMPARISON OF RELATIONAL ALGEBRA AND RELATIONAL CALCULUS
    HANSEN, GW
    HANSEN, JV
    INTERNATIONAL JOURNAL OF MAN-MACHINE STUDIES, 1987, 26 (06): : 683 - 694
  • [35] IMPLEMENTATION OF A STRUCTURED ENGLISH QUERY LANGUAGE
    ASTRAHAN, MM
    CHAMBERLIN, DD
    COMMUNICATIONS OF THE ACM, 1975, 18 (10) : 580 - 588
  • [36] The design and implementation of an intelligent query tool for relational databases
    Kok, AJ
    EXPERT SYSTEMS, 1995, 12 (04) : 347 - 352
  • [37] An Implementation of a Query Language with Generalized Quantifiers
    Badia, Antonio
    Debes, Brandon
    Cao, Bin
    Conceptual Modeling - ER 2008, Proceedings, 2008, 5231 : 547 - 548
  • [38] Efficient Implementation of Generalized Quantification in Relational Query Languages
    Cao, Bin
    Badia, Antonio
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2013, 6 (04): : 241 - 252
  • [39] BtSQL: nested bitemporal relational database query language
    Atay, Canan
    Tansel, Abdullah Uz
    TURKISH JOURNAL OF ELECTRICAL ENGINEERING AND COMPUTER SCIENCES, 2014, 22 (02) : 479 - 498
  • [40] A RELATIONAL-CALCULUS QUERY LANGUAGE FOR HISTORICAL DATABASES
    BASSIOUNI, MA
    LLEWELLYN, MJ
    COMPUTER LANGUAGES, 1992, 17 (03): : 185 - 197