Tabular Data Field Mapping for Multi-System Data Completion

Solution Overview

Problem

Existing methods for tabular data processing involve manual downloading and merging of data from multiple systems into CSV/Excel files or using spreadsheet software, which is inefficient and labor-intensive.

Innovation Solution

A method and apparatus for tabular data processing that includes presenting a field filtering interface to automatically add and complement data from multiple data systems into a specified table, utilizing a field filtering interface, field name adding module, and data complementing module, with support from a field name mapping list to facilitate data integration and updating.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual downloading and merging of data from multiple systems into CSV/Excel files is used, then data integration can be achieved, but the workload and time consumption increase significantly

Engineering Contradiction:

Improvedata integration efficiencyVSAvoidtime for downloading and editing files

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system pre-establishes field name mapping lists that define correspondence relationships between fields in different data systems before data integration is needed. When data needs to be integrated, the system automatically queries and matches fields using these pre-defined mappings, eliminating the need for manual field correspondence setup during the data merging process.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces a field name mapping list as an intermediary layer between multiple data systems. This mapping list acts as a translation dictionary that enables automatic field name correspondence and data matching across different systems, replacing the manual field-by-field matching process that previously required significant human effort.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Ease of operation

If spreadsheet software is used to obtain and merge data from online APIs, then data can be integrated into tables, but the process remains labor-intensive and inefficient

Engineering Contradiction:

Improvedata integration process simplicityVSAvoiddata processing efficiency

Core Design Contradiction:

Ease of operationVSProductivity

Solution Approach 1:

The system enables self-service data integration by automatically querying the data system, performing field name matching using the pre-defined mapping list, and completing the data integration process without requiring manual intervention. The system serves itself by autonomously handling the entire data integration workflow from query to result generation.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent replaces the mechanical manual operations of downloading, copying, and merging data in spreadsheet software with an automated electronic system. The system uses computer-based automated querying and programmatic field matching to substitute the manual mechanical processes, significantly improving efficiency while maintaining ease of use through a user-friendly interface.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

3Measurement precision

If manual field-by-field data matching is performed across multiple data systems, then accurate data integration can be achieved, but the complexity and time required increase

Engineering Contradiction:

Improvefield name matching accuracyVSAvoiddata processing system complexity

Core Design Contradiction:

Measurement precisionVSDevice complexity

Solution Approach 1:

The system pre-establishes field name mapping lists that define correspondence relationships between fields in different data systems before data integration is needed. When data needs to be integrated, the system automatically queries and matches fields using these pre-defined mappings, eliminating the need for manual field-by-field matching processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces a field name mapping list as an intermediary layer between multiple data systems. This mapping list acts as a translation dictionary that enables automatic field name correspondence and data matching across different systems, replacing the manual field-by-field matching process that previously required significant human effort.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS12475307B2Method and apparatus for tabular data processing, terminal, and storage medium

Publication Date: 2025.11.18 BEIJING ZITIAO NETWORK TECH CO LTD

AI summary

The disclosure provides a method and an apparatus for tabular data processing, a terminal, and a storage medium. The method for tabular data processing includes: in response to a triggering operation of a specific control associated with a specified table, presenting a field filtering interface; wherein each candidate field name in the field filtering interface is a predetermined field name that exists in at least one data system, and each candidate field name in the field filtering interface has an association relationship with a field name corresponding to a filled column in the specified table; in response to a field name selecting operation on the field filtering interface, adding the selected field name into the specified table; and complementing data corresponding to data of a filled column and each field name in the specified table; wherein the complemented data is data from the at least one data system.