Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Home

Lecture

Data Warehouses and Decision Support Systems

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (48)

Data-Intensive Applications and Systems: Overview Log in to Mediaspace to watch this video

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

OLAP Data Model: Multidimensional and Relational Approaches Log in to Mediaspace to watch this video

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

Accelerating Data Analytics: Innovations in Post-Moore Era Log in to Mediaspace to watch this video

Covers advancements in data analytics systems and the role of hardware-software co-design in enhancing performance in the Post-Moore era.

Data Warehouses and Decision Support Systems Log in to Mediaspace to watch this video

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

Views: Simplifying SQL Queries Log in to Mediaspace to watch this video

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

Query Processing with Relational Operations Log in to Mediaspace to watch this video

Covers query processing with relational operations, including query optimization and different join algorithms.

Semantic Web: Overview and Tools Log in to Mediaspace to watch this video

Explores the Semantic Web, ontologies, schema mapping, RDF, and knowledge graphs.

Distributed Information Systems: Overview and Course Information Log in to Mediaspace to watch this video

Covers key concepts of Distributed Information Systems and course logistics.

Introduction to Database Systems Log in to Mediaspace to watch this video

Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.

Query Optimization: Heuristics and Cost-based Strategies Log in to Mediaspace to watch this video

Explores heuristic-based query optimization, join ordering, and cost estimation strategies in database systems.

Knowledge Representation: Semantics and Data Structures Log in to Mediaspace to watch this video

Explores knowledge representation, data structures, semantics, and the challenges of searching for data on the web.

Untitled Log in to Mediaspace to watch this video

Query Processing: Operations Overview Log in to Mediaspace to watch this video

Explores query processing operations, join conditions, set operations, and buffering impact on query performance.

Data Processing at Massive Scale: Query Optimization Techniques Log in to Mediaspace to watch this video

Discusses query optimization techniques for data processing at massive scale, comparing optimization strategies and sharing opportunities to reduce processing costs.

System-R Optimizer: Query Optimization and Cost Estimation Log in to Mediaspace to watch this video

Explores the System-R Optimizer, query optimization, cost estimation, join orderings, and cardinality challenges in database systems.

Query Optimization: Introduction and Equivalences Log in to Mediaspace to watch this video

Explores query optimization fundamentals, heuristics-based optimizers, cost estimation, and decision-making impact on performance and scalability.

Query Optimization: Execution Models Log in to Mediaspace to watch this video

Explores Run-Length Encoding, Query optimization, and Execution models for efficient query processing.

JIT Compilation: The Hyper Approach Log in to Mediaspace to watch this video

Explores code generation approaches, operator abstractions, query compilation, data format adaptation, and operational systems in database query processing.

Cost-based Query Optimization Log in to Mediaspace to watch this video

Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.

Relational Algebra and SQL: Foundations of Database Management Log in to Mediaspace to watch this video

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Page 2 of 3