Ans: following are the various four fundamental phases of data warehousing. They are:
- Offline Operational Databases
- Offline data warehouse
- Real-time data warehouse
- Integrated data warehouse
Now, let us know about each phase of the data warehouse with useful insights.
Offline Operational Databases: This is the initial stage of the data warehouse, evolved from copying the original operating system into an offline server. This process doesn’t impact the performance of the system.
Offline Data Warehouse: In this phase, data warehouses update the operational data regularly such as daily, weekly, and monthly and the data is stored in an homogenous report oriented way.
Real-time Data Warehouse: In this phase, the operating system executes an action or an event every time and updates the events in the data warehouse.
Integrated Data Warehouse: In this last phase, data warehouses generate transactions and activities that pass through the OS, which assists the organization in daily business functionality.