Previous | Page 2 of 2 | Next

Component Products of OCDM

Leveraging Data Warehouse Features of the Oracle Database

Oracle Database 11g is a comprehensive information platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply integrated analytics, and embedded integration and data quality. The Oracle Database 11g provides:

• Best-of-breed functionality for data warehouses and data marts, with robust partitioning functionality, proven scalability to hundreds of terabytes, and innovative query-processing optimizations.
• A uniquely integrated platform for analytics. By embedding OLAP, Data Mining, and statistical capabilities directly into the database, Oracle delivers all of the functionality of stand-alone analytic engines with the enterprise scalability, security, and reliability of the Oracle Database.
• Best-of-breed and proven extraction, transformation, and loading (ETL) capabilities of Oracle Warehouse Builder; robust ETL is critical for any DW/BI project, and OWB provides a solution for every Oracle Database. OCDM is also compatible with any Oracle-compatible ETL tool, such as ODI or Informatica.

Click the links for descriptions of the data warehouse features leveraged by OCDM:

	Partitioning and Partitioned Exchange Loading
	Materialized Views, Windows Aggregate Function
	Compression, Parallel Query, and Parallel DML
	Data Mining Models
	OLAP Models

Note:

The Oracle database Spatial Option is required if you want to use mapping software (called MapViewer); if you do not need maps, you do not need the Spatial option.

Compression and OWB are currently part of the Oracle Database Enterprise Edition 11gR2

Previous | Page 2 of 2 | Next