| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Notions of Type
Bob Badour wrote:
> Keith H Duggar wrote:
>
>> Bob Badour wrote: >> >>> JOG wrote: >>>
What a refreshing change of topic, back to basics (instead of anti-existentialist mumbo-jumbo and extravagant philosophy as well as big words that don't seem necessary to learn the cdt topic) is okay with me. Not being a mathematician or engineer or for that matter not being much of anything, in my old assembler days I unconsciously eliminated all domains that included zero. This was partly because I didn't know how to get the OS to trap divide-by-zero (in some cases, even the OS didn't know how to do that!) - I just made sure all numbers had a very small fractional part. For reading anything tabular, I prefer blanks over zeroes any day.
Most of that programming had to do with market research and I can't remember a customer ever complaining. (What they did complain about was being told their market share was declining while their business was increasing - president of Loblaws regularly refused to pay for reports unless we bumped his share! Similar attitude from big-name accountants who got rid of the rounding errors in their books by zeroing all penny amounts.)
I haven't met a user yet who didn't understand at some level that the use of any computer software involves some mental suspension of reality. They typically put up with consultants who stated otherwise out of fear of the boss or the consultant's shareholder uncle. In the mundane biz world that pays for most of the db hokum, there are a few times when high precision matters but I'd say it's economical to handle those specially.
As for the 'empty algebra', I think in an ideal world this appl'n pgmr would prefer a string domain that didn't even support length and was limited to only 'member of' and 'equals' operators. That's assuming complete disjunction and negation aren't supported, which for a mundane appl'n they don't need to be. (I seem to remember some people here think an equality test is part of the RM, so please don't bother flaming me with objections to the above, on this point I'd had to say I'm a fairly quiet ignorami whose mind is pretty much made up.)
p Received on Wed Aug 16 2006 - 20:12:16 CDT
![]() |
![]() |