Nested Timeseries Generation for Faster Building Data Queries

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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 processing and visualization.

Innovation Solution

A BMS that includes a data collector, a timeseries service, and a timeseries storage interface, which collects data from building equipment, applies processing workflows to generate derived timeseries data, and stores it in a timeseries database, allowing for pre-aggregated data to be used for efficient querying and visualization.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of manufacture

If raw timeseries data is stored without significant organization or processing at the time of data collection, then storage simplicity is improved, but data presentation speed deteriorates due to processing delays at query time

Engineering Contradiction:
Improvestorage simplicityVSAvoiddata presentation delay
Core Design Contradiction:
Ease of manufactureVSLoss of time

Solution Approach 1:

The patent applies preliminary action by organizing and processing timeseries data into structured formats with metadata (such as tags, data types, and hierarchical relationships) at the time of data collection rather than at query time. This pre-organization enables faster data retrieval and processing when queries are executed, resolving the contradiction between storage simplicity and data presentation speed.

Inventive Principle:
Principle #10Preliminary action

2Adaptability or versatility

If applications retrieve and generate views of timeseries data in response to requests, then data processing flexibility is improved, but data presentation speed deteriorates

Engineering Contradiction:
Improvedata processing flexibilityVSAvoiddata presentation speed
Core Design Contradiction:
Adaptability or versatilityVSSpeed

Solution Approach 1:

The patent applies segmentation by dividing timeseries data into organized structures with metadata tags, data types, and hierarchical relationships. This segmentation allows the system to quickly locate and retrieve only the relevant data subsets needed for specific applications, maintaining processing flexibility while significantly improving data presentation speed by avoiding full data scans.

Inventive Principle:
Principle #1Segmentation

3Device complexity

If raw timeseries data is stored without significant organization, then device complexity is reduced, but measurement precision deteriorates due to inability to efficiently query and process specific data

Engineering Contradiction:
Improvesystem complexityVSAvoiddata query accuracy
Core Design Contradiction:
Device complexityVSMeasurement precision

Solution Approach 1:

The patent applies preliminary action by embedding metadata (tags, data types, hierarchical relationships) during data collection and storage. This pre-annotation enables precise and efficient querying of specific data subsets without requiring complex post-processing or full data scans, thereby improving measurement precision while maintaining relatively simple system architecture.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS12055908B2Building management system with nested stream generation
Publication Date: 2024.08.06 JOHNSON CONTROLS TECHNOLOGY CO
  • US12055908B2 patent drawing
  • US12055908B2 patent drawing
  • US12055908B2 patent drawing

AI summary

A building management system (BMS) includes building equipment configured to provide samples of one or more data points in the building management system and a timeseries service. The timeseries service is configured to identify a first timeseries processing workflow that uses an input timeseries as an input and defines processing operations to be applied to the samples of the input timeseries, perform the processing operations defined by the first timeseries processing workflow to generate a first derived timeseries comprising a first set of derived timeseries samples, identify a second timeseries processing workflow that uses the first derived timeseries as an input and defines processing operations to be applied to the samples of the first derived timeseries, and perform the processing operations defined by the second timeseries processing workflow to generate a second derived timeseries comprising a second set of derived timeseries samples.