Building Timeseries Views for Faster BMS Data Queries
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 query times.
Innovation Solution
A BMS that includes a data collector to generate raw data timeseries, a timeseries processing engine to apply predefined workflows for processing and optimization, and a storage interface to store both raw and derived timeseries data, allowing for pre-processing and efficient data retrieval.
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 timeseries data immediately upon collection through a processing engine that identifies applicable workflows and generates derived data timeseries. This preprocessing includes organizing raw data into structured formats and creating aggregated views before storage, eliminating the need for time-consuming processing at query time while maintaining storage efficiency
2Device complexity
If applications are responsible for retrieving raw timeseries data and generating views in response to requests, then system complexity is reduced, but query response time deteriorates significantly
Solution Approach 1:
The system performs preliminary action by pre-generating derived data timeseries and organized views at the time of data collection rather than waiting for application requests. The processing engine creates multiple derived timeseries with different organizational structures in advance, so applications can retrieve pre-processed data immediately without performing complex processing operations
Solution Approach 2:
The patent introduces an intermediary processing engine between data collection and application retrieval. This engine automatically identifies applicable workflows, processes raw timeseries data, and generates organized derived data timeseries, mediating between the simple storage requirement and the need for fast query response without increasing application complexity
3Device complexity
If no timeseries processing workflows are applied to raw data, then processing complexity is minimized, but data utility and presentation efficiency deteriorate
Solution Approach 1:
The system applies preliminary action by automatically identifying and executing applicable timeseries processing workflows immediately when raw data is collected. The processing engine determines which workflows apply based on data characteristics and executes them to generate organized derived data timeseries in advance, improving data utility without requiring complex application-side processing
Solution Approach 2:
The patent implements self-service by enabling the timeseries data to automatically undergo appropriate processing workflows without external intervention. The processing engine autonomously identifies applicable workflows and generates derived data timeseries, allowing the data to serve itself in a organized, query-efficient format while minimizing processing complexity through automated workflow selection
Data Source
AI summary
A building management system (BMS) includes building equipment configured to provide raw data samples of one or more data points in the BMS. The BMS further includes a data collector configured to collect raw data samples from the building equipment and generate one or more raw data timeseries comprising a plurality of the raw data samples. The BMS also includes a timeseries processing engine. The timeseries processing engine is configured to identify one or more timeseries processing workflows that apply to the raw data timeseries, each of the workflows comprising a predefined sequence of timeseries processing operation. The timeseries processing engine is further configured to process the raw data timeseries using the identified timeseries processing workflows to generate one or more derived data timeseries. The BMS further includes a timeseries storage interface configured to store the raw data timeseries and the derived data timeseries in a timeseries database.