Automated Data Validation via Contextual Anomaly Detection

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current data validation processes are slow, expensive, and require substantial manual involvement, limiting scalability and accuracy, especially when dealing with inconsistencies, formatting errors, and anomalies in extracted data from various sources.

Innovation Solution

A fully-automated data validation and correction system utilizing a data manager that identifies anomalies using contextual information and validation rules, generates weighted lists of similar data elements, and automatically corrects errors, reducing the need for manual validation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual validation processes are used to ensure data accuracy, then data quality can be maintained, but the process becomes slow and expensive with limited scalability

Engineering Contradiction:
Improvedata qualityVSAvoidvalidation speed
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The patent replaces manual mechanical validation processes with an automated computer-based system that uses optical character recognition (OCR), pattern matching, and validation rules to detect and correct data anomalies, thereby maintaining data quality while dramatically increasing validation speed and scalability

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The system performs self-validation by automatically comparing extracted data against validation rules, business logic, and reference data sources, enabling the system to identify and correct its own errors without requiring continuous manual intervention

Inventive Principle:
Principle #25Self-service

2Measurement precision

If manual validation processes are used to identify and correct data anomalies, then data accuracy can be improved, but substantial manual involvement is required increasing costs

Engineering Contradiction:
Improvedata accuracyVSAvoidmanual involvement
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The patent substitutes manual inspection and correction activities with automated computational processes including OCR technology, pattern recognition algorithms, and rule-based validation systems that maintain high data accuracy while eliminating the need for substantial manual involvement

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

Solution Approach 2:

The system introduces an intermediary automated validation layer between data extraction and final data usage, which includes computer-implemented algorithms that act as mediators to detect, flag, and correct anomalies before human reviewers need to intervene

Inventive Principle:
Principle #24Intermediary (Mediator)

3Reliability

If traditional validation methods are used, then some data errors can be detected, but the process lacks scalability when dealing with large volumes of extracted data

Engineering Contradiction:
Improveerror detection capabilityVSAvoidscalability
Core Design Contradiction:
ReliabilityVSAdaptability or versatility

Solution Approach 1:

The patent creates a universal automated validation system that can handle multiple types of data anomalies (formatting errors, content errors, OCR misrecognitions, business rule violations) across various data sources and formats, enabling the system to scale efficiently with increasing data volumes while maintaining consistent error detection capabilities

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS8468167B2Automatic data validation and correction
Publication Date: 2013.06.18 CORELOGIC INC
  • US8468167B2 patent drawing
  • US8468167B2 patent drawing
  • US8468167B2 patent drawing

AI summary

Techniques disclosed herein include systems and methods for data validation and correction. Such systems and methods can reduce costs, improve productivity, improve scalability, improve data quality, improve accuracy, and enhance data security. A data manager can execute such data validation and correction. The data manager identifies one or more anomalies from a given data set using both contextual information and validation rules, and then automatically corrects any identified anomalies or missing information. Identification of anomalies includes generating similar data elements, and correlating against contextual information and validation rules.