MB Software Solutions <> wrote:
> Paul Newton wrote:
>>> Because you’re a sissy? http://www.kottke.org/04/10/normalized-data
>>>
>>>
>> OK - I checked it out - a LOT of the comments were in disagreement
>> with the thesis
>>
>
> The attitude "space is cheap" has always bothered me. Imo, it's cut
> from the same cloth as "let's just throw more people/money at the
> problem rather than fix it." Sure, like everything, the answer "it
> depends" is relevant here yet again. I've seen tables used for
> messaging and/or simple lookups, and although at one glance they look
> like shit, well, that's what makes the views/stored procedures that
> much more valuable--to extract and give you what you need rather than
> worry about the structure of the underlying database tables.
>
> Personally, I don't like denormalization in most instances because of
> the same reason this guy said in the comments of that article:
>
> chris crippen says:
> and if you have more then one programmer working on different
> parts of an application, each programmer then needs to know where
> to update each table that that holds this "duplicate" information.
> missing one update could invalidate your entire database.
> *
> *
>
> The integrity of the data means more to me than squeezing a few more
> fractions of a second for speed.
Chris Crippen has got to be kidding? Right? "each programmer then needs to
know where
to update each table that that holds this "duplicate" information."
What is duplicate information? Pkey to Fkey or did I miss something along
the lines? I am not restating the customer info for each Sales Order I
write, and I hope that Chris is not as well.
Having Views and or SPs are just a central code base for extracting data. I
like them but currently am not allowed to ask for them. So I have to create
the same code base in a biz tier. Oh well you do what you have to.
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.14/912 - Release Date: 7/22/2007
7:02 PM
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
