=====Consistency=====

===Definitions===
  * Temporal consistency is the degree to which [[data_concept:data value|data values]] of a [[data_concept:data element|data element]] of a [[data_concept:dataset|dataset]] at different points in time comply with a [[data_quality_management_system/data_quality_rule|data quality rule]].
  *   Consistency across datasets is the degree to which [[data_concept:data value|data values]] of [[data_concept:data element|data elements]] of different [[data_concept:dataset|datasets]] comply with a [[data_concept:data element|data element]] of a [[data_concept:dataset|dataset]] at different points in time comply with a [[data_quality_management_system/data_quality_rule|data quality rule]].
  * Cross records consistency is the degree to which [[data_concept:data value|data values]] between [[data_concept:data record|data records]] comply with a [[data_concept:data element|data element]] of a [[data_concept:dataset|dataset]] at different points in time comply with a [[data_quality_management_system/data_quality_rule|data quality rule]].
  * Record level consistency is the degree to which two [[data_concept:data value|data values]] within a [[data_concept:data record|data record]] comply with a [[data_concept:data element|data element]] of a [[data_concept:dataset|dataset]] at different points in time comply with a [[data_quality_management_system/data_quality_rule|data quality rule]].

===Relation===
|Consistency| is a [[general_term:characteristic|characteristic]] of related |[[data_concept:data value|data values]]|


===Examples==

==Inconsistancy within a record==

^ Adress      ^ Postcode  ^ City    ^
| Veldweg 11  | 8051 NK   | Hattem  |

Postcode doesn't match with adress.\\ 
Data quality rule: The postcode matches the address according to the postcode table

==Inconsisteny within a file==
|^ ID    ^ Customer  ^ City name            ^
| 248   | Johson    | Alphen aan den rijn  |
| 2342  | Smith     | Alphen a/d rijn      |

Different spelling of city name.\\ 
Data quality rule: City names are spelled out in a uniform manner.

==Inconsistency between two files==

^ ID    ^ Initials  ^ Name     ^
| 4320  | T         | Sanders  |


^ ID    ^ Initials  ^ Name     ^
| 4320  | T.M.D     | Sanders  |

Inconsistency: Different initials of the same customer.\\ 
Data quality rule: Initials of the same person are the same.

==Inconsistency over time==
^ License plate  ^ Date          ^ Mileage  ^
| 123-RT-97      | 6 March 2020  | 60,543   |
| 123-RT-97      | 8 May 2021    | 45,765   |

Inconsistency: Mileage decreases over time.\\ 
Data quality rule: Maileage increases over time or remained the same.

===Reference===
DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https://www.dama-nl.org/wp-content/uploads/2020/09/DDQ-Dimensions-of-Data-Quality-Research-Paper-version-1.2-d.d.-3-Sept-2020.pdf

{{tag>All DataQualityDimension}}