Patent ID: 11966410
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A system for loading data to a cloud database, the system comprising:
a microprocessor;
a plurality of staging tables in the cloud database;
a flush point configured for the plurality of staging tables, wherein a value of the flush point determines when to flush the data in the plurality of staging tables to a target table in the cloud database;
a data synchronization application on a server executing on the microprocessor, wherein the data synchronization application uploads data from an associated data source in a plurality of parallel streams to the plurality of staging tables in the cloud database, each of the plurality of streams corresponding to one of the plurality of staging tables; and
a semaphore that is set when each particular staging table of the plurality of staging tables reaches the configured flush point value, wherein the semaphore being set triggers a transform and merge process to merge the data from said each particular staging table into the target table by invoking a single transform and merge process in turn, wherein the value of the flush point is selected by the system for different invocations of the transform and merge process to provide adjustable size control of the data that is staged in each particular staging table to be transformed and merged into the target table.