Building management system with virtual points and optimized data integration

Patent metadata

Field	Value
Publication number	US-11119458-B2
Application number	US-201916687011-A
Country	US
Kind code	B2
Filing date	Nov 18, 2019
Priority date	Jun 14, 2016
Publication date	Sep 14, 2021
Grant date	Sep 14, 2021

Abstract

A building management system (BMS) includes building equipment, a data collector, a sample aggregator, and an application. The building equipment is operable to monitor and control a variable in the BMS and to provide raw data samples of the variable. The data collector is configured to collect the raw data samples from the building equipment and generate a raw data timeseries including a plurality of the raw data samples. The sample aggregator is configured to automatically generate a data rollup timeseries including a plurality of aggregated data samples. The aggregated data samples are generated by aggregating the raw data samples as the raw data samples are collected from the building equipment. Both timeseries are stored in a timeseries database. The application is configured to retrieve the raw data timeseries and the data rollup timeseries from the timeseries database in response to a request for timeseries data associated with the variable.

First claim

What is claimed is:

1. A building management system comprising:
one or more memory devices configured to store instructions thereon that, when executed by one or more processors, cause the one or more processors to:
receive raw data samples from building equipment and generate a raw data timeseries comprising a plurality of the raw data samples;
generate a data rollup timeseries comprising a plurality of aggregated data samples as the raw data samples are received;
receive one or more new raw data samples from the building equipment;
determine whether an update is triggered based on the one or more new raw data samples;
update the data rollup timeseries with the one or more new raw data samples in response to a determination that the update is triggered; and
store the data rollup timeseries in a database.

2. The building management system of claim 1 , wherein:
each of the raw data samples comprises a timestamp and a raw data value; and
wherein the instructions cause the one or more processors to generate the plurality of aggregated data samples by aggregating one or more of the raw data samples that have timestamps within a predetermined aggregation interval.

3. The building management system of claim 2 , wherein aggregating the one or more of the raw data samples comprises averaging one or more raw data values of the one or more of the raw data samples.

4. The building management system of claim 1 , wherein the instructions cause the one or more processors to store one or more raw data samples of the raw data samples with a timestamp, the timestamp comprising:
a local time indicating a time at which each of the one or more raw data samples was collected in a time zone within which each of the one or more raw data samples was collected; and
a time offset indicating a difference between the local time and universal time.

5. The building management system of claim 1 , wherein the instructions cause the one or more processors to update the data rollup timeseries by:
identifying a timestamp of a new raw data sample of the one or more new raw data samples;
identifying a particular aggregated data sample of the data rollup timeseries that was generated using an aggregation interval that includes the timestamp of the new raw data sample; and
recalculating an aggregated data value of the particular aggregated data sample using the new raw data sample and any other raw data samples that have timestamps within the aggregation interval.

6. The building management system of claim 1 , wherein the instructions cause the one or more processors to update the data rollup timeseries by:
identifying a timestamp of a new raw data sample of the one or more new raw data samples;
determining that the timestamp of the new raw data sample is not within any aggregation interval used to generate the plurality of aggregated data samples;
generating a new aggregated data sample using the new raw data sample and a new aggregation interval that includes the timestamp of the new raw data sample; and
adding the new aggregated data sample to the data rollup timeseries.

7. The building management system of claim 1 , wherein the instructions cause the one or more processors to:
create a virtual data point representing a variable not directly measured by the building equipment;
calculate data values for each of a plurality of samples of the virtual data point using at least one of the raw data samples and the plurality of aggregated data samples;
generate a virtual point timeseries comprising the plurality of samples of the virtual data point; and
store the virtual point timeseries in the database.

8. The building management system of claim 1 , wherein the instructions cause the one or more processors to:
detect faults in timeseries data by applying fault detection rules to at least one of the raw data timeseries and the data rollup timeseries;
generate a fault detection timeseries comprising a plurality of fault detection data samples, each of the plurality of fault detection data samples having a timestamp and a data value indicating whether a fault is detected at the timestamp; and
store the fault detection timeseries in the database.

9. The building management system of claim 1 , wherein the instructions cause the one or more processors to monitor updates to the raw data samples of the building equipment and trigger an automatic update to the data rollup timeseries.

10. A building management system comprising:
one or more memory devices configured to store instructions thereon that, when executed by one or more processors, cause the one or more processors to:
receive raw data samples from a sensor and generate a raw data timeseries comprising a plurality of the raw data samples;
associate the raw data timeseries with a measured data point;
generate a virtual data point representing a non-measured variable;
calculate the virtual data point based on the measured data point and generate a virtual point timeseries comprising a plurality of samples of the virtual data point; and
store the virtual point timeseries in a database.

11. The building management system of claim 10 , wherein the instructions cause the one or more processors to synchronize the raw data timeseries with an asynchronous timeseries by aggregating both the raw data timeseries and the asynchronous timeseries using equivalent aggregation intervals.

12. The building management system of claim 11 , wherein the instructions cause the one or more processors to calculate the virtual data point by:
identifying a plurality of aggregated data values generated by aggregating the raw data timeseries;
identifying, for each of the plurality of aggregated data values, a corresponding synchronized data value generated by aggregating the asynchronous timeseries; and
calculating, for each sample of the virtual data point, a data value of the sample by evaluating a function of one of the plurality of aggregated data values and the corresponding synchronized data value.

13. The building management system of claim 10 , wherein the instructions cause the one or more processors to calculate the virtual data point by:
applying values of the measured data point as inputs to a mathematical function; and
evaluating the mathematical function to determine corresponding values of the virtual data point.

14. The building management system of claim 10 , wherein the instructions cause the one or more processors to calculate the virtual data point as a function of the measured data point and one or more other data points.

15. The building management system of claim 10 , wherein the instructions cause the one or more processors to:
generate a data rollup timeseries comprising a plurality of aggregated data samples; and
calculate a value for each of the plurality of aggregated data samples by aggregating one or more of the raw data samples that have timestamps within a predetermined aggregation interval.

16. The building management system of claim 10 , wherein the sensor measures a weather-related variable;
wherein the instructions cause the one or more processors to:
associate the raw data timeseries with a measured weather-related data point; and
calculate the virtual data point as a function of the measured weather-related data point.

17. The building management system of claim 10 , wherein the instructions cause the one or more processors to:
detect faults in timeseries data by applying fault detection rules to the virtual point timeseries;
generate a fault detection timeseries comprising a plurality of fau

Assignees

• Johnson Controls Tech Co
• Johnson Controls Tyco IP Holdings LLP

Inventors

• Asp Gerald A
• Park Youngchoon
• Craig Peter A

Classifications

• G06Q50/06 Primary

  Energy or water supply · CPC title

• G06F16/38

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title

• G05B15/02 Primary

  electric · CPC title