Building management system with distributed data storage and processing

A method for a building management system (BMS) comprising:

• receiving, by a BMS controller, a processing request that requires time-series data of a particular HVAC device stored by one or more of a plurality of device controllers;
• querying, by the BMS controller, a master-index of a BMS database comprising a plurality of data source identifiers, each data source identifier of the plurality of data source identifiers linking an HVAC device with one or more device controllers of the plurality of device controllers managing data of the HVAC device to determine the one or more of the plurality of device controllers storing the time-series data required by the processing request based on a data source identifier of the master-index linking the particular HVAC device to the one or more of the plurality of device controllers, wherein the master-index is stored in the BMS database and identifies the time-series data stored by each of the plurality of device controllers;
• generating, by the BMS controller, one or more processing sub-requests based on the processing request, wherein each processing sub-request is associated with one of the one or more of the plurality of device controllers and comprises a request for one or more processing operations to be performed by the associated device controller on the time-series data stored by the associated device controller;
• generating, by each of the one or more of the plurality of device controllers, one or more processing results based on the one or more processing sub-requests and sending the one or more processing results to the BMS controller;
• combining, by the BMS controller, the one or more processing results received from the one or more of the plurality of device controllers.

A building management system (BMS) controller comprising:

• a network interface communicably coupled to a user device, the network interface configured to receive a processing request from the user device;
• a BMS database configured to store a master-index comprising a plurality of data source identifiers, each data source identifier of the plurality of data source identifiers linking an HVAC device with one or more device controllers of a plurality of device controllers, wherein the one or more device controllers of the plurality of device controllers manage data of the HVAC device, the master-index identifying time-series data stored by each of the plurality of device controllers;
• a processing circuit communicably coupled to the plurality of device controllers, the BMS database, and the network interface, wherein the processing circuit is configured to:
• receive the processing request via the network interface, wherein the processing request requires time-series data of a particular HVAC device stored by one or more of the plurality of device controllers;
• query the master-index of the BMS database to determine the one or more of the plurality of device controllers storing the time-series data required by the processing request based on a data source identifier of the master-index linking the particular HVAC device to the one or more of the plurality of device controllers;
• generate one or more processing sub-requests based on the processing request, wherein each processing sub-request is associated with one of the one or more of the plurality of device controllers and comprises a request for one or more processing operations to be performed by the associated device controller on the time-series data stored by the associated device controller;
• receive, via the network interface, one or more processing results from the one or more of the plurality of device controllers;
• and
• combine the one or more processing results received from the one or more of the plurality of device controllers.