Object Model Visualization for Database Table Data Sources

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data visualization applications face challenges in generating appropriate visualizations from complex or multiple data sources, as users struggle to determine the type of visualization needed based on their selections, leading to unclear or ineffective data representation.

Innovation Solution

The method involves constructing an object model of the data source, which stores relationships and allows users to build visualizations by selecting data fields, recommending additional fields, and limiting actions to prevent unusable combinations, using a graphical user interface that displays data sources, object models, and data grids to facilitate drag-and-drop analytics and relationship building.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If users directly select data fields from complex or multiple data sources, then the user interface remains simple, but it becomes unclear what type of visualization to generate

Engineering Contradiction:
Improveuser interface simplicityVSAvoidvisualization type guidance
Core Design Contradiction:
Ease of operationVSLoss of information

Solution Approach 1:

The system performs preliminary action by automatically generating an object model that represents the structure and relationships of data sources before the user creates visualizations. This pre-established model provides guidance on appropriate visualization types based on the selected data fields, eliminating the need for users to manually determine visualization appropriateness while maintaining interface simplicity.

Inventive Principle:
Principle #10Preliminary action

2Adaptability or versatility

If the system provides full freedom in field selection, then user flexibility increases, but unusable combinations may be created

Engineering Contradiction:
Improvefield selection flexibilityVSAvoidvisualization usability
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The system implements feedback by using the object model to evaluate user-selected data fields and provide guidance on valid visualization types. The object model continuously assesses the selected fields against known relationships and constraints, feedbacking appropriate visualization options to the user, thereby maintaining flexibility while preventing unusable combinations.

Inventive Principle:
Principle #23Feedback

3Loss of information

If an object model is constructed to organize data relationships, then visualization guidance improves, but system complexity increases

Engineering Contradiction:
Improvedata relationship structureVSAvoidsystem architecture
Core Design Contradiction:
Loss of informationVSDevice complexity

Solution Approach 1:

The system introduces an object model as an intermediary layer between the raw data sources and the visualization generation process. This intermediary structure captures and organizes data relationships in a manageable format, allowing the system to provide guidance without requiring complex direct analysis of underlying data sources, thus balancing information preservation with system manageability.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS12189663B2Systems and methods for visualizing object models of database tables
Publication Date: 2025.01.07 TABLEAU SOFTWARE INC
  • US12189663B2 patent drawing
  • US12189663B2 patent drawing
  • US12189663B2 patent drawing

AI summary

A method visualizes object models for data sources. The device displays, in an object model visualization region, a first visualization of a tree of data object icons, each data object icon representing a logical combination of one or more tables. The device also displays recommendations for one or more data sources to add objects to the tree. While displaying the first visualization in the object model visualization region, the device detects a first input on a first data object icon of the tree of data object icons. In response to detecting the first input on the first data object icon, the device displays a second visualization of the tree of the data object icons in a first portion of the object model visualization region and displays a third visualization of information related to the first data object icon in a second portion of the object model visualization region.