Data Processing Apparatus Highlighting Conversion Changes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In data processing, particularly in statistical analysis and data science, the conversion accuracy of tabular data using programming by example (PBE) relies heavily on conversion examples, leading to trial and error, and users often overlook incorrect conversions when dealing with large datasets, resulting in low accuracy and increased effort in verifying conversion results.
Innovation Solution
A data processing method that repeatedly generates and applies conversion programs based on input conversion examples, highlights values in the conversion results that have changed from previous results, allowing users to easily identify and correct inaccuracies, thereby improving conversion accuracy and reducing oversight.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Manufacturing precision
If users repeatedly input conversion examples and generate recipes to improve conversion accuracy, then conversion accuracy improves, but the time and effort required for verification increases
Solution Approach 1:
The patent applies color changes by highlighting converted values in the data table using visual differentiation. When a conversion recipe is applied, values that have been converted are highlighted to draw the user's attention. This allows users to quickly verify conversion results without manually checking each value, significantly reducing verification time while maintaining high conversion accuracy through the iterative recipe generation process
2Manufacturing precision
If users visually check conversion results for large numbers of records, then conversion accuracy can be verified, but oversight of incorrect conversions is likely to occur
Solution Approach 1:
The patent uses highlighting to visually distinguish converted values from unconverted values in the data table. This visual differentiation ensures that users cannot overlook converted values during verification, even when dealing with large numbers of records. The highlighting mechanism provides a reliable detection method that eliminates human oversight errors in verifying conversion accuracy
Solution Approach 2:
The patent implements feedback by displaying the conversion results directly in the data table with highlighted values, allowing users to immediately see the effect of applied recipes. This real-time feedback mechanism enables users to verify conversion accuracy reliably without manual checking of each record, improving both detection reliability and verification efficiency
3Manufacturing precision
If conversion examples are repeatedly input to improve recipe accuracy, then conversion accuracy improves, but user burden increases
Solution Approach 1:
The patent reduces user burden by automatically highlighting converted values in the data table, eliminating the need for users to manually track or verify each conversion. This visual feedback system makes the iterative process of inputting conversion examples and generating recipes much easier, as users can quickly assess results without intensive manual verification, thereby reducing overall user burden while maintaining high conversion accuracy
Data Source
AI summary
A method includes: repeatedly executing a first processing configured to generate, in response to input of conversion examples of values set, a conversion program for converting values of records, convert the values of the records by executing the conversion program, and display a conversion result; and executing a second processing configured to select one or more second records from the records, each of the one or more records being a record on an upper side of a first record, the first record being a record for which a conversion example is added in second or subsequent input, determine whether a value of each second record is changed in a latest conversion result from a previous conversion result, and in response that a value of the second record is changed, cause the first processing to highlight a value of the second record in display of the latest conversion result.