Oracle Data Warehouse Architecture

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. 

Latest Articles