Term Kind Topic What it is
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.
Slowly Changing Dimension SCD pattern Data Warehousing A strategy for handling attributes that change over time, deciding whether history is preserved and how facts attach to the correct version.
Star Schema pattern Data Warehousing A dimensional model with one central fact table of measurements surrounded by denormalised dimension tables describing them.