Building Energy Dashboard With Optimized Timeseries Switching
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 allows for real-time visualization through an ad hoc dashboard with interactive user interface options, including various widget types for data 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 optimized data structures (such as time-series databases or columnar storage formats) at the time of data collection rather than storing raw data. This preliminary organization enables faster query performance and data presentation without sacrificing storage simplicity, as the data is structured for efficient retrieval from the beginning
Solution Approach 2:
The patent segments the data storage and processing system into multiple layers: raw data collection, pre-processing/organization layer, and query/access layer. By segmenting the data into organized timeseries structures with metadata, indexes, and optimized storage formats, the system achieves both storage simplicity and fast presentation by handling different data stages separately
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 patent pre-computes and stores optimized data structures, aggregations, and metadata at the time of data collection. This allows applications to quickly retrieve pre-processed data without performing heavy processing at query time, thereby maintaining flexibility while significantly improving presentation speed
Solution Approach 2:
The patent implements data buffering and caching mechanisms that store pre-processed timeseries data in optimized formats. This cushioning layer between raw data collection and application retrieval ensures that even when applications need flexible data processing, the system can quickly serve pre-prepared data, reducing presentation delays
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.