BMS Timeseries Workflow Enrichment for Faster Data Visualization
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 with a timeseries processing engine that identifies and executes a predefined workflow to generate enriched timeseries data by aggregating and processing raw data samples, allowing for pre-aggregated data to be stored and quickly retrieved, reducing the need for real-time processing during query times.
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-aggregating and processing timeseries data into enriched datasets with computed fields before query time. The system identifies enrichment opportunities, generates enrichment expressions, and computes derived fields in advance, so that when queries are executed, the data is already prepared and ready for rapid presentation without requiring real-time processing of raw data.
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 increases significantly
Solution Approach 1:
The system performs preliminary enrichment of timeseries data by identifying enrichment opportunities, generating enrichment expressions, and computing derived fields in advance. This pre-processing creates enriched datasets that can be quickly retrieved and presented, eliminating the need for applications to perform complex real-time processing while maintaining data accuracy and relevance.
Solution Approach 2:
The patent introduces an intermediary enrichment service that acts as a mediator between raw data storage and application queries. This service pre-processes data into enriched formats with computed fields, serving as an intermediate layer that simplifies application logic while accelerating query response times by providing pre-computed results.
3Measurement precision
If raw timeseries data is processed in response to requests, then data processing accuracy is maintained, but data visualization efficiency deteriorates
Solution Approach 1:
The system performs preliminary enrichment by identifying enrichment opportunities, generating enrichment expressions, and computing derived fields in advance with full accuracy. This pre-processing maintains measurement precision through systematic computation of time-based, state-based, and cross-dataset enrichments, while simultaneously improving visualization efficiency by making enriched data immediately available for presentation without real-time processing delays.
Data Source
AI summary
A building management system (BMS) includes building equipment configured to provide raw data samples of data points in the BMS, a data collector configured to generate raw data timeseries including raw data samples from the building equipment, and a timeseries processing engine. The timeseries processing engine is configured to identify an initial timeseries processing workflow that applies to the raw data timeseries, identify other data timeseries required as inputs to the initial timeseries processing workflow, and generate an enriched timeseries processing workflow that includes the initial timeseries processing workflow, the raw data timeseries, and the other data timeseries. The timeseries processing engine is configured to execute the enriched timeseries processing workflow to generate a 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.