Jim Lawrence
accessd at shaw.ca
Wed Jun 1 19:57:12 CDT 2011
Hi Susan: Database technology has definitely evolved. Most major internet sites are using blended "NoSQL" solutions, like Amazon, Google, Facebook, Yahoo etc. The new Cloud environment is a serious implementer of this technology. http://en.wikipedia.org/wiki/NoSQL These new super-DBMS can handle millions of transactions per second...really awesome and even the new distributive languages that support these new data stores are equally as impressive as they have almost unlimited scalability. Jim PS you should do a write up on this Susan. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, June 01, 2011 4:46 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] 2 quick questions And... I've been wanting to say this for days now... technology evolves. Why is the idea that a pk could evolve -- or perhaps devolve as may be more accurate in this case -- ... controversial to some? Things change. We learn, we adapt, and we improve. You could open a dictionary to just about any page and find a few words that mean more, or less, than they once did. Second time this week I've been reminded of the Mad Max movie where the kids out in the desert create their own language. :) Susan H. > But you must admit that his "laws" have never been fully implemented in > database designs for that very reason. > > Charlotte Foust > > On Wed, Jun 1, 2011 at 4:29 PM, Jim Dettman <jimdettman at verizon.net> > wrote: > >> 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 >> >> >> > -- > 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