Skip to main content
Graph
Search
fr
en
Login
Search
All
Categories
Concepts
Courses
Lectures
MOOCs
People
Quizes
Exercises
Publications
Startups
Units
Show all results for
Home
Lecture
Cost-based Query Optimization
Graph Chatbot
Related lectures (51)
Optimizing Recursive Queries
Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.
NoSQL Databases: Origins and Types
MOOC: Geographical Information Systems 1
Covers the origins and types of NoSQL databases, focusing on MongoDB and CRUD operations.
Query Fusion, Nested Queries
MOOC: Geographical Information Systems 1
Covers query fusion, nested queries, and SQL operators in a geographical context.
Query Operators: Joins and Query Processing Techniques
Log in to Mediaspace to watch this video
Discusses advanced query operators, focusing on join techniques and their processing methods in relational databases.
Query Processing: Relational Operations and Models
Log in to Mediaspace to watch this video
Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.
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.
Materialization Problems in Database Systems
Log in to Mediaspace to watch this video
Discusses materialization challenges in databases, query execution strategies, and performance implications.
Relational Query Optimization
Log in to Mediaspace to watch this video
Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Query Operators: Part 1
Log in to Mediaspace to watch this video
Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Efficient GPU Join Optimization
Log in to Mediaspace to watch this video
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Query Optimization: Improving Database Performance
Log in to Mediaspace to watch this video
Discusses query optimization in database systems, emphasizing the impact on performance and the decisions involved in improving database performance.
Query Optimization: Heuristics and Cost-Based Approach
Log in to Mediaspace to watch this video
Explores query optimization principles, challenges in cardinality estimation, and the impact of errors on plan selection.
Data-Intensive Systems: Relational Model and Algebra
Log in to Mediaspace to watch this video
Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.
Block-oriented Execution: Query Processing in Database Systems
Log in to Mediaspace to watch this video
Explores block-oriented query processing in databases, emphasizing materialization challenges and optimized execution for data-intensive applications.
Efficient GPU Join Optimization
Log in to Mediaspace to watch this video
Discusses efficient GPU-accelerated join optimization for complex queries, aiming to improve optimization times and heuristic plan quality.
Compilation: Code Generation and Performance Optimization
Log in to Mediaspace to watch this video
Explores code generation, performance optimization, and compilation trade-offs in DBMS.
Storage Technologies Overview
Log in to Mediaspace to watch this video
Covers the basics of storage technologies and database system architecture.
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.
Relational Model: Basics
Log in to Mediaspace to watch this video
Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Optimization Heuristics: Example of INGRES Database System
Log in to Mediaspace to watch this video
Explores heuristic-based optimization using the INGRES database system example.
Previous
Page 1 of 3
Next
