Building Graph Timeseries Layer for Faster BMS Dashboards
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Building management systems (BMS) face delays in data presentation due to the need for raw timeseries data to be retrieved and processed in response to requests, leading to inefficiencies in data visualization and management.
Innovation Solution
A building energy management system that includes a data collector, data platform services, and an energy management application, which generates optimized timeseries data and allows for the creation of ad hoc dashboards with interactive visualizations, enabling real-time data processing and visualization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If raw timeseries data is stored in a relational database without significant organization or processing at the time of data collection, then data storage simplicity is improved, but data presentation speed deteriorates due to processing delays at query time
Solution Approach 1:
The patent pre-processes and organizes timeseries data into structured formats with metadata (such as tags, units, and data types) at the time of data collection rather than waiting until query time. This preliminary organization enables faster data retrieval and presentation while maintaining storage efficiency through standardized data structures.
2Adaptability or versatility
If applications retrieve and process raw timeseries data in response to requests, then data processing flexibility is improved, but data presentation speed deteriorates
Solution Approach 1:
The system pre-organizes data with metadata tags, units, and structural information at collection time, creating a standardized framework that enables both fast retrieval and flexible processing. Applications can efficiently query pre-structured data while maintaining the ability to adapt to different processing needs.
Solution Approach 2:
The patent introduces an intermediate data structure layer between raw data collection and application processing. This intermediate layer includes organized timeseries data with metadata (tags, units, data types) that serves as a mediator, enabling both fast retrieval and flexible processing without requiring applications to handle raw unstructured data.
3Speed
If significant organization and processing of timeseries data is performed at the time of data collection, then data presentation speed is improved, but system complexity increases
Solution Approach 1:
The patent implements automated preliminary organization of data with metadata tagging, unit assignment, and structural formatting at collection time. This automation reduces the perceived complexity by handling organization tasks systematically, enabling fast data presentation without requiring complex manual processing systems.
Data Source
AI summary
A building energy management includes building equipment, one or more data platform services, a timeseries database, and an energy management application. The building equipment operate to monitor and control a variable and provide raw data samples of a data point associated with the variable. The timeseries database stores a plurality of timeseries associated with the data point. The plurality of timeseries include a timeseries of the raw data samples and the one or more optimized data timeseries generated by the data platform services based on the raw data timeseries. The energy management application generates an ad hoc dashboard including a widget and associates the widget with the data point. The widget displays a graphical visualization of the plurality of timeseries associated with the data point and includes interactive user interface options for switching between the plurality of timeseries associated with the data point.