Sumários
Physical design of data warehouses
14 Maio 2024, 13:00 • António Ferreira
Physical design of data warehouses: motivation; tree-based, hash-based, and bitmap indexes; clustered and multi-attribute indexes; materialized views; data compression; data partitioning; distributed storage.
ETL system
7 Maio 2024, 13:00 • António Ferreira
ETL system: staging steps of a data warehouse; conceptual ETL plan; logical data map; ETL build sequence; metadata; flat files vs. databases; data quality screens; conforming data; loading data into dimensions; handling SCD type 2 changes; loading data into facts; loading snapshot fact tables; indexes during the ETL processing; outwitting the database log; increasing ETL throughput.
Case studies in data warehousing
16 Abril 2024, 13:00 • António Ferreira
Case studies in data warehousing: order management, bus matrix, order requests, customers, prices in multiple currencies, profit and loss breakdown; customer relationship management, feed back to operational systems, outriggers, mini-dimensions, names and addresses, hierarchies; telecommunications, bus matrix, initial model, criticism, revised model; electronic commerce, clickstream, sessions and visits to individual pages, dimensions, fact tables with different grains.