8. etapp

DDL-i genereerimine ja ülevaatus

Genereerib sihtmurdele DDL-i ja vaatab selle üle mudeli, andmebaasimootori, andmete ja juurutuse suhtes

37 knobitit (9 teadmist, 28 oskust) · Tulemus: generated DDL · Tugineb: Andmekvaliteedi reeglite tuletamine, Füüsilise andmemudeli kujundamine

Knobitite kaart

Iga märk on üks knobit. Ülemised knobitid tuginevad alumistele; vali üks, et see avada.

Ring: oskus
Ruut: teadmine

Selle etapi knobitid

Knobit		Liik
K-801	Recognises generated SQL edited by hand	Oskus
K-802	Recognises DDL older than its model	Oskus
K-803	Recognises an object in the SQL missing from the model	Oskus
K-804	Recognises generator warnings carried without a decision	Oskus
K-310	Recognises a constraint claimed by a rule and missing from the schema	Oskus
K-806	Recognises a configured dialect left unregenerated	Oskus
K-313	Recognises a declared constraint the target platform does not enforce	Oskus
K-808	Recognises a CHECK constraint parsed and ignored	Oskus
K-809	Recognises an expression running on one engine only	Oskus
K-810	Recognises a truncated identifier taken as the real name	Oskus
K-811	Recognises a reserved word used as an identifier	Oskus
K-812	Recognises a type meaning something else on another engine	Oskus
K-813	Recognises an index the target engine cannot create or run	Oskus
K-814	Recognises a foreign-key cycle taken as resolved	Oskus
K-618	Recognises binary floating point used for an exact quantity	Oskus
K-816	Recognises one decimal scale for every currency	Oskus
K-817	Recognises a length taken from sample data	Oskus
K-827	Recognises an event timestamp stored without a time zone	Oskus
K-828	Recognises a business date stored with a time of day	Oskus
K-819	Recognises a collation changing what a key means	Oskus
K-820	Recognises a default inventing a business fact	Oskus
K-821	Recognises a restricted column without access design	Oskus
K-822	Recognises greenfield DDL aimed at a populated database	Oskus
K-823	Recognises a drop script used as a rollback	Oskus
K-824	Recognises an environment baked into the script	Oskus
K-825	Recognises SQL reviewed without being run	Oskus
K-826	Recognises undetected drift between database and model	Oskus
K-851	Explains generated artefacts and their single source of truth	Teadmine
K-852	Explains SQL dialect differences	Teadmine
K-853	Explains currency minor units	Teadmine
K-854	Explains time zones in timestamps and business dates	Teadmine
K-855	Explains collation and case or accent sensitivity	Teadmine
K-856	Explains access design for classified data	Teadmine
K-857	Explains schema migration and rollback	Teadmine
K-858	Explains environment-independent deployment	Teadmine
K-859	Explains testing DDL by execution and detecting drift	Teadmine
K-641	Routes a defect to the deliverable responsible for it	Oskus