Streaming Analytics for Dynamic Asset Targeting

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems for processing continuous data or event streams lack the necessary processing flexibility to effectively handle modern event processing needs, particularly in applications involving dynamic assets with changing positions and viewerships.

Innovation Solution

A method and system that utilize streaming analytics to determine potential target viewership by overlaying a grid of polygons on a geographic map, associating advertisements with these polygons based on viewer profiles, and dynamically updating advertisements displayed on moving assets based on their position and temporal data.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If traditional database systems with SQL queries are used to process data, then queries can be executed on finite stored data sets, but the system cannot handle continuous unbounded event streams effectively

Engineering Contradiction:
Improvecapability to handle continuous event streamsVSAvoidsystem architecture complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements dynamic query execution where SQL queries are continuously executed on streaming data rather than static datasets. The system maintains running aggregates and stateful computations that adapt to incoming events in real-time, transforming the static nature of traditional SQL into a dynamic stream processing model.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent creates a unified processing engine that handles both traditional batch queries and continuous stream queries through the same SQL interface. This multi-functional system can process finite datasets and unbounded event streams using consistent query semantics, eliminating the need for separate processing paradigms.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Adaptability or versatility

If static SQL queries are executed on finite data sets, then simple processing is achieved, but the system lacks the processing flexibility required for modern event stream applications

Engineering Contradiction:
Improveprocessing flexibilityVSAvoidquery execution efficiency
Core Design Contradiction:
Adaptability or versatilityVSProductivity

Solution Approach 1:

The patent pre-compiles and optimizes SQL queries before execution, creating execution plans that are tailored to the specific query structure. This preliminary preparation enables efficient runtime execution on streaming data without sacrificing the flexibility of complex query expressions.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent implements continuous query execution where processing operates continuously on incoming event streams rather than in discrete batch operations. The system maintains persistent state and continuously updates results as new events arrive, eliminating idle periods between processing cycles.

Inventive Principle:
Principle #20Continuity of useful action

3Adaptability or versatility

If vendors offer product suites for event stream processing, then some event processing capability is provided, but the processing flexibility required for handling today's event processing needs is still lacking

Engineering Contradiction:
Improveevent processing flexibilityVSAvoidproduct suite complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the event processing system into distinct modular components: event sources, query processing engines, aggregation functions, and output sinks. Each component has a specific responsibility and can be independently configured, allowing flexible composition of processing pipelines without monolithic complexity.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces an intermediary layer that translates between traditional SQL query semantics and stream processing operations. This mediator enables users to write familiar SQL queries while the system handles the complex transformations needed for continuous event processing, shielding users from underlying complexity.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS11657425B2Target user estimation for dynamic assets
Publication Date: 2023.05.23 ORACLE INT CORP
  • US11657425B2 patent drawing
  • US11657425B2 patent drawing
  • US11657425B2 patent drawing

AI summary

Techniques for processing event streams are provided that use streaming analytics to estimate a target user for dynamic assets. An exemplary technique includes receiving a batch of events that have position data for a potential target, determining one or more polygons that comprise the potential target based on the position data for the potential target, determining an approximate target viewership for the one or more polygons based on a profile or taxonomy of the potential target, associating an advertisement with the one or more polygons based on the approximate target viewership, receiving a continuous stream of events that have position data for a dynamic asset, determining that the one or more polygons include the dynamic asset based on the position data for the dynamic asset, obtaining the advertisement associated with the one or more polygons, and providing the advertisement to a sink for display on the dynamic asset.