Database Transactions and Consistency Models: A Comprehensive Guide Understanding ACID properties, isolation levels, and consistency models in distributed systems 2025-12-15