Abstract
A method is disclosed for enforcing, inside a relational database, which actors may move a container of a work-tracking hierarchy (a task, a project, a program) into a closure state, whichever writer performs the update. Actor authority is stored as data in a rank table, and the minimum rank for each pair of hierarchy level and target closure state is stored as data in a transition matrix. On each level's state column, a before-update row trigger fires whenever the value changes and acts only when the new value is a closure state. It resolves the rank of the actor identity carried in the row being written and aborts the statement with a named exception when that rank is below the matrix minimum. Because the actor travels in the row rather than in the database connection, batch processes, interactive boards, hand-written statements and automated jobs are held to one rule. A before-insert rule requires a new outermost container to have a creator at or above a compiled creation rank and complete governance fields. It exempts rows whose creator carries a reserved seed prefix, because insert-or-ignore seed statements still fire before-insert triggers. Required parent references are promoted to NOT NULL at boot only when the stored population is already clean. Derivation triggers are sequenced by the engine's name-order firing rule, and a periodic pass detects missing, disabled or interleaved chain triggers.
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 License.
Recommended Citation
Assuncao, gustavo matthew, "Rank-as-Data Closure Authority Enforced by Row-Carried Actor Identity in State-Transition Triggers, with Seed-Exempt Birth Rule, Population-Gated Constraint Promotion and Name-Ordered Trigger Chains", Technical Disclosure Commons, ()
https://www.tdcommons.org/dpubs_series/13247