Inter-table parallel refresh maximizer

Abstract

An approach for inter-table parallel refresh in a database management system (DBMS). An inter-table refresher receives DBMS source and target databases comprising source parent and related source child datasets. The inter-table refresher determines a collection of the source parent and the related source child datasets and creates a collection of parent and child refresh segments based on the collection of the source parent and child datasets. The inter-table refresher creates a collection of parent and child refresh batches based on the collection of parent and child refresh segments respectively and outputs an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches where the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows the completion of a respective current parent refresh batch.

Description

BACKGROUND OF THE INVENTION[0001]The present invention relates generally to Database Management System (DBMS) replication and more particularly, to refreshing datasets between DBMS sources and targets.[0002]In high availability computing environments, data replication is an important element to ensure continuous data availability, minimize / avoid downtime and / or distribute workload of database management systems. Dataset refreshes, as part of data replication function, can also be used to maintain multiple copies of database for database management and administration needs. A replicated database can be used the event of a data failure / loss and / or to off-load read-only transactions toward a replica DBMS, however activities to refresh datasets can become complex when a refresh process is executed while a database is actively operating (e.g., insertion, deletion and changing data records). The process of copying data records for a refresh can compete for CPU, interfere with referential ...

AI Technical Summary

Benefits of technology

The patent describes a method for refreshing data in a database system. The method involves creating a collection of parent and child datasets, and then creating a collection of refresh segments based on these datasets. These refresh segments are then used to create a schedule for refreshing the data. The method allows for concurrent refreshing of parent and child datasets, and also allows for recursive processing of data. The technical effect of this method is improved efficiency and speed in refreshing data in a database system.

Problems solved by technology

A replicated database can be used the event of a data failure / loss and / or to off-load read-only transactions toward a replica DBMS, however activities to refresh datasets can become complex when a refresh process is executed while a database is actively operating (e.g., insertion, deletion and changing data records).

The process of copying data records for a refresh can compete for CPU, interfere with referential integrity rules and cause table locking due to blocked and / or waiting child table processing.

A time-consuming refresh operation can prevent record access availability and adversely affect database availability to users / transactions in actively operating systems.

Images