BMS Eventseries Processing for Faster Timeseries Queries
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Building management systems (BMS) face delays in data presentation due to the need to retrieve and process raw timeseries data from relational databases, which can lead to inefficient data visualization and query performance.
Innovation Solution
Implementing an eventseries generator that assigns sample states to data samples based on predefined rules, generating events with start and end times, and storing these events in an eventseries database, allowing for efficient storage and retrieval of processed data.
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
Solution Approach 1:
The patent applies preliminary action by organizing and processing timeseries data into eventseries format at the time of data collection and storage, rather than waiting until query time. The BMS generates events from raw data samples immediately, assigning sample states and creating structured event records with start times, end times, and event states. This pre-processing eliminates the need for time-consuming processing at query time, thus improving data presentation speed while maintaining storage efficiency.
2Adaptability or versatility
If applications retrieve and process raw timeseries data in response to requests, then data processing flexibility is improved, but query performance deteriorates
Solution Approach 1:
The system performs preliminary processing of timeseries data into eventseries format during data collection, creating pre-organized event records that can be quickly retrieved. This maintains flexibility because the eventseries structure preserves all necessary information while enabling faster queries. The pre-generated events include all relevant attributes (start time, end time, event state) that applications need, eliminating the need for complex real-time processing while maintaining adaptability.
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 applies segmentation by dividing the data processing task into distinct components: the BMS performs event generation from raw samples, the eventseries database stores the organized events, and applications query the pre-processed data. This segmentation distributes complexity across system components rather than concentrating it in one place. The eventseries format itself segments the data into discrete events with clear boundaries, making the data structure more manageable and queryable while improving presentation speed.
Data Source
AI summary
A building management system (BMS) includes building equipment, an eventseries generator, and a storage interface. The building equipment are configured to generate a plurality of data samples. Each of the data samples includes a data value and a timestamp. The eventseries generator is configured to assign a sample state to each data sample based on the data value of the data sample and generate one or more events based on the timestamp of each data sample and the sample state assigned to each data sample. Each of the events includes a start time, an end time, and an event state. The eventseries generator is configured to generate an eventseries including the one or more generated events. The storage interface is configured to store the eventseries in an eventseries database.