Dynamic Table Generation via Category Extraction
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing table generation systems become overly complex and data-intensive when users select categories, leading to slow rendering and excessive data representation.
Innovation Solution
A table generation system that only adds new columns or lines with selected categories and their associated values, omitting non-selected categories, and includes features like sparklines and data filtering to reduce complexity and data volume.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If the table is enlarged by adding new columns or lines with all possible categories into which first categories may be subdivided, then the table contains complete information for all categories, but the table becomes overly complex and space-consuming
Solution Approach 1:
The patent extracts and displays only the subcategories that are actually selected by the user, removing unnecessary subcategories from the table. When a user selects a first category, only its corresponding subcategories are added to the table, rather than adding all possible subcategories for all first categories. This extraction principle resolves the contradiction by maintaining information completeness for selected categories while reducing overall table complexity.
Solution Approach 2:
The patent applies local quality by making the table structure dynamic and adaptive to user selections. Different parts of the table are populated based on specific user choices - each selected first category receives its own subcategories locally, rather than uniformly adding all subcategories everywhere. This allows the table to maintain high information quality where needed while keeping other areas simple.
2Loss of information
If the table includes all subcategories for all first categories, then the table provides comprehensive data, but the amount of data increases leading to slow table assembly
Solution Approach 1:
The system extracts and processes only the data necessary for the user's current view - specifically, subcategories corresponding to selected first categories. By extracting only relevant data subsets rather than processing the entire category hierarchy, the table can be assembled faster while still providing complete information for the selected categories.
Solution Approach 2:
The patent applies partial action by generating the table incrementally based on user selections rather than generating the complete table structure upfront. Only the necessary subcategories for selected first categories are added, performing partial table generation that is sufficient for the user's needs while avoiding the performance penalty of generating excessive data.
3Loss of information
If the table displays all categories and subcategories, then the table is comprehensive, but the graphical representation becomes complex and space-consuming
Solution Approach 1:
The patent extracts and displays only the subcategories relevant to selected first categories, removing unnecessary category entries from the visual representation. This extraction reduces the display area required while maintaining complete information for the user's selected categories, directly resolving the contradiction between comprehensiveness and display space.
Data Source
AI summary
The present invention relates to a system for generating a table comprising generating means for generating a table which contains at least a column or line depicting one or more first categories and at least a column or line depicting first values associated with said first categories and wherein the system further comprises selecting means for selecting one of said first categories by a user and adding means for enlarging the table upon selection of a category by said selecting means, said adding means being adapted to enlarge the table by adding a new column or line which comprises second categories into which said selected first category may be subdivided as well as second values associated with said second categories and wherein said new column or line does not comprise categories into which non selected first categories may be subdivided.