In this post I want to show you one of the key components to achieving an agile data warehouse – the business information model. We use this capability to drive everything in and about the warehouse – its structure, its content and its ability to rapidly change. The business model gives us a common language that both IT and business people can understand. Take a look at the video to get a quick tour of what the business model is about.
You can see that these models can quickly become very complex. And yet they can still be made easy to understand and navigate. Even better, when you need to make a change, no jackhammers are required!
But the business model is more than just a nice picture. Kalido reads in the model and of course it creates all the tables like a data modeling tool would do. But it also creates routines to load data, enforce business rules, and all the operational routines required for development, deployment and the ongoing care and feeding of the warehouse.
Check back for future videos that cover some of the capabilities in the model and the Information Engine that automate warehouse processes.