Skip to content
~/reflective_data

analytics-dictionary / term / data infrastructure

OLAP

OLAP (online analytical processing) systems are built for fast analysis of large volumes of historical data.

Written by Reflective Data experts · updated Oct 5, 2026

Data warehouses are OLAP systems: they favour reading and aggregating many rows, often with columnar storage. They stand in contrast to OLTP databases that serve live applications.

Knowing which kind of system you query avoids slow, expensive mistakes.

related

Columnar storageData warehouseOLTP

// how we can help

We design, build and optimise data warehouses and the cloud infrastructure around them. Data infrastructure services → · Managed data pipelines

more in data infrastructure

data-masking.md

Data masking

Data masking hides or obscures sensitive values, so people can work with data without seeing personal…
dagster.md

Dagster

Dagster is an orchestration platform that models data pipelines in terms of the data assets they…
google-bigquery.md

Google BigQuery

BigQuery is Google serverless cloud data warehouse, popular for analytics and a common destination for GA4…
microsoft-azure.md

Microsoft Azure

Azure is Microsoft cloud platform, with data services such as Synapse, Data Lake Storage and Fabric.
data-ingestion.md

Data ingestion

Data ingestion is the process of bringing data from sources into a storage or analytics system.
pii.md

Personally identifiable information (PII)

PII is any data that can identify a person, such as a name, email address, phone…

← full analytics dictionary