Data Table Integration Device Using Uniqueness Detection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data table integration methods are inefficient in reducing processing loads during the generation of integrative data tables.
Innovation Solution
An integration device and method that determines uniqueness and position of data elements in two data tables, sorting them in ascending order, and identifying integration-target rows to generate an integrative data table by comparing and matching data elements, thereby reducing processing loads.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If existing data table integration methods are used, then integration functionality is provided, but the amount of processing is large and efficiency is low
Solution Approach 1:
The patent applies preliminary action by performing uniqueness determination and ascending sorting on data elements before the actual integration process. The position determination means calculates lower-limit positions in advance based on sorted data, allowing the integration means to efficiently identify integration-target rows without exhaustive comparisons during the integration phase. This preprocessing approach significantly reduces the computational burden during the actual integration operation.
2Measurement precision
If comprehensive comparison of data elements is performed, then accurate integration-target rows are identified, but the amount of processing increases
Solution Approach 1:
The patent segments the integration process into distinct functional stages: uniqueness determination, ascending sorting, position determination, and integration execution. Each stage handles a specific aspect of the problem - uniqueness determination identifies unique data elements, sorting organizes them systematically, position determination calculates insertion points, and integration executes the actual merging. This segmentation allows each component to be optimized independently while maintaining overall accuracy.
Solution Approach 2:
By performing uniqueness determination and sorting before integration, the patent reduces the search space for matching rows. The position determination means pre-calculates where rows from the second data table should be inserted based on sorted values from the first data table, eliminating the need for exhaustive pairwise comparisons and reducing processing complexity while maintaining accurate matching.
Data Source
AI summary
An integration device is configured to integrate two data tables each having at least one row of data elements having comparability in magnitude as a first data table and a second data table. Uniqueness is determined with respect to each of data elements of the first data table. Upon finding uniqueness, the integration device determines the lower-limit position, at which a row of the second data table can be added to the lowermost row of the first data table after ascending sorting, in conformity with an ascending order of sorting. The integration device determines integration-target rows when the data element of the row of the second data table matches the data element of the next row to the lower-limit position of the first data table after ascending sorting, thus generating an integrative data table to integrate integration-target rows with the first data table and the second data table.