As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” and it is being published by O’Reilly. I have spent a ton of time writing the book and it’s getting close to being finished.

There are now nine chapters and the preface available in their Early Release program. The book will have 16 chapters. Here is the TOC so far:

1. Big Data
   • What is Big Data and how can it help you?
   • Data maturity
   • Self-Service Business Intelligence
   • Summary
2. Types of Data Architectures
   • Evolution of data architectures
   • Summary
3. The Architecture Design Session
   • What is an ADS?
   • Why hold an ADS?
   • Before the ADS
   • Conducting the ADS
   • After the ADS
   • Tips
   • Summary
4. The Relational Data Warehouse
   • What is a relational data warehouse?
   • The top-down approach
   • Why use a relational data warehouse
   • Drawbacks to using a relational data warehouse
   • Populating a data warehouse
   • The death of the relational data warehouse has been greatly exaggerated
   • Summary
5. Data Lake
   • What is a data lake?
   • Why use a data lake?
   • Bottoms-up approach
   • Best practices for data lake design
   • Multiple data lakes
   • Summary
6. Data Storage Solutions and Process
   • Data storage solutions
   • Data processes
   • Summary
7. Approaches to Design
   • Online transaction processing (OLTP) versus online analytical processing (OLAP)
   • Operational and analytical data
   • Symmetric multiprocessing (SMP) and massively parallel processing (MPP)
   • Lambda architecture
   • Kappa architecture
   • Polyglot persistence and polyglot data stores
   • Summary
8. Approaches to Data Modeling
   • Relational modeling
   • Dimensional Modeling
   • Common Data Model (CDM)
   • Data Vault
   • The Kimball and Inmon data warehouse methodologies
   • Summary
9. Approaches to Data Ingestion
   • ETL versus ELT
   • Reverse ETL
   • Data governance
   • Summary
     
     Future chapters:
   • Modern data warehouse
   • Data fabric
   • Data lakehouse
   • Data mesh foundation
   • Data mesh adoption
   • People and process
   • Technologies
     
     

It’s 147 printed pages so far. Check it out here. You can expect to see two additional chapters appear every few weeks. This is a great way to start reading the book without having to wait until the entire book is done. Note you have to have an O’Reilly subscription to access it, or start a free 10-day trial. The site has the release date for the full book as May 2024, but I’m expecting it to be available by the end of this year. Please send me any feedback on the book to jamesserra3@gmail.com. Would love to hear what you think!