Search code examples
databasedata-integritydata-quality

Is there a difference between the terms "data integrity" and "data quality"?

I was asked this question in an interview today, and didn't know how to answer.

Can anyone provide an insight as to the differences?

Solution

  • Data integrity: The accuracy and consistency of stored data, indicated by an absence of any alteration in data between two updates of a data record. Data integrity is imposed within a database at its design stage through the use of standard rules and procedures, and is maintained through the use of error checking and validation routines.

    Data quality is a perception or an assessment of data's fitness to serve its purpose in a given context.

    Aspects of data quality include: 

    Accuracy
Completeness
Update status
Relevance
Consistency across data sources
Reliability
Appropriate presentation
Accessibility