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:22] peter |
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== | ||
- | ^ Customer | + | |^ ID |
- | | Johson | + | | 248 | Johson |
- | | Smith | Alphen a/d rijn | | + | | 2342 |
- | * Different | + | Different spelling |
- | | + | Data quality rule: City names are spelled out in a uniform manner. |
- | ===Inconsistency between two files=== | + | ==Inconsistency between two files== |
- | ^ Customer | + | |
- | | 4320 | T | Sanders | + | |
+ | ^ ID ^ Initials | ||
+ | | 4320 | T | Sanders | ||
- | ^ Customer | ||
- | | 4320 | T.M.D | Sanders | ||
- | * Inconstistency: | + | ^ ID ^ Initials |
- | | + | | 4320 | T.M.D | Sanders |
+ | Inconsistency: | ||
+ | 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(s)=== | + | ===Reference=== |
DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https:// | DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https:// | ||
+ | |||
+ | {{tag> | ||