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 条
  • [22] SQL query optimization through nested relational algebra
    Cao, Bin
    Badia, Antonio
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2007, 32 (03):
  • [23] A QUERY INTERFACE FOR IMAGE DATABASES BASED ON RELATIONAL ALGEBRA
    NG, CS
    SACKSDAVIS, R
    AUSTRALIAN COMPUTER JOURNAL, 1986, 18 (01): : 1 - 8
  • [24] Implementation of Relational Algebra Operations for Web
    Ikhsan, Rijal Fajriatul
    Hasbi, Muhammad
    2016 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND CYBERNETICS, 2016, : 121 - 126
  • [26] XML query algebra operators, and strategies for their implementation
    Abraham, J
    Chaudhari, NS
    Prakash, EC
    TENCON 2004 - 2004 IEEE REGION 10 CONFERENCE, VOLS A-D, PROCEEDINGS: ANALOG AND DIGITAL TECHNIQUES IN ELECTRICAL ENGINEERING, 2004, : B286 - B289
  • [27] PSQL: A query language for probabilistic relational data
    Dey, D
    Sarkar, S
    DATA & KNOWLEDGE ENGINEERING, 1998, 28 (01) : 107 - 120
  • [28] PIQUE - A RELATIONAL QUERY LANGUAGE WITHOUT RELATIONS
    MAIER, D
    ROZENSHTEIN, D
    SALVETER, S
    STEIN, J
    WARREN, DS
    INFORMATION SYSTEMS, 1987, 12 (03) : 317 - 335
  • [29] Interfaces to Query Relational Databases in Natural Language
    Singh, Harjit
    IT PROFESSIONAL, 2019, 21 (01) : 67 - 73
  • [30] Implementation of Language Interpreter based on Reusable Components
    Du Genyuan
    Miao Fang
    2009 INTERNATIONAL CONFERENCE ON EDUCATION TECHNOLOGY AND COMPUTER, PROCEEDINGS, 2009, : 53 - 55