Capturing data of a database system
First Claim
1. In a data processing system having a database comprising a plurality of elements being stored in at least one storage device, each of the elements being asynchronously updatable and deletable by tasks operating within the data processing system, a computer implemented method for creating a snapshot copy of selected elements of the database, comprising the steps of:
- copying sequentially said selected elements from said storage device storing said selective elements into a secondary storage device;
identifying, in response to a request from a task operating in said data processing system to delete one of said selected elements while said sequential copying of said selected elements is in progress, in a first record, stored within said data processing system, said selected element to be deleted if said selected element has not bee copied to said secondary storage device at the time when said request for deletion was made;
deleting said identified selected element as identified in said first record after said identified selected element has been copied to said secondary storage device;
creating and storing in a temporary storage, in response to a request from a task operating within said data processing system to update one of said selected elements while said sequential copying of said selected elements is in progress, a duplicate copy of said selected element to be updated before said selected element is updated if said selected element has not bee copied to said secondary storage device at the time when said request to update was made;
identifying said selected element in a second record stored within said data processor system if a duplicate copy of said selected element has been stored in said temporary storage;
updating said selected element to be updated stored in said storage device;
copying from said temporary storage said duplicate copy of a said selected element identified in said second record to said second storage device when said update selected element would have been sequentially copied to said second storage device.
0 Assignments
0 Petitions
Accused Products
Abstract
To create a snapshot copy of selected elements of a database in a data processing system, the selected elements are copied sequentially to a secondary storage device. During the copying operation, when a task requests to delete one of the selected elements from the database before it is copied to the secondary storage device, a record is made to identify the requested element, the task is allowed to continue processing. After the element has been copied to the secondary storage device, the identified element will be deleted based upon the record. Also, during the creation of the copy, when a task requests to update one of the selected elements, a duplicate copy of the requested element is created and the task is allowed to update the requested element. When it is time to copy the requested element to the secondary storage device, the duplicate copy will be used.
-
Citations
18 Claims
-
1. In a data processing system having a database comprising a plurality of elements being stored in at least one storage device, each of the elements being asynchronously updatable and deletable by tasks operating within the data processing system, a computer implemented method for creating a snapshot copy of selected elements of the database, comprising the steps of:
-
copying sequentially said selected elements from said storage device storing said selective elements into a secondary storage device; identifying, in response to a request from a task operating in said data processing system to delete one of said selected elements while said sequential copying of said selected elements is in progress, in a first record, stored within said data processing system, said selected element to be deleted if said selected element has not bee copied to said secondary storage device at the time when said request for deletion was made; deleting said identified selected element as identified in said first record after said identified selected element has been copied to said secondary storage device; creating and storing in a temporary storage, in response to a request from a task operating within said data processing system to update one of said selected elements while said sequential copying of said selected elements is in progress, a duplicate copy of said selected element to be updated before said selected element is updated if said selected element has not bee copied to said secondary storage device at the time when said request to update was made; identifying said selected element in a second record stored within said data processor system if a duplicate copy of said selected element has been stored in said temporary storage; updating said selected element to be updated stored in said storage device; copying from said temporary storage said duplicate copy of a said selected element identified in said second record to said second storage device when said update selected element would have been sequentially copied to said second storage device. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. In a data processing system having a database comprising a plurality of elements being stored in at least one storage device, each of the elements being asynchronously updatable and deletable by tasks operating within the data processing system, a computer implemented method for creating a snapshot copy of selected elements of the database, comprising the steps of:
-
a. providing and continuously maintaining a map to identify elements to be selected for inclusion in a snapshot copy of the database; b. in response to a command from said data processing system to create a snapshot copy of the database performing the steps of; b1. creating a copy of said map to identify said elements selected for said snapshot copy; and b2. disabling access to the database only during the period of time said map is being copied; c. copying said selected elements identified in said map copy sequentially into a secondary storage device; d. in response to a request from a task operating within said data processing system to delete a said selected element while said sequential copying of said selected elements is in progress performing the steps of; d1. identifying said selected element to be deleted in a first record stored in said data processing system if said selected element to be deleted has not been copied into said secondary storage device; and d2. deleting each said identified selected element in said first record after each said identified selected element has been copied into said secondary storage device; and e. in response to a request from a task operating within said data processing system to update a said selected element while said sequential copying of said selected elements is in progress performing the steps of; e1. creating and storing in a temporary storage a temporary copy of said selected element to be updated before said selected element is updated if said selected element has not been copied to said secondary storage device; e2. identifying in a second record stored in said data processing system a said selected element to be updated if said temporary copy of said selected element has been stored in said temporary storage; e3. updating said selected element to be stored in said storage device; e4. copying from said temporary storage said temporary copy of a said selected element, identified in said second record, to said secondary storage device when said updated selected element would have been sequentially copied to said secondary storage device. - View Dependent Claims (8, 9)
-
-
10. In a data processing system having a database comprising a plurality of elements being stored in at least one storage device, each of the elements being asynchronously updatable and deletable by tasks operating within the data processing system, an apparatus for creating a snapshot copy of selected elements of the database, comprising:
-
first means, in response to a request from said data processing system to create said snapshot copy, fir copying said selected elements sequentially into a secondary storage device; first recording means, in response to a request from a task operating in said data processing system to delete one of said selected elements and where said deletion request occurs when said first means is in the process of sequentially copying said snapshot copy, for identifying said selected element to be deleted if said selected element has not been copied to said secondary storage device; second means responsive to said first recording means for deleting each said identified selected element as identified by said first recording means after each said identified selected element has been copied to said secondary storage device; temporary storage means; third means, in response to a task operating in said data processing system requesting to update one of said selected elements and where said update request occurs when said first means is in the process of copying said snapshot copy, for creating and storing in said temporary storage means a temporary copy of said selected element to be updated before said selected element is updated if said selected element has not been copied to said secondary storage device; second recording means for identifying said selected element to be updated for which a temporary copy has been stored in said temporary storage by said third means; fourth means for updating said selected element to be stored in said storage device; fifth means responsive to said second recording means for copying from said temporary storage said temporary copy of said selected element as identified by said second recording means into said secondary storage device when said updated selected element would have been sequentially copied into said secondary storage device. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. In a data processing system having a database comprising a plurality of elements being stored in at least one storage device, each of the elements being asynchronously updatable and deletable by tasks operating within the data processing system, an apparatus for creating a snapshot copy of selected elements of the database, comprising:
-
a. first means for identifying in a map selected elements which will be selected to be included in a snapshot copy of said database; b. second means, in response to a request from said data processing system to create said snapshot copy of the database, for creating a temporary copy of said map to identify said selected elements to be included in said requested snapshot copy; c. third means for disabling access to the database during the period of time during which said second means is creating said temporary map; d. fourth means for sequentially copying said selected elements identified in said temporary map into a secondary storage device; e. first record means, response to a request from a task operating within said data processing system to delete said selected element when said request is made while said fourth means is in the process of copying all said selected elements, for identifying said selected element to be deleted if said selected element to be deleted has not been copied into said secondary storage device; f. fifth means for deleting said identified selected element as identified by said first record means after said identified selected element has been copied to said secondary storage device; g. temporary storage; h. sixth means, responsive to a request from a task operating within said data processing system to update a said selected element when said request to update a selected element is made while said fourth means is in the process of sequentially copying all said selected elements, for creating and storing in said temporary storage a temporary copy of said selected element to be updated before said selected element to be updated is updated; i. second record means for identifying said selected element to be updated if said temporary copy of said selected element has been stored in said temporary storage by said sixth means; j. seventh means for updating said selected element to be stored in said storage device; and k. eighth means for copying from said temporary storage said temporary copy of a said selected element as identified in said second record means to said secondary storage device when said updated selected element would have been sequentially copied into said second secondary device. - View Dependent Claims (17, 18)
-
Specification