Skilirium

Recognises an attribute holding several facts

K-505 · Skill knobit · Activity: Derive the logical data model · Competence: Data modelling

An attribute whose value is parsed: an aggregate the business sorts or matches by part, or a code whose segments carry meaning. When the meaning of a segment changes, every value is wrong.

Can AI do this?

AI does this well Most of the tested AI models master this. 9 of 10 models master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 100%Mastered
gemini-3.1-pro-previewFlagship 100%Mastered
gpt-6-astraFlagship 100%Mastered
claude-fable-5-1Flagship 100%Mastered
gemini-3.8-flashMid tier 100%Mastered
gpt-6.1-solMid tier 100%Mastered
claude-sonnet-5-5Mid tier 100%Mastered
gemini-3.5-flash-liteLow cost 70%Not shown
gpt-6-lunaLow cost 98%Mastered
claude-haiku-5-5Low cost 94%Mastered

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The attribute and the separate facts its value contains

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Account Identifier (the IBAN) as one Text although reports group by bank identifier; product code CUR-TLN-2026-0042 parsed for product family, branch and year Acceptable: Country code, check digits, bank identifier and account number as separate attributes; Product Code kept opaque, with product family, branch and year as attributes of their own

Also known as: Several facts in one attribute (logical model)

Related knobits

Builds on

All 56 knobits of Derive the logical data model.

Source: Review checklist 05-logical, row 5; S&W 2.5.1, 5.3.1–5.3.3