Tabular Data Extraction from OCR Documents with Header Repair

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing OCR systems face challenges in accurately extracting and structuring data from scanned documents with tabular or columnar data, particularly due to interference from header information, graphic elements, and errors caused by dirt, different shades of printing, and stamps, leading to incomplete or inaccurate recognition and misapplication of text strings and their positions.

Innovation Solution

A method for automatic structured extraction of data from OCR documents involves identifying strings and their positions, forming content cells, localizing table columns, clustering OCR scan lines based on repetitive patterns, determining header lines, associating header and content cells, and repairing missing patterns with dummy data to create a structured table format.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Extent of automation

If traditional OCR systems are used to extract data from scanned documents with tabular data, then the extraction process can be automated, but the accuracy and completeness of data extraction deteriorate due to interference from header information, graphic elements, and errors caused by dirt, different shades of printing, and stamps

Engineering Contradiction:
Improveautomation of data extractionVSAvoidaccuracy of data extraction
Core Design Contradiction:
Extent of automationVSMeasurement precision

Solution Approach 1:

The patent segments the OCR extraction process into multiple independent modules: header detection module that identifies header rows, pattern recognition module that detects repetitive structures, clustering module that groups similar lines, and repair module that corrects errors. Each module handles specific aspects of the extraction challenge, allowing the system to maintain automation while improving accuracy through specialized processing at each stage.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces intermediary processing steps between raw OCR output and final extracted data. These include a preprocessing stage that cleans and normalizes OCR strings, a pattern matching stage that identifies structural elements, and a postprocessing stage that repairs inconsistencies. These intermediary layers act as mediators that filter out noise from headers, graphics, and printing artifacts while preserving genuine data.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Loss of information

If OCR systems attempt to recognize all text in scanned documents, then comprehensive text coverage is achieved, but the reliability of recognized strings deteriorates due to interference from header information, graphic elements, and errors caused by dirt, different shades of printing, and stamps

Engineering Contradiction:
Improvecompleteness of text recognitionVSAvoidreliability of recognized strings
Core Design Contradiction:
Loss of informationVSReliability

Solution Approach 1:

The patent extracts and separates header information from body content through dedicated header detection algorithms. By identifying and isolating header rows based on their distinctive characteristics (such as repetitive patterns, positioning, and formatting), the system can exclude these low-reliability elements from the main data extraction process, thereby improving the overall reliability of extracted strings while maintaining completeness of genuine data.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent implements feedback mechanisms where the system continuously evaluates the confidence levels of recognized strings and adjusts its extraction behavior accordingly. Low-confidence strings from problematic areas (headers, graphics, stained regions) are flagged and either excluded or subjected to additional verification, while high-confidence strings are accepted directly. This feedback loop maintains both completeness and reliability of the extracted data.

Inventive Principle:
Principle #23Feedback

3Measurement precision

If manual review and arrangement of extracted data is required to meet user needs, then data accuracy can be improved, but the productivity and efficiency of the extraction process deteriorates

Engineering Contradiction:
Improvedata accuracyVSAvoidextraction efficiency
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The patent implements self-service capabilities where the extraction system automatically performs tasks that would traditionally require manual intervention. The system autonomously detects headers, identifies table structures, clusters similar lines, repairs missing patterns, and formats output according to user specifications. This self-service automation maintains high data accuracy while eliminating manual review steps, thereby preserving productivity.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent allows dynamic adjustment of extraction parameters based on the characteristics of the input document and user requirements. Confidence thresholds, pattern matching sensitivity, and output formatting options can be modified without requiring manual reprocessing. This flexibility enables the system to adapt to different document types and user needs while maintaining both accuracy and efficiency through automated parameter optimization.

Inventive Principle:
Principle #35Parameter changes

4Adaptability or versatility

If the extraction system must handle various document formats and user customization requirements, then user flexibility is improved, but the device complexity increases

Engineering Contradiction:
Improveuser flexibilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent designs the extraction system with universal components that can handle multiple document formats and user requirements through a single unified architecture. The core pattern recognition engine, clustering algorithms, and repair mechanisms work across different document types (invoices, transcripts, forms, etc.) without requiring separate specialized systems. User customization is achieved through configurable parameters rather than structural modifications, maintaining system simplicity while enhancing flexibility.

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

Data Source

PatentUS9785830B2Methods for automatic structured extraction of data in OCR documents having tabular data
Publication Date: 2017.10.10 HYLAND SWITZERLAND SARL
  • US9785830B2 patent drawing
  • US9785830B2 patent drawing
  • US9785830B2 patent drawing

AI summary

Methods to select and extract tabular data among the optical character recognition returned strings to automatically process documents, including documents containing academic transcripts.