One number
Served and reported values come from one source, so disagreements become bugs.
Plant data answered without making a copy of it.
Operational reporting is the least glamorous workload and the one that decides whether a platform is trusted: the number served and the number reported have to be the same number.
One number: what the application serves and what the report says.
One data layer
Aggregates run over the live tables, with document fields filterable beside them. Because there is no extract, a report describes the state of the system at the moment it ran, and the operational view agrees.
One number: what the application serves and what the report says.
The system of record
The application writes rows and documents all day, every day.
SQL · JSON / documents
The same shapes, held two ways. The difference is not the storage, it is where the agreement between them lives.
Every shape below is a surface of the layer, not a format to be converted into one. They are read and written together.
The models this workload names, the path a request takes through them, and the surfaces that speak to the layer.
The shape of the work itself.
The models this workload names.
One path from a request to the data it names.
How the workload reaches the layer.
Choose a stage to read what happens there, or a shape to see every stage that handles it.
Operate
The application writes records and documents
SQL · JSON / documents
The application writes records and documents
Reporting aggregates over the same tables
Document fields used as filters, not decoration
The same numbers serve every consumer
Each one is a property of the system rather than a number somebody else has to measure for you.
Served and reported values come from one source, so disagreements become bugs.
Reporting availability stops being tied to a batch window.
Document fields are part of the query surface rather than opaque payload.
Each copy removed is both a cost and a place where the truth could diverge.
Operational reporting is a trust problem before it is a performance problem. These are the parts that address it.
Derived from the industry pages that reference this solution, so the two directions of the relationship always agree.