Hello,

I am trying to compile a list of ORCL database features that 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

"Jack" <jack_posemsky (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:209b7e58.0405121553.743dc6b7 (AT) posting (DOT) google.com...
There are many more since you can harness lots of features for decision
support. The most important is the OLAP option which came with 9i, others
are specialized indices, the Oracle Warehouse Builder or SQL support.
Register at http://otn.oracle.com and find out more.

Kind regards,

Joerg

Hi Jack

Here are some of the features that have been added to the Oracle
database since Oracle 8.0 specifically for BI and data warehousing. You
can read more about all this, as Joerg recommended already, on OTN
(www.otn.oracle.com).

Oracle 8.0 added (over an above features of Oracle 7.3.x)
---------------------------------------------------------
* Partitioned Tables and Indexes
* Partition Pruning
* Parallel Index Scans
* Parallel Insert, Update, Delete
* Parallel Bitmap Star Query
* Parallel ANALYZE
* Parallel Constraint Enabling
* Server Managed Backup/Recovery
* Point-in-Time Recovery

Oracle8i added
--------------
* Hash and Composite Partitioning
* Resource Manager
* Progress Monitor
* Adaptive Parallel Query
* Server-based Analytic Functions
* Materialized Views and Query Re-Write
* Transportable Tablespaces
* Direct Loader API
* Functional Indexes
* Partition-wise Joins
* Security Enhancements

Oracle9i added
--------------
* List and Range-List Partitioning
* Table Compression
* Bitmap Join Index
* Self-Tuning Runtime Memory
* New Analytic Functions in SQL
* Grouping Sets
* External Tables
* MERGE
* Multi-Table Insert
* Proactive Query Governing
* System Managed Undo
* Oracle OLAP Option (9i Release2) - full multidimensional calculation
engine, multidimensional storage, & multidimensional OLAP API, inside
the Oracle Database. In addition to the OLAP API, Multidimensional data
and information is also open via simple SQL for access by general
purpose reporting tools thru ad-hoc Query and Reporting tools.

Oracle10g adds :
----------------
* Significant enhancements to the OLAP Option
* Self-tuning SQL Optimization
* SQL Access Advisor
* Automatic Storage Manager
* Self-tuning Memory
* Change Data Capture
* SQL Models
* SQL Frequent Itemsets
* SQL Partition Outer Joins
* Statistical functions
and more ...

Joerg mentioned Oracle Warehouse Builder - Oracles ETL and DW Management
tool - which now ships with Oracle 10g, and of course, Oracle also
supplies a range of BI&DW tools and applications.

Hope it helps, Kevin (@Oracle)

Jack wrote: