data_quality_dimension:consistency

Consistency

Temporal consistency is the degree to which data values of a data element of a dataset at different points in time comply with a data quality rule.
Consistency across datasets is the degree to which data values of data elements of different datasets comply with a data element of a dataset at different points in time comply with a data quality rule.
Cross records consistency is the degree to which data values between data records comply with a data element of a dataset at different points in time comply with a data quality rule.
Record level consistency is the degree to which two data values within a data record comply with a data element of a dataset at different points in time comply with a data quality rule.

Consistency

is a characteristic of related

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

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.

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.

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.