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

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.

Share

COinS