The enterprise data warehouse isn’t dead just yet.
Bjarne Berg, co-founder of the business intelligence consultancy Comerit, said, 99 percent of Fortune 500 companies are still using some kind of enterprise data warehouse (EDW). That places EDWs firmly in the land of the living, at least for now.
Berg is an SAP University Alliance professor, and said he helped implement a significant number of those warehouses in the first place as an SAP partner. Now, he said, many large companies are starting to move away from the rigid data modeling of the traditional EDW and toward faster and more flexible technologies like Hadoop or in-memory databases.
But just because results come faster and there is significantly less data modeling involved in the newer approaches doesn’t mean some core concepts if the EDW aren’t still crucial, like data integration and cleansing, historical reporting and security. It’s just that business users need their reports more quickly today than the monolithic, schema-based warehouses can provide.
In this interview with Data Informed staff writer Ian B. Murphy, Berg discusses how the EDW as we know it is changing. He also describes what a new enterprise-level data store looks like today, and how the drive for self-service business intelligence, and increases in database performance, have made the traditional EDW model more cumbersome than useful.
Related articles on Data Informed: