SQL extensions for OLAP

8 novembro 2018, 15:30 • Diogo Ribeiro Ferreira

OLAP vs. OLTP. Data grouping and aggregation in OLAP. Grouping sets in SQL. Roll-up operation in SQL. Cube operation in SQL. Data cubes vs. relational tables. SQL/OLAP operations: window partitioning, window ordering, and window framing.

Data warehouse logical design

8 novembro 2018, 14:30 • Helena Galhardas

• DW logical schema: star, snowflake, starflake and constellation schema
  
• Hierarchies: balanced, unbalanced, recursive, generalized, ragged, alternative, parallel, and strict.
• Measures: additive, semi-additive, non-additive, derived
• Summarizability conditions.

Lab 7

8 novembro 2018, 14:00 • Diogo Ribeiro Ferreira

Lab guide about developing a complete ETL process for creating a data warehouse.

Lab 7

8 novembro 2018, 12:30 • Diogo Ribeiro Ferreira

Lab guide about developing a complete ETL process for creating a data warehouse.

Lab Guide 7: Creating a Data Warehouse

6 novembro 2018, 15:30 • João Pedro Lebre Magalhães Pereira

• ETL process to populate a data warehouse using PDI
• Resolution of the Lab Guide 7 exercises.