Subject:
|
RE: wishing upon a star
|
Newsgroups:
|
lugnet.db.brictionary
|
Date:
|
Thu, 26 Aug 1999 20:58:02 GMT
|
Viewed:
|
1814 times
|
| |
|
|
Let me add my support to this as well. Make the key be some arbitrary
unique number. I've been programming for about 17-18 years, and in the
early days I would have disagreed. Experience has proven otherwise.
---
Dave Hylands Email: DHylands@creo.com 3700 Gilmore Way
Principal Software Developer Tel: (604) 451-2700 x2329 Burnaby B.C.
Creo Products Inc. Fax: (604) 437-9891 Canada V5G 4M1
-----Original Message-----
From: Larry Pieniazek [mailto:lar@voyager.net]
Sent: Wednesday, August 25, 1999 10:56 AM
To: lugnet.db.brictionary@lugnet.com
Subject: Re: wishing upon a star
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.
|
|
1 Message in This Thread:
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
