Oracle DB features that support BI/ warehousing

From: Jack <jack_posemsky_at_yahoo.com>
Date: 13 May 2004 12:13:51 -0700
Message-ID: <209b7e58.0405131113.1c33dabe@posting.google.com>

Does anyone know what the big ORCL database features are really intended to support OLAP or reporting requirements...so far I have:

Query re-write
Materialized Views
Bitmap Indexing
Read Consistency – a previous pilot was required to use NSK "READ UNCOMMITTED" to get any sort of viable performance, which implies dirty reads (typically handled with rollback segments in Oracle)
Data concurrency: Readers don't block readers, readers don't block writers, writers don't block readers.
Rollback - undo any uncommitted changes made by a transaction. The transaction is ended.

Are there others I should consider ?

Thanks,

Jack Received on Thu May 13 2004 - 14:13:51 CDT