Enterprise Data Warehouse

Why Trust Techopedia

What Does Enterprise Data Warehouse Mean?

An enterprise data warehouse is a unified database that holds all the business information an organization produces and makes it accessible to employees across the company. Although there are many interpretations of what makes an data warehouse enterprise-class, the following features are often included:

  • A unified approach to aggregating, normalizing and sharing data.
  • The ability to classify data according to subject and grant access privileges according to job role.
  • A high level of security that supports the principle of least privilege (PoLP).
  • A high level of scalability.
  • A robust infrastructure with contingency plans for business continuance in the event information and communication technology (ICT) services are disrupted.

Techopedia Explains Enterprise Data Warehouse

The primary attraction of creating and managing an enterprise data warehouse is to ensure that an organization's data is always available for analyzing and planning purposes.

The alternative is for a business to have a series of different databases (called data marts) for each major branch office or organizational division. The problem with this approach is that it creates data silos and can makes data integration more difficult for employees engaged in analytics and high level planning.

The challenge is to provide employees with access to the data they need to do their jobs — without compromising the security and integrity of the organization's data. Data warehouse governance frameworks can be used to create policies that impose a standard treatment of data that can grow with a business’s needs.


Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.