AISWARYA SOMAN

• Jul 18th, 2005

 

Real-time data warehousing is a combination of two things: 1) real-time activity and 2) data warehousing. Real-time activity is activity that is happening right now. The activity could be anything such as the sale of widgets. Once the activity is complete, there is data about it. 
 
Data warehousing captures business activity data. Real-time data warehousing captures business activity data as it occurs. As soon as the business activity is complete and there is data about it, the completed activity data flows into the data warehouse and becomes available instantly. In other words, real-time data warehousing is a framework for deriving information from data as the data becomes available. 
 

Muhammed Kamal

• Aug 30th, 2005

 

A real time data warehouse provide live data for DSS (may not be 100% up to that moment, some latency will be there). Data warehouse have access to the OLTP sources, data is loaded from the source to the target not daily or weekly, but may be every 10 minutes through replication or logshipping or something like that. SAP BW is providing real time DW, with the help of extended starschma, source data is shared.

sithusithu

 Profile Answers by sithusithu 

• Jan 12th, 2006

 

In real-time data warehousing, your warehouse contains completely up-to-date data and is synchronized with the source systems that provide the source data. In near-real-time data warehousing, there is a minimal delay between source data being generated and being available in the data warehouse. Therefore, if you want to achieve real-time or near-real-time updates to your data warehouse, you?ll need to do three things:

1. Reduce or eliminate the time taken to get new and changed data out of your source systems.
2. Eliminate, or reduce as much as possible, the time required to cleanse, transform and load your data.
3. Reduce as much as possible the time required to update your aggregates.

Starting with version 9i, and continuing with the latest 10g release, Oracle has gradually introduced features into the database to support real-time, and near-real-time, data warehousing. These features include:

• Change Data Capture
• External tables, table functions, pipelining, and the MERGE command, and
• Fast refresh materialized views

Cheers

Sithu

satyambabu

• Mar 22nd, 2006

 

Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose.

ashwinijawalgekar

 Profile Answers by ashwinijawalgekar 

• Jul 7th, 2010

 

The Real time data warehouse is really a combination of real time (Current) and historical data warehouse.

In real time world the historical systems are less valuables because of issues facing managers govt. officials in the real world.

According to Management needs to analyse the current information when trying to detect suspicious group of passengers or tracking to some illegal activities...  the Real Time Data warehouse is needed.