Lectures related to Data mart | EPFL Graph Search

Data Warehouses and Decision Support Systems

Explores data warehouses, decision support systems, OLAP, data lakes, multidimensional data models, and query optimizations.

OLAP Data Model: Multidimensional and Relational Approaches

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

OLAP: Overview and Queries

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

Data Warehousing and Decision Support

Explores data warehousing, decision support systems, and the importance of statistics in data analysis.

OLAP Queries and Optimizations

Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.

OLAP Queries: Aggregations, Cube Operator, and Optimizations

Explores OLAP queries, cube operator, super-aggregates, and optimization techniques.

Data Warehousing: Overview and Challenges

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

Views: Simplifying SQL Queries

Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.

Data Warehouses and Decision Support Systems

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

Views: SQL Queries Simplification

Explores how views simplify query writing and are key in data warehouses.

Exam Instructions: Types of Questions and Code Grading

Covers exam instructions, types of questions, and code grading for understanding concepts and coding.

Distributed Query Processing: Execution Models and Declustering Tradeoffs

Covers analytical query processing, declustering strategies, and distributed operations.

Data Lakes: Structure and Optimization

Explores data lakes, data structure, and optimization for effective querying.

Data formats and data wrangling with Hadoop

Explores Apache Hive for data warehousing, data formats, and partitioning, with practical exercises in querying and connecting to Hive.

Data Warehouses and Data Lakes

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

Database Systems: Overview

Introduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.

Data Wrangling: Structuring and Wrangling Issues

Covers data wrangling stages, structuring techniques, and common issues in data preparation.

Semi-Structured Data

Explores semi-structured data, embedding schema information to explain data values and relationships, discussing XML, schema-less data benefits, and serialization.

Data Warehouses: Introduction and Challenges

Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.

Data-Intensive Applications and Systems: Overview

Covers the exponential growth of data, challenges in processing technology, data variety, cleaning, approximate query processing, multi-query analytics, and hybrid transaction processing.