Oracle Corporation
Integrating Kafka data-in-motion with data-at-rest tables

Last updated:

Abstract:

Techniques are described herein for analyzing data streams in conjunction with relational database data in a DBMS. A database dictionary defines one or more columns for an external table and a data source for said external table that comprises an external message stream. Executing a query that targets the external table includes generating one or more rows from the external table, each row corresponding to a message in the external message stream that was retrieved from the external message stream after a message stream offset.

Status:
Grant
Type:

Utility

Filling date:

4 Oct 2019

Issue date:

9 Nov 2021