Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: A Question on Integrety

Re: A Question on Integrety

From: Mike Sherrill <MSherrillnonono_at_compuserve.com>
Date: Sun, 21 Dec 2003 01:27:02 -0500
Message-ID: <3qeauv0n8sqes6t0csn6kbv0a9lss9ao0d@4ax.com>


On Sat, 20 Dec 2003 08:42:51 -0600, "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote:

>> IME, the idea never bears fruit. Bad data never becomes good data
>> without a *lot* of effort, and the effort is almost wasted when you
>> put the good data into a database where "anything goes (in)".
>>
>
>This statement seems analogous to something like "it makes no sense to make
>a draft of a paper using word processing software before finalizing it".

It might seem that way, but it's not. A draft of a paper and a published version of a paper are two different things. And that's my point. A CHAR(2) column (say) whose domain is all possible two-letter combinations is a different thing than a CHAR(2) column whose domain is the two-letter state codes governed by the USPS.

>A good implementation of a DBMS should provide similar features. As I
>understand it, in some implementations of an RDBMS (or perhaps only in
>Tutorial D) there is the ability to implement local constraints rather than
>only global constraints.

Where did you read that?

-- 
Mike Sherrill
Information Management Systems
Received on Sun Dec 21 2003 - 00:27:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US