Last year Oracle published a white paper called “Enabling Pervasive BI Through a practical Data Warehouse Reference Architecture”. I took a read through this paper and have some comments on it (so maybe this is a book report). For your convenience, I’ve uploaded a copy of it here Oracle DW Reference Architecture Feb 2010. I also believe the architecture is a little vague (on purpose I suppose). Depending on how you look at it, you might be looking at how the BI Apps are Architected, or you might be looking at how a real-time Enterprise Data Warehouse is built. Read the rest of this entry
Question #3: With the power of Exadata, are Data Warehouses even needed anymore? Can’t you just map your BI tools to the transactional system without all of the back end ETL work?
Short Answer: For most systems a DW and ETL are necessary. However a simple reporting system however can leverage this option for a while.
Long Answer: Data Warehouses started out as a means to offload processing of large data set queries from online transactional systems. Basically breaking up the workload. Read the rest of this entry