Re: Newbie question about db normalization theory: redundant keys OK?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Fri, 14 Dec 2007 17:40:38 -0400
Message-ID: <4762f85a$0$5277$9a566e8b_at_news.aliant.net>


raylopez99 wrote:

> On Dec 14, 9:02 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>
>

>>Why does this thread seem to have an air of deja vu all over again?
>>
>>http://groups.google.com/group/comp.databases.theory/browse_thread/th...

>
>
> That was one long thread, and the introduction was very interesting,
> but it was a bit over my head. I didn't finish the thread. From the
> punny and ironic tone I could not figure out whether the OP was for or
> against GUIDs (I think he was for them), but it did set a lot of
> thought processes in motion, and I sort of see the point about data
> integrity being "built in" using compound keys, while flexibility is
> the most when using GUIDs (or something like that).

GUIDs don't buy you anything that I can see. Pay attention to JOG and Liebniz equality.

   I really need to
> buy a book (I saw a few names in the thread) on this stuff at some
> point, though I should tell you I'm coding for fun as a hobby (and
> doing a simple dB now) rather than as a profession.

What do you intend to get out of the hobby? I know people who do carpentry as a hobby, and they want to learn about carpentry. I know people who watch birds as a hobby, and they want to learn about ornithology. When I meet someone who does applied mathematics as a hobby, the person probably wants to learn about applied mathematics.

> And apparently Bob Badour, "Neo" really hates your guts! LOL. These
> debates can get as heated as the ones at alt.global-warming!

I will let Neo speak to the issue whether he hates me. I didn't really see any evidence of that. Profanity doesn't necessarily equate to hatred.

Neo appears to think very much at a concrete level with little abstraction. He has put tremendous effort into whatever it is he calls his product. xdb or something. Sadly, his apparent inability to abstract things limits his product in spite of his efforts. I am never sure whether to admire his tenacity or to pity his limitations.

While I would like nothing better than for Neo to come up with something truly revolutionary for all his efforts, I try not to encourage him because I think the possibility exceedingly unlikely.

> Good luck
>
> RL
Received on Fri Dec 14 2007 - 22:40:38 CET

Original text of this message