ACID Properties
Atomicity, Consistency, Isolation, and Durability in databases
B-Trees vs LSM-Trees
Comparing write-optimized LSM-trees with read-optimized B-trees for database storage
Change Data Capture (CDC)
Capturing database changes for real-time replication and streaming
Isolation Levels
Read uncommitted, committed, repeatable read, and serializable isolation levels
MVCC (Multi-Version Concurrency Control)
How databases provide isolation without locking
Partitioning Strategies
Key range, hash, and composite partitioning approaches
Serializability
Ensuring transaction outcomes are equivalent to serial execution
Single-Leader Replication
Master-slave replication with one writable leader