Relational Database Modeling - Aggregate Table

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Relational Table - Data Modeling

1 - About

An Aggregate table is a persistence unit of aggregate data.

Aggregate tables are also known as summary table

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 ...).

Pre-aggregating and storing additive information is the standard practice for improving the query performance of databases.

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.

However when data becomes bigger, the pre-calculation processing becomes impossible – even with powerful hardware. However, with the benefit of distributed computing power (such as Hadoop), calculation jobs can leverage hundreds of thousands of nodes.

Advertising

3 - Implementation

4 - Documentation / Reference