Explains vertical and horizontal partitioning of tables

K-660 · Knowledge knobit · Activity: Design the physical data model · Competence: Data modelling

Splitting a table by columns or rows, and what keeps the parts one entity.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: Splitting a table by columns or rows, and what keeps the parts one entity

How it is assessed: Decides for sample splits whether they stay lossless and constrained

Related knobits

Builds on

• K-563 Explains lossless-join decomposition

Needed for

• K-604 Recognises a lossy or unconstrained vertical split
• K-605 Recognises an entity split into clone tables by value

All 40 knobits of Design the physical data model.

Source: Data-management practice used by the stage 6 reference and review checklist