Re: Generalised approach to storing address details

From: Neo <neo55592_at_hotmail.com>
Date: 9 Dec 2006 20:26:56 -0800
Message-ID: <1165724815.971323.195210_at_f1g2000cwa.googlegroups.com>


> My impression has been that the IP transcends the relational model, in
> that it requires that what a system allows a user to see is all that a
> user needs to predict what the system might do, ie., it doesn't demand
> attributes and tuples per se in order to do that. I'd say that any data
> model besides the well-described relational one (not that I'm suggesting
> another one) would be right to follow the IP, otherwise it is hiding
> information which seems crazy to me. That way people don't have to
> memorize what a particular product does under such and such a
> circumstance, which would open the door for all the cuckoo arbitary
> behaviours that the products Codd was railing against.

Would you say the following table is hiding information? If so, how would you store it in a relational db such that it isn't.

T_Hierarchy
Parent Child
john jim Received on Sun Dec 10 2006 - 05:26:56 CET

Original text of this message