Recognises a business fact held in physical row order
A business fact read from row order, insertion order or the order of generated key values rather than from a column. It changes with parallel loads, sequence caching, reorganisation or migration.
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: The fact and the column to hold it
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: "The current address is the one with the highest address_id"; "payments in order of booking" read from identity order Acceptable: booked_at, valid_from or a version number as columns, and the current row identified by its data
Also known as: Meaning held in physical order (physical model)
Related knobits
Builds on
All 40 knobits of Design the physical data model.
Source: Review checklist 06-physical, row 20; Codd 1970 §1.2