Term Kind Topic What it is
Data Warehousing concept Data Warehousing A separate analytical store modelled for questions rather than transactions, physically isolated from the systems that generate the data.
OLTP vs OLAP concept Data Warehousing Two workload shapes with opposite requirements — many small indexed transactions versus few large scans and aggregations — which is why they belong in different stores.
Star Schema pattern Data Warehousing A dimensional model with one central fact table of measurements surrounded by denormalised dimension tables describing them.