Automated Data Validation System Using Mapping Logic

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Manual data validation becomes impractical for ensuring data accuracy and consistency across multiple platforms, especially with large volumes of data, leading to a need for an automated solution.

Innovation Solution

An automated system that transforms and validates data sets across different structures using customizable mapping logic, providing real-time notifications and allowing users to mitigate mismatches through a user interface, ensuring data consistency within a predetermined tolerance level.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If manual data validation is used to ensure data accuracy, then data correctness can be verified, but the process becomes impractical and inefficient for large volumes of data across multiple platforms

Engineering Contradiction:

Improvedata accuracyVSAvoidvalidation efficiency

Core Design Contradiction:

Measurement precisionVSProductivity

Solution Approach 1:

The patent replaces manual mechanical validation processes with an automated computer-based system that uses processing devices to execute validation logic, compare data sets, and generate reports automatically, thereby maintaining accuracy while dramatically improving efficiency for large-scale data validation across multiple platforms

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The system enables self-service data validation by automatically performing validation operations without requiring manual intervention for each data comparison, allowing the system to handle large volumes of data independently while maintaining precision through programmed validation rules

Inventive Principle:

Principle #25Self-service

2Productivity

If automated validation system is implemented to improve processing efficiency, then validation speed increases, but system complexity increases

Engineering Contradiction:

Improvevalidation speedVSAvoidsystem complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The patent segments the validation system into distinct functional modules including data reception components, transformation components, validation logic components, and reporting components, allowing each module to handle specific tasks independently and reducing overall system complexity while maintaining high processing speed

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The system implements universal processing devices and validation logic that can handle multiple data types, formats, and validation rules through a single automated platform, reducing the need for separate specialized systems and thereby reducing complexity while improving efficiency

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS10366073B2System for automating data validation

Publication Date: 2019.07.30 BANK OF AMERICA CORP

AI summary

Embodiments of the invention are directed to systems, methods, and computer program products for automating data validation. The system is configured to receive the initial data set in the first data structure from a network of distributed servers; transform the initial data set into an expected data set having the second data structure using a first mapping logic; use the expected data set to validate a converted data set that was generated by converting the initial data set into the second data structure using a second mapping logic; and transmit control signals configured to cause a user device associated with the user to receive a notification indicating that the match is within the pre-determined tolerance level.