Data sets represent a placeholder for different kinds of data collected by the Gateway. Currently, they have only time series as a type.
To create a Time series:
- Select Data sets from the tree in the GSE.
- Click on New Time series.
Time series data is stored in the Geneos database in two optional tables. The table names are:
The schema for these tables is available in the Gateway resources directory provided as part of the Gateway bundle.
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_id must be
unique in this table.
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
- start_time: The start time for the
valueof 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
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.
Data Sets are a placeholder for different kinds of data collected by the gateway. They have only time series as a type.
The name specifies a name that the user wants to identify each time series with.
The description specifies additional information about the time series. You can enter multi-line comments in the description field.
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).