Building management system with declarative views of timeseries data

• US 10,095,756 B2
• Filed: 07/07/2017
• Issued: 10/09/2018
• Est. Priority Date: 02/10/2017
• Status: Active Grant

• Current Assignee: Johnson Controls Technology Company (Johnson Controls International plc)
• Original Assignee: Johnson Controls Technology Company (Johnson Controls International plc)
• Inventors: Park, Youngchoon, Sinha, Sudhi R., Chennupati, Vijaya S., Venkiteswaran, Vaidhyanathan, Pourmohammad, Sajjad, Paulson, Erik S., Ma, Ada L., Asp, Gerald A.
• Primary Examiner(s): Moser, Bruce M
• Application Number:
  US15/644,519
• Publication Number:
  US 20180232422A1
• Time in Patent Office: 459 Days
• CPC Class Codes: G05B 15/02 electric
• CPC Class Codes: G05B 2219/2614 HVAC, heating, ventillation, climate control
• CPC Class Codes: G05B 2219/2642 Domotique, domestic, home control, automation, smart house
• CPC Class Codes: G05D 23/1917 using digital means
• CPC Class Codes: G05D 23/1931 to control the temperature of one space
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2322 using timestamps
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence

Abstract

A building management system (BMS) includes building equipment configured to provide raw data samples of one or more data points in the BMS. The BMS further includes a data collector configured to collect raw data samples from the building equipment and generate one or more raw data timeseries comprising a plurality of the raw data samples. The BMS also includes a timeseries processing engine. The timeseries processing engine is configured to identify one or more timeseries processing workflows that apply to the raw data timeseries, each of the workflows comprising a predefined sequence of timeseries processing operation. The timeseries processing engine is further configured to process the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries. The BMS further includes a timeseries storage interface configured to store the raw data timeseries and the derived data timeseries in a timeseries database.

Claims

1. A building management system comprising:

building equipment configured to provide raw data samples of one or more data points in the building management system, the building equipment comprising one or more physical devices that operate to monitor or control a physical building condition;

a data collector configured to collect the raw data samples from the building equipment and generate one or more raw data timeseries comprising a plurality of the raw data samples;

a timeseries processing engine configured to;

receive one or more timeseries processing workflows that apply to the raw data timeseries, each of the timeseries processing workflows comprising a sequence of timeseries processing operations, the sequence of timeseries processing operations comprising a user defined fault rule that indicates whether one or more values of the raw data samples representing the physical building condition are fault values;

identify the one or more timeseries processing workflows that apply to the raw data timeseries; and

process the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries and one or more fault timeseries, the one or more fault timeseries being generated in response to a determination, based on the user defined fault rule, that the one or more values of the raw data samples representing the physical building condition are the fault values; and

a timeseries storage interface configured to store the raw data timeseries and the derived data timeseries in a timeseries database;

wherein the timeseries processing engine is configured to generate a plurality of directed acyclic graphs, each directed acyclic graph corresponding to one of the timeseries processing workflows and visually representing the predefined sequence of timeseries processing operations in the corresponding workflow, wherein each directed acyclic graph comprises;

one or more input blocks representing one or more input timeseries to which the corresponding workflow applies;

one or more functional blocks representing the predefined sequence of timeseries processing operations in the corresponding workflow; and

one or more output blocks representing the one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

2. The building management system of claim 1, wherein each of the timeseries processing workflows comprises:

an indication of one or more input timeseries to which the workflow applies;

a predefined sequence of timeseries processing operations; and

an indication of one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

3. The building management system of claim 2, wherein the input timeseries comprise at least one of:

the one or more raw data timeseries generated by the data collector;

or

the one or more derived data timeseries generated by the timeseries processing engine.

4. The building management system of claim 1, wherein the timeseries processing engine is configured to:

receive user input via a graphical workflow editor, the user input comprising an adjustment to at least one of the input blocks, the functional blocks, or the output blocks in one of the directed acyclic graphs;

determine an adjustment to the corresponding timeseries processing workflow based on the user input; and

automatically apply the adjustment to the corresponding timeseries processing workflow in response to receiving the user input.

5. The building management system of claim 1, wherein the timeseries processing engine is configured to optimize each of the timeseries processing workflows by combining two or more individual timeseries processing operations in a single workflow into a combined timeseries processing operation.

6. The building management system of claim 1, wherein the timeseries processing engine is configured to optimize the timeseries processing workflows by:

identifying multiple timeseries processing workflows that require one or more shared input timeseries; and

combining the identified timeseries processing workflows into a single timeseries processing workflow.

7. The building management system of claim 1, wherein the timeseries processing engine is configured to generate the derived data timeseries prior to a request for the derived data timeseries.

8. The building management system of claim 1, further comprising a workflow manager configured to detect a change in one or more of the raw data timeseries or the derived data timeseries;

wherein the timeseries processing engine is configured to process the changed data timeseries in response to detecting the change.

9. The building management system of claim 8, wherein processing the changed data timeseries in response to detecting the change comprises:

identifying one or more of the timeseries processing workflows that apply to the changed data timeseries;

identifying any other timeseries indicated as required inputs to the identified timeseries processing workflows; and

providing the changed data timeseries, the other timeseries indicated as required inputs, and the identified workflows to the timeseries processing engine.

10. The building management system of claim 9, wherein the workflow manager is configured to:

receive, from the timeseries processing engine, a plurality of derived data samples generated by processing the changed data timeseries; and

generate one or more derived data sample timeseries comprising a plurality of the derived data samples.

11. A method for processing timeseries data in a building management system, the method comprising:

operating building equipment comprising one or more physical devices to monitor or control a physical building condition and to generate raw data samples of one or more data points in the building management system;

collecting the raw data samples from the building equipment;

generating one or more raw data timeseries comprising a plurality of the raw data samples;

receiving one or more timeseries processing workflows that apply to the raw data timeseries, each of the timeseries processing workflows comprising a sequence of timeseries processing operations, the sequence of timeseries processing operations comprising a user defined fault rule that indicates whether one or more values of the raw data samples representing the physical building condition are fault values;

identifying the one or more timeseries processing workflows that apply to the raw data timeseries;

processing the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries and one or more fault timeseries, the one or more fault timeseries being generated in response to a determination, based on the user defined fault rule, that the one or more values of the raw data samples representing the physical building condition are the fault values;

storing the raw data timeseries and the derived data timeseries in a timeseries database; and

generating a plurality of directed acyclic graphs, each directed acyclic graph corresponding to one of the timeseries processing workflows and visually representing the predefined sequence of timeseries processing operations in the corresponding workflow, wherein each directed acyclic graph comprises;

one or more input blocks representing one or more input timeseries to which the corresponding workflow applies;

one or more functional blocks representing the predefined sequence of timeseries processing operations in the corresponding workflow; and

one or more output blocks representing the one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

12. The method of claim 11, wherein each of the timeseries processing workflows comprises:

an indication of one or more input timeseries to which the workflow applies;

a predefined sequence of timeseries processing operations; and

an indication of one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

13. The method of claim 12, wherein the input timeseries comprise at least one of:

the one or more of the raw data timeseries;

or

the one or more of the derived data timeseries.

14. The method of claim 11, further comprising:

receiving user input via a graphical workflow editor, the user input comprising an adjustment to at least one of the input blocks, the functional blocks, or the output blocks in one of the directed acyclic graphs;

determining an adjustment to the corresponding timeseries processing workflow based on the user input; and

automatically applying the adjustment to the corresponding timeseries processing workflow in response to receiving the user input.

15. The method of claim 11, further comprising optimizing each of the timeseries processing workflows by combining two or more individual timeseries processing operations in a single workflow into a combined timeseries processing operation.

16. The method of claim 11, further comprising optimizing the timeseries processing workflows by:

identifying multiple timeseries processing workflows that require one or more shared input timeseries; and

combining the identified timeseries processing workflows into a single timeseries processing workflow.

17. A building management system comprising:

building equipment configured to provide raw data samples of one or more data points in the building management system, the building equipment comprising one or more physical devices that operate to monitor or control a physical building condition;

a data collector configured to collect the raw data samples from the building equipment and generate one or more raw data timeseries comprising a plurality of the raw data samples;

a timeseries processing engine configured to;

identify one or more timeseries processing workflows that apply to the raw data timeseries, each of the timeseries processing workflows comprising a predefined sequence of timeseries processing operations; and

process the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries; and

a timeseries storage interface configured to store the raw data timeseries and the derived data timeseries in a timeseries database;

wherein the timeseries processing engine is configured to optimize the timeseries processing workflows by;

identifying multiple timeseries processing workflows that require one or more shared input timeseries; and

combining the identified timeseries processing workflows that require the one or more shared input timeseries into a single timeseries processing workflow.

18. The building management system of claim 17, wherein each of the timeseries processing workflows comprises:

an indication of one or more input timeseries to which the workflow applies;

a predefined sequence of timeseries processing operations; and

an indication of one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

19. The building management system of claim 18, wherein the input timeseries comprise at least one of:

the one or more raw data timeseries generated by the data collector;

or

the one or more derived data timeseries generated by the timeseries processing engine.

20. The building management system of claim 17, wherein the timeseries processing engine is configured to generate a plurality of directed acyclic graphs, each directed acyclic graph corresponding to one of the timeseries processing workflows and visually representing the predefined sequence of timeseries processing operations in the corresponding workflow, wherein each directed acyclic graph comprises:

one or more input blocks representing one or more input timeseries to which the corresponding workflow applies;

one or more functional blocks representing the predefined sequence of timeseries processing operations in the corresponding workflow; and

one or more output blocks representing one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

21. The building management system of claim 20, wherein the timeseries processing engine is configured to:

receive user input via a graphical workflow editor, the user input comprising an adjustment to at least one of the input blocks, the functional blocks, or the output blocks in one of the directed acyclic graphs;

determine an adjustment to the corresponding timeseries processing workflow based on the user input; and

automatically apply the adjustment to the corresponding timeseries processing workflow in response to receiving the user input.

22. The building management system of claim 17, wherein the timeseries processing engine is configured to optimize each of the timeseries processing workflows by combining two or more individual timeseries processing operations in a single workflow into a combined timeseries processing operation.

23. The building management system of claim 17, wherein the timeseries processing engine is configured to generate the derived data timeseries prior to a request for the derived data timeseries.

24. A method for processing timeseries data in a building management system, the method comprising:

operating building equipment comprising one or more physical devices to monitor or control a physical building condition and to generate raw data samples of one or more data points in the building management system;

collecting the raw data samples from the building equipment;

generating one or more raw data timeseries comprising a plurality of the raw data samples;

identifying one or more timeseries processing workflows that apply to the raw data timeseries, each of the timeseries processing workflows comprising a predefined sequence of timeseries processing operations;

processing the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries;

storing the raw data timeseries and the derived data timeseries in a timeseries database; and

optimizing the timeseries processing workflows by;

identifying multiple timeseries processing workflows that require one or more shared input timeseries; and

combining the identified timeseries processing workflows that require the one or more shared input timeseries into a single timeseries processing workflow.

25. The method of claim 24, wherein each of the timeseries processing workflows comprises:

an indication of one or more input timeseries to which the workflow applies;

a predefined sequence of timeseries processing operations; and

an indication of one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

26. The method of claim 25, wherein the input timeseries comprise at least one of:

the one or more of the raw data timeseries;

or

the one or more of the derived data timeseries.

27. The method of claim 24, further comprising generating a plurality of directed acyclic graphs, each directed acyclic graph corresponding to one of the timeseries processing workflows and visually representing the predefined sequence of timeseries processing operations in the corresponding workflow.

28. The method of claim 27, wherein each directed acyclic graph comprises:

one or more input blocks representing one or more input timeseries to which the corresponding workflow applies;

one or more functional blocks representing the predefined sequence of timeseries processing operations in the corresponding workflow; and

one or more output blocks representing one or more derived data timeseries generated by applying the predefined sequence of timeseries processing operations to the input timeseries.

29. The method of claim 28, further comprising:

receiving user input via a graphical workflow editor, the user input comprising an adjustment to at least one of the input blocks, the functional blocks, or the output blocks in one of the directed acyclic graphs;

determining an adjustment to the corresponding timeseries processing workflow based on the user input; and

automatically applying the adjustment to the corresponding timeseries processing workflow in response to receiving the user input.

30. The method of claim 24, further comprising optimizing each of the timeseries processing workflows by combining two or more individual timeseries processing operations in a single workflow into a combined timeseries processing operation.