You are here:  Home  >  Data Education  >  Data Architecture News, Articles, & Education  >  Current Article

What is a Data Warehouse?

By   /  October 23, 2017  /  No Comments

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

About the author

Michelle Knight enjoys putting her information specialist background to use by writing technical articles on enhancing Data Quality, lending to useful information. Michelle has written articles on W3C validator for SiteProNews, SEO competitive analysis for the SLA (Special Libraries Association), Search Engine alternatives to Google, for the Business Information Alert, and Introductions on the Semantic Web, HTML 5, and Agile, Seabourne INC LLC, through AboutUs.com. She has worked as a software tester, a researcher, and a librarian. She has over five years of experience, contracting as a quality assurance engineer at a variety of organizations including Intel, Cigna, and Umpqua Bank. During that time Michelle used HTML, XML, and SQL to verify software behavior through databases Michelle graduated, from Simmons College, with a Masters in Library and Information with an Outstanding Information Science Student Award from the ASIST (The American Society for Information Science and Technology) and has a Bachelor of Arts in Psychology from Smith College. Michelle has a talent for digging into data, a natural eye for detail, and an abounding curiosity about finding and using data effectively.

You might also like...

Thinking Inside the Box: How to Audit an AI

Read More →