Explain in brief various fundamental stages of Data Warehousing. Stages of a data warehouse helps 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.
Explain in brief various fundamental stages of Data Warehousing.The following are the stages of data warehousing:
Offline Operational Database:It is the stage where copying the data off an operational system to another server where the report processing load against the copied data takes place and OS performance does not impact.
Offline Data Warehouse:In this stage, data warehouses are updated from data in the OS and the data of data warehouse is stored in a data structure that is designed for facilitating reports.
Real time Data Warehouse:The data warehouses are updated often when an OS performs a transaction.
Integrated Data Warehouse:The data warehouses are updated by OS, at the time of performing a transaction. Then transactions are generated which are passed back into the operational systems.