Re: Does Oracle have anything like SAP Business Intelligence Accelerator?

zigzagdna_at_yahoo.com wrote:
>
> Being Oracle Developer and DBA for many years, I was really intrigued
> by SAP’s
> Business Intelligence Accelerator (BIA).
> https://www.sdn.sap.com/irj/sdn/bia
>
> SAP BIA is said to improve performance of
> Adahoc queries on data warehouses by 10 to 100. BIA stores data of a
> table using columns (instead of rows as is done in relation
> databases). It then compresses column based data and creates indexes.
> Many customers are using BI accelerator and find it lives to its
> claims.
>
> I know Oracle recently introduced database machine for data
> warehouses, but BIA column based storage, compression and indexing is
> quite different. I am trying to find parallaels in Oracle but could
> not find any.

I think you are confusing apples and trees. Almost all SAP installs are done using the Oracle database. So when one looks at SAP technology one is asking about an SAP technology built with an Oracle database as its foundation (just as all apples grow on trees).

Thus a question such as "Does Oracle have something like this" is lacking in context.

If you are asking about E-Business Suite then there is something we can discuss but it would be off-topic in this usenet group which is for server technology and I would direct you to look at Oracle's TimesTen In-Memory Cache.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org