Column Stores (cont)
Stored representation of logical (relational) tables
- each table is stored as a set of projections (slices)
- each projection consists of a different set of columns
- each column appears in at least one projection
- "rows" can be ordered differently in each projection
Example: Enrolment(course,student,term,mark,grade)
- projection1: (course,student,grade) ordered by course
- projection2: (term,student,mark) ordered by student
- projection3: (course,student) ordered by course
|