What is a Data Warehouse?

By on

data warehouseA Data Warehouse is an implementation used to provide decision support data and support workers engaged in reporting, query, and analysis. This technology enables organizations to integrate data from a range of sources into a common Data Models. Data Warehouses provide insight into operational processes and open new possibilities to leverage data towards making decisions and creating organizational value.

Other Definitions of a Data Warehouse Include:

  • A “storage architecture designed to hold data extracted from transaction systems, operational data stores and external sources.” (Gartner)
  • “Provides clearly defined communications, for a known aggregate set of data, to a well-defined user set, like a travel itinerary.” (Michelle Knight, DATAVERSITY®)
  • “A tool that is: (Kelle O’Neal and John Ladley)
    • Structured, processed
    • Schema on write,
    • Expensive for large data volumes
    • A Fixed configuration
    • Mature
    • Made for Business pros.”
  • A “stable, read only database that combines information from separate systems into one easy-to-access location.” (MIT)
  • A place “having structured data in rows and columns, requiring security and access controls.” (Thomas Davenport, Harvard Business Review).
  • “A place like a central distribution and storage warehouse, where individual data marts all come together to reside.” (Adrian Bridgewater, Forbes)

Businesses Use Data Warehouses to:

 

Photo Credit: ScandinavianStock/Shutterstock.com

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept