Building management system with declarative views of timeseries data

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.

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.

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.