Unified Table Sorting with Primary Data Prioritization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database table management systems require excessive computing resources and time to navigate and sort data from multiple tables, often obscuring primary records within the data, making it inefficient for users to access and view high-priority information.
Innovation Solution
A method that allows simultaneous sorting of data in a table using multiple rules, where primary database objects are prioritized to remain in prominent positions, while secondary data is sorted according to a default rule, enabling efficient display and access of high-priority data without shuffling it among less important data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple tables are opened and sorted separately to view data from multiple purpose groups, then data can be organized by different sorting rules, but it requires excessive computing resources and time
Solution Approach 1:
The patent combines multiple tables representing different purpose groups into a single unified table. This table displays data from multiple purpose groups simultaneously, allowing users to view and sort data from different categories without opening separate windows or tables, thereby reducing computing resource consumption and improving data access efficiency
Solution Approach 2:
The unified table serves multiple functions by displaying data from various purpose groups in a single interface. It can simultaneously present data organized by different sorting rules and prioritize display of primary database objects across different purpose groups, eliminating the need for separate specialized tables for each purpose
2Ease of operation
If conventional sorting is applied to tables, then data can be arranged by sort rules, but primary records may be sorted along with other records making them less visible
Solution Approach 1:
The patent applies different sorting priorities to different types of data within the same table. Primary database objects are assigned a higher sorting priority and are consistently positioned in prominent locations (such as the top of the table or top of their purpose group section), while secondary data objects are sorted according to standard sorting rules. This local differentiation ensures primary records remain visible and accessible
Solution Approach 2:
The system preliminarily positions primary database objects in prominent locations before applying standard sorting to secondary data. By pre-establishing the priority positioning of primary records and then sorting secondary data around them, the system ensures that primary information remains visible and accessible while still allowing comprehensive data organization
Data Source
AI summary
A system and method adapted to facilitate efficient sorting and displaying of data in a table. An example method includes displaying a table with a first portion of data and a second portion of data; simultaneously applying a first sort rule to the first portion of data (primary database object(s)) and a second sort rule to the second portion of data (secondary database object(s)) in response to user selection of a sort option; and illustrating sorted data via the table, wherein the first sort rule is adapted to cause the first portion of data to appear in one or more predetermined locations in the table relative to the second portion of data. The second portion of data is sorted according to the second sort rule. In a more specific embodiment, primary database objects are sorted via the first sort rule and are not subject to the second sort rule. The first sort rule includes a specification that primary database objects be displayed at a predetermined location in the table, such as in an uppermost position in the table or in an upper most position in a purpose group section of the table.