Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

White Papers

Posted Feb 9, 2010

Oracle Data Warehouse Architecture

By DatabaseJournal.com Staff

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. 

View Article

White Papers Archives