Declarative Visualization Queries for Real-Time Data Exploration

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing systems do not provide real-time business analytics for large volumes of data, limiting businesses' ability to make informed decisions through live data rendering and flexible data analysis.

Innovation Solution

A platform for ultra-fast, ad-hoc data exploration and faceted navigation on integrated, heterogeneous data sets using declarative specification of visualization queries, allowing for live data rendering on a live dashboard with animated informational morphing replay and flexible display options.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If real-time data analysis is implemented for large volumes of data, then business decision-making capability is improved, but system processing speed and performance deteriorate

Engineering Contradiction:
Improvedata analysis capabilityVSAvoidsystem processing speed
Core Design Contradiction:
Loss of informationVSSpeed

Solution Approach 1:

The patent segments the data analysis process into multiple independent components: faceted navigation filters, visualization queries, and result rendering. Each facet (e.g., date, category, region) operates as an independent filter that can be applied and removed without reprocessing the entire dataset, enabling real-time analysis of large volumes of data while maintaining system responsiveness.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system performs preliminary actions by pre-computing and storing aggregated data at multiple levels of granularity. When a user applies faceted filters, the system retrieves pre-computed results rather than recalculating from raw data, significantly reducing processing time and enabling real-time interactive analysis of large datasets.

Inventive Principle:
Principle #10Preliminary action

2Loss of time

If live data rendering is provided on dashboard, then data presentation timeliness is improved, but system resource consumption increases

Engineering Contradiction:
Improvedata presentation timelinessVSAvoidsystem resource consumption
Core Design Contradiction:
Loss of timeVSUse of energy by moving object

Solution Approach 1:

The system applies local quality by rendering only the specific data portions that match the current faceted filter criteria, rather than rendering the entire dataset. When users navigate through facets, the system updates only the relevant visualization segments, reducing computational resource consumption while maintaining live data presentation timeliness.

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The system creates simplified copies of data at aggregated levels for display purposes. Instead of rendering raw detailed data, the system generates condensed visual representations that capture essential patterns and trends, reducing processing requirements while delivering timely insights for business decision-making.

Inventive Principle:
Principle #26Copying

3Adaptability or versatility

If flexible display options and animated morphing are added, then user interaction and visualization quality are improved, but system complexity increases

Engineering Contradiction:
Improvevisualization flexibilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system implements dynamic visualization where charts and graphs can morph between different types and configurations based on user interaction and data characteristics. The animated transitions between visualization states provide intuitive feedback while the underlying system manages complexity through standardized transformation routines that reuse existing rendering engines rather than implementing separate complex systems for each visualization type.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS11954109B2Declarative specification of visualization queries
Publication Date: 2024.04.09 SALESFORCE INC
  • US11954109B2 patent drawing
  • US11954109B2 patent drawing
  • US11954109B2 patent drawing

AI summary

The technology disclosed relates to a platform for ultra-fast, ad-hoc data exploration and faceted navigation on integrated, heterogeneous data sets. The disclosed method of declarative specification of visualization queries, display formats and bindings represents queries, widgets and bindings combined on a dashboard in real time, with flexible display options for analyzing data and conveying analysis results.