Re: database integrity

From: x <x_at_not-exists.org>
Date: Thu, 19 May 2005 16:56:59 +0300
Message-ID: <d6i5vu$hgp$1@domitilla.aioe.org>

"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:1116507337.775726.148290_at_f14g2000cwb.googlegroups.com...

> mountain man wrote:
> > Q1: What is database integrity?
> >
> > A1:  A measure of the self-referential consistency of all
> > the relations existent between the physical data elements
> > defined in the schema of a database.
> >
> > Any disagreements, improvements, comments?

> So perhaps, and with additional simplifications:

> A2: A measure of the consistency of the relationships between the data > elements defined in a database.

Or (database) integrity is (a measure of ???) consistency (of relationships) ?
I think it is an all or nothing affair unless you are in the data recovery business.

Means to protect database integrity:
- constraints (normalization, data type, keys, referential integrity, etc.)

• permissions, privileges
• backups
• good hardware
• good software
• good users
• good watchdogs
• good luck
• plan B

Received on Thu May 19 2005 - 08:56:59 CDT