Building Energy Dashboard With Precomputed Timeseries Views
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 inefficient data visualization and management of building energy data.
Innovation Solution
A building energy management system that includes a data collector, data platform services, and an energy management application, which processes raw data samples to generate optimized timeseries data and provides an ad hoc dashboard with interactive visualization options, enabling real-time data analysis and management.
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 applies preliminary action by pre-processing and organizing timeseries data into optimized data structures (such as time-series databases or columnar storage formats) 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, directly resolving the contradiction between storage simplicity and presentation speed.
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 performs preliminary processing of raw timeseries data into multiple pre-computed views and aggregated forms during data collection. When applications request data, they can directly utilize these pre-processed views rather than processing raw data from scratch, thereby maintaining processing flexibility while dramatically improving presentation speed.
Solution Approach 2:
The patent segments the data processing workflow by creating multiple pre-computed views of the timeseries data with different levels of aggregation and organization. This segmentation allows applications to select the most appropriate pre-processed view for their specific needs, maintaining flexibility while enabling fast data presentation without processing delays.
3Adaptability or versatility
If multiple views of timeseries data are generated at query time, then data visualization adaptability is improved, but processing time increases
Solution Approach 1:
The system segments the data into multiple pre-computed views with different aggregation levels and organizational structures at the time of data collection. These segmented views can be directly combined or selected based on visualization needs without requiring re-processing at query time, thus maintaining visualization adaptability while eliminating processing delays.
Solution Approach 2:
Multiple data views are pre-computed and stored in optimized formats during the data collection phase. When visualization is needed, the system can directly retrieve and combine these pre-computed views without performing processing operations at query time, thereby maintaining adaptability while significantly reducing processing time.
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.