Inter-table parallel refresh maximizer

• US 10,678,811 B2
• Filed: 04/17/2019
• Issued: 06/09/2020
• Est. Priority Date: 09/30/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kedia, Pravin K., Kumar, Nirmal, Sarkar, Dev K., Spyker, James D.
• Primary Examiner(s): Nguyen, Phong H
• Application Number:
  US16/386,343
• Publication Number:
  US 20190243843A1
• Time in Patent Office: 419 Days
• Field of Search: 707610, 707634, 707803
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

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.

Claims

1. A method for inter-table parallel refresh in a database management system (DBMS), the method comprising:

receiving, by one or more computer processors, DBMS source database and DBMS target database wherein the DBMS source database comprise source parent datasets and related source child datasets;

determining, by one or more computer processors, a collection of the source parent datasets and the related source child datasets for the inter-table refresh, wherein determining the related source child datasets is based on matching a source child dataset key field identifier with at least one of a source parent dataset key identifier or a source parent dataset foreign key identifiers;

creating, by one or more computer processors, a collection of parent refresh segments and a related collection of child refresh segments based on the collection of the source parent datasets and the related source child datasets, wherein each parent refresh segment of the collection of parent refresh segments comprises a group of rows subdividing the source parent datasets, and wherein each child refresh segment of the related collection of child refresh segments comprises a related group of rows subdividing the source child datasets;

creating, by one or more computer processors, a collection of parent refresh batches and a collection of child refresh batches based on the collection of parent refresh segments and the collection of child refresh segments respectively;

outputting, by one or more computer processors, an inter-table refresh batch schedule based on the collection of the parent refresh batches and the collection of the child refresh batches, wherein the collection of the parent refresh batches and the collection of the child refresh batches operate concurrently and a current child refresh batch follows a completion of a respective current parent refresh batch;

identifying, by one or more computer processors, a sub-child wherein the sub-child is based on a first source child dataset being related to a second source child dataset wherein a first source child dataset foreign key identifier matches a second source child dataset key identifier;

responsive to identifying the sub-child, marking, by one or more computer processors, the first source child dataset as a source parent dataset and marking the sub-child as a source child dataset for recursive processing of the inter-table refresh until the found sub-child is segmented; and

executing, by one or more computer processors, the inter-table refresh batch schedule.