knobit.org

Recognises a declared constraint the target platform does not enforce

edu:Knobit

https://knobit.org/id/knobit/K-313

Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium

Context functionsResult evaluation
Knobit creation methodsAI generated, AI edited
Knobit creation methodsAI generated, human edited
Knobit typesSkill
LCG purposesAssessing the learner's knowledge or skill state
LCG purposesSelecting an assessment task or learning activity
action verbRecognises en
applies knowledgeExplains rule enforcement mechanisms and platform enforcement
assessment criterionFlags the deficient case and passes the acceptable one. Deficient: `enforcement: constraint` on a Snowflake target, with nothing else Acceptable: A DQ rule citing it as well, so the load is the guarantee and the check reports breaches (`DQR-017`) en
assessment methodskill-tests task: Loan application data rules (data rule anomaly skills) en
conforms to profilehttps://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifierK-313
dcterms:identifierQ-213
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
dcterms:sourceReview checklist 02-data-rules (data-quality), row 13; formerly data-modelling K-313 en
dcterms:sourceShared-URI copy of data-quality Q-213 (Review checklist 02-data-rules (data-quality), row 13) en
expected resultThe constraint, the fact nothing enforces it, and the data quality check it needs en
owl:sameAshttps://bitbucket.org/reffa/ontology/id/knobit/data-modelling/03-data-rules/13
rdfs:labelRecognises a declared constraint the target platform does not enforce en
schema:creativeWorkStatusaccepted
schema:isPartOfData modelling (DAMA-DMBOK2)
schema:isPartOfData quality management (DAMA-DMBOK2)
skos:altLabelConstraint the platform does not enforce (physical model) en
skos:altLabelConstraint the platform does not enforce, with no check (data quality rule) en
skos:altLabelRule lost to a non-enforcing platform (data rule) en
skos:altLabel`-- NOT ENFORCED` read as a guarantee (generated DDL) en
skos:definitionSnowflake and Databricks accept constraint syntax and enforce none of it, so every rule marked `constraint` there is unenforced. en
skos:prefLabelRecognises a declared constraint the target platform does not enforce en
target objectconstraint declared on Snowflake, Databricks or another non-enforcing target en

Used by

includes knobitDesigns a physical data model for the target platform without introducing anomalies
includes knobitGenerates DDL per target dialect and reviews it against model, engine, data and deployment
includes knobitDocuments data rules in SBVR and resolves rule anomalies
includes knobitDerives data quality rules from the data rules and the physical model
includes knobitIdentify critical data and business rules
includes knobitDevelop and deploy data quality operations: manage data quality rules
requires knobitDesign the physical data model
requires knobitGenerate and review DDL
requires knobitDocument data rules in SBVR
requires knobitDerive data quality rules
schema:supersededByConstraint the platform does not enforce (physical model)
schema:supersededBy`-- NOT ENFORCED` read as a guarantee (generated DDL)
schema:supersededByConstraint the platform does not enforce, with no check (data quality rule)