CPC G06F 16/254 (2019.01) [G06F 16/211 (2019.01); G06F 16/2365 (2019.01)] | 20 Claims |
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.
|