Title: Using dimensions
Query rewriting to use materialized views requires
dimensions to be defined.
Tanel.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 29, 2003 7:14
PM
Subject: RE: Using
Raj,
what does TFM STFW mean ?!!
let me also get used to the list's acronyms :)
Jp.
- Original Message -
From: Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses
of dimensions ... where does
: Using dimensions
Raj,
what does TFM STFW mean ?!!
let me also get used to the list's acronyms :)
Jp.
- Original Message -
From: Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Thanks Scott, okay lets forget OLTP .. but I haven't seen any
_actual_
uses
OwwThank God Raj hasn't replied yet :-)
Thanx Gints.
Jp.
30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote:
google gave me for example such an address
http://www.gaarde.org/acronyms/
I'm sure one of hundreds or even thousands
-Original Message-
From: Prem Khanna J
Title: Re: Using dimensions
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 [EMAIL PROTECTED] wrote:
Query rewriting to use materialized views requires dimensions to be defined
Title: RE: RE: Using dimensions
I am out sick today ... glad you found the acronyms ... the F is left to your own imagination.
Raj
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 30, 2003 5:45 AM
To: Multiple recipients of list ORACLE-L
Title: Using dimensions
Got a
link for this requirement in the manual?
Raj
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003
4:50 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Using dimensions
Query rewriting to use
Title: Using dimensions
Hm, I did a brief check and it seems I was a bit
wrong:
Dimensions are requiredonly when you want
query rewrite to use materialized views computed on other
constraintsrelationships than primary/foreign/unique keys.If you want
to use your custom relationships
Title: 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
Title: 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
Title: 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 scannedTFM, but haven't STFW'd yet ... scared of too many
hits.
Thanks
Raj
]
Date: 2003/09/29 Mon PM 12:14:39 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
Raj - Actually a good place to start is the Oracle9i Data Warehousing Guide
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical.
htm#97703
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/logical
.htm#97703
I think it is important for all Oracle DBAs to
Title: Using dimensions
I`ve
not used dimensions in Oracle only read about them.
But I
have designed DW using dimensional modeling. So from what I've read in the doc,
Oracle will used the dimensions to be better atquery rewriting because it
knows the hierarchy of the data (example
Title: RE: Using dimensions
Thanks Dennis ...
We have a group who design their application as if this is a DW environment, so I thought learning this stuff might be beneficial for me.
I'll check it out.
Raj
so basically your saying you use dimensions hand in hand with materialized views.
do they have other uses?
From: Stephane Paquette [EMAIL PROTECTED]
Date: 2003/09/29 Mon PM 02:39:43 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Using dimensions
Using
Raj - There is some melding of DW and OLTP environments at some sites today.
Most DW's are separate environments with data extracted from the OLTP on a
regular batch schedule. But it is possible to have a combined environment
that satisfies both requirements, especially if you are starting from
basically your saying you use dimensions hand in hand with materialized
views.
do they have other uses?
From: Stephane Paquette [EMAIL PROTECTED]
Date: 2003/09/29 Mon PM 02:39:43 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Using dimensions
Using
of list
ORACLE-L [EMAIL PROTECTED]
Rajendra.Jamadagncc:
[EMAIL PROTECTED] Subject: RE: Using dimensions
19 matches
Mail list logo