Query Operators Part 2Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
Relational Query OptimizationCovers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Parallel & Distributed DBMSCovers the architecture of parallel databases, benefits of parallelism, distributed databases, and replication methods.
Hashing and SortingCovers hashing, sorting, extendible hashing, linear hashing, and external sorting.
Query OptimizationCovers query optimization, from logical to physical plans, including query transformation and cost estimation.
Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Architecture of CockroachDBExplores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.
Biological Contaminants: PathogensCovers the definition of biological contaminants and the transmission of pathogens, including emerging infectious diseases and antibiotic resistance.
Relational AlgebraIntroduces relational query languages, focusing on algebra operators and query optimization.
Terminating Reliable Broadcast & NBACExplores Terminating Reliable Broadcast and Non-Blocking Atomic Commit in distributed systems, covering agreement, consensus, and transaction commitment.