Re: Demo: Things in Hierarchies (w/o RM/SQL)
Date: 5 Nov 2004 11:43:51 -0800
Message-ID: <4b45d3ad.0411051143.2d70324e_at_posting.google.com>
> > > I have no urge at all to repeat that again.
> >
> > But then why do you insist on bring it up repeatedly?
>
> I did't bring it up - the discussion whether you will pay me or not is
> closed as far as I'm concerned.
Your RM Sol#1 and #2 failed the challenge because they were not able to represent things in hierarchies without NULLs or redundancy and were slower at generating the desired report. XDb1 is normalized down to atomic symbols. Because your solutions were not generic, they could not represent the following data without NULLs or redundancy:
Case1: God is the parent of an unnamed person. God is also the parent of second person with three names (string 'john', integer 100, decimal 3.14).
Case2: john isa person. john's color is brown. mary isa person. mary's color is brown. brown is a person.
Besides being non-generic and requiring NULLs, your solutions were slower. As shown by the measurements made below, even when executed on a 5.6 times slower 233 Mhz Pocket PC, XDb1 generated the small common ancestor report nearly twice as fast as your non-normalized, non-generic SQL Server 2000 Solution running on a 1,300 MHz desktop.
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
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, genericReceived on Fri Nov 05 2004 - 20:43:51 CET