Database Notes Index Complete collection of database concepts, architecture, and best practices. Table of Contents Topic Category Introduction to ACID ACID What is a Transaction ACID Atomicity ACID Isolation ACID Consistency ACID Durability ACID Row based & Column based DB Database Internal Database Pages Database Internal Indexing Indexing SQL query planner, optimizer Indexing Bitmap index scan vs index scan vs table scan Indexing Key vs Non-key column database indexing Indexing Index Scan vs Index Only Scan Indexing How Database Optimizers Decide to Use Indexes Indexing Create Index Concurrently - Avoid Blocking Production Database Writes Indexing The Cost of Long running Transactions Indexing B-Tree vs B+Tree BTree Vertical vs Horizontal Partitioning Partitioning Sharding Sharding Shared vs Exclusive Locks Concurrency Control Two-Phase Locking (2PL) in PostgreSQL Concurrency Control Offset pagination is slow Concurrency Control Database connection pooling Concurrency Control Master-Standby Replication Database Replication Multi Master Replication Database Replication What is Database Cursors? Database Cursors MongoDB Clustered Collections NoSQL Memcached In-Memory Cache Architecture NoSQL What is a Distributed Transaction? Transaction
