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¶
Does it exist? Not checked yet. This entry carries no identifier to resolve. It was extracted from the citation as written in the article, normalized, and deduplicated against the rest of the registry.
Does it back the claim? Not recorded. The single citation of this work carries no recorded support check.
Support is checked per citation rather than per work — the same source can be cited soundly in one article and wrongly in another. Per-citation recording began recently, so a citation with no recorded check is a gap in the record rather than evidence it went unchecked.
See how references were verified.
Registry ID ref:7a02cdcdca2f · see in the full table