Composite Filter Generation for Nested Visualization Query Optimization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional enterprise software systems consume excessive processing resources and time due to iterative querying of data sources when applying multiple filters across nested visualization levels, leading to inefficient data visualization.
Innovation Solution
Generating a single composite OR-based filter from multiple filters associated with the same dimension at different visualization levels, allowing for a single query to the data source instead of multiple iterative queries, thereby reducing backend calls and improving efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If iterative querying from highest to lowest-level container is used to apply multiple filters, then each filter can be applied systematically, but the number of backend queries increases exponentially with container levels and dimensions
Solution Approach 1:
The patent combines multiple nested filters from different container levels into a single composite filter expression. Instead of applying filters iteratively through multiple backend queries, the system merges all filter criteria into one unified query that retrieves all necessary data in a single backend call, then applies the composite filter client-side to generate the result set.
Solution Approach 2:
The patent segments the filtering process into two distinct phases: (1) a single backend query that retrieves raw data using a unified filter expression, and (2) client-side processing that applies the composite filter to generate the final result set. This segmentation separates data retrieval from data filtering, reducing backend load while maintaining filter completeness.
2Reliability
If multiple iterative queries are made to apply filters at each container level, then comprehensive filtering is achieved, but the time required for data visualization increases
Solution Approach 1:
The patent performs preliminary action by constructing the complete composite filter expression before executing the backend query. All filter criteria from nested containers are pre-combined into a unified filter expression using OR logic for same-dimension filters, allowing the system to retrieve all necessary data in one query and then apply the complete filter set client-side without requiring multiple iterative queries.
3Measurement precision
If nested filters on the same dimension are applied iteratively, then precise filtering is achieved, but the complexity of query management increases
Solution Approach 1:
The patent changes the logical parameter of filter combination by using OR logic to combine nested filters on the same dimension within a single composite filter expression, rather than applying them iteratively with AND logic across multiple queries. This parameter change simplifies query management while maintaining precise filtering through client-side application of the composite filter to the result set.
Data Source
AI summary
A system includes identification of dimension filters associated with a visualization, identification, from the identified dimension filters, of nested dimension filters associated with a first dimension, generation of a composite filter based on the identified nested dimension filters, transmission of a query to a data source, the query including the composite filter, reception of a result set based on the query from the data source, and display of the visualization presenting the result set on the display.