Column Navigator with Overview Menu for Table Data

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Electronic devices often lack efficient mechanisms for navigating large datasets displayed in tables, requiring users to perform multiple operations to scroll or page through columns and rows, leading to user frustration and errors, especially for those with impaired motor skills or spatial visualization issues.

Innovation Solution

The implementation of a navigator system that allows rapid movement between columns and rows with minimal selection operations, maintaining visibility of leading attributes while displaying secondary attributes, using an overview menu to select and display desired columns and rows without the need for extensive scrolling or paging.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Area of stationary object

If a display shows limited columns at a time, then the display can accommodate more rows and maintain readability, but users must perform multiple scrolling operations to access columns, increasing complexity and time

Engineering Contradiction:
Improvedisplay areaVSAvoidcolumn navigation
Core Design Contradiction:
Area of stationary objectVSEase of operation

Solution Approach 1:

The display is segmented into a main display area showing limited columns and a separate overview menu area showing all columns. This segmentation allows the main display to focus on detailed view of a subset of columns while the overview menu provides a separate interface for selecting which columns to display, resolving the contradiction between display area utilization and navigation ease.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The overview menu acts as an intermediary between the user and the column selection process. Instead of requiring users to scroll through multiple pages of columns, the overview menu provides a direct selection interface where users can choose any column to display, reducing the number of operations needed and improving navigation ease.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If users scroll or page through columns multiple times, then they can access different columns of data, but they lose track of their place and must repeat operations to return to starting point

Engineering Contradiction:
Improvecolumn accessVSAvoidnavigation time
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The overview menu displays all available columns in advance, allowing users to select their desired column before actually viewing the data. This preliminary presentation of all column options eliminates the need for sequential scrolling and repeated navigation operations, reducing time loss.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system provides visual feedback by highlighting the currently displayed column in the overview menu and updating the main display accordingly. This feedback mechanism allows users to quickly understand the current state and make precise selections, reducing navigation time and preventing loss of place.

Inventive Principle:
Principle #23Feedback

3Quantity of substance

If the display shows only secondary attribute columns, then it can display more columns, but users cannot see the leading attribute column that associates data in each row

Engineering Contradiction:
Improvenumber of columns displayedVSAvoidleading attribute visibility
Core Design Contradiction:
Quantity of substanceVSLoss of information

Solution Approach 1:

The display is segmented into a fixed leading attribute column that remains visible on the left side and a variable secondary attribute columns area. This segmentation ensures that the leading attribute column is always displayed regardless of which secondary columns are selected, preventing loss of information while allowing maximum column quantity.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system merges the leading attribute column with the overview menu selection mechanism. The leading attribute column is always included in the display regardless of the selected columns from the overview menu, effectively combining the navigation function with the information display function to prevent data association loss.

Inventive Principle:
Principle #5Merging (Combining)

4Productivity

If users perform extensive scrolling or paging operations, then they can navigate through large datasets, but users with impaired motor skills or spatial visualization difficulties find it difficult to plan and execute movements

Engineering Contradiction:
Improvedata navigation efficiencyVSAvoidmotor skill requirement
Core Design Contradiction:
ProductivityVSEase of operation

Solution Approach 1:

The overview menu serves as an intermediary that translates complex navigation tasks into simple selection actions. Users with impaired motor skills or spatial visualization difficulties can easily select columns from the overview menu without needing to plan and execute multiple scrolling operations, significantly improving ease of operation.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs the complex navigation and column selection automatically based on user input. Instead of requiring users to manually scroll and page through multiple columns, the overview menu allows users to directly select desired columns, and the system handles the rest, reducing the motor skill requirements.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS8161416B2Navigator for displays
Publication Date: 2012.04.17 SAP SE
  • US8161416B2 patent drawing
  • US8161416B2 patent drawing
  • US8161416B2 patent drawing

AI summary

Various embodiments include apparatus, methods, and systems for column navigation within a view of a table or other source of two-dimensional data. Various embodiments include method comprising displaying a first column of data from a plurality of columns of data included in table and having one or more rows across each of the plurality of columns of data, displaying a second column of data from of the plurality of columns of data directly beside the first column of data so that the one or more rows in the second column of data align with the same one or more rows in the first column and displaying with the second column of data a symbol that when actuated provides an overview menu including a list of selectable columns of data included in the plurality of columns of data included in the table.