Dynamic Query Rewriting in Complex Event Processing

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current complex event processing (CEP) systems lack the ability to modify continuous queries during runtime, requiring users to stop and restart queries to adapt to changing preferences, which can cause downtime and resource inefficiency, and existing techniques do not effectively improve user experience by adapting query results to user preferences.

Innovation Solution

Implementing a method that allows users to dynamically modify adaptable parameters of CEP queries through a graphical user interface (GUI) during runtime, enabling query customization and execution adjustments without restarting or running parallel queries, using a system that automatically identifies and adapts parameters based on user feedback and interaction.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If users modify CEP queries by stopping and starting new queries, then query results can be adapted to user preferences, but system downtime increases and resource efficiency decreases

Engineering Contradiction:
Improvequery adaptabilityVSAvoiddowntime
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent implements dynamic query modification capability where CEP queries can be modified during runtime without stopping execution. The system allows users to adjust query parameters and adapt results to changing preferences while the query continues to execute, eliminating downtime associated with stopping and restarting queries.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent enables changing query parameters dynamically during execution. Users can modify adaptable parameters such as time windows, threshold values, and result formatting without creating entirely new queries. This parameter modification approach allows continuous operation while adapting to user preferences.

Inventive Principle:
Principle #35Parameter changes

2Adaptability or versatility

If users modify CEP queries by stopping and starting new queries, then query results can be adapted to user preferences, but additional system resources are consumed

Engineering Contradiction:
Improvequery adaptabilityVSAvoidsystem resources
Core Design Contradiction:
Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent implements a mechanism to discard modifications to queries that are not adapted to user preferences and recover resources accordingly. When users do not modify a query or when modifications are rejected, the system can terminate the modified query execution and release associated resources, preventing waste of system resources on unadapted queries.

Inventive Principle:
Principle #34Discarding and recovering

Solution Approach 2:

The dynamic modification capability allows the system to adjust query parameters in real-time without creating parallel query executions. By modifying existing queries during runtime rather than creating new ones, the system avoids duplicating resource consumption while still achieving adaptability to user preferences.

Inventive Principle:
Principle #15Dynamics

3Device complexity

If CEP queries are executed continuously without modification capability, then system simplicity is maintained, but user experience deteriorates due to inability to adapt to changing preferences

Engineering Contradiction:
Improvesystem simplicityVSAvoiduser experience
Core Design Contradiction:
Device complexityVSEase of operation

Solution Approach 1:

The patent implements self-service query modification capabilities where users can directly adjust query parameters through user-friendly interfaces without requiring deep technical knowledge. The system provides intuitive controls for modifying adaptable parameters, enabling users to adapt queries to their preferences independently without involving IT staff or requiring complex query rewriting skills.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system incorporates feedback mechanisms that monitor user interactions with query results and automatically identify adaptable parameters. By analyzing user behavior patterns and preferences, the system can suggest modifications or automatically adjust query parameters to improve user experience while maintaining relative system simplicity.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS8788484B2Systems and/or methods for user feedback driven dynamic query rewriting in complex event processing environments
Publication Date: 2014.07.22 SOFTWARE AG
  • US8788484B2 patent drawing
  • US8788484B2 patent drawing
  • US8788484B2 patent drawing

AI summary

Certain example embodiments described herein relate to techniques for user feedback driven dynamic query rewriting in complex event processing (CEP) environments. In certain example embodiments, the adjustment of already-initiated queries may be permitted during runtime in order to help continuously or substantially continuously meet a user's requirements. In certain example embodiments, parameters of a query may be adapted dynamically, e.g., without the need to redeploy it. Adaptable parameters in certain example embodiments may be identified and/or based on, for instance, an automatic determination from original query creation, user specifications, the way in which a user interacts with a user interface for visualizing the results of queries, etc.