IoT Data Aggregation with Contextual Schema Merging

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current IoT systems lack an efficient method to merge and analyze IoT device data with contextual data, limiting their ability to provide comprehensive insights and decision-making capabilities across various applications.

Innovation Solution

A technology that merges IoT device data with contextual data in a relational database, allowing for queries and analysis that combine IoT device data with contextual information, enabling users to make informed decisions through the unified query interface.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If IoT device data is collected and stored separately without merging with contextual data, then data storage and management remain simple, but the system lacks comprehensive insights and decision-making capabilities

Engineering Contradiction:
Improvecontextual informationVSAvoiddata merging system
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The patent merges IoT device data with contextual data from external sources into a unified data structure. The server receives IoT device data, identifies relevant contextual data from multiple external sources, and combines them into a single merged data set that enables comprehensive analysis and insights while managing complexity through centralized processing.

Inventive Principle:
Principle #5Merging (Combining)

2Measurement precision

If IoT device data is analyzed without contextual data, then analysis processing remains fast and simple, but the system cannot detect patterns, correlations, and anomalies effectively

Engineering Contradiction:
Improvedata analysis accuracyVSAvoiddata processing efficiency
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The system performs preliminary actions by pre-identifying and pre-fetching contextual data that is likely to be relevant to incoming IoT device data. The server maintains relationships between data types and proactively retrieves contextual information before analysis is needed, reducing latency during actual analysis while ensuring comprehensive data availability for accurate pattern detection and anomaly identification.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11514069B1Aggregation of contextual data and internet of things (IoT) device data
Publication Date: 2022.11.29 AMAZON TECH INC
  • US11514069B1 patent drawing
  • US11514069B1 patent drawing
  • US11514069B1 patent drawing

AI summary

Technology is described for processing Internet of Things (IoT) device data. IoT device data may be received from an IoT device. Contextual data that is related to the IoT device data from the IoT device may be identified. A first schema that defines the IoT device data and a second schema that defines the contextual data may be identified. A relational database that merges the IoT device data with the contextual data may be created. Knowledge of the first schema and the second schema may enable the IoT device data and the contextual data to be read and organized in the relational database.