Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Normalization by Composing, not just Decomposing

Re: Normalization by Composing, not just Decomposing

From: Alan <alan_at_erols.com>
Date: Tue, 13 Apr 2004 12:32:56 -0400
Message-ID: <c5h4n1$1if1u$1@ID-114862.news.uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US