Re: OO and relation "impedance mismatch"
Date: Wed, 6 Oct 2004 16:40:08 -0400
Message-ID: <QoSdneKNwqSgxfncRVn-jA_at_comcast.com>
> Here is an example of how different they are. Question: if you were
> designing a dd, and had complete freedom to do it anyway you wanted, how
> would you specify a foreign key? Well, we always start with the absolute
> simplest way and then embellish, so we get:
Then I'd add whatever features necessary to automate the trigger generation
you were talking about, together with suppressing the inclusion of the IR
constraints in the DDL. That way I could have my cake and eat it too. The
biz rules, including Integrity rules, would be in "one master place", but
I could choose which of them got enforced in the DBMS.
Next, I'd add support for some network and hierarchical DBMS products.
Maybe throw in the Nelson-Pick model to see if it's as great as it's touted
by the Pickies in here.