This guide organizes database systems from traditional relational databases to highly distributed NoSQL systems, focusing on their consistency models, ACID compliance, CAP theorem trade-offs, and reconciliation mechanisms.