This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data_quality_dimension:consistency [2023/03/12 17:24] peter [Table] |
data_quality_dimension:consistency [2024/03/08 13:33] (current) |
||
---|---|---|---|
Line 7: | Line 7: | ||
* Record level consistency is the degree to which two [[data_concept: | * Record level consistency is the degree to which two [[data_concept: | ||
- | ===Relation(s)=== | + | ===Relation=== |
- | | + | |Consistency| is a [[general_term: |
- | * Consistency | + | |
- | * Consistency is a [[general_term: | + | |
- | * Consistency is a [[general_term: | + | |
===Examples== | ===Examples== | ||
Line 20: | Line 18: | ||
| Veldweg 11 | 8051 NK | Hattem | | Veldweg 11 | 8051 NK | Hattem | ||
- | * Postcode doesn' | + | Postcode doesn' |
- | | + | Data quality rule: The postcode matches the address according to the postcode table |
==Inconsisteny within a file== | ==Inconsisteny within a file== | ||
Line 28: | Line 26: | ||
| 2342 | Smith | Alphen a/d rijn | | | 2342 | Smith | Alphen a/d rijn | | ||
- | * Different | + | Different spelling |
- | | + | Data quality rule: City names are spelled out in a uniform manner. |
+ | |||
+ | ==Inconsistency between two files== | ||
- | ===Inconsistency between two files=== | ||
^ ID ^ Initials | ^ ID ^ Initials | ||
| 4320 | T | Sanders | | 4320 | T | Sanders | ||
- | ^ Customer | + | ^ ID ^ Initials |
- | | 4320 | + | | 4320 | T.M.D | Sanders |
- | * Inconstistency: Different initials of the same customer. | + | 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 | ||
+ | | 123-RT-97 | ||
+ | Inconsistency: | ||
+ | Data quality rule: Maileage increases over time or remained the same. | ||
- | + | ===Reference=== | |
- | ===Reference(s)=== | + | |
DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https:// | DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https:// | ||
+ | |||
+ | {{tag> | ||