Re: Expressing SQL in relational algebra

> > SQL: "SELECT * FROM T_Person WHERE (age=20) AND (weight=180);
>
> Relational Algebra:
> T_Person | age=Years(20) AND weight=Pounds(180)),
> RESTRICT(T_Person,age=Years(20) AND weight=Pounds(180)),
> T_Person WHERE ( age=Years(20) AND weight=Pounds(180) )
>
> > SQL: "SELECT * FROM T_Car JOIN
> > T_Part ON T_Car.ID = T_Part.CarID WHERE T_Part.Color = 'red'";
>
> Relational Algegra:
> ((T_Car RENAME ID AS CarID) JOIN (T_Part)) WHERE Color = Color('Red')

What is the advantage of expressing a query in relational algebra? Received on Tue Mar 18 2003 - 19:14:47 CET