Correlation Engine for Data Consistency Across Distributed Sources

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Businesses face challenges in managing and ensuring the accuracy and consistency of data distributed across multiple, diverse data sources and storage locations, leading to potential use of incomplete or non-current data in decision-making processes, which can result in suboptimal decisions.

Innovation Solution

A system and method utilizing a correlation engine to extract, validate, and standardize data from various sources, comparing it against other copies to ensure currentness, and storing it in a correlation database for accessible consumption across the organization, using data collection scripts, APIs, and microservices for data management.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If data is distributed across multiple storage locations and data sources, then data availability and accessibility are improved, but data consistency and accuracy deteriorate

Engineering Contradiction:
Improvedata availabilityVSAvoiddata consistency
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The patent introduces a correlation engine as an intermediary component that receives data from multiple distributed storage locations and data sources. This engine correlates the incoming data streams, comparing and validating data across sources to ensure consistency. The correlation engine acts as a mediator between the distributed data sources and the data consumers, resolving conflicts and ensuring that only consistent, accurate data is made available throughout the organization.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Device complexity

If manual data correlation processes are used, then implementation simplicity is maintained, but productivity and efficiency deteriorate

Engineering Contradiction:
Improveprocess simplicityVSAvoiddata management efficiency
Core Design Contradiction:
Device complexityVSProductivity

Solution Approach 1:

The patent implements an automated correlation engine that performs data correlation tasks without requiring manual intervention. The system self-manages the complex process of extracting data from multiple sources, comparing data across sources, resolving conflicts, and distributing correlated data to consumers. This automation eliminates the need for manual data correlation processes while maintaining system manageability through standardized interfaces and procedures.

Inventive Principle:
Principle #25Self-service

3Productivity

If data is extracted and processed automatically, then productivity is improved, but system complexity deteriorates

Engineering Contradiction:
Improvedata processing efficiencyVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent divides the data correlation system into distinct functional modules: data extraction components that retrieve data from various sources, a correlation engine that processes and compares data, validation mechanisms that ensure data quality, and distribution systems that deliver correlated data to consumers. This segmentation allows each component to be developed, maintained, and scaled independently, managing overall system complexity while enabling high-productivity automated data processing.

Inventive Principle:
Principle #1Segmentation

4Measurement precision

If data validation and correlation processes are implemented, then data accuracy is improved, but processing time deteriorates

Engineering Contradiction:
Improvedata accuracyVSAvoidprocessing time
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The patent implements preliminary validation and correlation checks as data enters the system from various sources. The correlation engine performs initial data quality assessments, format validations, and consistency checks at the point of data ingestion rather than waiting until data is needed. This preliminary action ensures data accuracy is established early in the process, reducing the need for time-consuming reprocessing and validation later when data is ready for consumption.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS10606828B2Storage correlation engine
Publication Date: 2020.03.31 JPMORGAN CHASE BANK NA
  • US10606828B2 patent drawing
  • US10606828B2 patent drawing
  • US10606828B2 patent drawing

AI summary

A method of and system for correlating data from among a disparate group of data sources and providing the correlated data to data consumers via API's and direct transmission of the data are disclosed. Once the validity of the data is verified, the data is translated from a format specific to the data source into a format that is usable by various other data repositories. Thereafter, the data may be provided to data consumers.