A data warehouse is not the dark, dusty place that comes to mind. It is a central digital repository of integrated historical data derived from operational systems and external data sources. DATAVERSITY brought this interesting information to our attention in their article, “The Difference Between a Traditional Data Warehouse and a Cloud Data Warehouse.

It is also a key component of business intelligence. It enables enterprises to support a wide range of business decisions, including product pricing, business expansion, and investment in new production methods.

A data warehouse facilitates analysis and reporting, and keeps data analysis separate from production systems. This brings consistency to disparate data sources.

With the emergence of cloud computing, data warehouse architecture has been dramatically impacted. In the cloud, scalability is easy as provisioning more resources from the cloud provider vs. on-premise scalability, which can be time-consuming and costly. However, the security concerns of sending terabytes of data over the Internet balances this out.

Melody K. Smith

Sponsored by Access Innovations, the world leader in taxonomies, metadata, and semantic enrichment to make your content findable.