Data Truth or Dare: "Data Warehouse"

October 24, 2013

Is a data warehouse a physical storage location for data OR a database with multiple sources?

Let’s face it: nothing changes faster than technology. It seems like every day there’s a new product, upgrade, or feature that changes the game. With so much evolving so quickly, it’s sometimes difficult to stay on top of the lingo, let alone technology itself. So at TARGIT we’ve designed a game we like to call Data Truth or Dare.

We want to make sure our TARGIT community members can walk the walk and talk the talk in the world of Business Intelligence and Analytics. Can you answer the following Data Truth or Dare? Let’s find out. And be sure to stay tuned for more installations of this series. Because the fun never ends at TARGIT.

Data Truth or Dare: “Data Warehouse” – Is it a physical storage location for data OR a database with multiple sources?

Data Truth: A data warehouse combines multiple sources in one database for all your analytics needs

A Data Warehouse is not a physical storage location, but a database that is geared toward the Business Intelligence requirements of an entire organization. The warehouse can integrate data from the various systems and enables analyses across the operational systems.

A data warehouse will congregate data from multiple sources into a single database so a single query engine can be used to present data. This mitigates the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running analysis queries in transaction processing databases.

This ensures organizations have a central view of their business. It improves data quality by ensuring consistency and provides a single data model for all data of interest, regardless of the data’s source.

Interested in learning more? Have a look at the free TARGIT ebook, the BI Dictionary, to hone your skills for the next Data Truth or Dare.