Online Analytical Processing (Tier 3 Analytical Aggregation)
All termsMulti-dimensional data aggregation tier powering sub-second analytical reporting and dashboards.
Online Analytical Processing (OLAP) is the high-performance multi-dimensional data warehousing and materialized aggregation architecture used in Tier 3 of TrustedTrucks. It compiles raw transactional rows (OLTP) into pre-aggregated cubes, enabling instantaneous analytical queries, KPI calculations, and historical trend evaluations without placing read locks on operational relational databases.
Drives the PT-0 Command Centre executive dashboards, carbon reconciliation summaries, and semantic telemetry reporting with sub-30ms fast-path responses.
Materialized views and columnar summary tables refreshed asynchronously via dbt and event streaming.
OLAP aggregates reflect periodic or micro-batched snapshots; real-time transactional writes occur in Tier 1 OLTP and GoQuorum.