Cloud Feedback Control Workflows for Building Timeseries Delays
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current web services platforms face delays in data presentation due to the need for applications to retrieve and process raw timeseries data from relational databases, leading to inefficient data processing and visualization.
Innovation Solution
A web services platform with a data collector and timeseries service that collects feedback samples from sensors, applies processing operations defined by a feedback control workflow to generate control signal timeseries, and provides these signals to controllable building equipment, utilizing techniques like PID control to optimize data processing and reduce delays.
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 delays in retrieval and processing at query time
Solution Approach 1:
The patent applies preliminary action by pre-processing and organizing timeseries data at the time of collection into time buckets with aggregated statistics (min, max, mean, sum, count) before storage. This preliminary organization eliminates the need for complex queries at presentation time, thereby resolving the contradiction between storage simplicity and data presentation speed.
2Adaptability or versatility
If applications are responsible for retrieving raw timeseries data and generating views in response to requests, then application flexibility is improved, but data processing efficiency deteriorates due to query-time delays
Solution Approach 1:
The patent pre-generates multiple views of the timeseries data during data collection and stores them in the database. Applications can directly query these pre-generated views without performing complex processing, thus maintaining application flexibility while dramatically improving data processing efficiency and eliminating query-time delays.
3Loss of time
If data is pre-aggregated and control workflows are applied in real-time, then data presentation speed is improved, but system complexity increases due to additional processing components
Solution Approach 1:
The patent reduces system complexity by performing aggregation at data collection time rather than requiring complex real-time processing systems. The pre-aggregated data structure with time buckets and statistics enables fast querying without needing sophisticated real-time processing infrastructure, thus improving data presentation speed while minimizing the increase in system complexity.
Data Source
AI summary
A web services platform includes a data collector and a timeseries service. The data collector is configured to collect feedback samples provided by one or more sensors of a building management system and generate one or more feedback timeseries including a plurality of the feedback samples. The timeseries service is configured to identify a feedback control workflow that uses the feedback timeseries as an input and defines one or more processing operations to be applied to the feedback samples of the feedback timeseries, perform the one or more processing operations defined by the feedback control workflow to generate a control signal timeseries including a set of control signal samples, and provide a control signal including at least one of the control signal samples or the control signal timeseries as an output to controllable building equipment of the building management system that operate using the control signal as an input.