BI Features - Scalability

PRODUCTS

Database
Middleware
Developer Tools
Enterprise Management
Applications Technology
Products A-Z

TECHNOLOGIES

BI & Data Warehousing
Embedded
Java
Linux
.NET
PHP
Security
Technologies A-Z

ARCHITECTURE

Enterprise Architecture
Enterprise 2.0
Grid
Service-Oriented Architecture
Virtualization

COMMUNITY

Join OTN
Oracle ACEs
Oracle Mix
Oracle Wiki
Blogs
Podcasts
Events
Newsletters
Oracle Magazine
Oracle Books
Certification
User Groups
Partner White Papers

Printer View

E-mail this page

Bookmark

10g database logo Business Intelligence Features - Scalability
Oracle Database 11g builds on the industry-leading scalability of earlier releases. Oracle's extensive parallel processing is at the heart of its scalability. Not only is parallelism central to query processing, it plays a key role in Oracle's ETL tasks. Oracle has also enhanced scalability and reduced costs through its powerful data compression feature.

Technical Information

	Asynchronous Autolog Change Data Capture Cookbook (PDF) Change Data Capture is vital ETL functionality for environments that handle large amounts of data. Near real-time environments specially benefit from capturing incremental changes. However, CDC impact on the source application should be minimal. This cookbook gives step-by-step code examples of how to set up an asynchronous distributed autolog change data capture environment using change data capture on a staging database separate from the source database.
	Asynchronous Change Data Capture Cookbook (PDF) Change Data Capture is vital ETL functionality for environments that handle large amounts of data. Near real-time environments specially benefit from capturing incremental changes. However, CDC impact on the source application should be minimal. This cookbook gives step-by-step code examples of how to set up an asynchronous distributed change data capture environment using Oracle Database 9i Release 2 or higher as the data source.
	Partitioning in Oracle Database 10g Release 2 (PDF) Describes benefits of Oracle Partitioning, which stretch beyond scalability into availability, manageability and performance.
	Building a Multi-Terabyte Data Warehouse Using Linux and RAC (PDF) Grids of industry standard commodity servers running Linux are now in use for applications traditionally deployed on large SMP systems or proprietary MPP systems. This paper describes how to build Linux based Oracle RAC systems for data warehouse applications which have the same reliability and performance as SMP or MPP systems, but at a considerably lower total cost of ownership.
	Table Compression in Oracle10g Release 2 (PDF) Oracle10g Release 2 enhances the compression facility introduced in Oracle 9i Release2. Oracle compresses data in relational tables with virtually no negative impact on query time against that data, enabling substantial disk system cost savings.
	Parallel execution in Oracle10g Release 2 (PDF) Oracle's parallel execution architecture offers major advantages over alternative approaches to parallelism. This paper explains Oracle's parallel execution architecture and details the advantages. In particular, the paper shows how Oracle parallelism can leverage hardware to its fullest extent, exploiting every CPU, all memory and full I/O bandwidth.
	ETL Processing in Oracle9i (PDF) Describes features in Oracle, such as external tables, table functions and resumable DML, designed to specifically support ETL (Extraction, Transformation, Loading). With these features, Oracle provides the most scalable and reliable ETL functionality in the industry.
	Table Compression in Oracle9i Release2 - A Performance Analysis (PDF) Discusses table compression space savings and the impact on query performance for a star schema and third normal form schema. Compression can enable significant performance boosts.
	Capturing Change (HTML - Oracle Mag.) Change Data Capture can simplify ETL in data warehouse applications. This article gives a step-by-step approach for setting up a Synchronous CDC environment on Oracle9i, outlines the prerequisites for the setup, and discusses the API's.

Learn More

·	Training
·	Oracle By Example
·	Discussion Forum - Oracle Database

Related Technologies

·	Oracle BI Home
·	Oracle BI DW Technology Center
·	OracleBI Discoverer
·	OracleBI Beans
·	OracleBI Spreadsheet Add-In
·	Oracle Warehouse Builder
·	Oracle Database BI Features
·	Oracle OLAP
·	Oracle Data Mining
·	Oracle Reports
·	Oracle JDeveloper

E-mail this page

Printer View

	About Oracle \| \| Careers \| Contact Us \| Site Maps \| Legal Notices \| Terms of Use \| Privacy