I am not David but I agree with his assessment. Relational model databases by definition are not supposed to use keys that have no meaning. They are supposed to create relations that have meaning. Even the use of numbers breaks the theoretical rule. The problem is that we have pushed all to use relational model rather that what he logical model proposes. Who out there remembers hierarchical, tree, or inverted structure models.
Regards Chuck Sent from my iPhone > On Aug 6, 2017, at 10:47 AM, steve simpson via 4D_Tech <[email protected]> > wrote: > > On Fri, 4 Aug 2017 12:52:28 -0700 > > David Adams <[email protected]> > wrote: > >> >> [snip] >> 4D's UUIDs function as globally unique row *serial numbers*. That's great >> for backups and convenient for physical relations, but it has exactly zero >> to do with a real "primary key" or relational integrity. >> [snip] >> > > Care to elaborate on that statement? I don't get why you'd say that. > _____________________ > Steve Simpson > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
