Automatic Data Layout Insertion via Cardinality Analysis

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data presentation systems often result in illogical default layouts when optimized for query actions or restricted query capabilities when optimized for layout actions, making it difficult to efficiently add new information to existing data layouts without manual correction.

Innovation Solution

A computer system determines an optimal data insertion point based on relative cardinalities and defined hierarchies between data objects, allowing for automatic insertion of additional information into existing data layouts, optimizing both data presentation and query capabilities.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If data presentation is optimized for query actions, then query capabilities are improved, but layout logic deteriorates (illogical default layouts)

Engineering Contradiction:
Improvequery capabilitiesVSAvoidlayout logic
Core Design Contradiction:
Adaptability or versatilityVSEase of operation

Solution Approach 1:

The system dynamically adjusts the data layout based on the type of action being performed. When a query action is detected, the layout is optimized for query capabilities; when a layout action is detected, the layout is optimized for logical presentation. This dynamic adaptation resolves the contradiction by allowing the system to have both strong query capabilities and logical layouts, depending on the current operational context.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The system performs partial optimization by detecting the user's intent (query vs. layout action) and applying only the necessary optimization for that specific action type. This avoids the excessive action of optimizing for both purposes simultaneously, which would create complexity, while still achieving the desired outcome of having appropriate layout logic for the current action.

Inventive Principle:
Principle #16Partial or excessive action

2Ease of operation

If data presentation is optimized for layout actions, then layout logic is improved, but query capabilities deteriorate (restricted query capabilities)

Engineering Contradiction:
Improvelayout logicVSAvoidquery capabilities
Core Design Contradiction:
Ease of operationVSAdaptability or versatility

Solution Approach 1:

The system dynamically switches between layout-optimized and query-optimized modes based on detected user actions. When layout actions are detected, the system applies layout optimization while preserving query capabilities. When query actions are detected, it switches to query optimization. This dynamic behavior resolves the contradiction by allowing both layout logic and query capabilities to be maintained at appropriate levels depending on context.

Inventive Principle:
Principle #15Dynamics

3Ease of operation

If manual correction is applied to fix illogical layouts, then layout logic is improved, but user time and effort increase

Engineering Contradiction:
Improvelayout logicVSAvoiduser time and effort
Core Design Contradiction:
Ease of operationVSLoss of time

Solution Approach 1:

The system performs automatic layout correction by detecting user actions and dynamically adjusting the data layout without requiring manual user intervention. When the system detects a query action, it automatically optimizes the layout for query capabilities; when it detects a layout action, it optimizes for logical presentation. This self-service approach resolves the contradiction by maintaining logical layouts while eliminating the time and effort users would otherwise need to spend on manual corrections.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary optimization by proactively adjusting the layout based on detected user actions before the user needs to manually correct it. By anticipating the user's needs and automatically adjusting the layout in advance, the system eliminates the need for subsequent manual correction, thereby resolving the contradiction between layout logic and user time/effort.

Inventive Principle:
Principle #10Preliminary action

4Ease of operation

If automatic layout adjustment is implemented, then layout logic is improved, but system complexity increases

Engineering Contradiction:
Improvelayout logicVSAvoidsystem complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The system implements a universal action detection mechanism that can identify multiple types of user actions (query actions, layout actions) using a single integrated detection framework. This multi-functional approach allows the system to handle different action types without requiring separate complex detection systems for each, thereby resolving the contradiction between automatic layout adjustment and system complexity by achieving versatility through a unified, efficient mechanism.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS8819069B2Automatic layout derivation and implementation
Publication Date: 2014.08.26 MICROSOFT TECHNOLOGY LICENSING LLC
  • US8819069B2 patent drawing
  • US8819069B2 patent drawing
  • US8819069B2 patent drawing

AI summary

Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.