By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,196 Members | 973 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,196 IT Pros & Developers. It's quick & easy.

Oracle DB features that support BI/ warehousing

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jack wrote:
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

SQL Analytics
Partitioning (option)
Parallel Operations
Data Compression
OLAP (Option)
Data Mining (Option)
There are more ......

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.