Visual Data Transformation Interface for Non-Technical Users
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing computer-based systems for transforming and applying rules and logic to data require significant technical expertise, often necessitating programming skills and limited transformation methods.
Innovation Solution
A computer-based apparatus with a graphical user interface that allows users to select data fields and operations represented by icons, generating flowcharts to transform data without programming expertise, enabling data transformation and storage in various formats.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If computer programming (XSLT or hard coded programs) is used to implement data transformation logic, then data transformation capability is achieved, but user expertise requirement increases significantly
Solution Approach 1:
The patent introduces a visual programming interface with drag-and-drop icons as an intermediary between the user and the underlying programming logic. Users select operations through visual icons rather than writing code, while the system automatically generates the corresponding XSLT or programmed logic, thus mediating between simplicity and transformation capability
Solution Approach 2:
The patent replaces the mechanical system of manual programming with an automated system that generates code from visual selections. The drag-and-drop interface substitutes manual coding mechanics with automated code generation, reducing the physical and cognitive effort required while maintaining transformation functionality
2Ease of operation
If field mapping and limited transformation methods are provided, then ease of operation improves, but transformation versatility is limited
Solution Approach 1:
The patent creates a universal platform that supports multiple transformation methods through a unified visual interface. The system can handle various data formats and transformation types using the same drag-and-drop mechanism, making the interface universally applicable while maintaining versatility in transformation capabilities
Solution Approach 2:
The patent implements a dynamic system where the available operations and interface elements adapt based on the selected data fields and context. The interface dynamically adjusts to provide relevant transformation options, enabling both simplicity for common tasks and versatility for complex transformations without requiring a fixed, limited set of methods
Data Source
AI summary
A computer-based apparatus, including: a memory element storing computer-readable instructions and at least one first data file; and a processor configured to execute the instructions to: display a second data file included in the at least one first data file, data fields for the second data file, and icons identifying operations applicable to first data in the second data file; accept a first input selecting a data field from the data fields for the second data file; accept a second input selecting an icon from the icons; associate the icon with the data field; generate a flowchart including the icon; display the flowchart on the GUI; generate second data by performing the operation for the icon on the first data; and replace the first data with the second data, or store the second data in a third data file included in the at least one first data file.