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.
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. Nothing on the map is a private interface.
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
Stated as properties of the system rather than as results we cannot 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.