Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

From: Neo <neo55592_at_hotmail.com>
Date: 5 Jun 2004 11:02:45 -0700
Message-ID: <4b45d3ad.0406051002.5312d2b4_at_posting.google.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. Received on Sat Jun 05 2004 - 20:02:45 CEST

Original text of this message