Sub-dimension of Kahn’s DQA framework | Keywords of ADL | Definition | Example of constraint description | DQR templates with example for problematic data (in pseudocode) |
---|---|---|---|---|
Relational conformance | Cardinality | Limits the max number of memberships | (2..5) | Select * |
From archetypes group by attributes having count(*) > 5 and count(*) < 2 | ||||
Occurrences | Data exist only once | (1..1) | Select attribute | |
From archetype | ||||
group by attribute having count(*) ! = 1 | ||||
Completeness | Existence | Attribute value is optional | (0..1) | – |
Attribute value is mandatary | (1..1) | Select attribute | ||
From archetype | ||||
Where attribute is Null or attribute = ‘’ | ||||
Uniqueness plausibility | Cardinality | Objects in one list are not duplicate | (..unique) | Select * |
From archetypes group by attributes having count(*) > 1 | ||||
Value conformance | Defining_code | Designate terminology code | (Codeset) | Select attribute |
From archetype | ||||
Where attribute.code not in {Codeset} | ||||
Matches( ∈) | Value range | (|10..1000|) | Select attribute | |
From archetype | ||||
Where attribute value < 10 or > 1000 | ||||
Designate value | (“mmHg”) | Select attribute | ||
From archetype | ||||
Where attribute.value ! = ‘mmHg’ |