Enterprise RTView® 
User Guide


Advanced Historian - Cache Properties

NOTE: You may not be licensed to run all Enterprise RTView features and/or data sources.

The Advanced Historian (when activated) provides the following additional Cache properties to describe your data management preferences:

compactionType

The Advanced Historian feature allows you to define rules about data compaction via aggregation or displacement.

  • Aggregate - Specify the granularity of time stamped data and the methods used to perform compaction.
  • Displace - Archive data in displaced tables by creating a new table per each defined retention period.

compactionGroupBy

Property Name Description
compactionGroupBy NOTE: This property only applies the selected compactionType is Aggregate.

Specify column and type of compaction to be performed. Double click on the property name and then click Add to open the Edit Compaction dialog.

Once you have added a column, the column name and compaction type will be displayed in the dialog.

Group Column Select a column name to compact.
by Select a method of compaction from the drop down menu:
sum
count
average
min
max

 


compactionRules

Property Name Description
compactionRules Specify compaction rules. Double click on the property name and then click Add to open the Edit Compaction Rule dialog. Compaction rules affect data differently depending on the selected compactionType.
Aggregate Displace
Once you have added a compaction rule, that rule will be displayed in the dialog as numbers followed by single characters indicating retention period and rate of compacted data samples (e.g. 1d 10m: over a period of 1 day, aggregate data every 10 minutes).

By default, data is aggregated in the table specified by historyTableName. Use the Alternate Table field to enter the name of another table.

Retention Enter a duration and select the desired time range in which to perform compaction.
Minutes m
Hours h
Days d
Weeks (7 days) w
Months (31 days) M
Years (365 days) y
Compacted in ... Samples Compaction rate of data samples within the specified retention period. Enter the duration and select the desired time period from the drop down menu.

NOTE: If you select Raw, all values are retained and no compaction is performed.

Raw -
Second s
Minute m
Hour h
Day d
Week (7 days) w
Month (31 days) M
Year (365 days) y
 
Alternate Table Enter an alternate table name in which to compact data. By default, data is compacted in the table specified by historyTableName.
Once you have added a compaction rule, that rule will be displayed in the dialog as numbers followed by single characters indicating retention period and rate of compacted data samples (e.g. 1d 10m: retain data for 1 day, create a new displaced table every 10 minutes).

NOTE: Currently, when the selected compactionType is Displace, this property only supports one compaction rule

Displaced tables are created and named according to the specified retention period and rate of compaction. (e.g. historyTableName_2009_06_16_14_35, historyTableName_2009_06_16_14_45, etc.).

Retention Amount of time displaced tables will be retained before being deleted. Enter the duration and select the desired retention period from the drop down menu (e.g. 1d: retain displaced tables for one day)
Minutes m
Hours h
Days d
Weeks (7 days) w
Months (31 days) M
Years (365 days) y
Compacted in ... Samples Compaction rate of data samples within the specified retention period. Enter the duration and select the desired time period from the drop down menu. (e.g. 10m: create a new displaced table every 10 minutes).

NOTE: If you select Raw, all values are retained and no compaction is performed.

Raw -
Second s
Minute m
Hour h
Day d
Week (7 days) w
Month (31 days) M
Year (365 days) y
 

 
Enterprise RTView contains components licensed under the Apache License Version 2.0.

 

Treemap Algorithms v1.0  is used without modifications and licensed by MPL Version 1.1. Copyright © 2001 University of Maryland, College Park, MD

 

Datejs is licensed under MIT. Copyright © Coolite Inc.

 

JCalendar 1.3.2 is licensed under LGPL. Copyright © Kai Toedter.

 

jQuery is licensed under MIT. Copyright © John Resig,

 
JMS, JMX and Java are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. They are mentioned in this document for identification purposes only. 

 
SL, SL-GMS, GMS, Enterprise RTView, SL Corporation, and the SL logo are trademarks or registered trademarks of Sherrill-Lubinski Corporation in the United States and other countries. Copyright © 1998-2009 Sherrill-Lubinski Corporation. All Rights Reserved.