Re: Dimension objects

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 27 Jun 2006 10:06:22 +0200
Message-ID: <e7qou1$885$03$1@news.t-online.com>

Mladen Gogala schrieb:
> On Mon, 26 Jun 2006 13:35:34 -0700, DA Morgan wrote:
>

>> It defines the relationship. Jonathan Lewis covers this in his tuning
>> course and his book.

>
> Hmmm, at the time I read the book, I wasn't overly interested in the data
> warehousing. I'll have to re-read the book. In the meantime, I researched
> the subject. It is, basically, a method of achieving star schema, sort of
> smart query rewrite. The whole thing is good for documentation purposes
> but it is, at least in my opinion, not as good as materialized views.
> Nonetheless, I find the idea of documenting the database structure through
> special "documentation objects" rather appealing. Designer probably can
> use those objects and make really pretty pictures (TM).
>

I agree with Daniel on the subject, but if the last book of Jonathan Lewis is meant - you'll not find any aspect of dimension objects there. All references in the book to dimensions ( Acroread counts 42 matches - is an accident ? ;-) ) are regarding the dimension tables, not the dimension objects. Some examples how dimensions can be used for query rewrite are here:
http://www.akadia.com/services/ora_dimensions.html http://www.akadia.com/services/ora_olap_dimensions.html I don't think - they are just for documentation purposes good, they expand a lot the capabilities of materialized views.

Best regards

Maxim Received on Tue Jun 27 2006 - 03:06:22 CDT