BMS Data Access Router for Multi-Tier Storage Consistency

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Building management systems face increased complexity due to dynamic data storage needs and multiple types of data stores, making it difficult for application developers to ensure access to the most recent version of data or the fastest storage device.

Innovation Solution

A multi-tiered data storage system is implemented, featuring an operational data store, a cache data store for redundant copies, and a reporting data store, with a data access router providing a consistent endpoint for applications. The router determines the availability of data objects in each store and optimally routes requests and writes data accordingly.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If multiple types of data stores are used to meet growing data storage requirements, then data storage capability is improved, but software complexity increases

Engineering Contradiction:
Improvedata storage capabilityVSAvoidsoftware complexity
Core Design Contradiction:
Quantity of substanceVSDevice complexity

Solution Approach 1:

The patent introduces an abstraction layer that acts as an intermediary between applications and multiple data stores. This abstraction layer provides a unified interface and handles the complexity of managing different data store types (relational, document, time series), allowing applications to access data without needing to understand the underlying storage complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The abstraction layer serves multiple functions: it manages different data store types, handles data consistency, provides unified access interfaces, and optimizes data retrieval. By making the system multi-functional, it reduces the need for separate management mechanisms for each data store type.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Speed

If the most recent version of data or fastest storage device is used dynamically, then data access performance is improved, but difficulty in anticipating storage availability increases

Engineering Contradiction:
Improvedata access performanceVSAvoidstorage availability predictability
Core Design Contradiction:
SpeedVSDifficulty of detecting and measuring

Solution Approach 1:

The system pre-establishes an abstraction layer that defines consistent access patterns and data retrieval strategies. By planning data access paths in advance through the abstraction layer, the system can optimize performance without requiring applications to dynamically determine storage availability, making the process more predictable.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The abstraction layer implements feedback mechanisms that monitor data store performance and availability, allowing the system to adaptively route data access requests to the most appropriate storage devices while maintaining predictable access patterns through centralized control.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS12112068B2Systems and methods for multi-tiered data storage abstraction layer
Publication Date: 2024.10.08 TYCO FIRE & SECURITY GMBH
  • US12112068B2 patent drawing
  • US12112068B2 patent drawing
  • US12112068B2 patent drawing

AI summary

A multi-tiered data storage system for building management system (BMS) data includes a plurality of data stores including a first data store and a second data store. The system further includes a data access router configured to provide a consistent endpoint for the BMS data to an application that provides or consumes the BMS data regardless of whether the BMS data is stored in the second data store or the first data store, obtain a requested data object of the BMS data from the second data store in response to a determination that the requested data object is available in the second data store, and obtain the requested data object from the first data store in response to a determination that the requested data object is not available in the second data store.