Definition - What does Enterprise Data Warehouse mean?
An enterprise data warehouse is a unified database that holds all the business information an organization and makes it accessible all across the company. Although there are many interpretations of what makes an enterprise-class data warehouse, the following features are often included:
A unified approach for organizing and representing data
The ability to classify data according to subject and give access according to those divisions (sales, finance, inventory and so on)
A normalized design
A robust infrastructure with contingency plans to allow for business continuance, accessibility and a high level of security
The primary attraction of an enterprise data warehouse is that all the data is constantly available for analyzing and planning purposes. The alternative is for a business to have different databases for each major branch or organizational division, leading to a complex schedule of data reporting to allow for higher level analytics and planning. An enterprise data warehouse imposes a standard treatment of data and can grow with a business’s needs by adding classifications as they emerge in the business model. Ideally, an enterprise data warehouse provides full access to all the data in an organization without compromising the security or integrity of that data.