Data Reconciliation Engine Creative Additive Source Classification

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing data reconciliation processes fail to distinguish between creative and additive data sources, leading to inefficient merging of data records and potential duplication, as they do not confirm the existence of resources before reconciliation.

Innovation Solution

A data reconciliation engine identifies creative and additive data sources, initiating the reconciliation process only when a creative data source is found, merging data from both types of sources into a reconciled data record while confirming the existence of the resource.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If the reconciliation process merges data from all data sources without distinguishing between creative and additive sources, then complete data consolidation is achieved, but resource duplication and processing inefficiency occur

Engineering Contradiction:

Improvedata reconciliation efficiencyVSAvoiddata duplication

Core Design Contradiction:

ProductivityVSLoss of information

Solution Approach 1:

The patent segments data sources into two distinct categories: creative data sources (which confirm resource existence) and additive data sources (which may reference non-existent resources). This segmentation allows the reconciliation process to selectively merge data only from creative sources, eliminating unnecessary processing of additive sources and preventing data duplication while maintaining reconciliation efficiency.

Inventive Principle:

Principle #1Segmentation

2Reliability

If the reconciliation process processes all data sources uniformly, then comprehensive data merging is achieved, but processing time and computational resources are wasted on additive sources

Engineering Contradiction:

Improvedata integrityVSAvoidreconciliation processing time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by classifying data sources as creative or additive before initiating the data merging process. This pre-classification enables the system to identify and process only creative data sources that confirm resource existence, eliminating wasted computational time on additive sources while ensuring data integrity through selective processing.

Inventive Principle:

Principle #10Preliminary action

3Adaptability or versatility

If the system creates merged data records for all resources regardless of existence confirmation, then complete resource coverage is achieved, but false resource entries are created

Engineering Contradiction:

Improveresource coverageVSAvoidresource existence accuracy

Core Design Contradiction:

Adaptability or versatilityVSMeasurement precision

Solution Approach 1:

The patent applies local quality by applying different processing rules to different types of data sources. Creative data sources (which provide existence confirmation) trigger merged data record creation, while additive data sources (which lack existence confirmation) do not trigger record creation. This localized quality control ensures that resources are only created when their existence is verified, eliminating false entries while maintaining appropriate resource coverage.

Inventive Principle:

Principle #3Local quality

Data Source

PatentUS11561766B2Creative and additive reconciliation of data records

Publication Date: 2023.01.24 BMC HELIX INC

AI summary

A data management system includes a data reconciliation engine that identifies data sources that contain data records referencing a resource and determines whether each of the identified data sources is a creative data source or an additive data source. When all of the identified data sources are additive data sources, the reconciliation engine terminates a data reconciliation process. When all of the identified data sources are not additive data sources, the reconciliation engine finds a first creative data source from among the identified data sources, and initiates the data reconciliation process by merging data from the identified data sources including the first creative data source, one data source-by-one data source, into a reconciled data record.