Skip to main content
Graph
Search
fr
en
Login
Search
All
Categories
Concepts
Courses
Lectures
MOOCs
People
Practice
Publications
Startups
Units
Show all results for
Home
Course
CS-422: Database systems
Graph Chatbot
Lectures in this course (104)
File Organization: Storage and Cache Management
Explores file and page organization in databases, cache management, and log-structured files.
DBMS Architecture: Query Optimization and Processing Models
Explores DBMS architecture, query optimization, and processing models for efficient query execution.
Buffer Management in DBMS
Discusses buffer management in a DBMS, covering challenges, buffer pool, and replacement policies.
Spark Storage Layer
Explores the Spark ecosystem, Resilient Distributed Datasets, and the storage layer abstraction in Spark.
Materialization Problems in Database Systems
Discusses materialization challenges in databases, query execution strategies, and performance implications.
N-ary Storage Model: Page and Record Formats
Explores the N-ary Storage Model, fixed-length and variable-length record formats, and storage hierarchy.
OLAP: Overview and Queries
Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.
Decomposition Storage Model: Column-Oriented Storage
Explores the advantages of Decomposition Storage Model with column-oriented storage and various compression techniques.
DBMS Processing Models
Explores DBMS processing models, operator boundaries, fusion, and code generation using LLVM.
PAX: Hybrid Solution for Efficient Data Storage
Presents PAX, a hybrid solution for efficient data storage, and Parquet, a columnar storage format for Hadoop.
Query Optimization: Execution Models
Explores Run-Length Encoding, Query optimization, and Execution models for efficient query processing.
Query Optimization: Introduction and Equivalences
Explores query optimization fundamentals, heuristics-based optimizers, cost estimation, and decision-making impact on performance and scalability.
Iterator Model: Query Processing in Database Systems
Explores the iterator model in query processing for database systems, focusing on tuple-at-a-time execution and interpreted expression evaluation.
Query Optimization: Heuristics and Cost-based Strategies
Explores heuristic-based query optimization, join ordering, and cost estimation strategies in database systems.
Block-oriented Execution: Query Processing in Database Systems
Explores block-oriented query processing in databases, emphasizing materialization challenges and optimized execution for data-intensive applications.
Query Optimization: Heuristics and Cost-Based Approach
Explores query optimization principles, challenges in cardinality estimation, and the impact of errors on plan selection.
Vectorization: Optimizing Query Processing in Database Systems
Explores the vectorization model in query processing for database systems, optimizing performance for OLAP queries.
Data Warehousing: Overview and Challenges
Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.
Compilation: Code Generation and Performance Optimization
Explores code generation, performance optimization, and compilation trade-offs in DBMS.
JIT Compilation: The Hyper Approach
Explores code generation approaches, operator abstractions, query compilation, data format adaptation, and operational systems in database query processing.
Previous
Page 2 of 6
Next
