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

Concept

Database administrator

Related lectures (32)

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.

File Organization and Indexing Log in to Mediaspace to watch this video

Explores file organization, record formats, indexing techniques, and index classifications in databases, emphasizing the importance of efficient data storage and access.

Life Cycle Analysis: Buildings in Swiss Context Log in to Mediaspace to watch this video

Explores Life Cycle Analysis applied to buildings in the Swiss context, covering stages, environmental impacts, and energy consumption indicators.

Transactional Memory: Two-phase Locking and Invisible Reads Log in to Mediaspace to watch this video

Explores historical perspectives and mechanisms of transactional memory, emphasizing the importance and challenges of its implementation in modern computing systems.

Transactions: Concepts and Implementations Log in to Mediaspace to watch this video

Explores the elegance and challenges of transactions, including ACID properties and transactional memory benefits in concurrent programming.

File Systems: Organization and Indexing Techniques Log in to Mediaspace to watch this video

Discusses file systems, focusing on data organization, indexing techniques, and their impact on database performance.

Tree-Structured Indexing: B+ Tree Log in to Mediaspace to watch this video

Explores tree-structured indexing with a focus on B+ trees in databases.

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.

File Organization and Indexing Log in to Mediaspace to watch this video

Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.

Data Management: Overview Log in to Mediaspace to watch this video

Introduces fundamental concepts of data management, including data models, databases, and key tasks.

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.

Transactions Log in to Mediaspace to watch this video

Explores the elegance and challenges of transactions in structuring stateful systems, emphasizing ACID properties and the trade-offs of transactional memory.