SQL Antipatterns: Avoiding the Pitfalls of Database Programming¶
Karwin, B. (2010). SQL Antipatterns: Avoiding the Pitfalls of Database Programming: Avoiding the Pitfalls of Database Programming.
Cited by¶
1 citation across 1 artifact.
Each citation links to the sentence it supports in the citing article.
Domain-specific¶
- Inner-Platform Effect
- Entity-Attribute-Value tables: facing rapidly-changing entity types, designers abandon table-and-column for a generic EAV table that ends up re-implementing query planning, type checking, constraint enforcement, and joins inside the relational database, worse than its native facilities.
This sourceDescribes the Entity-Attribute-Value (EAV) anti-pattern, in which a generic schema re-implements typing, constraints, and query planning worse than the host RDBMS.
- Entity-Attribute-Value tables: facing rapidly-changing entity types, designers abandon table-and-column for a generic EAV table that ends up re-implementing query planning, type checking, constraint enforcement, and joins inside the relational database, worse than its native facilities.
Verification¶
This reference passed the adversarial substantiation pipeline: it was checked to exist and to support the claim it is attached to. See how references were verified.
Registry ID ref:7a02cdcdca2f · see in the full table