Term Kind Topic What it is
Hub and Satellite pattern Data Vault Modelling Separating stable business keys from their changing attributes and from their relationships, so each can be loaded independently and kept forever.
Log-Based Ingestion pattern CDC Pipeline Design Building the pipeline around a database's own change log — an initial snapshot followed by a continuous delta stream, with the two stitched together.
Merge Upsert pattern Ingestion Patterns Applying a batch of changes to a target by matching on a key and inserting, updating or deleting per row, which is expensive and frequently avoidable.
Operational Data Push pattern Reverse ETL Sending modelled analytical data back into operational tools, which turns a warehouse table into a production dependency with none of the guarantees.
Query Federation pattern Data Virtualisation Executing a single query across several underlying systems without moving the data, and the performance ceiling that pushdown determines.