Re: Normalization by Composing, not just Decomposing
Date: Tue, 13 Apr 2004 10:39:05 -0400
Here's what I didn't expect: it took less time top copy the data from the OLTP system to the star schema, and then from the star schema into the cube than it took to load the cube directly from the OLTP data. I don't know whether that was just a fluke or was to be expected.
Interesting discussion you are having concerning dimensional modeling, relational modeling and star schemas.
I think of a star schema as a projection of a dimensional model into the world of tables, columns etc. I don't think of a star schema as having been particularly derived from a relational model. Received on Tue Apr 13 2004 - 16:39:05 CEST