Data Sets (Time series)

Overview

Data sets represent a placeholder for different kinds of data collected by the Gateway. Currently, they have only time series as a type.

Time series model a day's worth of data and are read by the Gateway from a user-defined database. These models can then be used as part of adaptive rules and breach prediction functionality.

How to create a Time series

To create a Time series:

  1. Select Data sets from the tree in the GSE.
  2. Click on New Time series.

Time series data is stored in the Geneos database in two optional tables. The table names are:

  • time_series_user_table
  • time_series_data_user_table

The schema for these tables is available in the Gateway resources directory provided as part of the Gateway bundle.

The time_series_user_table stores a set of names and unique IDs. The names are used to map the names of the time series defined in the Gateway setup to the IDs used in the time_series_data_user_table. Both name and time_series_id must be unique in this table.

The time_series_data_user_table stores the time series data. There are 3 values per row;

  • time_series_id: The ID used to link the data back to the name in the time_series_data_user_table.
  • start_time: The start time for the value of a point in the time series data. This time is in seconds since the start of the day.
  • value: The value of the time series at the start_time.

The data is read from the database at Gateway start time and at the reload time defined in the setup. It is up to an external process to maintain and update the timeseries tables. This can be controlled using the gateway scheduled command.

adaptive-rules0

Configuration

Data Sets

Data Sets are a placeholder for different kinds of data collected by the gateway. They have only time series as a type.

Mandatory: No

timeSeries

Time Series model a day's worth of data uploaded from the database.

Mandatory: No

timeSeries > name

The name specifies a name that the user wants to identify each time series with.

Mandatory: Yes

timeSeries > description

The description specifies additional information about the time series. You can enter multi-line comments in the description field.

Mandatory: No

timeSeries > external

This specifies the database external settings.

timeSeries > external > reloadTime

The reload time specifies the time of the day that data should be uploaded from the database every day. For this, the time series name must corresponds to one of the database tables configured by you.

Mandatory: No (Default value is the current time during time series creation).