Description
Book SynopsisDiscover critical considerations and best practices for improving database performance based on what has worked,and failed,across thousands of teams and use cases in the field. This open access book provides practicalguidance for understanding thedatabase-related opportunities, trade-offs, and traps you might encounter while trying to optimize data-intensive applications for high throughput and low latency. Whether you are building a new system from the ground up or trying to optimize an existing use casefor increased demand, this book covers the essentials. The book begins with a look at the many factors impacting database performance at the extreme scale that today's game changing applications faceor at least hope to achieve. You'll gain insight into the performance impact of both technical and business requirements, and how those should influence your decisions around databaseinfrastructureand topology. The authors share an inside perspective on often-overlooked engi
Table of Contents1: A Taste of What You’re Up Against: Two Tales.- 2: Your Project, Through the Lens of Database Performance .- 3: Database Internals: Hardware and Operating System Interactions.- 4: Database Internals: Algorithmic Optimizations.- 5: Database Drivers.- 6: Getting Data Closer.- 7: Infrastructure and Deployment Model.- 8: Topology Considerations.- 9: Benchmarking.- 10: Monitoring.- 11: Administration.- Appendix: A Brief Look at Fundamental Database Design Decisions.