Enterprise data movement system and method which performs data load and changed data propagation operations
First Claim
1. A method for performing data load and changed data propagation operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database and a target database, wherein the enterprise computing system also includes a changed data log for storing changed data of the source database, the method comprising:
- initiating a load process to load data onto the target database;
determining the status of an apply process of a changed data propagation task;
providing information to the apply process regarding the load process;
the apply process suspending apply processing in response to said providing if the apply process is active;
the load process operating to load data into at least a portion of the target database;
updating control information of the apply process, wherein said updating includes providing information regarding a restart point in the changed data log;
restarting the changed data propagation task after said loading and said updating control information;
repositioning the changed data propagation task to a correct location within the changed data log in response to said updated control information.
19 Assignments
0 Petitions
Accused Products
Abstract
An Enterprise Data Movement (EDM) system and method for performing bulk data move operations and changed data propagation operations in an enterprise computing system with improved efficiency. The present invention provides synergy of operations between a bulk data move operation and a changed data propagation, wherein the load process of a bulk data move operation and the apply process of a changed data propagation operation operate to communicate with each other to ensure proper operation and also to ensure that each of the bulk move and propagation operations do not interfere with each other. Thus, the present invention provides an improved and automated procedure for performing bulk move and changed data propagation operations which reduces the amount of time required by database administrators to monitor and/or perform tasks.
-
Citations
48 Claims
-
1. A method for performing data load and changed data propagation operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database and a target database, wherein the enterprise computing system also includes a changed data log for storing changed data of the source database, the method comprising:
-
initiating a load process to load data onto the target database; determining the status of an apply process of a changed data propagation task; providing information to the apply process regarding the load process; the apply process suspending apply processing in response to said providing if the apply process is active; the load process operating to load data into at least a portion of the target database; updating control information of the apply process, wherein said updating includes providing information regarding a restart point in the changed data log; restarting the changed data propagation task after said loading and said updating control information; repositioning the changed data propagation task to a correct location within the changed data log in response to said updated control information. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A method for performing data move and changed data propagation operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database and a target database, wherein the enterprise computing system also includes a changed data log for storing changed data of the source database, the method comprising:
-
initiating a bulk data move task from the source database to the target database; performing the bulk data move task, wherein said performing the bulk data move task comprises; determining the status of an apply process of a changed data propagation task; providing information to the apply process regarding the bulk data move task; wherein the apply process suspends apply processing in response to said providing if the apply process is active; loading data into at least a portion of the target database; updating control information of the apply process, wherein said updating includes providing information regarding a restart point in a changed data log; restarting the changed data propagation task after said loading and said updating control information; repositioning the changed data propagation task to a correct location within the changed data log in response to said updated control information. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35)
-
-
36. A method for performing data load and changed data propagation operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database and a target database, wherein the enterprise computing system also includes a changed data log for storing changed data of the source database, the method comprising:
-
initiating a load process to load data onto the target database; performing the load process, wherein said performing the load process comprises; determining the status of an apply process of a changed data propagation task; providing information to the apply process regarding the load process; wherein the apply process suspends apply processing in response to said providing if the apply process is active; loading data into at least a portion of the target database; updating control information of the apply process, wherein said updating includes providing information regarding a restart point in the changed data log; restarting the changed data propagation task after said loading and said updating control information; repositioning the changed data propagation task to a correct location within the changed data log in response to said updated control information.
-
-
37. A memory media which stores program instructions for performing data load and changed data propagation operations in an enterprise computing system, wherein the enterprise computing system comprises a plurality of computer systems and includes a source database and a target database, wherein the enterprise computing system also includes a changed data log for storing changed data of the source database, wherein, in response to a load process being initiated to load data onto the target database, the program instructions are executable to implement:
-
determining the status of an apply process of a changed data propagation task; providing information to the apply process regarding the load process; the apply process suspending apply processing in response to said providing if the apply process is active; the load process operating to load data into at least a portion of the target database; updating control information of the apply process, wherein said updating includes providing information regarding a restart point in the changed data log; restarting the changed data propagation task after said loading and said updating control information; repositioning the changed data propagation task to a correct location within the changed data log in response to said updated control information. - View Dependent Claims (38, 39, 40, 41, 42, 43, 44, 45, 46, 47)
-
-
48. An enterprise computing system which performs data load and changed data propagation operations, wherein the enterprise computing system comprises:
-
a plurality of computer systems, wherein the plurality of computer systems includes a source computer system including a source database and a target computer system including a target database; a changed data log for storing changed data of the source database; a load process comprised in one or more of the source computer system or the target computer system which is operable to load data into at least a portion of the target database; an apply process comprised in one or more of the source computer system or the target computer system, wherein the apply process is a part of a changed data propagation task; a program for determining the status of the apply process, wherein the program is operable to provide information to the apply process regarding the load process; wherein the apply process is operable to suspend apply processing in response to said information if the apply process is active; wherein the program is operable to update control information of the apply process, including providing information regarding a restart point in the changed data log; wherein the changed data propagation task restarts after the load process loads said data and the program updates said control information, wherein the changed data propagation task repositions to a correct location within the changed data log in response to said updated control information.
-
Specification