Skip to content

Explain to us about various fundamental phases of data warehousing?

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. 

Leave a Reply

Your email address will not be published. Required fields are marked *

ULLU Web Series New: Watch this Bold Web Series by putting the latch of the room Rani Pari Web Series List Watch Online Charmsukh Tapan Web Series: देवर और भाभी ने किया जमकर रोमांस Romantic Web Series: Enjoy this web series alone, full of bold scenes Top 10 Current Affairs In Hindi TOP 10 FACT You Have to Know
%d bloggers like this: