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.