Query rewrite from materialized views does not require dimensions; they are
only used in certain fairly obscure situations.
on 9/30/03 1:49 AM, Tanel Poder at tanel.poder.003_at_mail.ee wrote:
> Query rewriting to use materialized views requires dimensions to be defined.
>
> Tanel.
>
>> ----- Original Message -----
>> From: Jamadagni, Rajendra <mailto:Rajendra.Jamadagni_at_ESPN.COM>
>> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com>
>> Sent: Monday, September 29, 2003 7:14 PM
>> Subject: RE: Using dimensions
>>
>> Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
>> of dimensions ... where does one use them? in SQLs?
>>
>> I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.
>>
>> Thanks
>> Raj
>> -----------------------------------------------------------------------------
>> ---
>> Rajendra dot Jamadagni at nospamespn dot com
>> All Views expressed in this email are strictly personal.
>> QOTD: Any clod can have facts, having an opinion is an art !
>>> -----Original Message-----
>>> From: Scott Canaan [mailto:srcdco_at_rit.edu]
>>> Sent: Monday, September 29, 2003 11:55 AM
>>> To: Multiple recipients of list ORACLE-L
>>> Subject: RE: Using dimensions
>>>
>>> Dimensions are data warehouse constructs. They are implemented as tables in
>>> the database, but have the characteristic of a hierarchy that can be
>>> traversed. For example: a time dimension can have the hierarchy of date,
>>> day, week, month, quarter, year, decade, century. This is used for rollup
>>> reporting within the data mart. I don't see any good use of it in an OLTP
>>> environment, but I may be wrong.
>>>
>>>
>>>
>>> Scott Canaan (srcdco_at_rit.edu)
>>>
>>> (585) 475-7886
>>>
>>> "Life is like a sewer, what you get out of it depends on what you put into
>>> it." - Tom Lehrer.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
>>> Sent: Monday, September 29, 2003 10:55 AM
>>> To: Multiple recipients of list ORACLE-L
>>> Subject: Using dimensions
>>>
>>>
>>>
>>> I have tried, but haven't found a good example of how to _use_ a dimension
>>> in 9ir2. I defined one, but then sat clueless on what to do with it. Is it
>>> any good in an OLTP environment? (I smell the answer is a NO, but still) ..
>>>
>>> Any notes from your experience?
>>>
>>> TIA
>>> Raj
>>> ----------------------------------------------------------------------------
>>> ----
>>> Rajendra dot Jamadagni at nospamespn dot com
>>> All Views expressed in this email are strictly personal.
>>> QOTD: Any clod can have facts, having an opinion is an art !
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: tim_at_sagelogix.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Tue Sep 30 2003 - 08:24:32 CDT
