Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews1.google.com!not-for-mail From: neo55592@hotmail.com (Neo) Newsgroups: comp.databases.object,comp.databases,comp.databases.theory,comp.object Subject: Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge) Date: 5 Jun 2004 11:02:45 -0700 Organization: http://groups.google.com Lines: 35 Message-ID: <4b45d3ad.0406051002.5312d2b4@posting.google.com> References: <4b45d3ad.0405161027.742aa17d@posting.google.com> <4b45d3ad.0405182220.55cf6463@posting.google.com> <4b45d3ad.0405192056.6dfe48fc@posting.google.com> <0j9qa09trv8qeu86pfbtjarpm7oqmvekfr@4ax.com> <4b45d3ad.0405261536.4deac675@posting.google.com> <4b45d3ad.0406041056.1c3b4fb1@posting.google.com> NNTP-Posting-Host: 67.98.160.205 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1086458566 21176 127.0.0.1 (5 Jun 2004 18:02:46 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 5 Jun 2004 18:02:46 +0000 (UTC) Xref: core-easynews comp.databases.object:25917 comp.databases:105422 comp.databases.theory:35699 comp.object:178609 X-Received-Date: Sat, 05 Jun 2004 11:03:28 MST (news.easynews.com) > And where in your original challenge was this "broader scope of data" > requirement stated? The part that stated "allow the user to create any hierarchy". Please show how to create the report for the class hierarchy using the original data and the parent heirarchy using the following data, with either RM Sol#1 or #2 "from normalized and NULL-less data". Normalized meaning either eliminating or replacing redundant things (data/schema) within the db with an appropriate reference/link (IDs in RM) to the one and only original. string isa thing. integer isa thing. decimal isa thing. john isa name. john isa string. 100 isa name. 100 isa integer. 3.14 isa name. 3.14 isa decimal. god isa thing. person isa thing. * isa person. (an unnamed person) * parent god. * isa person. (another unnamed person) *'s name is john. (assign first name) *'s name is 100. (assign second name) *'s name is 3.14. (assign third name) *'s parent god.