Query Pattern Repository for Automated Visualization Generation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional reporting tools require expertise and creativity to determine appropriate queries and generate visualizations, making it difficult for users to display additional related result sets that may be of interest, as they lack the necessary knowledge to formulate effective queries.
Innovation Solution
The system architecture includes a metadata-driven approach that stores query sets and patterns, allowing users to input queries with dimensions and measures, and automatically generates visualizations based on stored metadata, enabling the association of queries with patterns and the display of related results through a user-friendly interface.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If conventional reporting tools are used, then users can access and display data in useful formats, but users require expertise and creativity to determine appropriate queries and generate visualizations of additional related result sets
Solution Approach 1:
The patent introduces an intermediary system consisting of a query pattern repository and automated query generation mechanism that mediates between the user's simple query and the complex task of generating related visualizations. The system automatically identifies relevant query patterns, generates appropriate queries, and creates visualizations without requiring user expertise in query formulation or visualization selection.
Solution Approach 2:
The system enables self-service by automatically performing tasks that previously required user expertise. The automated query generation and visualization creation mechanisms allow the system to serve itself by identifying relevant data relationships and generating appropriate visual representations without human intervention beyond the initial query input.
2Loss of information
If users manually formulate queries and generate visualizations, then they can access specific data views, but the process requires time and technical knowledge that users may not possess
Solution Approach 1:
The system performs preliminary action by pre-storing query patterns and relationships in a repository during system initialization or offline processing. This allows the system to quickly retrieve and apply pre-analyzed data relationships when users submit queries, eliminating the need for users to manually formulate complex queries and reducing the time required to access relevant data.
3Ease of operation
If the system automatically generates related queries and visualizations, then user interaction is enhanced and data accessibility is improved, but the system complexity increases
Solution Approach 1:
The patent segments the complex task of query generation and visualization creation into distinct modular components: a query pattern repository for storing predefined patterns, a pattern matching module for identifying relevant patterns, a query generation module for creating queries based on patterns, and a visualization generation module for creating visual representations. This segmentation manages system complexity by organizing functions into independent, reusable modules.
Data Source
AI summary
A system includes reception of a first query, the first query comprising at least one of one or more dimensions and one or more measures, identification, in response to reception of the first query, of a first stored query set associated with the first query, the first stored query set comprising a plurality of queries, determination, in response to identification of the first stored query set, of a first plurality of result sets, each of the first plurality of result sets comprising a respective result set of the first query and each query of the plurality of queries, and presentation of a visualization of each of the first plurality of result sets.