US 12,169,501 B2
Optimizing incremental loading of warehouse data
Justin Hyde, Oakland, CA (US); and Jeff Titmas, Berkshire (GB)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Nov. 2, 2023, as Appl. No. 18/386,509.
Application 18/386,509 is a continuation of application No. 17/314,960, filed on May 7, 2021, granted, now 11,847,131.
Application 17/314,960 is a continuation of application No. 15/156,992, filed on May 17, 2016, granted, now 11,036,752, issued on Jun. 15, 2021.
Claims priority of provisional application 62/188,804, filed on Jul. 6, 2015.
Prior Publication US 2024/0061855 A1, Feb. 22, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/20 (2019.01); G06F 16/21 (2019.01); G06F 16/23 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 16/211 (2019.01); G06F 16/2365 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
switching, at runtime by a computing system, a source of data to be incrementally loaded into a data warehouse from a server of a plurality of sources to a local data store of the plurality of data sources;
determining, in advance of incrementally loading the data by the computing system, which partitions of a plurality of partitions are to be affected by the data to be incrementally loaded into the data warehouse based at least in part on analyzing an attribute of the data stored in one or more staging tables by at least determining, in advance of incrementally loading the data, a target partitioning strategy;
selectively disabling, by the computing system, the one or more indexes on each affected partition of the plurality of partitions in order to load the data into the data warehouse by at least applying the target partitioning strategy to disable an index of a data partition while loading a record into a target table; and
re-enabling, by the computing system, the one or more indexes on each affected partition of the plurality of partitions after the data is loaded into the data warehouse.