Microsoft Corporation
EFFICIENT CREATION AND/OR RESTATEMENT OF DATABASE TABLES

Abstract:

Techniques for rebuilding at least a portion of a SCD table in a database based on a set of snapshots individually containing a current value of a variable corresponding to a dimension in the table are discloses herein. In one example, a method includes grouping the snapshots in the set into multiple pairs of snapshots and concurrently generating multiple first table segments individually from a corresponding one of the multiple pairs of snapshots in the set. The method also includes grouping the generated multiple first table segments into multiple pairs of the first table segments and concurrently merging the multiple pairs of first table segments individually into a second table segment. The grouping and concurrently merging operations can be repeated until only one table segment is present.