Cross-Pivoted Data Visualization via 3D Coordinate Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data visualization tools require costly and unreliable methods to flatten cross-pivoted data for computers to generate visual representations, as they prefer data in a flat format, whereas humans find cross-pivoted data more comprehensible in table format.
Innovation Solution
Converting non-numerical data in cross-pivoted tables into numerical values using ASCII values or assigning distinct numerical values, allowing visualization without un-pivoting or flattening, and rendering as three-dimensional graphs or charts.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Extent of automation
If cross-pivoted data is flattened to enable computer visualization, then visualization capability is improved, but data comprehension for humans deteriorates
Solution Approach 1:
The patent introduces a third dimension (visual representation dimension) to accommodate both cross-pivoted and flattened data formats simultaneously. By mapping cross-pivoted data points to three-dimensional coordinates where one axis represents the row dimension, another represents the column dimension, and the third represents the value, the system enables computer visualization without requiring data flattening, thus preserving human comprehension while achieving machine processing capability.
2Extent of automation
If traditional flattening tools are used to prepare cross-pivoted data, then data visualization is enabled, but cost and reliability worsen
Solution Approach 1:
The patent implements self-service by enabling the visualization system to directly process cross-pivoted data through automated coordinate transformation. The system automatically maps cross-pivoted data structures to three-dimensional visual representations without requiring external flattening tools, thereby eliminating the reliability issues and costs associated with traditional flattening processes while maintaining automated visualization capability.
3Ease of operation
If cross-pivoted data is kept in table format for human comprehension, then ease of understanding is improved, but computer processing capability deteriorates
Solution Approach 1:
The patent introduces an intermediary coordinate transformation process that bridges cross-pivoted table format and computer visualization requirements. This intermediary layer automatically converts cross-pivoted data coordinates into three-dimensional visual coordinates, allowing the system to maintain cross-pivoted data in human-comprehensible table format while simultaneously enabling computer processing and visualization through the coordinate mapping mechanism.
Data Source
AI summary
Various techniques for visualizing cross-pivoted tables are disclosed herein. In one embodiment, a method includes determining if a first dimension and a second dimension of a cross-pivoted table contain non-numerical values, the cross-pivoted table having a plurality of data points each dependent upon a first value in the first dimension and a second value in the second dimension. In response to determining that the first dimension and the second dimension contain non-numerical first and second values, the non-numerical first and second values can be converted to corresponding numerical first and second values. The method can then include plotting, on a display, a visual representation of the plurality of data points of the cross-pivoted table using the numerical first and second numerical values as first and second axis, respectively.