Peng Cai

This book analyzes in detail the technological evolution process of databases in the era of cloud computing and explains how traditional database technology has gradually developed to cloud-native form from multiple perspectives such as architecture design, implementation mechanism, and system optimization. This book emphasizes the full combination of theory and practice and also analyzes the SQL optimization and execution, transaction processing, caching and indexing principles of databases implemented by MySQL, PostgreSQL and other systems, what trade-offs and compromises are made in the face of actual application requirements, how to optimize in the face of complex application scenarios, and the reasons behind making various choices. At the same time, combined with Alibaba Cloud's R&D experience in the database field, this book focuses on a series of core technical principles of modern database evolution from system to service, such as the use of cloud computing resource pooling technology and distributed technology to achieve high availability, elastic expansion, and on-demand use of databases. The book is informative, combines theoretical depth and implementation details, and openly explores the new development direction of the database, which can inspire readers to think further.

Transaction processing is fundamental for many modern applications. These applications require the backend transaction processing engines to be available at all times as well as provide a massive horizontal scale for intensive transaction requests.Concurrency Control and Recovery features recent progress in research in online transaction processing. The book also showcases the authors' research on a highly scalable OLTP system. Its contents include the designs of an efficient multiple version storage engine, a scalable range optimistic concurrency control, high-performance Paxos-based log replication, global snapshot isolation, and fast follower recovery.This book is written for professionals, researchers, and graduate students specialising in database systems and its related fields.