I5 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I5
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I5 |
| rdfs:label | I5 (1 points) en |
| schema:hasPart | dm-physical-postgres I5: product group hierarchy as a path string |
| schema:identifier | I5 |
| schema:position | 9 |
| schema:text | Hierarchy encoded redundantly: product_group.path holds ancestor ids as a string, edited by hand, with no foreign key on its parts; reorganising a group rewrites every descendant and a mistyped path loads. parent_product_group_id with a self-referencing foreign key becomes the system of record; a path (or closure table) survives only as a derived structure with a derivation and a DQ rule. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I5: product group hierarchy as a path string |