Using TSDB Data Sources


The TSDB data source uses device data from EnOS Time Series Database Management (TSDB). EnOS Time Series Database Management provides efficient and stable storage and management of real-time data uploaded by devices, data processed by streaming data, and time series data integrated through offline channels.

Prerequisites


Before use, ensure the following:

  • The current OU has connected assets, and the asset tree or model where the assets are located already has the auth_unit:ture tag. This tag is used to sync assets into the EnOS application portal.

  • In EnOS time series data management, the corresponding storage policy has been created for the required model, see Configuring TSDB Storage. After creation, ensure that the relevant measuring point data has been uploaded to TSDB through Data Insights.


The relationship between TSDB type data sources in DTV and TSDB data storage strategy is as follows:

  • Assets have been synced to the application portal. If necessary, contact the OU administrator.

  • Asset permissions have been assigned to the current account to ensure that the current account can use and view relevant data in DTV. If necessary, contact the OU administrator.

  • The site where the asset is located has been mounted to an organizational structure, and the organizational structure has been assigned to the DTV application. DTV can obtain the hierarchical information of this organizational structure and the asset information mounted in the organizational structure. If necessary, contact the OU administrator.

Steps


  1. In DTV Center > Data Sources, enable the required data source.

  2. Open any page in DTV Center > Dashboard/Single Page App.

  3. Select the Edit button of any widget to open the widget configuration panel.

  4. Follow the steps in Configuring Widget Data to configure the TSDB data source in the widget.

  5. Refer to the following content to configure the request parameters of the data source.

LatestData Data Source


The LatestData data source is real-time data for assets associated with the EnOS model. In the LatestData data source, the default structure and scope of the data are defined by the Model.

The request parameters of the LatestData data source include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Electric Power Data Source


The Electric Power data source is the electricity data of the assets associated with the EnOS model over a period of time. In the Electric Power data source, the default structure and scope of the data is defined by the Model.

Request parameters for the Electric Power data source include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.

Aggregation type

aggregation

None

Time series data aggregation method, for example: calculating the average value of time series data within a time period.

Aggregation granularity

interval

None

Aggregation thickness of time series data, for example: aggregate data every 5 minutes.

DI Data Data Source


The DI Data data source is the state change (DI) data of the assets associated with the EnOS model over a period of time. In a DI Data data source, the default structure and scope of data is defined by the Model.

The request parameters for the DI Data data source include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.

AI Raw Data Source


The AI ​​Raw data source is the AI ​​raw data of the measurement points of the assets associated with the EnOS model over a period of time. In AI Raw data sources, the default structure and scope of the data are defined by the Model.

Request parameters for AI Raw data sources include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.

AI Aggregation Data Source


The AI ​​Aggregation data source is the AI ​​minute-level normalized data of the measurement points of the assets associated with the EnOS model over a period of time. In AI Aggregation data sources, the default structure and scope of data are defined by the Model.

Request parameters for AI Aggregation data sources include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.

Aggregation type

aggregation

None

Time series data aggregation method, for example: calculating the average value of time series data within a time period.

Aggregation granularity

interval

None

Aggregation thickness of time series data, for example: aggregate data every 5 minutes.

Generic Data Source


Generic data source is a common type of data for measurement points of assets associated with the EnOS model within a period of time. In a Generic data source, the default structure and scope of the data is defined by the Model.

Request parameters for Generic data sources include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.

RAW DATA Data Source


The RAW DATA data source is the historical data of the measurement points of the assets associated with the EnOS model over a period of time. In RAW DATA data sources, the default structure and scope of the data are defined by the Model.

Request parameters for the RAW DATA data source include:

Name

Key

Default Value

Description

Asset ID

mdmId

None

Select the asset, which is the asset ID corresponding to the management console.

Start Time

startTime

None

Set the starting date and time for querying data.

End Time

endTime

None

Set the end date and time of query data.