Datawarehouses and Big Data (271146)

Learning Outcomes

Students should be able to:

1) understand the importance of the DW and the OLAP technologies to the process of management of an organization;

2) understand the importance of Big Data to the organizations including ways of how to deal with it.

Study Program

Data Warehouses: Introduction, main features, fundamental concepts (operational DB vs DW, star-schema, heterogeneous dimensions, granularity, process of creation of a DW, models with several stars, big dimensions, snow flakes schema, mini-dimensions, changes in dimension tables, factless tables, interviews, aggregates); OLAP; Big Data

Bibliography

MAIN REFERENCES:

The Data Warehouse Toolkit. The Complete Guide to Dimensional Modeling. R. Kimball e M. Ross, Wiley & Sons, 2a Ed, 2002. (Biblioteca)
SQL Server 2014 – Curso Completo. Alberto Magalhães, FCA, 2015
Mining of Massive Datasets, Jure Leskovec, Anand Rajaraman e Jeff Ullman, Cambridge University Press, disponível em http://www.mmds.org/#top