Chapter 12.1

Operational Analytics

Abstract

Performance is of the essence in the operational environment. In order to enhance performance, data are denormalized. However, when data are denormalized, data become disintegrated. In order to achieve integration, data are integrated as they enter the data warehouse. Data in the warehouse are at a granular. Because data in the data warehouse are granular, the data can be shaped and reshaped into many different forms, serving the needs of many different communities. Supplementing the data warehouse are data marts. Data marts primarily support KPIs.

Keywords

Denormalization; Integration; ETL; Data warehouse; Granularity; Data marts; KPIs; Historical data

The operational environment is one where ...

Get Data Architecture: A Primer for the Data Scientist, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.