Re: Question about OLAP, ROLAP etc.

From: <TCarlson_at_bunge.com>
Date: Mon, 8 Jan 2001 08:55:18 -0600
Message-Id: <10735.125973@fatcity.com>

--0__=WTzfAvNqDbPRQUEuHoCyEZQ3VXWJLM4ssgNtzsKrMA8dm8RMR7KB3ngY Content-type: text/plain; charset=us-ascii Content-Disposition: inline

The only one you missed was Dolap. Desktop olap. The cubes are created and stored separately from the database. The dimension structures are defined in the application that creates the cubes. Examples of this are Cognos and Business Objects.

HTH,
Todd Carlson
Oracle 8 Certified DBA
Bunge Corporation

|--------+----------------------------->

|        |          paquette stephane  |
|        |          <stephane_paquette@|
|        |          yahoo.com>         |
|        |                             |
|        |          01/08/2001 02:20 AM|
|        |          Please respond to  |
|        |          ORACLE-L           |
|        |                             |


|--------+----------------------------->

  >----------------------------------------------------------|
  |                                                          |
  |       To:     Multiple recipients of list ORACLE-L       |
  |       <ORACLE-L_at_fatcity.com>                             |
  |       cc:     (bcc: Todd Carlson/STL/BungeCorp/Bunge/US) |
  |       Subject:     Re: Question about OLAP, ROLAP etc.   |
  >----------------------------------------------------------|

--0__=WTzfAvNqDbPRQUEuHoCyEZQ3VXWJLM4ssgNtzsKrMA8dm8RMR7KB3ngY

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

You have 3 families in the olap world : rolap, molap and holap.
Rolap stands for relationnal olap meaning the users see their data organized in cubes with dimensions but the data is really store in a rdbms (Oracle). Molap stands for multidimensionnal olap, the users see their data organized in cubes with dimensions and the data is store in a mdbms (Oracle Express). Holap stands for hybrid olap, it is a combination of both world, Holos is a holap environnement.

Each olap has its strenghts and weaknesses. Rolap means that the rdbms will store data at a very fine grain, response time is usually slow. Molap means that a lot of queries have a finite answer, performance is usually critical and fast. Holap means that you have queries on aggregated data as well as on detailed data.

I played with the Oracle Data Marts Suite 2 years ago , it was a bundle of half of Designer2000, an Oracle database, Discoverer, Oracle Web server and the heart of the product was the ETL tool provided by Sagent. The product was only running on NT at that time.

Oracle Express is multidimensionnal database meaning it is storing data like in a cube. It's a proprietary environment.

The DataMart suite and Express are different products and are not included with Oracle8i.

Most of the time, you build cubes for a type of users and let another type of users access the detailed data.

Helmut Daiminger <hdaiminger_at_vivonet.com> a =E9crit=A0: > Hi there! > > We are about to introduce Data Warehousing into our > shop and I haven't had > much exposure to that so far. > > I have a question about OLAP and ROLAP. I know what > the expressions mean, > but I don't know what the big difference between > those two are. When are > they used? And what are the advantages/disadvantages > between the two? > > What the Oracle Tools 'Data Mart' and 'Oracle > Express' good for? Is part of > their functionality already in 8i? And Oracle is > going to move functionality > into 9i, right? > > Any input would be appreciated. > > > This is 8.1.6 on Win2k. > > > Thanks, > Helmut > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Helmut Daiminger > INET: hdaiminger_at_vivonet.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists >
> To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru_at_fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing).

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Mon Jan 08 2001 - 08:55:18 CST