Description
Pack your field kit—this is a guided safari through today’s database ecosystem. In the wild, one size rarely fits all: Modern systems often need specialized databases to deliver realâworld performance and scale. This book is a practical field guide to those less commonly used databases—vector, timeâseries, graph, columnar/OLAP, geospatial, eventâstream, and more. It shows you how each engine works, where it excels, and how to choose the right engine for each workload. The book provides clear tradeâoff tables, indexing strategies, query patterns, and useâcase recipes you can apply immediately.
Starting with foundations in SQL and NoSQL, this book explores each “species” chapter by chapter, emphasizing handsâon scenarios and pitfalls to avoid. It then brings everything together in polyglot/hybrid architectures, helping you combine engines confidently, whether you’re designing a similarity search with vector databases (ANN), building observability pipelines on timeâseries data and event logs, modeling relationships in graph databases, or delivering analytics with columnar/OLAP and geospatial queries. The result is a concise, engineerâfirst map of the database landscape that turns theory into pragmatic decisionâmaking.
What You Will Learn
- Identify the right engine for the job across vector, timeâseries, graph, columnar/OLAP, geospatial, and eventâstream databases
- Evaluate tradeâoffs in performance, scalability, consistency, storage layout, indexing, and operational complexity
- Design polyglot architectures that combine multiple engines (e.g., vector + OLAP + eventâstream) for endâtoâend solutions
- Apply useâcase patterns for similarity search (ANN), observability metrics, fraud/network analysis, geospatial routing, and analytical reporting
- Understand core internals that matter (index types, retention policies, logâstructured storage, spatial indexes, columnar execution) without vendor lockâin
- Avoid common pitfalls in schema design, query planning, and crossâengine data movement
- Build a decision checklist and tradeâoff tables to justify engine selection to stakeholders
Who This Book Is For
Software engineers; back-end developers; data engineers; system architects; site reliability engineers (SREs); technical leads with basic SQL/NoSQL experience who need practical guidance to select, compare, and combine specialized databases for realâworld applications
Table of Contents
1. Foundations of SQL and NoSQL: The Basics of Relational and Non-Relational Databases.- 2. Columnar/OLAP Databases: Large-Scale Aggregation.- 3. Lakehouse Table Formats: ACID Tables on Object Storage.- 4. Event-Stream and Append-Only Databases: Managing Sequential, Immutable Data.- 5. Time-Series Databases: Handling High-Volume Temporal Data.- 6. Probabilistic/Approximate Databases: Trading Accuracy for Efficiency.- 7. Vector Databases and High-Dimensional Search: Semantic Similarity at Scale.- 8. Graph Databases: Modeling Highly Connected Data.- 9. Geospatial and Spatial Databases: Storing and Querying Location-Based Data.- 10. Choosing the Right Engine and Hybrid Architectures.



