Invention Grant
- Patent Title: Inter-table parallel refresh maximizer
-
Application No.: US16386343Application Date: 2019-04-17
-
Publication No.: US10678811B2Publication Date: 2020-06-09
- Inventor: Pravin K. Kedia , Nirmal Kumar , Dev K. Sarkar , James D. Spyker
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Andrew K. Aubert
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/25

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.
Public/Granted literature
- US20190243843A1 INTER-TABLE PARALLEL REFRESH MAXIMIZER Public/Granted day:2019-08-08
Information query