How to use RELAX (Relational Algebra Calculator)

preview_player
Показать описание
A quick video on how to use Relax
For loading the Group you need to click "use Group in editor".
Please keep in mind that Relax is case sensitive, and give spaces.
Also, strings are denoted in single quotes inside queries.
Рекомендации по теме
Комментарии
Автор

I saw this video 2 years ago when I was trying to learn relax. Now I am a TA and back here to understand what the shit I learnt back then

this shit is definitely not RELAXing:)

lessgo
Автор

The developers need this video in they website! Thanks!

tutorialesmagicos.
Автор

Thank you so much bro for uploading this video.

rishabhjain
Автор

Do you know how to convert SQL queries into Relational Algebra in RelaX
It is mentioned in the website Calculator features: that it can convert SQL queries into Relational Algebra
If you know please help me ASAP

Ai-infoo
Автор

anyone know if there's a way in this program to assign a result to a new/temporary relation for use later?
R1 <-
R2 <- yyyy
R1 - R2

Having to put everything in a single query is messy (and means you can't incrementally test R1, then R2, then R3). I'm doing the best I can by using multilines and brackets/indents but it's still hopeless compared to temporary relations. Or maybe there's another program that supports this? Here's one of my queries I'd like to break up:

π cName(
Group ⨝ (
π dID σ place = 'America' (Coach ⨝ Group) - π dID σ price > 0 (Coach ⨝ sport) -
π dID (σ sportcount < 2 (γ gID ; count(*)->sportcount ( Play )) ⨝ Coach)
)
)

Would like to do:

R1 <- π dID σ place = 'America' (Coach ⨝ Group) - π dID σ price > 0 (Coach ⨝ sport)
R2 <- π dID (σ sportcount < 2 (γ gID ; count(*)->sportcount ( Play )) ⨝ Coach)
R3 = (R1 - R2) ⨝ Group
answer = π cName(
R3)

liamhudson
join shbcf.ru