@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-826 a edu:Knobit ;
    rdfs:label "Recognises undetected drift between database and model"@en ;
    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 ;
    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 ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-859,
        knobit:K-914 ;
    edu:assessmentCriterion "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 ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "The missing comparison with the generated DDL"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "deployed catalogue"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-859 rdfs:label "Explains testing DDL by execution and detecting drift"@en .

knobit:K-914 rdfs:label "Explains forward and reverse engineering of data models"@en .