Data Informed

Data Informed


Reports of the Enterprise Data Warehouse’s Death Are Premature

June 19, 2013

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.Email Staff Writer Ian B. Murphy at ian.murphy@wispubs.com. Check out other Data Warehouse podcasts from Data Informed.Related articles on Data Informed:Alternative to in-memory analytics relies on column-based data stores. Considerations for storage, appliances and NoSQL systems for big data analytics management.League of Legends powers up Hadoop-based queries with Platfora.