Intermediate Window Results in Streaming Data Processing

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Database systems are not well-suited for real-time processing and analyzing large amounts of streaming data efficiently, as they struggle to store, index, and analyze data in real-time.

Innovation Solution

A stream computing method that allows intermediate results to be sent before the termination of a stream operator's window, enabling efficient processing and transmission of data through a plurality of stream operators, which accumulate and process data streams using windowing conditions to manage tuple processing and communication.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If database systems store and index data before querying, then data analysis accuracy is improved, but real-time processing speed deteriorates

Engineering Contradiction:
Improvedata analysis accuracyVSAvoidreal-time processing speed
Core Design Contradiction:
Measurement precisionVSSpeed

Solution Approach 1:

The patent segments the window processing into multiple intermediate results that can be sent at different stages. Instead of waiting for the complete window to terminate before sending any results, the system divides the processing into segments that can be transmitted incrementally, enabling both accurate analysis and faster response times.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent performs preliminary actions by sending intermediate results before the window terminates. Downstream operators can perform preliminary processing on these intermediate results while the current window is still being processed, preparing for subsequent operations and reducing overall processing time.

Inventive Principle:
Principle #10Preliminary action

2Reliability

If stream operators wait for window termination before sending results, then data completeness is improved, but communication bandwidth utilization deteriorates

Engineering Contradiction:
Improvedata completenessVSAvoidcommunication bandwidth utilization
Core Design Contradiction:
ReliabilityVSLoss of energy

Solution Approach 1:

The patent enables continuous transmission of useful intermediate results throughout the window processing period rather than having a single transmission event at the end. This continuous action keeps the communication channel utilized throughout the processing period, improving bandwidth efficiency while maintaining data completeness through the incremental result set.

Inventive Principle:
Principle #20Continuity of useful action

Solution Approach 2:

By sending intermediate results before window termination, the patent enables downstream operators to perform preliminary processing actions earlier. This reduces the need for reprocessing the same data later and improves overall system efficiency by keeping communication channels actively utilized.

Inventive Principle:
Principle #10Preliminary action

3Productivity

If intermediate results are sent before window termination, then processing speed is improved, but data completeness may deteriorate

Engineering Contradiction:
Improveprocessing speedVSAvoiddata completeness
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The patent segments the complete result set into multiple intermediate results transmitted at different stages. Each intermediate result represents a segment of the processing progress, ensuring that data completeness is maintained in the sense that all intermediate states are captured, even if the final complete result is not yet available.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system implements feedback mechanisms where downstream operators can request specific intermediate results based on their processing needs. This feedback loop ensures that the most relevant and complete data is retrieved at the appropriate times, balancing processing speed with data completeness requirements.

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS9922091B2Intermediate window results in a streaming environment
Publication Date: 2018.03.20 INTERNATIONAL BUSINESS MACHINE CORPORATION
  • US9922091B2 patent drawing
  • US9922091B2 patent drawing
  • US9922091B2 patent drawing

AI summary

A stream computing application may receive a stream of tuples to be processed by a plurality of stream operators. A first stream operator may receive a data stream, and the first stream operator may be configured to accumulate the data stream according to a window before performing one or more operations and transmitting tuples to a second stream operator. The second stream operator may request that the first stream operator send out tuples before the first stream operator's window has terminated. In response, the first stream operator may perform its operations on the tuples that it had accumulated before the request came in and then transmit a group of tuples with the intermediate results to the second stream operator.