Re: Oracle Spatial Options and Data Warehouse

"ICare" <gmigotto_at_icare.it> writes:

> With Oracle 7.3 has made their debut the Spatial Options.
>Oracle says that the new HH encoding scheme can be useful for every data
>which is determined by a number of independent dimensions, so pushing its
>use for data warehouse (and in particular, multidimensional data warehouse)
>data modeling.
 

>Has anybody of you experience in this kind of application of the Spatial
>Options? What are the limits of this approah? Must the subject area have
>particular characteristics?
 

>Thanks in advance
 

>Giovanni Migotto
>gmigotto_at_icare.it

Hi Giovanni,

I think your Oracle rep is getting his terms confused. In my understanding, the Oracle spatial option (formerly called Oracle multidimension, which is why the confusion) is used for storing and accessing geographic data. It is designed to store attributes with ranges of data like longitude/latitude, elevation, temperature, etc to build a geographic information system.

Multidimensional data modeling in a data warehouse is more typically associated with On-Line Analytical Processing (OLAP) This topic is covered extensively in the comp.databases.olap newsgroup. The company I work for makes an olap server called Essbase, which is used by many Oracle shops. You can get more information at http://www.arborsoft.com including many white papers on OLAP and on OLAP in data warehousing.

Good Luck,

-- 

- Dan

Home:                                           Office:
Daniel Druker                                   Daniel Druker
                                                Strategic Alliances
1427 Byron Street                               Arbor Software Corporation
Palo Alto, CA, 94301                            1325 Chesapeake Terrace
ddruker_at_netcom.com                              Sunnyvale, CA, 94089
                                                (408) 541-4027
                                                ddruker_at_arborsoft.com