An Aggregate table is a persistence unit of aggregate data.
Aggregate tables are also known as summary table (from summary)
A materialized view can be used to implement aggregate data
A aggregate is a table that contains the result of a query (generally an aggregated one but not always …).
Data - Cache - Pre-aggregating and storing additive information is the standard practice for improving the query performance of databases.
An aggregate table is for an analytics system what an index is for an OLTP system.
When users request information at a high grain of aggregation, Pre-aggregating and storing additive information is the standard practice for improving the query performance of relational databases.
When a user or an application asks for a column in a fact table, a sql engine that is aware of the aggregate table is capable of rewrite the query against/using the aggregate table. See SQL Engine - Query Rewrite
To improve the throughput, you can run the process in parallel by adding more
Stream - How to capture change of state - Change Data Capture (CDC)
You can implement an aggregate table with: