O'Reilly logo

Agile Analytics: A Value-Driven Approach to Business Intelligence and Data Warehousing by Ken W. Collier

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Version Control for Data Warehousing

If your data warehouse server(s) failed catastrophically, how long would it take to redeploy the system into production?

If you discovered a critical defect in your production DW/BI system, how long would it take to revert to a previous version while you resolve the problem?

If you had to prove that what you had in production was the same as what you think is in production, how long would that take?

As with other mission-critical systems, it should take no more than a few days to rebuild your DW/BI system from scratch—including reconfiguring new servers and reloading data. The actual redeployment of your warehouse implementation (database schemas, ETL scripts, BI applications, etc.) should range ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required