📊 Analytics & BI

OLAP (Online Analytical Processing)

A category of software tools that provide analysis of data stored in a database, typically for multi-dimensional business reporting.

OLAP databases are optimized for 'Reads'. They are designed to aggregate millions or billions of rows in seconds. Unlike OLTP (Postgres), they usually store data in columns to optimize for wide-scanning queries.

Key Points

← Back to Glossary
SR

Published by

Sainath Reddy

Data Engineer at Anblicks
🎯 4+ years experience
LinkedIn