ROLAP
- ROLAP: Relational OLAP
- Data represented in relations
- Dimension tables: structural hierarchy
Locations(locid: integer, city: string, country: string)
Products(pid: integer, pname: string, category: string, price: real);
Times(timeid: integer, date: string, week: integer, month: integer,
quarter: integer, year: integer, holiday_flag: boolean)
- Fact table: relates the dimensions to the measure of interest