Summarization rules
For records of the PI record type, two types of data are stored in the Store database: the data collected at the interval set in Collection Interval, and the data summarized for a specific period of time (minute, hour, day, week, month, or year) according to a predefined rule. The type of summarization is defined for each field. This definition is called a summarization rule.
Depending on the summarization rule, intermediate data used during the summarization period must sometimes be retained. In this case, a field for holding the intermediate data is added to a record in the Store database. This field is called an added field.
Part of an added field is displayed as a record field in PFM - Web Console. The added fields displayed on PFM - Web Console can be used as the fields to be displayed in a historical report.
To differentiate them from the fields that are added through summarization, the fields described in the explanation of each record in this chapter are called fixed fields.
The following field names are used for added fields:
The table below shows the suffixes to be added to the PFM - Manager name, the corresponding suffixes to be added to the PFM - View name, and the data stored in the fields.
Table 8-3 List of suffixes for added fields
PFM - Manager name | PFM - View name | Stored data |
---|---|---|
_TOTAL | (Total) | Total field value of the records within the summarization period |
_TOTAL_SEC | (Total) | Total field value of the records within the summarization period (for a utime field) |
_COUNT | -- | Number of records collected within the summarization period |
_HI | (Max) | Maximum field value of the records within the summarization period |
_LO | (Min) | Minimum field value of the records within the summarization period |
The table below shows a list of summarization rules.
Table 8-4 List of summarization rules
Summarization rule name | Summarization rule |
---|---|
COPY | Stores the field value of the latest record within the summarization period without any modification. |
AVG | Stores the average field value within the summarization period. The computation formula follows: (total-field-value)/(number-of-collected-records)
|
% | Stores the average field value within the summarization period. Applied primarily to percentage fields. The computation formula follows: (total-field-value)/(number-of-collected-records)
|
R | Stores the average field value within the summarization period. Applied primarily to percentage fields that indicate the amount per second. The computation formula follows: (total-field-value)/(number-of-collected-records) When delta is specified for a real-time report, the special computation method that divides the difference by an interval is used.
|
-- | No summarization |