Nested Data User Interface for Complex Database Selection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
User interfaces struggle to effectively present and manage complex data relationships from multiple database tables, requiring intimate knowledge of table associations, which complicates the selection and display of relevant data items.
Innovation Solution
A user interface system employing two models during design time: a user interface model for selecting data items and a communication model for tracking and updating selected data items, facilitating the generation of customized views by hiding table complexity and managing data associations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If data items from multiple database tables are presented in a user interface, then the information completeness is improved, but the interface complexity increases due to complex table associations
Solution Approach 1:
The patent segments the complex data selection process into distinct phases: (1) selecting a primary data source, (2) selecting associated data sources, and (3) selecting specific data items. This segmentation allows users to navigate complex table associations step-by-step rather than overwhelming them with all possible data items at once, thereby maintaining information completeness while reducing perceived interface complexity.
Solution Approach 2:
The patent implements a nested selection structure where selecting a primary data source reveals nested levels of associated data sources, which in turn reveal nested levels of data items. This nested doll approach allows the interface to present complex multi-table relationships in a hierarchical, manageable format where each level is only revealed when needed, reducing overall interface complexity while maintaining complete data representation.
2Measurement precision
If interface designers select data items with intimate knowledge of tables and associations, then the data selection accuracy is improved, but the ease of operation deteriorates
Solution Approach 1:
The patent introduces an intermediary mechanism that automatically manages the complex associations between data tables. The system acts as a mediator by: (1) automatically identifying and presenting relevant associated data sources when a primary source is selected, and (2) automatically managing the relationships between selected items across tables. This intermediary approach maintains data selection accuracy by ensuring proper associations while shielding users from the complexity of table relationships.
Solution Approach 2:
The system provides self-service by automatically managing data associations and relationships. When users select a primary data source, the system automatically identifies and presents relevant associated data sources and data items without requiring users to manually navigate complex table associations. This self-service mechanism maintains selection accuracy while dramatically improving ease of operation.
3Ease of operation
If customized views are generated by hiding table complexity, then the ease of operation is improved, but the loss of information increases
Solution Approach 1:
The patent implements dynamic view generation where the level of detail and information presented adapts based on user selections and needs. The interface dynamically adjusts by: (1) initially presenting a simplified view that hides table complexity, and (2) allowing users to progressively reveal more detailed information about data associations and sources. This dynamic approach maintains ease of operation while preventing information loss through on-demand detail revelation.
Data Source
AI summary
Example embodiments of a user interface system employing nested data are described. In an example embodiment, first data items of a first data source available for selection is presented via a user interface, the first data items including an association with a second data source. A first user selection of the association with the second data source is received via the user interface. In response to the first user selection, second data items of the second data source available for selection are presented via the user interface. A second user selection of a data item of the second data items is received via the user interface. In response to the second user selection, an indication of the selected data item of the second data items is presented.