I attended an excellent presentation give by Maria Colgan, Sr. Product Manager at Oracle. The title was ‘Best Practices for a Data Warehouse on Oracle’.
Great tuning tips encompassing the entire architecture of a DW — hardware, network, storage, and of course, Oracle DB.
A whitepaper version of the presentation may be found on the OTN website:
http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_dw_best_practies_11g11_2008_09.pdf
I highly recommend.
At Collaborate 2010, I attended a presentation given by Ray Roccaforte, VP of Data Warehouse Development at Oracle.
The focus of presentation was on three areas:
My key take away is that Oracle is committed to be a solution provider rather than just a software products company.
The Exadata machine is all about delivering a packaged solution for data warehouse environments. Hardware and software bundled together ready to go. What’s interesting is that Oracle is now pushing down a lot of the performance improvements to the storage level and not trying to do everything in the Oracle database.
Also, Oracle has rewritten the optimizer to take advantage of the 5TB of flash (yes … 5 terabytes!).
In addition to the “data warehouse machine”, Oracle is also building data models for specific industries.
Retail and Telco are the first to to roll out. They include multi-dimensional data models and prebuilt reports to jump start any BI initiative within that industry.