CONSISTENT QUERY EXECUTION FOR BIG DATA ANALYTICS IN A HYBRID DATABASE

Patent №

US 10,691,722

Granted

2020-06-23

Filed 2017

Owner

ORACLE INTERNATIONAL CORPORATION

Lab

AI components

1

planning

Assignment

Recorded

Dataset

AIPD

2023_r1 edition

Application

15610171

Techniques are described for efficient query processing and data change propagation to a secondary database system. The secondary database system may execute queries received at a primary database system. Database changes made at the primary system are copied to the secondary system. The primary system receives a query to be executed on either the primary system or the secondary system. The primary system determines whether to send the query to the secondary system based upon whether data objects stored within the secondary system have pending changes that need to be applied to the data objects. The pending changes are stored within in-memory journals within the primary system. The primary system scans for the pending changes to the data objects and sends the pending changes to the secondary system. The secondary system then receives and applies the pending changes to the data objects within the secondary system. Upon applying the pending changes, the secondary system executes the query.

PlanningG06F 16/273G06F 16/2365G06F 16/2379G06F 16/2455

AI classification

Planning1.00
AI hardware0.21
Knowledge representation0.05
Evolutionary computation0.01
Machine learning0.00
Vision0.00
Natural language0.00
Speech0.00

Ownership

ORACLE INTERNATIONAL CORPORATION

assignment · 428540525

Assignors

GUIRGUIS, SHENODA, PASUPULETI, KANTIKIRAN, PETRIDE, SABINA, IDICULA, SAM

On an employer assignment, the assignors are typically the inventors.

© 2026 NYSGPT2525 LLC