analytics-dictionary / term / data infrastructure

Data cost optimization

Data cost optimization is reducing the cost of storing, moving and querying data without hurting the business.

Written by Reflective Data experts · updated Oct 5, 2026

Typical wins are partitioning and clustering, removing duplicate or unused tables, scheduling heavy jobs sensibly, caching, and choosing the right pricing model. Visibility comes first: know which queries and teams drive spend.

Savings of a third or more are common in neglected warehouses.

Google BigQuery Partitioning and clustering Snowflake

// how we can help

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

Infrastructure as code

Infrastructure as code defines cloud resources in version-controlled files, so environments are reproducible and reviewable.

materialized-view.md

Materialized view

A materialized view stores the precomputed result of a query, so reports read it quickly instead…

master-data-management.md

Master data management (MDM)

MDM is managing the core entities of a business, like customers and products, so that one…

columnar-storage.md

Columnar storage

Columnar storage stores data by column rather than by row, which makes analytical queries much faster.

data.md

Data

Data is recorded information, such as numbers, text or events, that can be stored and analysed.

oltp.md

OLTP

OLTP (online transaction processing) databases are built to run applications, handling many small reads and writes…

← full analytics dictionary