Drew Wutka
DWUTKA at Marlow.com
Wed Jun 1 20:52:25 CDT 2011
But the argument about 'intelligent keys' are about human ways of thinking. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, June 01, 2011 6:29 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] 2 quick questions Drew, <<His laws really only apply to how a HUMAN sees the data, you would need a complete paradigm shift in computer technology, in order to make computers operate the same way humans do.>> Sorry, but that's not correct. Relational theory has nothing to do with how humans see data nor computers. It's irrespective of each. It's based on mathematics and set relations. Nothing more and nothing less. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, June 01, 2011 12:47 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] 2 quick questions I AGREE that intelligent keys have a place in the world.... the human world. It is our job, as developers, to create a computer system that works well on the computer, and INTERFACES well with its users (humans). Labels with an intelligent key are fine... they are being read by humans. Entry screens allowing a human to put in an intelligent key are fine. The data should NOT be related/stored based on the intelligent key. Let's go with Batch, Lot, Item again. In a XXXX-XXXX-XXXX format. Someone wants to view all the Items in Lot 3425. You are now doing a query for %-3425-%... how inefficient is that? Each Batch should have its own primary key which is unique to each batch, so should each lot, and each item, and internally, the one to many relationships are recorded using their primary keys. Even if you created a database system that met the 12 rules (rather 13 rules...LOL) that Codd presented for his relational model, internally, you would be breaking the laws to deal with the 1's and 0's of a computer. His laws really only apply to how a HUMAN sees the data, you would need a complete paradigm shift in computer technology, in order to make computers operate the same way humans do. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, June 01, 2011 10:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] 2 quick questions The problem (not to do with programming but rather the real world) concerns batches. Just as CPUs are made in large stamped volumes, and hence chopped into individual chips. The problem devolves into batch not individual chips, or eggs for that matter. Much as I love AutoNumbers, I also realize that Intelligent Keys have a place in the world, and everything depends on the discipline. A. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.