Subject:
|
Re: wishing upon a star
|
Newsgroups:
|
lugnet.db.brictionary
|
Date:
|
Thu, 26 Aug 1999 00:05:44 GMT
|
Viewed:
|
1657 times
|
| |
![Post a public reply to this message](/news/icon-reply.gif) | |
In lugnet.db.brictionary, Larry Pieniazek writes:
> 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.
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 PartSearch.com (or whatever) are
NOT businessmen, NOT out to make cash from this, but simply ignoramuses like
myself who would potentially benefit from a more logical numbering sytem that
might enable them to track down the parts they're trying to find.
That said, I'll crawl back under my rock....(made of BURP's, no less)...
Jot and Jab
|
|
Message has 2 Replies: ![](/news/x.gif) | | Re: wishing upon a star
|
| (...) Whoops. Talking in shorthand tripped me up. In system-architect-speak "business" logic is the actual desired work effort of the program (contrasted with non business logic which is the infrastructure or other code that you have to do in order (...) (25 years ago, 26-Aug-99, to lugnet.db.brictionary, lugnet.off-topic.geek)
| ![](/news/x.gif) | | Re: wishing upon a star
|
| In lugnet.db.brictionary, Dave Lovelace writes: [SNIP] (...) Well, not so fast. All ideas are welcome here. Maybe a larger perspective might help. I understand the frustration of an ignoramus coming to LEGO parts naming and numbering. I've been (...) (25 years ago, 26-Aug-99, to lugnet.db.brictionary)
|
Message is in Reply To:
![](/news/x.gif) | | 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 (...) (25 years ago, 25-Aug-99, to lugnet.db.brictionary)
|
22 Messages in This Thread: ![Re: wishing upon a star -Robert Munafo (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Adam Howard (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -John Cromer (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Larry Pieniazek (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/246.gif) ![Re: wishing upon a star -Frank Filz (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Larry Pieniazek (25-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Steve Bliss (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Tamyra Teed (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Robert Munafo (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif)
![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![You are here](/news/here.gif) ![](/news/246.gif) ![Re: wishing upon a star -Larry Pieniazek (26-Aug-99 to lugnet.db.brictionary, lugnet.off-topic.geek)](/news/x.gif) ![](/news/46.gif) ![OID generation (was: Re: wishing upon a star) -Todd Lehman (26-Aug-99 to lugnet.db.brictionary, lugnet.off-topic.geek)](/news/x.gif) ![](/news/246.gif) ![Re: OID generation (was: Re: wishing upon a star) -Larry Pieniazek (26-Aug-99 to lugnet.db.brictionary, lugnet.off-topic.geek)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: OID generation (was: Re: wishing upon a star) -Robert Munafo (26-Aug-99 to lugnet.off-topic.geek)](/news/x.gif) ![](/news/46.gif) ![Re: OID generation (was: Re: wishing upon a star) -Larry Pieniazek (26-Aug-99 to lugnet.off-topic.geek)](/news/x.gif) ![](/news/46.gif) ![Re: OID generation (was: Re: wishing upon a star) -Chris Moseley (28-Aug-99 to lugnet.off-topic.geek)](/news/x.gif)
![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: wishing upon a star -John Cromer (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Dave Lovelace (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/246.gif) ![Re: wishing upon a star -Robert Munafo (26-Aug-99 to lugnet.db.brictionary)](/news/x.gif)
![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: wishing upon a star -John Cromer (27-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Larry Pieniazek (27-Aug-99 to lugnet.db.brictionary)](/news/x.gif) ![](/news/46.gif) ![Re: wishing upon a star -Dave Lovelace (27-Aug-99 to lugnet.db.brictionary)](/news/x.gif)
- 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
|
|
|
|