A unified database also known as an enterprise data warehouse holds all the business information of an organization and makes it accessible all across the company. Most companies today, have their data managed in isolated silos while different teams of the same organization use various data management tools for various types of data such as data quality, data integration, data governance, metadata and master data management, B2B data exchange, database administration and architecture,etc. The adoption of enterprise DWs in large companies has become a best practice for storing integrated and centralized data extracted from various disparate operational sources. In this way, complicated queries can be executed without conflicting with the transactional operations of the operational systems.
The typical architecture of a DW consists of different components where data is passed from one component to the next after some critical operation is performed on the data. The structure of a unified data warehouse consists of a subset of the components contained in the Data warehouse architecture, namely: the data sources, the core DW, the data marts, the Extraction, Transformation and Loading (ETL) processes and the metadata repositories. The most important benefit of unified data warehousing comes from the fact that all the data is based on one central premise: as a result, there is no need to analyze the data separately in order to convert it into actionable information which can facilitate an improved decision-making process.