Relational Algebra consists of
several groups of operations
Unary Relational
Operations
SELECT (symbol: s (sigma))
PROJECT (symbol: _ (pi))
RENAME (symbol: r (rho))
Relational
Algebra Operations From Set Theory
UNION ( U ), INTERSECTION ( _ ),
DIFFERENCE (or MINUS, – )
CARTESIAN PRODUCT ( x )
Binary
Relational Operations
JOIN (several variations of JOIN
exist)
DIVISION
Additional
Relational Operations
OUTER JOINS, OUTER UNION
Unary Relational
Operations
SELECT (symbol: s (sigma))
PROJECT (symbol: _ (pi))
RENAME (symbol: r (rho))
0 comments