RECREATING AN OLTP TABLE AND REAPPLYING DATABASE TRANSACTIONS FOR REAL-TIME ANALYTICS
Patent №
US 11,625,381
Granted
2023-04-11
Filed 2021
Owner
ORACLE INTERNATIONAL CORPORATION
Lab
—
AI components
2
planning · hardware
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
17238967
Techniques for processing data streaming from one or more event sources in order to recreate a database table with database transactions for real-time analytics. An exemplary technique includes receiving a stream of events comprising change data for a table attribute, populating an in-memory table with the change data based on a token associated with an operation type and a mapping of a first attribute and a second attribute to a key attribute of the in-memory table, executing a continuous query on the change data for the key attribute of the in-memory table to generate events comprising data for a third attribute, and outputting the events having an output shape comprising the third attribute, where the events include the data for the third attribute.
AI classification
Ownership
ORACLE INTERNATIONAL CORPORATION
assignment · 560240339
Assignors
BISHNOI, SANDEEP, THUKKARAM, PRABHU, SHMELEVA, IULIIA, MARKOVSKII, DMITRII, BYCHKOV, VITALY VITALIEVICH, GEISZTER, GYORGY
On an employer assignment, the assignors are typically the inventors.