The Relational Algebra
Overview
The RA Operators
Set Operations
Select
Project
Join
"Equi" and "Natural" join
Semi Joins (not in book)
Division: R1 ? R2
Division Details of R = R1?R2
Division Examples
Aggregate Functions (not in book)
Grouping and Aggregates
Grouping Notation and Example
Relational Completeness
Notice Something Missing?
Looking Ahead: Query Processing
Email: dickey@cs.washington.edu
Home Page: http://www.cs.washington.edu/education/courses/444/99sp/
Download presentation source