Building Energy Data Model With Bidirectional Timeseries Views

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 visualization and management of building energy data.

Innovation Solution

A building energy management system that includes a data collector, data platform services, and an energy management application, which processes raw data samples to generate optimized timeseries data and provides an ad hoc dashboard with interactive visualization options, enabling real-time data analysis and management.

Engineering Contradictions & Design Principles

VSEngineering 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

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

Solution Approach 1:

The patent pre-processes and organizes raw timeseries data into structured formats with metadata (such as data types, units, descriptions) at the time of data collection rather than waiting until query time. This preliminary organization enables faster data retrieval and presentation while maintaining storage efficiency through standardized data structures.

Inventive Principle:
Principle #10Preliminary action

2Device complexity

If applications are responsible for retrieving and processing raw timeseries data to generate views, then system complexity is reduced, but data presentation efficiency deteriorates due to processing delays

Engineering Contradiction:
Improvesystem complexityVSAvoiddata presentation efficiency
Core Design Contradiction:
Device complexityVSProductivity

Solution Approach 1:

The patent introduces an intermediary data structure layer between raw data collection and application processing. This intermediary structure includes organized timeseries data with embedded metadata that bridges the gap between simple storage and efficient processing, allowing applications to quickly generate views without extensive processing while maintaining manageable system complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS10921972B2Building system with data model including bidirectional relationships
Publication Date: 2021.02.16 JOHNSON CONTROLS TECHNOLOGY CO
  • US10921972B2 patent drawing
  • US10921972B2 patent drawing
  • US10921972B2 patent drawing

AI summary

A building energy management includes building equipment, one or more data platform services, a timeseries database, and an energy management application. The building equipment operate to monitor and control a variable and provide raw data samples of a data point associated with the variable. The timeseries database stores a plurality of timeseries associated with the data point. The plurality of timeseries include a timeseries of the raw data samples and the one or more optimized data timeseries generated by the data platform services based on the raw data timeseries. The energy management application generates an ad hoc dashboard including a widget and associates the widget with the data point. The widget displays a graphical visualization of the plurality of timeseries associated with the data point and includes interactive user interface options for switching between the plurality of timeseries associated with the data point.