Online analytical processing

Related lectures (28)

Page 2 of 3

Explains OLAP data models, focusing on multidimensional and relational approaches.

Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.

Provides an overview of HTAP systems, covering concurrency control, data layout, consolidation trade-offs, and workload-driven snapshot efficiency.

Presents PAX, a hybrid solution for efficient data storage, and Parquet, a columnar storage format for Hadoop.

Explores views in data warehouses, materialization tradeoffs, top-k queries optimizations, and the impact of column stores.

Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.

Explores challenges in data growth for advertisers and introduces Crocodile DB for resource-efficient query processing.

Covers operational analytics, focusing on the adaptive STEP system for efficient access to fresh data in analytical processing.

Explores hardware changes, query optimization, workload distribution, and effective strategies for academia and work-life balance.

Covers data warehouses, data lakes, OLTP vs. OLAP, data quality, and the Data Lakehouse concept.