Oracle Data Warehouse Architecture

Tuesday Feb 9th 2010 by DatabaseJournal.com Staff

Oracle provides best of breed technologies for today's Data Warehouse and Business Intelligence solutions. By using Oracle's Exadata Storage engine technology coupled with Sun hardware, Oracle has been able to provide a highly optimize I/O environment for Data Warehousing.

Oracle Database 11g provides the best of breed Data Warehouse and Business Intelligence solutions.  Oracle provides a stable, reliable, and scalable environment that has continued to set performance benchmark standards for data warehouse processing.  With Oracle Database 11g, you get an ETL tool for transforming and accessing heterogeneous data sources. 

One of the keys to a well performing database is to have a solid and scalable hardware base. One of the biggest challenges to optimize performance is to minimize the potential bottleneck issues related to I/O.  Oracles Exadata storage architecture on top of Sun hardware provides a well-engineered storage solution for data warehousing.

Workloads on Data Warehouses can vary dramatically.  Oracle meets this challenge by providing different optimization techniques depending on the workload. With Database Resource Manager DBAs are able to place different workloads into resource groups, and then control CPU, I/O and memory usage by these resource groups.  Oracle provides multi-read consistence to ensure that data loads do not affect normal query processing. 

By using Exadata smart scans, some of the data intensive processes can be offloaded to the Exadata storage server.   Taking advantage of other hardware options like parallel in-memory processing, partitioning and compression provides for robust data warehouse performance.  OLAP materialized views and embedded data mining software allows you to find hidden insight into your data.

Oracle continues to be the industry leader in providing data warehouse technology.  Its flexibility, data partitioning, and consistence model provide the performance oriented capability needed for a data warehouse.  The Exadata storage engine on top of a Sun database machine provides the kind of solution needed to minimize the I/O bottleneck problems with large data warehouses. 

Mobile Site | Full Site