Aggregation

Aggregation is a collection of units or distinct items together. In a statistics or information technology context, aggregation typically refers to the aggregating of data. Functionally, aggregation compounds primary data into a singular group, generally in order to express the data in summary form. For example, overall land value in the United States, in contrast to the land value of a specific plot of land.

Data aggregation refers to any process where information is gathered and expressed in a summary. For example, data is aggregated in databases in a structured manner so that it can be retrieved and/or analyzed.

Data is often aggregated in order to derive information about particular groups, such as age, profession, or income, so it can be used in marketing and advertising. This kind of group demographic data can be used to choose content and advertising on a website likely to appeal to an individual belonging to a particular group. For example, an ecommerce site that sells women’s clothes could have content and advertising directed at a specific age group as women in that age range are most likely to purchase the style of clothes they sell.

Idera’s SQL Diagnostic Manager allows you to choose your method of data aggregation when you create custom reports. SQL diagnostic manager custom reports can include any metric collected by SQL DM. You can select the counters you want to include in your report, choose the order the metrics appear in the report, and specify the aggregation method to be used on each metric.