Converting SQL to relational algebra [closed]
Asked Answered
B

2

9

Does anyone know any good online resources which I can use to practise SQL to relational algebra conversion?

Buzzer answered 24/4, 2011 at 15:25 Comment(4)
SQL is the most common way to express relational algebra on a computer. What kind of language would you convert it to?Intermezzo
possible duplicate of SQL -> Relational AlgebraIntermezzo
I just want to be able to express an SQL statement as in its relational algebraic form (using selection, projection, intersection, union etc)Buzzer
@Andomar, not a duplicate of that question. This ask a general question, the other an example SQL statement for a given query.Flawed
F
9

See: http://db.grussell.org/index.html
The following powerpoint presentation may also be of help:
http://www.cs.wayne.edu/~shiyong/csc6710/slides/kiferComp_348761_ppt05.ppt

Flawed answered 24/4, 2011 at 16:31 Comment(1)
Half answers the question. +1 nonetheless for good sources. The sources don't explain how to convert aggregate SQL operators (like GROUP BY) to RA, which is what I was looking for.Hackbut
L
9

The online tool RelaX will allow you to convert SQL to Relational Algebra. You can also compose and execute relational algebraic expressions on small datasets.

Lander answered 27/10, 2015 at 19:51 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.