Re: Normalizing vs. Denormalizing
From: Austin Moseley <\"moseba_at_audv55.aud.alcatel.com'>
Date: 1996/04/02
Message-ID: <4jq5p0$ffo_at_news01.aud.alcatel.com>#1/1
Date: 1996/04/02
Message-ID: <4jq5p0$ffo_at_news01.aud.alcatel.com>#1/1
Peter Beahan <beahanpj_at_pacific.net.sg> wrote:
>I find it hard to believe that a normalized database is better than
>denormalized database.
>
Run your own test cases on 3 tables, 3f normalized, with 2xref tables, vs one big denormalized table.
Do selects and updates, both on indexed and non-indexed columns, after inserts. Do this for increments of 1000 rows per table. Start with the 3-f tables, then copy down to the denormalized table, tracking the resources used. Be sure you have xrefs for every row - like in real life, with some rows having multiple xrefs.
-Austin Received on Tue Apr 02 1996 - 00:00:00 CEST