Method of optimizing database organization using sequential unload/load operations
First Claim
1. A method, executed by a machine, of reorganizing an IMS database having a hierarchical structure, comprising:
- (a) creating, in a storage device, a header data structure containing information about the size and hierarchical structure of the database;
(b) determining a number of sequential files in which to partition the database to be used for temporary storage of data from the database;
(c) determining a desired number of unload processes to be used in parallel in unloading the database;
(d) initiating the desired number of unload processes to copy data from the database to one or more sequential files so that hierarchically-related data in the database is copied in sequence;
(e) providing a storage space to contain the database, said storage space having a plurality of addresses;
(f) assigning respective address ranges of the storage space to the sequential files; and
(g) initiating a plurality of load processes to execute concurrently, the load processes being assigned to write data from one or more specified sequential files to the storage space at the respective address ranges assigned to the specified sequential files.
9 Assignments
0 Petitions
Accused Products
Abstract
A method of reorganizing an IMS database. The method creates, in a storage device, a header data structure containing information about the size and key structure of the database. Next, the number of sequential files to be used for temporary storage of data from the database and the desired number of parallel unload processes to be used in unloading the database are determined. Then, the desired number of unload processes are initiated. These unload processes copy data from the IMS database to one or more sequential files so that hierarchically-related data in the database is copied in sequence. Next, a storage space to contain the IMS database is provided and address ranges of the storage space to the sequential files are assigned. Finally, a plurality of concurrent load processes are initiated. These load processes write data from the specified sequential files to the storage space at the respective address ranges assigned to the specified sequential files.
132 Citations
16 Claims
-
1. A method, executed by a machine, of reorganizing an IMS database having a hierarchical structure, comprising:
-
(a) creating, in a storage device, a header data structure containing information about the size and hierarchical structure of the database; (b) determining a number of sequential files in which to partition the database to be used for temporary storage of data from the database; (c) determining a desired number of unload processes to be used in parallel in unloading the database; (d) initiating the desired number of unload processes to copy data from the database to one or more sequential files so that hierarchically-related data in the database is copied in sequence; (e) providing a storage space to contain the database, said storage space having a plurality of addresses; (f) assigning respective address ranges of the storage space to the sequential files; and (g) initiating a plurality of load processes to execute concurrently, the load processes being assigned to write data from one or more specified sequential files to the storage space at the respective address ranges assigned to the specified sequential files. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 16)
-
-
12. A method, executed by a machine, of unloading an IMS database having a hierarchical structure, comprising:
-
(a) creating, in a storage device, a header data structure containing information about the size and hierarchical structure of the database; (b) determining a number of sequential files in which to partition the database, to be used for temporary storage of data from the database; (c) determining a desired number of unload processes to be used in parallel in unloading the database; and (d) initiating the desired number of unload processes to copy data from the database to one or more sequential files so that hierarchically-related data in the database is copied in sequence. - View Dependent Claims (13)
-
-
14. A method, executed by a machine, of loading a partitioned IMS database having a hierarchical structure, comprising:
-
(a) providing a plurality of sequential files comprising the partitioned database, each containing data to be loaded into the database, the data in each sequential file being organized so that hierarchically related data is stored sequentially in the sequential file; (b) providing a header data structure in a storage device, said header data structure containing information defining the organization of hierarchical data within the plurality of sequential files; (c) providing a storage space to contain the partitioned IMS database, said storage space having a plurality of addresses; (d) assigning respective address ranges of the storage space to the sequential files; and (e) initiating a plurality of load processes to execute concurrently, the load processes being assigned to write data from one or more specified sequential files to the storage space at the respective address ranges assigned to the specified sequential files. - View Dependent Claims (15)
-
Specification