Micro-batch Timestamp Assignment for Event Stream Processing

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Traditional database systems are inadequate for processing continuous event streams, as they lack the processing flexibility required for modern applications that generate unbounded data sets, such as sensor data and financial tickers, leading to difficulties in detecting relationships within micro-batches and creating accurate results for applications needing millisecond or nanosecond window durations.

Innovation Solution

Implementing a system that generates unique timestamps for each event in a micro-batch using algorithms like wall clock progression, evenly distributed, and sequenced top-off strategies, and introduces heartbeat events for automatic time progression, enabling event-by-event processing and improving timestamp management in micro-batching based stream processing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If traditional micro-batching is used to process event streams, then processing throughput is improved, but the ability to detect relationships within tight time windows deteriorates

Engineering Contradiction:
Improveprocessing throughputVSAvoidtimestamp precision
Core Design Contradiction:
ProductivityVSMeasurement precision

Solution Approach 1:

The patent segments the timestamp assignment process into two levels: (1) batch-level timestamp for the entire micro-batch, and (2) event-level offset timestamps for individual events within the batch. This segmentation allows the system to maintain batch processing efficiency while introducing fine-grained timestamp precision for relationship detection within tight time windows.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent adds a new dimension to timestamp representation by combining a batch-level timestamp with an event-level offset. Instead of using a single scalar timestamp, the system uses a composite timestamp structure that includes both the batch timestamp and an offset within the batch, enabling precise time window detection while maintaining batch processing throughput.

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

2Device complexity

If a single timestamp is assigned to all events in a micro-batch, then processing complexity is reduced, but the ability to identify individual event timing deteriorates

Engineering Contradiction:
Improvetimestamp management complexityVSAvoidindividual event timing information
Core Design Contradiction:
Device complexityVSLoss of information

Solution Approach 1:

The timestamp information is segmented into two components: a shared batch timestamp that applies to all events in the micro-batch, and individual offset values for each event. This segmentation reduces complexity compared to managing fully individual timestamps while preserving the ability to determine precise timing relationships between events.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent merges batch-level timestamp management with event-level offset tracking into a unified timestamp assignment mechanism. The stream processor assigns a single batch timestamp and generates offsets for all events in the batch simultaneously, combining the simplicity of batch processing with the precision of individual event timing.

Inventive Principle:
Principle #5Merging (Combining)

3Productivity

If micro-batching is implemented for stream processing, then processing efficiency is improved, but the capability to handle millisecond or nanosecond window durations deteriorates

Engineering Contradiction:
Improveprocessing efficiencyVSAvoidtime window accuracy
Core Design Contradiction:
ProductivityVSManufacturing precision

Solution Approach 1:

The patent introduces an offset dimension within the batch timestamp structure, allowing the system to represent time windows with millisecond or nanosecond precision even when processing events in micro-batches. The offset component enables fine-grained time window calculations without requiring individual event processing.

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

Solution Approach 2:

The patent changes the parameter representation from a single coarse-grained timestamp to a composite parameter including batch timestamp and offset. This parameter transformation enables the system to maintain micro-batch processing efficiency while achieving the precision required for millisecond or nanosecond time window operations.

Inventive Principle:
Principle #35Parameter changes

Data Source

PatentUS11061722B2Processing timestamps and heartbeat events for automatic time progression
Publication Date: 2021.07.13 ORACLE INT CORP
  • US11061722B2 patent drawing
  • US11061722B2 patent drawing
  • US11061722B2 patent drawing

AI summary

An event processing system for processing events in an event stream is disclosed. The system is configured for configuring a stream processor to micro-batch incoming events from a stream source. The system is also configured for generating a single timestamp for a micro-batch of the incoming events and/or receiving the micro-batch of the incoming events from the stream source. The system can also be configured for assigning the single timestamp to each event of the micro-batch and/or generating separate timestamp values for each respective event of the micro-batch. In some examples, the system can also be configured for assigning, for each respective event of the micro-batch, an individual one of the separate timestamp values.