Re: database integrity

> Is the measure of integrity an issue in your organisation's database?
> If it is, how do you go about increasing the level of this integrity?

> Finally, are there any here who think that database integrity is
> a theoretical concept only, in that it may always be treated as being
> measured at the 100% level due to the "new relational technology"?

Suppose at the core of your business is a huge database maintained by your organisation and each false piece of data from the database can cost you millions of dollars if you rely on it.
What can you do if you are not 100% sure of the data ? The database become useless because you need to manually verify each piece of data you retrieve.

Now suppose that each false piece of data cost you 0.01 dollars and you have only a few hundreds of those pieces.
Then you risk a few dollars. In this case maybe you can talk about levels.

Integrity is not the only issue. The database may contain false data (by aging for example).
Integrity measures are the only way for a DBMS to protect the data from coruption.
You need to complement the automated integrity procedures with manual procedures and introduce feedback circuits in your data processing system. Received on Thu May 19 2005 - 17:21:56 CEST