knobit.org

Generates DDL per target dialect and reviews it against model, engine, data and deployment

edu:LearningOutcome edu:Skill

https://knobit.org/id/outcome/LO-8

Also as Turtle · JSON-LD · RDF/XML

dcterms:descriptionStage 5 (DDL) of the data-modelling skill: Generates DDL per target dialect and reviews it against model, engine, data and deployment; produces 05-ddl/<dialect>/. en
dcterms:identifierLO-8
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
has prerequisiteDesigns a physical data model for the target platform without introducing anomalies
includes knobitRecognises a constraint claimed by a rule and missing from the schema
includes knobitRecognises a declared constraint the target platform does not enforce
includes knobitExplains rule enforcement mechanisms and platform enforcement
includes knobitRecognises binary floating point used for an exact quantity
includes knobitRoutes a defect to the deliverable responsible for it
includes knobitRecognises generated SQL edited by hand
includes knobitRecognises DDL older than its model
includes knobitRecognises an object in the SQL missing from the model
includes knobitRecognises generator warnings carried without a decision
includes knobitRecognises a configured dialect left unregenerated
includes knobitRecognises a CHECK constraint parsed and ignored
includes knobitRecognises an expression running on one engine only
includes knobitRecognises a truncated identifier taken as the real name
includes knobitRecognises a reserved word used as an identifier
includes knobitRecognises a type meaning something else on another engine
includes knobitRecognises an index the target engine cannot create or run
includes knobitRecognises a foreign-key cycle taken as resolved
includes knobitRecognises one decimal scale for every currency
includes knobitRecognises a length taken from sample data
includes knobitRecognises a collation changing what a key means
includes knobitRecognises a default inventing a business fact
includes knobitRecognises a restricted column without access design
includes knobitRecognises greenfield DDL aimed at a populated database
includes knobitRecognises a drop script used as a rollback
includes knobitRecognises an environment baked into the script
includes knobitRecognises SQL reviewed without being run
includes knobitRecognises undetected drift between database and model
includes knobitRecognises a time zone dropped from a timestamp
includes knobitRecognises a business date stored with a time of day
includes knobitExplains generated artefacts and their single source of truth
includes knobitExplains SQL dialect differences
includes knobitExplains currency minor units
includes knobitExplains time zones in timestamps and business dates
includes knobitExplains collation and case or accent sensitivity
includes knobitExplains access design for classified data
includes knobitExplains schema migration and rollback
includes knobitExplains environment-independent deployment
includes knobitExplains testing DDL by execution and detecting drift
owl:sameAshttps://bitbucket.org/reffa/ontology/id/outcome/data-modelling/08-ddl
rdfs:labelGenerates DDL per target dialect and reviews it against model, engine, data and deployment en
rdfs:labelGenereerib sihtmurdele DDL-i ja vaatab selle üle mudeli, andmebaasimootori, andmete ja juurutuse suhtes et
related topicData modelling and design (DAMA-DMBOK2 chapter 5)

Used by

assesses learning outcomeGenerated DDL review, Postgres and Snowflake (DDL review skills)
assesses learning outcomeCard and account mart DDL on five engines, with its release evidence (DDL review skills)
assesses learning outcomeData modelling knowledge: Terms, rules and the conceptual model (CDMP-style questions)
assesses learning outcomeData modelling knowledge: Physical design and DDL (CDMP-style questions)
assesses learning outcomeLoan application physical model on Snowflake (physical design anomaly skills)
has prerequisiteReleases model changes with reasons, impact, semantic versions, migrations, baselines and approval
includes learning outcomeLearning path: Data modelling
related learning outcomeStage 8 — DDL generation
related learning outcomeDDL review checklist
schema:itemhttps://knobit.org/id/path/data-modelling/LO-8