What are fundamental stages of Data Warehousing?

Data warehousing - What are fundamental stages of Data Warehousing? - August 07, 2008 at 17:10 pm by Rajmeet Ghai

What are 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.

Data warehousing - What are fundamental stages of Data Warehousing? - May 11, 2009 at 14:40 pm by Vidya Sagar

What are fundamental stages of Data Warehousing?

Offline Operational Databases: This is the initial stage of data warehousing. In this stage the development of database of an operational system to an off-line server is done by simply copying the databases.

Offline Data warehouse: In this stage the data warehouses are updated on a regular time cycle from operational system and the data is persisted in an reporting-oriented data structure.

Real time Data Warehouse: Data warehouses are updated based on transaction or event basis in this stage. An operational system performs a transaction every time.

Integrated Data Warehouse: The activity or transactions generation which are passed back into the operational system is done in this stage. These transactions or generated transactions are used in the daily activity of the organization.


Write your comment - Share Knowledge and Experience

More Related Links
What is Data warehousing?

Answer - A data warehouse can be considered as a storage area where interest specific or relevant data........            

What are cubes?

Answer - A data cube stores data in a summarized version which helps in a faster analysis of data..........

What is XMLA?

Answer - XMLA is XML for Analysis which can be considered as a standard for accessing data in OLAP.......

Explain the difference between Data warehousing and Business Intelligence.

Answer - Data Warehousing helps you store the data while business intelligence.....

What is Dimensional Modeling?

Answer - Dimensional modeling is often used in Data warehousing.......

What is junk dimension?

Answer - In scenarios where certain data may not be appropriate to store in....

Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us