Data warehouse - relations between dimensions

From: Hale, Robert [CREST:5K46:EXCH] <rhale_at_americasm05.nt.com>
Date: 2000/03/28
Message-ID: <38E168B7.203124EC_at_americasm05.nt.com>#1/1

Hi All,
I'm putting together my first star schema and got a request from a development team that I'm having a hard time arguing against. The developers have requested relations between certain dimensions in the star schema. These dimensions are used in an OLTP system to maintain a toplogy and the developers want to maintain the relationship between dimensions rather then sort through the records in a fact table to determine related rows.

To me, this seems to break the simplicity requirement of a Star schema. Do relations between dimensions impact the efficiency of a data warehouse design? Received on Tue Mar 28 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: rkeets_at_my-deja.com: "marketing database challenge"
Previous message: Markus Janscha: "Reporting Database design"
Next in thread: Markus Janscha: "Re: Data warehouse - relations between dimensions"
Reply: Markus Janscha: "Re: Data warehouse - relations between dimensions"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message