Derive data quality rules

https://knobit.org/id/activity/QO-3

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/activity/data-quality/03-dq-rules
rdfs:comment	Stage 3 (Data quality rules) of the data-quality skill: produces 03-dq-rules/dq-rules.yaml and passes the stage's validation gate. en
rdfs:label	Andmekvaliteedi reeglite tuletamine et
rdfs:label	Derive data quality rules en
requires knobit	Explains current value, history and point-in-time reproducibility
requires knobit	Recognises a declared constraint the target platform does not enforce
requires knobit	Recognises an update anomaly in a logical data model
requires knobit	Recognises a stored derivable attribute
requires knobit	Explains the insertion, update and deletion anomalies
requires knobit	Explains third normal form
requires knobit	Explains derived data and point-in-time snapshots
requires knobit	Recognises an unmanaged duplicate column
requires knobit	Recognises a stored derived or summary value
requires knobit	Recognises an overwrite where history is required
requires knobit	Recognises inconsistent validity periods in a versioned table
requires knobit	Recognises a reference to a versioned table by business key alone
requires knobit	Explains controlled denormalisation
requires knobit	Explains null semantics and three-valued logic
requires knobit	Explains history strategies and validity-period conventions
requires knobit	Recognises history kept without its constraints checked
requires knobit	Explains SQL dialect differences
requires knobit	Recognises a rule assigned to a missing data quality check
requires knobit	Recognises a data-update rule with no enforcing or detecting mechanism
requires knobit	Recognises a constraint deferred without a check
requires knobit	Recognises a derived or copied column without a check
requires knobit	Recognises a check with no rule behind it
requires knobit	Recognises a check outliving its rule
requires knobit	Recognises a check unable to fail
requires knobit	Recognises a check on the wrong object
requires knobit	Recognises a check weaker than its rule
requires knobit	Recognises a check stronger than its rule
requires knobit	Recognises a check measuring the wrong population
requires knobit	Recognises nulls left to chance in a check predicate
requires knobit	Recognises a past event judged against present data
requires knobit	Recognises a set rule written as a row rule
requires knobit	Recognises a check expression unable to run
requires knobit	Recognises a misfiled data quality dimension
requires knobit	Recognises duplicate checks for one rule
requires knobit	Recognises a threshold at odds with its rule
requires knobit	Recognises disagreeing severity, threshold and failure action
requires knobit	Recognises a rejection destroying more than it protects
requires knobit	Recognises a check failure with no capable owner
requires knobit	Recognises a check scheduled at the wrong moment
requires knobit	Recognises an aggregate hiding a total failure
requires knobit	Recognises an empty population reported as a pass
requires knobit	Explains data quality dimensions
requires knobit	Explains traceability from data rule to check
requires knobit	Explains the population, measure and threshold of a check
requires knobit	Explains row-level and set-level checks
requires knobit	Explains severity, threshold and failure action
requires knobit	Explains scheduling checks against loads and use
requires knobit	Explains segmented data quality reporting
requires knobit	Explains ownership of data quality failures
schema:position	3

Used by

consists of	Data quality