Recognises an index set not derived from access paths
https://knobit.org/id/knobit/K-621
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains index design from access paths |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `payment.account_id` unindexed, so deleting an account scans and locks `payment`; an index on every column; `ix_party_registry_code` non-unique Acceptable: An index for each foreign key (`PHY-022`), each natural-key unique constraint, and each access path in the requirements, each index's `comment` citing which; speculative ones marked provisional en |
| assessment method | skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-621 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 04-physical, row 21; Karwin, Index Shotgun; C&B ("design file organisations and indexes"); S&W 12.4; E&N 17.7 en |
| expected result | Missing, duplicate or wrongly non-unique indexes against the access paths en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/21 |
| rdfs:label | Recognises an index set not derived from access paths en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Index set not derived from access paths (physical model) en |
| skos:definition | Indexes missing where foreign keys, natural keys and stated access paths need them; indexes duplicated or overlapping; a non-unique index where the rule says unique. The last is a specific form of row 14; the rest are performance defects. en |
| skos:prefLabel | Recognises an index set not derived from access paths en |
| target object | index set of a table en |
Used by
| includes knobit | Designs a physical data model for the target platform without introducing anomalies |
|---|---|
| requires knobit | Design the physical data model |