What are fundamental stages of Data Warehousing

What are fundamental stages of Data Warehousing

Hi my name is Rizwan.

Stages of a data warehouse are helpful to find and understand how the data in the warehouse changes. At an initial stage of data warehousing data of the transactions is merely copied to another server. Here, even if the copied data is processed for reporting, the source data’s performance won’t be affected.

In the next evolving stage, the data in the warehouse is updated regularly using the source data. In Real time Data warehouse stage data in the warehouse is updated for every transaction performed on the source data (E. g. booking a ticket).

When the warehouse is at integrated stage, It not only updates data as and when a transaction is performed but also generates transactions which are passed back to the source online data.

Virtual Data Warehousing. A virtual data warehouse provides a compact view of the data inventory. It contains Meta data. It uses middleware to build connections to different data sources. They can be fast as they allow users to filter the most important pieces of data from different legacy applications.

What are fundamental stages of Data Warehousing

A data warehouse, abbreviated as DW or DWH, is a federated or combined repository for all collected data by an enterprise’s different operational systems whether physical or logical. It is also known as EDW or “Enterprise Data Warehouse”. It is a system used for data analysis and reporting and is believed to be the core component of business intelligence.

Data warehousing highlights the capture of data from various sources for access and analysis rather than for transaction processing. Data warehouses are central repositories of integrated data from one or more unrelated sources. A data warehouse, normally, is a relational database housed on an enterprise mainframe server or, progressively, in the cloud.

They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise.