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

Claim 7:
8. A method for loading data to a cloud database, comprising:
providing a data synchronization application on a server executing on a microprocessor;
providing a plurality of staging tables in the cloud database;
configuring a flush point 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;
uploading, using the data synchronization application, 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;
setting a semaphore when each particular staging table of the plurality of staging tables reaches the configured flush point value;
triggering, with the semaphore, a transform and merge process to merge the data from said each particular staging table into the target table using a single process; and
selecting the value of the flush point by the data synchronization application executing on the server 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.