Building management system with virtual points and optimized data integration

A building management system comprising:

• a sensor configured to measure a variable in the building management system and to provide raw data samples of the measured variable;
• a data collector configured to collect the raw data samples from the sensor, generate a raw data timeseries comprising a plurality of the raw data samples, and associate the raw data timeseries with a measured data point;
• a virtual point calculator configured to create a virtual data point representing a non-measured variable, calculate the virtual data point as a function of the measured data point, and generate a virtual point timeseries comprising a plurality of samples of the virtual data point;
• a timeseries database configured to store the raw data timeseries and the virtual point timeseries;
• and
• an application configured to retrieve the virtual point timeseries from the timeseries database in response to a request for timeseries data associated with the virtual data point and operate one or more pieces of building equipment to control an environmental condition of a building based on the virtual point timeseries.

A system comprising:

• equipment operable to monitor and control a variable in the system and to provide raw data samples of the variable;
• a data collector configured to collect the raw data samples from the equipment, generate a raw data timeseries comprising a plurality of the raw data samples, and store the raw data timeseries in a timeseries database;
• a sample aggregator configured to automatically generate a data rollup timeseries comprising a plurality of aggregated data samples generating, as the raw data samples are collected, the data rollup timeseries based on at least a first raw data sample of the raw data samples and updating, as the raw data samples are collected, the data rollup timeseries based on at least a second raw data sample of the raw data samples collected subsequent to generating the data rollup timeseries based on at least the first raw data sample of the raw data samples, and to store the data rollup timeseries in the timeseries database, wherein the sample aggregator is configured to perform a data cleansing operation on the raw data timeseries before using the raw data timeseries to generate the data rollup timeseries;
• and
• an application 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 and operate the equipment based on the data rollup timeseries.