Data warehousing

28 Fevereiro 2023, 13:00 António Ferreira

Data warehousing: differences between operational and Decision Support Systems (DSS); history of DSS. Data warehouse objectives; support for decision making; internal elements; comparison with federated databases. Multidimensional data models; data cubes and star schemas; operations on data cubes; data warehouse development process. Open Data definition and requirements; comparison with Big Data; data formats and distribution; some data repositories.