Introduction to Data Warehousing (cont.) and Online Analytical Processing (OLAP)

28 outubro 2019, 15:30 • Helena Galhardas

Introduction to Data Warehousing (cont.):

  • Multidimensional model
  • Typical Data Warehouse Architecture
Online Analytical Processing (OLAP):
  • OLAP vs OLTP (Online Transaction Processing)
  • OLAP: Data Grouping and Aggregation
  • SQL/OLAP: GROUPING SETS; ROLLUP, CUBE, Window Partitioning, Window Ordering, Window Framing.