CA Executive Insight runs a periodic aggregation process to aggregate the raw indicator data into hourly and daily intervals. This facilitates visualization of aggregated data for the longer time ranges. It also helps minimize the amount of raw data that is retained in the database. The raw indicator data, which is typically one-minute interval data, is used to serve the 15 minute and the 1 Hour duration charts.
One part of the aggregation process runs hourly, which aggregates the raw interval data into hourly intervals. Therefore, this aggregates all raw data for an hour into one data point per hour per indicator. This data is used for visualizing the charts for the daily and weekly time ranges. This part runs 30 minutes past the hour, every hour. This running frequency ensures that there is enough time for gathering any late arriving interval data before aggregation begins.
The second part of the aggregation process runs daily, which aggregates the hourly interval data into daily intervals. Therefore, this aggregates all hourly data for a day into one data point per day per indicator. This data is used for visualizing the charts for the monthly, quarterly, and yearly time ranges. This will typically run as part of the aggregation that is kicked off after midnight. The daily aggregation process may also run right after an hourly aggregation if a previous daily aggregation process has not been completed normally.
The raw and aggregated data are purged daily based on the purge settings.
|
Copyright © 2014 CA.
All rights reserved.
|
|