Re: A Normalization Question

From: Tony <andrewst_at_onetel.net.uk>
Date: 30 Jun 2004 02:57:47 -0700
Message-ID: <c0e3f26e.0406300157.1c401c82_at_posting.google.com>


neo55592_at_hotmail.com (Neo) wrote in message news:<4b45d3ad.0406290941.1327f3cd_at_posting.google.com>...
> > Good to see that you're back. You haven't forgotten that you still owe me
> > $1.000, have you?
>
> RM Sol#1 and #2 fail to meet the challenge because, they contain
> redundant schema (schema is data) to store the class hierarchy which
> cannot be accessed by the provided report procedure, and stores
> redundant data (ie "brown"). Deficiencies in the genericness of the
> solutions can be shown by the inability to handle things without an
> attribute (ie name) and things with multiple attributes each of
> different type, etc.
>
> Below are measurements made thus far using RM solutions that aren't as
> generic or normalized as XDb1's.
>
> Small Report Generation Summary (provided by Hugo)
> ---------------------------------------------------------------------
> Solution Time(ms) Platform Notes
> -------------- -------- ----------------- --------------------------
> RM#1 SqlSrvr2K 14.3 1.3 Ghz PC Unnormalized, non-generic
> RM#2 SqlSrvr2K 11.0 1.3 Ghz PC Unnormalized, non-generic
> XDb1 4.4.7 16 1.3 Ghz PC Debug ver, norm and gener
>
>
> Small Report Generation Summary (provided by Neo)
> ---------------------------------------------------------------------
> Solution Time(ms) Platform Notes
> ------------- -------- ----------------- --------------------------
> RM#1 SqlSrvr7 65.0 500 Mhz Server Unnormalized, non-generic
> RM#2 SqlSrvr7 68.9 500 Mhz Server Unnormalized, non-generic
> XDb1 4.5.7 1.632 500 Mhz Server Normalized, generic
> XDb1 4.5.9 6.561 233 MHz PocketPC Normalized, generic
>
>
> Large Report (28,940 rows) Generation Summary (provided by Neo)
> 200 Goat Hierarchy (5 generations x 40 goats/generation,
> each goat having two parents, except 1st gen).
> ---------------------------------------------------------------------
> Solution Time(sec) Platform Notes
> ------------- -------- ----------------- --------------------------
> RM#5 SqlSrvr7 40.5 500 Mhz Server Unnormalized, non-generic
> XDb1 4.5.7 2.9 500 Mhz Server Normalized, generic
> XDb1 4.5.9 16.971 233 Mhz PocketPC Normalized, generic
>
>
> Larger Report (276,620 rows) Generation Summary (provided by Neo).
> 400 Goat Hierarchy (10 gen x 40 goats/gen),
> ---------------------------------------------------------------------
> Solution Time(ms) Platform Notes
> ------------- -------- ----------------- --------------------------
> RM#5 SqlSrvr7 105 min 500 Mhz Srvr, NT Avg of 2 runs, UnNrm,UnGen
> XDb1 4.5.10 44 min 500 Mhz Srvr, NT Avg of 2 runs, Norm, gener
> XDb1 4.5.10 57 min 450 Mhz PC, 98 1 run, Normalized, generic
> XDb1 4.5.10 195 min 233 Mhz PocketPC 1 run, Normalized, generic
>
> Note: SQL Server scripts are available from website.

Neo, why do you cut and paste the same answer over and over again? It gets boring. But it least there can't be many people around here by now who don't know you are a charlatan who does not honour his promises, so I guess you are doing us all a service of sorts... Received on Wed Jun 30 2004 - 11:57:47 CEST

Original text of this message