OLTP and OLAP

OLTP refers to transactional systems: many small write and read operations, normalized schema, strong consistency. OLAP refers to analytics: heavy aggregation queries over large historical volumes, often a denormalized schema. The two uses have different needs and are often kept separate.

Example

The online store is OLTP; the data warehouse that feeds the dashboards is OLAP.

Related concepts

The whole glossary