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

Concept

Query language

Related lectures (32)

Database Management Systems: Fundamentals Log in to Mediaspace to watch this video

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

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.

Real-time Update of Column Store on Disk Log in to Mediaspace to watch this video

Explores challenges and solutions for real-time updates on large column stores on disk, focusing on snapshot isolation and query performance.

OLAP Queries: Aggregations, Cube Operator, and Optimizations Log in to Mediaspace to watch this video

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

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 Sampling Paradigm Shift Log in to Mediaspace to watch this video

Discusses data sampling as a paradigm shift to optimize processing time and reduce overheads in query engines.

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.

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.

Query Operators Part 2 Log in to Mediaspace to watch this video

Covers query processing with relational operations, focusing on different join methods and the impact of buffering.

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 Optimization: Multi-query Optimization Log in to Mediaspace to watch this video

Explores database query optimization, discussing static versus dynamic optimization, scan sharing, and the impact on DBMS performance.

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.