Re: Is this De-Normalization?

From: Tom Hester <>
Date: Mon, 1 Dec 2003 14:17:45 -0800
Message-ID: <f4e0$3fcbbe12$45033832$>

Yes, this is denormalization; but it is in first normal form. So, it is not 'First-Order de-normalization', I suppose. "tom dorgan" <> wrote in message
> Hello,
> We have a table, call it DataParent. Another table, call it
> DataChildren, contains foreign keys to DataParent. You get the idea
> that this is a one-to-many relationship like the well-known Order and
> LineItem pair.
> In a discussion regarding increasing performance, the idea was brought
> up to pull each of the DataChildren items into the DataParent table by
> using a fixed number of columns, call them DataChildren1-N in
> DataParent. Leave unused slots null and only allow N DataChildren per
> DataParent.
> I understand this to be First Order de-normalization - we are putting
> an array, set or tuple into a table. I was told that this was not the
> case but did not get an explanation.
> Any insights appreciated.
> TIA,
> Tom.
Received on Mon Dec 01 2003 - 23:17:45 CET

Original text of this message