Our new book “Data Warehouse Blueprints” is now available at Hanser Verlag as printed edition and e-book. Here a short overview of the book and some background information about the long history of this publication.
Together with my colleagues Claus Jordan, Peter Welker and Joachim Wehner, I originally wrote this book as an internal document for our BI consultants at Trivadis. It is a guideline for Data Warehouse projects and a helpful toolbox with architecture principles, technical concepts and implementation hints for different Data Warehouse projects. Instead of starting from scratch in every customer project, the Data Warehouse Blueprints can be used as a baseline for new and existing Data Warehouses.
Because most of our customers and Trivadis employees work in Germany, Switzerland and Austria, the book was written in German. Currently, an English version of the book is not available – sorry for that. Nevertheless, I write about the same subjects covered in the book in my Data Warehouse blog. Therefore some of the ideas and examples described in the book are already available or will be published here in the future. Of course, not the whole book – so you still have a reason to order it.
If you already know our previous book Data Warehousing mit Oracle (released in January 2011), you will find out easily that some of the chapters look very similar. The Data Warehouse Blueprints are actually a new, extended edition of this book. Compared to the first edition, the new book contains new chapters about Big Data, Data Vault Modeling and Real-Time BI, but also many extensions of the existing chapters: Additional topics about Dimensional Modeling, ETL design tips for performance optimization and error handling, design of the different DWH layers with many implementation examples and information about the physical database design.
The concepts and methods described in the Data Warehouse Blueprints are not limited to a specific database system. For this reason, we decided to write this second edition more generic than the first book to support other technologies than Oracle, too. Most of the examples are implemented with Oracle syntax, but can easily be adapted to other database systems. Some of our Trivadis colleagues (working with SQL Server) are quite happy about this decision.
After we finished our first book, I realized that writing a book is much more work than expected – especially if the authors are not full-time writers, but consultants working in customer projects most of their time. When we started with the second edition, I thought this would be much easier, because we do “only” some updates of the existing chapters. But in fact, rewriting and extending an existing chapter is even more work than writing a new chapter from scratch. This seems to be the same as in software projects. Finally, it took more than three years (elapsed time of course, not CPU time…) to write the new edition of the book. And almost a year to redact and prepare it for the public release.
The acknowledgments are already in the book, but nevertheless I want to thank again all my colleagues in Trivadis for their reviews and feedbacks and the Trivadis management board to provide the publication of the Data Warehouse Blueprints. And of course Claus, Jojo and Peter for the good collaboration.