Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

what is meant by data integrity

Former Member

‎06-20-2007 6:39 AM

0 Kudos

hi

what is meant by data integrity

2 REPLIES 2

satykumar
Product and Topic Expert
Product and Topic Expert

‎06-20-2007 6:42 AM

0 Kudos

Hi,

The term data integrity has the following meanings:

1. Ensuring that the data is "whole" or complete. For example, a social security id belongs to a person. Without relating the social security id to a person, the social security id is orphan data or not complete / whole.

2. The condition in which data is identically maintained during any operation, such as transfer, storage, and retrieval.

3. The preservation of data for their intended use.

4. Relative to specified operations, the a priori expectation of data quality.

Regards,

Satyendra

Former Member

‎06-20-2007 7:35 AM

0 Kudos

Data integrity also means that ensuring data is not duplicated. So instead of putting whole data into one large d/b table, it is split into multiple small tables and then they are linked using foreign key relationship.

Give points if useful,

Aleem.