Historical Modeling Pattern

Tritemporal Modeling

Quick answer

Tritemporal modeling separates valid time, visibility time and publication time.

Use tritemporal modeling when it is not enough to know what was true and what was known. You also need to know what was officially published, disclosed or used in a reporting output.

This matters when published reports, regulatory submissions, customer statements or executive KPIs must remain reproducible even after corrected history arrives later.

Core idea

Bitemporal modeling tracks truth and knowledge. Tritemporal modeling also tracks publication.

Bitemporal models usually separate business-valid time from system-visible time. That allows you to answer what was true in the business and what the platform knew at a previous point in time.

Tritemporal modeling adds a third axis: publication time. This captures when a result was officially published, frozen, disclosed or used by a downstream reporting process.

Interactive Example

The customer was corrected to Premium, but the official January report was already published as Standard.

The same historical case can produce different answers depending on whether you ask for business-valid truth, platform-visible knowledge or the officially published output.

Timeline

01 Jan

10 Jan

31 Jan

Valid

Visible

Published

Business-valid time

Corrected truthPremium

Publication time

Official reportStandard

Query perspective

Published reporting perspective

Customer segmentStandard

The official January report had already been published with Standard and must remain reproducible.

Key idea

Tritemporal modeling prevents one timeline from pretending to answer every historical question. Truth, knowledge and publication are related, but they are not the same thing.

Three time axes

Each time axis answers a different historical question.

Valid time

When was it true in the business?

Contract valid from 01 Jan

Visibility time

When did the platform know it?

Change arrived on 10 Jan

Publication time

When was it officially published or used?

Report published on 31 Jan

When it matters

Use tritemporal modeling when published outputs have their own lifecycle.

Regulatory reportsPublished KPIsInvestor reportingCustomer statementsAudit evidenceRestatementsFrozen month-end reports

If a corrected record arrives after a report has already been published, the corrected business truth and the published output may intentionally differ. Tritemporal modeling makes that difference explicit instead of hiding it inside ad-hoc reporting logic.

Typical risk

Without publication time, corrected history can silently rewrite published history.

A January customer segment may be corrected from Standard to Premium in February. A bitemporal model can tell you when that correction became visible. But if the January report was already published before the correction was accepted, you also need to preserve what was actually published.

Otherwise, a rebuilt report may look correct from today's data perspective but fail auditability because it no longer matches the official report that users saw at the time.

Validation checks

Validate truth, knowledge and publication separately.

✓ Valid time is separated from visibility time✓ Publication time is modeled explicitly✓ Published reports can be reproduced✓ Corrections do not silently rewrite published outputs✓ As-known and as-published queries are different by design✓ Late-arriving records have defined publication behavior

Related concepts

Tritemporal modeling connects to several historical modeling patterns.

Bitemporal Modeling

Tritemporal modeling extends bitemporal modeling by adding publication time.

As-Known Reporting

As-known reporting asks what was visible at a previous knowledge date.

Snapshot Reproducibility

Publication time helps reproduce reports exactly as they were released.

Historical Correction

Corrections need explicit rules for whether published outputs are restated or preserved.

Try it

Explore the Advisor for your own model.

Use the advisor when you are unsure whether your model needs valid time, visible time, publication time or a simpler historical design.

Explore the Advisor →