Subject:
|
Re: wishing upon a star
|
Newsgroups:
|
lugnet.db.brictionary
|
Date:
|
Wed, 25 Aug 1999 17:55:47 GMT
|
Reply-To:
|
LPIENIAZEK@spamcakeNOVERA.COM
|
Viewed:
|
1598 times
|
| |
|
|
Yes, indeed, John is (as evah) right. Let me weigh in here as well...
Putting meaning in keys is a sign of not very well seasoned designers,
IMHO.
A pretty strong principle of database design is NOT to let your key have
business meaning. Get keys from a source that is intended to be unique,
then never ever ascribe meaning to them. All meaning should be in
attributes.
Else your business logic will be tres brittle and you will live to
regret it. Don't do it. Trust me.
obQual: 15 years experience in the industry, make a living as a System
Architect, have cleaned up the mess that business meaning in keys makes
at over a dozen different clients.
--
Larry Pieniazek larryp@novera.com http://my.voyager.net/lar
- - - Web Application Integration! http://www.novera.com
fund Lugnet(tm): http://www.ebates.com/ Member ref: lar, 1/2 $$ to
lugnet.
NOTE: I have left CTP, effective 18 June 99, and my CTP email
will not work after then. Please switch to my Novera ID.
|
|
Message has 2 Replies:
 | | Re: wishing upon a star
|
| (...) Taking that to the ultimate suggests even the TLG part number should not be the key (which of course is already a known issue if you want to account for color and/or printing). (25 years ago, 25-Aug-99, to lugnet.db.brictionary)
| | | Re: wishing upon a star
|
| (...) Pardon my inexperience. I am neither a program designer, nor a person with any business logic whatsoever...perhaps I should have footnoted these factss before sticking my idea out here. I think that 90% of the users of a would-be (...) (25 years ago, 26-Aug-99, to lugnet.db.brictionary)
|
Message is in Reply To:
| | Re: wishing upon a star
|
| Hi guys, I would urge caution on the creation of complex codes to identify pieces. I admit, I am prejudiced. I worked on a database management project back in the early 80s for a water-quality study in which water samples were identified with a (...) (25 years ago, 25-Aug-99, to lugnet.db.brictionary)
|
22 Messages in This Thread:
  
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
