Interactive Smart Copy Data Profiling and Reformatting

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

The existing copy and paste operations often result in data errors due to formatting discrepancies between the originating and target systems, leading to clumsy and difficult-to-read final documents, with formatting issues frequently being overlooked.

Innovation Solution

An automatic monitoring method is implemented during the cut and paste operation, using a user interactive pop-up window to confirm the correct placement and format of the selected data, which includes an automatic data identifier analysis to determine a confidence score and reformat the data if necessary to match the target area's format.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If automatic data type analysis and confidence scoring are implemented, then data placement accuracy is improved, but system complexity increases

Engineering Contradiction:

Improvedata placement accuracyVSAvoidsystem complexity

Core Design Contradiction:

ReliabilityVSDevice complexity

Solution Approach 1:

The system performs preliminary data profiling and analysis before the actual copy-paste operation. By pre-analyzing the data types, formats, and structures of both source and target areas, the system prepares confidence scores and potential action recommendations in advance, ensuring accurate data placement while managing complexity through staged processing

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system implements feedback mechanisms by calculating confidence scores based on data type matching and providing recommendations to users. The feedback loop allows the system to adjust its analysis depth and user interaction based on the confidence level, resolving the contradiction by adapting complexity to the actual data compatibility situation

Inventive Principle:

Principle #23Feedback

2Reliability

If user interactive pop-up windows are generated for confirmation, then data placement reliability is improved, but operation time increases

Engineering Contradiction:

Improvedata placement reliabilityVSAvoidoperation time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system applies partial confirmation actions by only generating pop-up windows when confidence scores fall below certain thresholds. When data types match with high confidence, the system proceeds automatically without user intervention, thus maintaining reliability for critical cases while minimizing operation time for routine cases

Inventive Principle:

Principle #16Partial or excessive action

Solution Approach 2:

The system dynamically changes the parameter of user interaction based on confidence score thresholds. By adjusting the level of user confirmation required according to the calculated confidence level, the system optimizes the balance between reliability and operation time, applying full verification only when necessary

Inventive Principle:

Principle #35Parameter changes

3Manufacturing precision

If automatic data format analysis and reformatting are performed, then formatting consistency is improved, but processing time increases

Engineering Contradiction:

Improveformatting consistencyVSAvoidprocessing time

Core Design Contradiction:

Manufacturing precisionVSLoss of time

Solution Approach 1:

The system performs preliminary format analysis during the data profiling phase, identifying format discrepancies between source and target areas before the actual data transfer. By detecting format issues in advance and preparing reformatting actions beforehand, the system ensures formatting consistency while minimizing the time impact during the critical data transfer phase

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system implements self-service reformatting by automatically detecting format mismatches and applying appropriate transformations without requiring manual user intervention. The system serves itself by identifying and correcting its own formatting issues, improving consistency while reducing the time burden on users

Inventive Principle:

Principle #25Self-service

4Measurement precision

If comprehensive data profiling and identifier determination are implemented, then data type matching accuracy is improved, but computational load increases

Engineering Contradiction:

Improvedata type matching accuracyVSAvoidcomputational load

Core Design Contradiction:

Measurement precisionVSUse of energy by moving object

Solution Approach 1:

The system segments the data analysis process into distinct phases: initial data profiling, identifier determination, format analysis, and confidence scoring. By dividing the comprehensive analysis into manageable segments that can be performed progressively and selectively, the system achieves high matching accuracy while managing computational load through staged processing

Inventive Principle:

Principle #1Segmentation

Data Source

PatentUS11995098B2Interactive smart copy method

Publication Date: 2024.05.28 CAPITAL ONE SERVICES LLC

AI summary

Systems and methods for automatically profiling data a user selects to transfer to a paste area are described. Data may be automatically profiled the at the user selected target paste area to determine if sets of data are of the same data type. There may be a clarification for a target paste area or for identifying the data type. Additionally, there may be reformatting the selected data set to match the target data's format. Machine learning may trigger formatting or prompting actions according to one or more predetermined thresholds.