Data Warehousing Best Practices: Oracle’s Data Warehouse Reference Architecture and OWB

Sometimes we talk about the details of Warehouse Builder functionality so much that it’s easy to forget to raise our heads from time to time, and look at the broader questions of data warehousing and business intelligence.

But recently I was asked by a few different customers, who are already using Oracle and OWB, “Wait… are we going about this the right way?” (No suggestion is intended that these customers aren’t generating smart solutions to really tough problems… but the problems can be really tough, and the solutions quite complex, and it’s always good to ask for help, especially when coming up to a technology or organizational inflection point that creates an opportunity for a re-think or a re-design.)

In connection with this, I introduced them to Oracle’s Data Warehouse Reference Architecture whitepaper, most recently revised in February 2010, which they and I found to be a great resource.

While actually mostly vendor neutral, even shying away from talking about specifics of the Oracle database, the paper if properly understood made the value proposition for data warehousing on Oracle (and Exadata) and for using OWB as the data warehousing tool quite compelling. So I thought I’d share it with you… Perhaps going forward an interesting blog post or paper could be built around the question, “What makes OWB 11gR2 the ideal tool for Oracle data warehousing?” with reference to this document.

One more thing on the to-do list, I guess. Until I get to it, go do the reading (and enjoy it!) Perhaps there will even be a quiz!

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today