Database fragment cloning and management
A device-readable storage media contains a computer program comprising device-executable instructions that, when executed by a processor, cause the processor to identify a primary cloned fragment associated with a database object; identify a secondary cloned fragment corresponding to the primary clo...
Gespeichert in:
Hauptverfasser: | , , , , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | A device-readable storage media contains a computer program comprising device-executable instructions that, when executed by a processor, cause the processor to identify a primary cloned fragment associated with a database object; identify a secondary cloned fragment corresponding to the primary cloned fragment with the secondary cloned fragment being stale relative to the primary cloned fragment and refresh the stale secondary cloned fragment with data in the primary cloned fragment by performing a database operation. The primary cloned fragment has a first plurality of records and a first plurality of update identifiers and each of the first plurality of update identifiers is a member of one of the first plurality of records. The secondary cloned fragment has a second plurality of records and a second plurality of update identifiers. Each of the second plurality of update identifiers is a member of one of the second plurality of records. The refreshing of the stale secondary cloned fragment with data in the primary cloned fragment further comprises identifying a first update identifier of a first record in the first plurality of records included in the primary cloned fragment; identifying a second update identifier of a second record in the second plurality of records in the stale secondary cloned fragment, the second record corresponding to the first record; and determining whether the first record and second record with identical cloned record identifiers are consistent based, at least in part, on whether the first update identifier and the second update identifier are equal. The database operation for refreshing the stale secondary cloned fragment includes batches of operations that incrementally refresh the stale secondary cloned fragment by identifying a collection of records that are inconsistent; determining a complete set of database operations that will modify each record in the collection of records; determining a batch size that specifies a number of records in the stale secondary cloned fragment that are updated with each batch; and incrementally refreshing the stale secondary cloned fragment by committing a plurality of transactions with each transaction affects the number of records specified by the batch size. A device-readable storage media contains a computer program comprising device-executable instructions that, when executed by a processor, cause the processor to divide a database table by automatically generating at least two fragmen |
---|