Recognises undetected drift between database and model
https://knobit.org/id/knobit/K-826
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains testing DDL by execution and detecting drift |
| applies knowledge | Explains forward and reverse engineering of data models |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `ix_fact_payment_status_code` added in production during an incident eighteen months ago. It exists in no environment's DDL and in no model, and the next rebuild of the mart is slow for reasons nobody can reconstruct Acceptable: A scheduled comparison of the deployed catalogue (`information_schema`, or the engine's own schema-compare tooling) with the generated DDL, each difference closed deliberately — into the model, or out of the database — and the comparison's result part of the stage-8 evidence en |
| assessment method | skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-826 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 05-ddl, row 26; BCBS 239; Humble & Farley 2010 en |
| expected result | The missing comparison with the generated DDL en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/08-ddl/26 |
| rdfs:label | Recognises undetected drift between database and model en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Drift between the database and the model never detected (generated DDL) en |
| skos:definition | Nothing that compares the deployed catalogue with the current generated DDL. Hotfix indexes, emergency nullability changes and a column someone added under incident pressure accumulate in production, and the model stops describing the thing people actually query — while continuing to look right, which is what makes it dangerous. en |
| skos:prefLabel | Recognises undetected drift between database and model en |
| target object | deployed catalogue en |
Used by
| includes knobit | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
|---|---|
| includes knobit | Maintain the data models |
| includes knobit | Manage data model versioning and integration |
| requires knobit | Generate and review DDL |