Data Integration System Merging Object Profiles

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Relational databases face challenges in managing increased size and complexity as new databases are integrated, requiring efficient data integration methods to maintain design flexibility without compromising performance.

Innovation Solution

A data integration system and method that utilizes a processor to receive and process data sets with user identifiers and message type codes, updating counter values in object profiles within a data repository, allowing for the merging of different data sets into a compact form by modifying pre-existing object profiles.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If new databases are incorporated into the relational database by linking data fields, then design flexibility is improved, but database size increases

Engineering Contradiction:

Improvedesign flexibilityVSAvoiddatabase size

Core Design Contradiction:

Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent merges multiple data sets into a single integrated data repository, consolidating what would otherwise be separate databases. This combining approach maintains design flexibility while preventing database size proliferation by storing all data in one unified structure rather than multiple linked databases.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The integrated data repository serves multiple functions: it stores data from various sources, maintains relationships between data elements, and provides a unified access point. This multi-functional approach replaces the need for multiple separate databases, maintaining versatility while reducing overall system complexity and size.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If new databases are added to the relational database framework, then data integration capability is improved, but system complexity increases

Engineering Contradiction:

Improvedata integration capabilityVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent combines multiple data sets and their management operations into a single integrated data repository, reducing system complexity by eliminating the need to manage multiple separate databases and their inter-linking relationships.

Inventive Principle:

Principle #5Merging (Combining)

Solution Approach 2:

The integrated data repository acts as an intermediary layer that handles all data integration operations centrally. This mediator approach simplifies the system by providing a single point of control for data integration, rather than requiring complex point-to-point linking between multiple databases.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS11562038B2System and method of integrating data

Publication Date: 2023.01.24 THE TORONTO DOMINION BANK

AI summary

A data set integration system receives a first data set that includes a user identifier and a message type code. The integration system locates an object profile that is associated with the terminal identifier in a data repository. The located object profile includes a tracking identifier and a counter value. The integration system updates the counter value in the object profile in accordance with a value of the message type code. The integration system updates receives a second data set from a communications device. The second data set includes the tracking identifier. The integration system locates the counter value in the object profile that is associated with the tracking identifier, and transmits to the communications device a data payload that includes the updated counter value.