Indexing option on numeric fact referred to in DW Toolkit 2nd edition

dennisf at 22h58
14
Apr
2009
Indexing option on numeric fact referred to in DW Toolkit 2nd edition

In the 2nd edition of THE DATA WAREHOUSE TOOLKIT, Chapter 9, page 208 at the end of the first paragraph, there is a reference to an indexing option on a numeric fact pioneered by SYBASE IQ product which has become a standard indexing option in competing databases. I would like to know what is the equivalent indexing option in Oracle?
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy
Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best
Please tell me what kind of indexes you are using in your dimension tables in your organization. I am looking for dimension tables indexing strategy for Sybase, Oracle and Db2. If you have any indexing strategy document for Dimension tables for
My customers are challenging me..... They tell me that my reporting models are not flexible enough. I agree, but I am not sure how to approach this issue and give them what they need in a simple way. My products today offers 2 types of reporting today:
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Indexing option on numeric fact referred to in DW Toolkit 2nd edition"

This topic has been viewed 802 times.

Last message :
14/04/2009 at 22h58 by "dennisf"