6. etapp

Füüsilise andmemudeli kujundamine

Kujundab sihtplatvormile füüsilise andmemudeli uusi anomaaliaid tekitamata

42 knobitit (12 teadmist, 30 oskust) · Tulemus: physical model · Tugineb: Loogilise andmemudeli tuletamine

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-601	Recognises an unmanaged duplicate column	Oskus
K-602	Recognises logical entities merged into one table	Oskus
K-603	Recognises a stored derived or summary value	Oskus
K-604	Recognises a lossy or unconstrained vertical split	Oskus
K-605	Recognises an entity split into clone tables by value	Oskus
K-606	Recognises rolled-up subtypes losing conditional constraints	Oskus
K-607	Recognises rolled-down subtypes losing supertype constraints	Oskus
K-608	Recognises a hierarchy encoded redundantly	Oskus
K-609	Recognises content held outside the database by reference	Oskus
K-610	Recognises a surrogate key without natural-key uniqueness	Oskus
K-611	Recognises a surrogate value with meaning, reused or renumbered	Oskus
K-612	Recognises an undeclared foreign key	Oskus
K-613	Recognises a referential action destroying what should survive	Oskus
K-310	Recognises a constraint claimed by a rule and missing from the schema	Oskus
K-313	Recognises a declared constraint the target platform does not enforce	Oskus
K-616	Recognises a changeable value list fixed in the DDL	Oskus
K-617	Recognises a physical domain differing from the logical domain	Oskus
K-618	Recognises binary floating point used for an exact quantity	Oskus
K-629	Recognises a sentinel value standing in for null	Oskus
K-630	Recognises a null with a business meaning	Oskus
K-620	Recognises a business fact held in physical row order	Oskus
K-621	Recognises an index set not derived from access paths	Oskus
K-622	Recognises an overwrite where history is required	Oskus
K-623	Recognises inconsistent validity periods in a versioned table	Oskus
K-624	Recognises a reference to a versioned table by business key alone	Oskus
K-625	Recognises a soft delete the constraints do not understand	Oskus
K-626	Recognises a fact table of mixed grain	Oskus
K-627	Recognises a measure without stated additivity	Oskus
K-628	Recognises a nullable foreign key on a reporting join path	Oskus
K-651	Explains controlled denormalisation	Teadmine
K-652	Explains the implementation options for subtypes	Teadmine
K-653	Explains referential integrity and referential actions	Teadmine
K-654	Explains exact and approximate numeric types	Teadmine
K-655	Explains null semantics and three-valued logic	Teadmine
K-656	Explains value sets held as reference data	Teadmine
K-657	Explains index design from access paths	Teadmine
K-658	Explains history strategies and validity-period conventions	Teadmine
K-659	Explains grain and additivity in dimensional models	Teadmine
K-660	Explains vertical and horizontal partitioning of tables	Teadmine
K-661	Explains consistency of content stored by reference	Teadmine
K-662	Explains the absence of row order in relational tables	Teadmine
K-641	Routes a defect to the deliverable responsible for it	Oskus