Parallel CEP Query Execution via Operator Segmentation

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Traditional database models are not well-suited for processing continuous event streams due to their single-threaded nature, leading to scalability issues and unnecessary data loss when errors occur, as they cannot efficiently utilize concurrent processing power and often require manual intervention to recover from faults.

Innovation Solution

A CEP query processor that splits queries into separate operators, determines concurrency constraints, and spawns multiple threads to execute parts of the query concurrently, while introducing fault handling mechanisms to allow customized responses to errors, enabling continuous query execution without halting the entire process.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If CEP queries are executed in a single-threaded manner, then state maintenance is simplified and query correctness is ensured, but processing throughput is limited and concurrent processing power is wasted

Engineering Contradiction:
Improvequery processing throughputVSAvoidconcurrent execution complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent segments a CEP query into multiple independent operators that can be executed in parallel. Each operator processes events independently, allowing concurrent execution across multiple threads while maintaining the overall query functionality through coordinated operator execution.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent transitions from single-threaded sequential execution to multi-threaded parallel execution by adding the dimension of concurrent processing. This enables multiple operators to execute simultaneously across different threads,充分利用 available processing resources.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

2Reliability

If CEP queries automatically restart after errors, then data loss is minimized and continuous processing is maintained, but incorrect events may cause repeated failures and waste processing resources

Engineering Contradiction:
Improvequery execution continuityVSAvoidprocessing resource waste
Core Design Contradiction:
ReliabilityVSLoss of energy

Solution Approach 1:

The patent implements a feedback mechanism where the system monitors query execution and automatically detects errors. Based on this feedback, the system intelligently determines whether to restart the query, preventing infinite loops from incorrect events while recovering from transient failures.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The patent enables the CEP query system to automatically handle its own errors and restarts without external intervention. The system self-diagnoses execution failures and autonomously decides on recovery actions, eliminating the need for manual administrator intervention.

Inventive Principle:
Principle #25Self-service

3Loss of energy

If manual intervention is required to recover from query errors, then processing resources are not wasted on repeated failures, but data loss occurs and processing time is lost

Engineering Contradiction:
Improveprocessing resource efficiencyVSAvoidquery recovery time
Core Design Contradiction:
Loss of energyVSLoss of time

Solution Approach 1:

The patent implements preliminary error handling mechanisms that detect and manage execution errors before they cause significant data loss. The system is pre-configured with error detection and automatic restart capabilities, enabling rapid response to failures without waiting for manual intervention.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The system performs self-diagnosis and self-recovery from execution errors without requiring external administrator intervention. This autonomous error handling eliminates both the data loss and time delay associated with manual recovery processes.

Inventive Principle:
Principle #25Self-service

Data Source

PatentEP2959408B1Executing continuous event processing (CEP) queries in parallel
Publication Date: 2019.10.23 ORACLE INT CORP
  • EP2959408B1 patent drawingFigure 1
  • EP2959408B1 patent drawingFigure 2
  • EP2959408B1 patent drawingFigure 3

AI summary

A continuous event processing (CEP) query processor determines how and when a CEP query can be processed in a concurrent manner, such that multiple threads of execution can concurrently perform at least some of the CEP query's operations concurrently with each other. According to one technique, a user can instruct a CEP query processor to attempt to execute a CEP query in a concurrent manner. The CEP query processor responsively determines whether the CEP query's execution, or parts thereof, can be made concurrent based on certain constraints that can depend on inheritance and operation type. Based on this determination, the CEP query processor can execute at least certain parts of a CEP query in parallel relative to the same event within an event stream.