Abstract
A method is disclosed for binding a free-text reference, stored inside a semi-structured document column of a relational record, to the catalogs of assets it may name, when the records are written by an external component presumed to fail open silently on a database error. The reference field's write path is deliberately left unconstrained: no foreign key, generated-column foreign key, rejecting trigger or check constraint is placed on it, because rejecting a write from a fail-open writer converts a visible defect (a reference that resolves to nothing) into an invisible one (a record that is never written). Instead, a resolved view normalizes the reference, left-joins it to two candidate target catalogs on each catalog's identifier key, and classifies every record into one of four states: resolved, dangling, missing (the record's declared response class calls for a referenced asset and none is named), and not required (the record's class is the designated no-response class or null and it names none). A guard program reads the active records from the view and exits with a defect code on dangling references not listed in a baseline of accepted pre-existing defects, keyed on the pair of record identifier and exact normalized (trimmed) reference value, or in a strict mode on every dangling reference. It separately reports as stale every baseline entry that no longer matches a current dangling record. An unreadable baseline suppresses nothing, and a guard that cannot query the view exits with a code distinct from both success and defect.
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 License.
Recommended Citation
Assuncao, gustavo matthew, "Write-Permissive Binding of Free-Text References in Semi-Structured Columns: Dual-Target Four-State Resolved View and a Baseline Guard That Reports Its Own Stale Suppressions", Technical Disclosure Commons, ()
https://www.tdcommons.org/dpubs_series/13248