SHR collects data from different data sources at periodic intervals based on the collection policies predefined in the Content Packs. The collected data is stored in the database in various types of fact tables. If the data is collected every minute, it is called raw data and stored in raw tables. Data can also be collected in a 5-minute interval as well. This type of data is called rate data and is stored in the database in rate tables.
The SHR database performs aggregation routines on the raw or rate data through the workflow process. The aggregation routines convert the data in hourly, weekly, monthly, and yearly data. This data is then stored in the following data tables:
To prevent the accumulation of excessive data in the tables, SHR ages the data. Aging involves the concept of retention time, which is the number of days the data is stored in the table. The aging process deletes the data when it has been in the table longer than the specified retention time for that table. Each table has a default retention time:
Note: Dimension data such as CI types and nodes that is collected by SHR remains in the database tables. SHR does not delete this data.
Using the Aging page of the Administration Console, you can configure the active retention period.