Real time data warehouse approach

diteps06
diteps06 used Ask the Experts™
on
I am looking on recent research or thesis on best approaches or architectures in achieving real time data warehouse. A data warehouse which is able to elaborate recent data inserted in diverse operational data sources. The system relays recently updated data to the data warehouse. The study should preferably regard a change data capture (CDC) approach and best join algorithms in such scenario
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008
Commented:
pay attention to following topics:

1. materialized views and their application in BI
2. Oracle Exadata DB machine that speeds up the warehouse and  OLTP processing

Oracle Magazine (online edition) is a good source of information.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial