Fundamentals of database systems

Fundamentals of database systems - Course Introduction

Query Optimization: Equivalent Expressions and Simple Equivalance Rules

Database Transactions: Properties and Failures

Query Optimization: Complex Equivalence Rules

Big Data

Query Optimization: Join Order

Concurrency Control: Locks

Schedules: View Serializability

Concurrency Control: Timestamp Ordering Protocol

Concurrency Control: Multiple Granularity for Locks

Database Transactions: States and Systems

Recovery Systems: Checkpointing and Shadow Paging

Recovery Systems: Deferred Database Modification

Concurrency Control: Two-phase Locking Protocol

Concurrency Control: Deadlock Recovery and Update Operations

Schedules: Introduction

Schedules: Recoverability

Schedules: Result Equivalence and Testing for Serializability

Concurrency Control: Deadlock Prevention and Deadlock Detection

Recovery Systems: Immediate Database Modification.

Query Optimization: Heuristics and Sizes

Schedules: Conflict Serializability

NoSQL: Different NoSQL Systems

NoSQL: Introduction and Properties

NoSQL: Columnar Families

Fundamentals of database systems - Course Introduction