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:23] 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== | ||
| 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== |
| - | ^ 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> | ||