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:
-
Added field name stored in the Store database
A field name consisting of the PFM - Manager name in the fixed field and an added suffix
-
Added field name displayed on PFM - Web Console
A field name consisting of the PFM - View name in the fixed field and an added suffix
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.
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.
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) Added fields (Store database)
Added field (PFM - Web Console)#1, #2
|
ADD |
Stores the total field value within the summarization period. |
HI |
Stores the maximum field value within the summarization period. |
LO |
Stores the minimum field value within the summarization period. |
HILO |
Stores the maximum, minimum, and average of the data within the summarization period. An average value is stored in the fixed field. The computation formula follows: (total-field-value)/(number-of-collected-records) Added fields (Store database)
Added fields (PFM - Web Console)#1, #2
|
% |
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) Added fields (Store database)
|
-- |
No summarization |