Data Warehousing Part 19.11.10: Data warehousing: introduction, business intelligence, data integration, OLTP vs. OLAP, DW definition [slides] 23.11.10: Data warehousing: multidimensional modeling, cubes, facts, dimensions, DW design [slides] 30.03.10: Data warehousing: more about dimensions, star scheme, snowflake scheme, DW implementation, DW applications [previous lecture] 03.12.10: Data warehousing: case studies [slides] 07.12.10: SQL OLAP extensions: SQL query expression, crosstabs, group by extensions, rollup, cube, grouping sets [slides] [sql] [sql] [sql] [sql] [sql] 10.12.10: SQL OLAP extensions: hierarchical cube, ranking, window functions [previous lecture] 14.12.10: Generalized multi-dimensional join: GMDJ definition, evaluation algorithms [slides] [Akinde et al. 11] [Chatziantoniou et al. 01] [Akinde et al. 02] [sql] 17.12.10: Generalized multi-dimensional join: subqueries, optimization rules, distributed evaluation [previous lecture] 21.12.10: DW performance: pre-aggregation, lattice framework, view selection [slides] [Harinarayan et al. 96] [Wu and Buchmann 98] 11.01.11: DW performance: view selection, view maintenance, bitmap indexing [previous lecture] 18.01.11, 08:30-10:30, E411: ETL and advanced modeling: ETL process [slides] 18.01.11, 10:30-12:30, E411: ETL and advanced modeling: changing dimensions, large-scale dimensional modeling [previous lecture]

Data Warehousing Part

1. 19.11.10: Data warehousing: introduction, business intelligence, data integration, OLTP vs. OLAP, DW definition [slides]
2. 23.11.10: Data warehousing: multidimensional modeling, cubes, facts, dimensions, DW design [slides]
3. 30.03.10: Data warehousing: more about dimensions, star scheme, snowflake scheme, DW implementation, DW applications [previous lecture]
4. 03.12.10: Data warehousing: case studies [slides]
5. 07.12.10: SQL OLAP extensions: SQL query expression, crosstabs, group by extensions, rollup, cube, grouping sets [slides] [sql] [sql] [sql] [sql] [sql]
6. 10.12.10: SQL OLAP extensions: hierarchical cube, ranking, window functions [previous lecture]
7. 14.12.10: Generalized multi-dimensional join: GMDJ definition, evaluation algorithms [slides] [Akinde et al. 11] [Chatziantoniou et al. 01] [Akinde et al. 02] [sql]
8. 17.12.10: Generalized multi-dimensional join: subqueries, optimization rules, distributed evaluation [previous lecture]
9. 21.12.10: DW performance: pre-aggregation, lattice framework, view selection [slides] [Harinarayan et al. 96] [Wu and Buchmann 98]
10. 11.01.11: DW performance: view selection, view maintenance, bitmap indexing [previous lecture]
11. 18.01.11, 08:30-10:30, E411: ETL and advanced modeling: ETL process [slides]
12. 18.01.11, 10:30-12:30, E411: ETL and advanced modeling: changing dimensions, large-scale dimensional modeling [previous lecture]