Re: Help! I can't support normalization
Date: 5 Nov 2002 17:28:05 -0600
Message-ID: <Xns92BDA8863232Epingottpingottbah_at_209.189.89.243>
mikharakiri_at_yahoo.com (Mikito Harakiri) wrote in news:bdf69bdf.0211051522.554294f8_at_posting.google.com:
> OK. People unanimously voted for the separation of the Last Name and
> a First Name.
>
> How about mantissa and logarithm of a decimal number? For example, why
>
> 1.33e-12
>
> couldn't be considered as a concatenation of the "first name" 1.33
> and the "last name" -12. Wouldn't it be better store a number in 2
> columns?
At a certain point, functionally decomposing because you can doesn't mean you should. Logically, separating the two doesn't make sense because atomic mathematical operations wouldn't work efficiently.
If there's a business requirement though (e.g. you need to search for -12), then I'd create derived columns to support the requirement but not replace the actual value.
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Wed Nov 06 2002 - 00:28:05 CET