Powerplay is optimized to build a cube from a flat file (which would have
been extracted from a star schema). I view the start schema as a variation
of the relational model. The constructs and constraints are the same, their
just assembled differently. It's a relational model that follows rules other
than normalization rules, IMO...
"Laconic2" <laconic2_at_comcast.net> wrote in message
news:1-ednaJKnbbBZubdRVn-ug_at_comcast.com...
> Alan,
>
> I once built a star schema to validate a powerplay cube
>
> (by providing an alternate route for the data from the OLTP system into
the
> cube.)
>
> 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 - 11:32:56 CDT
