Query Engine Merging Heterogeneous Widget Filters
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Global filtering across heterogeneous datasets in dashboard management systems is complex due to the need for unified real-time data presentation from diverse sources, and existing solutions fail to effectively merge and prioritize filters across multiple widgets.
Innovation Solution
A method involving a query engine that identifies, merges, and prioritizes filters for widgets across computing devices, determining relevance and compatibility to create a unified filter template applicable to multiple widgets, regardless of data sources, using a system comprising a computing device, server, and databases connected via a network.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If filters are merged across multiple widgets with heterogeneous data sources, then unified real-time data presentation is achieved, but filter compatibility and relevance determination become complex
Solution Approach 1:
A query engine is introduced as an intermediary component that receives filters from multiple widgets, determines their relevance and compatibility, and merges them into a unified filter template. This mediator handles the complexity of filter integration across heterogeneous data sources, allowing unified real-time data presentation without increasing the complexity of individual widgets.
Solution Approach 2:
The filter merging process is segmented into distinct steps: identifying filters across widgets, determining relevance, assessing compatibility, and generating a merged filter template. This segmentation allows the complex task of filter integration to be broken down into manageable operations performed sequentially by the query engine.
2Quantity of substance
If real-time data from diverse sources is aggregated, then comprehensive dashboard information is obtained, but data processing time and computational resources increase
Solution Approach 1:
The query engine performs preliminary actions by pre-identifying filters and determining their relevance and compatibility before actual data aggregation occurs. This preliminary processing of filter templates allows the system to prepare filtering logic in advance, reducing processing time during real-time data aggregation from diverse sources.
Solution Approach 2:
Multiple filters from different widgets are merged into a single unified filter template that can be applied across all heterogeneous data sources simultaneously. This merging approach consolidates processing operations rather than handling each filter separately, thereby reducing overall computational resources and processing time while maintaining comprehensive dashboard information.
Data Source
AI summary
Aspects of the present invention disclose a method, computer program product, and system for generating global widget filters. The method includes identifying, by one or more computer processors, one or more widgets on a computing device. The method further includes identifying, by one or more computer processors, a new filter for the one or more widgets on the computing device. The method further includes identify, by one or more computer processes, one or more existing filters for the one or more widgets. The method further includes determine, by one or more computer processors, if the new filter is relevant to the one or more widgets. The method further includes in response to determining if the new filter is relevant to the one or more widgets, generating, by one or more computer processors, a merged filter for the relevant one or more widgets.