Multi-dimensional Database Visualization Navigation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing multi-dimensional databases are user-driven and lack effective navigation tools, making it cumbersome and inefficient for users to drill down or up through data layers, especially as data volumes increase, leading to complex navigation challenges.
Innovation Solution
A graphical user interface is provided that allows users to select cells in a crosstab visualization, automatically filtering and updating the display to show associated dimensions, enabling 'Pin & Pivot' navigation for quick focus on detailed data, using a computer-readable storage medium with executable instructions to manage and visualize multi-dimensional databases.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If manual navigation methods are used in multi-dimensional databases, then users can access data, but navigation becomes cumbersome and time-consuming as data volumes increase
Solution Approach 1:
The system automatically determines and displays relevant dimensions and hierarchies based on the selected cell, eliminating the need for users to manually configure navigation parameters. The database self-adapts to user intent by analyzing the selected data point and autonomously generating the appropriate drill-down path and display parameters.
Solution Approach 2:
The patent replaces manual mechanical navigation operations with an automated computational system. Instead of users manually selecting dimensions, hierarchies, and drill-down paths, the system uses automated algorithms to determine navigation parameters based on the selected cell, substituting human cognitive and manual operations with computational processing.
2Ease of operation
If comprehensive navigation options are provided, then users can access detailed data, but the interface complexity increases
Solution Approach 1:
The interface automatically configures navigation parameters based on the selected cell, eliminating the need for users to manually select dimensions, hierarchies, and other complex parameters. The system serves itself by autonomously determining the appropriate view and navigation path.
Solution Approach 2:
The patent extracts and displays only the most relevant dimensions and hierarchies based on the selected cell, removing unnecessary interface elements and complexity. Instead of presenting all possible navigation options, the system extracts and presents only what is relevant to the current data context.
3Speed
If automatic dimension determination is implemented, then navigation speed improves, but system complexity increases
Solution Approach 1:
The database system autonomously determines navigation parameters by analyzing the selected cell and automatically generating the appropriate drill-down path, dimension set, and hierarchy configuration without requiring manual user input or complex configuration management.
Solution Approach 2:
The system pre-configures navigation parameters and dimension hierarchies based on the selected cell before the user actually navigates. By determining the appropriate view and path in advance, the system eliminates navigation delays and provides immediate access to detailed data.
Data Source
AI summary
A computer readable storage medium comprises executable instructions to provide a Graphical User Interface for displaying visualizations of a multi-dimensional database. An action is received within a visualization of a table of the multi-dimensional database, the action performed by a user when selecting a cell of the table. A slice in the visualization is populated in response to the action. The visualization is filtered to drill down on dimensions associated with the cell.