| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A Simple Notation
paul c wrote:
> Bob Badour wrote: >
> > Just agreeing (I think) - in Codd's RM, "NOT" means complement relative > to a relation with a specific heading. For argument's sake, if today's > giga-byte machines were limited to types of single byte integers, many > negated results would be tractable. For the average person (like me!) > <AND> is not hard to see as inference, <NOT> seems inherent in "DELETE" > and <OR> seems necessary to "INSERT". Mechanically, we could get rid of > any two ops if we wanted, but they are helpful at least for our > intuition. They are merely devices and remind me that RM > implementations can only imitate what we think we are modelling whereas > the mystical school seems to believe that we can echo exactly. The > usefulness of the RM approach seems to me to be that when comparing the > machine result to our own activities there is only one mental > transformation needed, ie., from "real world" to first-order logic and > sets - no need to ask whether the machine is wrong assuming it is > faithful to FOL.
I am not sure whether you understood my point, and this is perhaps where a concrete example might help.
In a mathematical sense, the domain of cattle is vast--even infinite. We can talk about hypothetical cows, steers, bulls, calves etc. that never existed and will never exist.
My neighbours operate a feedlot. To my neighbours, the concept of cattle who do not have 3 or more permanent teeth is a very important concept. When discussing this concept with my neighbours, the universe of discourse is always obvious.
If we are talking about my neighbours sorting their cattle, the universe of discourse is the finite set of cattle in their feedlot. If we are talking about the price of cattle, the universe of discourse is the finite set of cattle within a reasonable travelling distance from the market.
In either case, the actual universe of discourse is infinitesimally small compared to the vastness of the mathematical domain of cattle. In both cases, the concept of "NOT 3 or more permanent teeth" is fully understood by all conversants from the context of the discussion.
Even the finite domain in a logical or physical data model of a computer system will generally be much larger than the known universe of discourse. One could argue that including all of the values in the domain that are not in the universe of discourse is not only cost ineffective but simply wrong.
Replacing NOT with MINUS allows one to explicitly state the universe of discourse--including the entire domain when that is the appropriate universe. Received on Thu Jul 05 2007 - 11:07:47 CDT
![]() |
![]() |