Analytical processing
Interactive processing of data through complex queries, transformations, and aggregations to support analysis, reporting, or decision-making.
Cloud Observability in Action
Online analytical processing is a workload pattern involving complex queries over large volumes of historical data, typically with fewer writes than transactional systems.
- How it is used
- Supports interactive insight extraction from large historical datasets, especially observability data, with relatively few transactions.
- How deep it goes
- Explains row- and column-oriented layouts and workload fit, but does not develop deeper storage-engine internals.
- Examples
- Uses ClickHouse, OpenTelemetry logs, Docker Compose, and a time-bounded SQL query as working artifacts.
- What you can do after
- Operate/configure ClickHouse with an OpenTelemetry Collector pipeline and query recent logs for matching events.
Read how Cloud Observability in Action explains analytical processing →
DuckDB in Action
Analytical processing is computation over data to produce aggregates, transformations, and insights rather than to support operational transactions.
- How it is used
- Deploys computation for local analytics, preprocessing, reporting, forecasting, and aggregation across device, edge, cloud, and notebook workflows.
- How deep it goes
- Explains practical SQL workflows through ingestion prerequisites, basic statements, common table expressions, window functions, and OLAP queries.
- Examples
- Uses log files, sensor readings, and PVDAQ quarter-hour photovoltaic measurements to demonstrate reduction, forecasting, and reporting.
- What you can do after
- Apply it via DuckDB to prepare, filter, aggregate, query, and report on larger datasets across local and cloud workflows.
Related concepts
- vertical partitioningused by · Vertical partitioning is a technique that divides tabular data into separate portions containing different subsets of columns while preserving row relationships.
- columnar dataused by · Columnar data is tabular data organized and stored by column rather than by complete row, enabling efficient access to selected fields and data compression.
- energy consumptionuses · Energy consumption is the amount of energy used by a system or process over a period of operation; its rate of use is power consumption.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.