Apparatus and methods for transferring database objects into and out of database systems
First Claim
7-1. The apparatus set forth in claim 1 wherein:
- the control database object includes a specification of one or more parameters for the job, the transfer mechanism transferring the objects in the set as specified by the parameter.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques for transferring objects between database systems. As implemented in a relational database management system, the techniques employ a data transfer mechanism that operates under control of a master table in the RDBMS that is performing the transfer operation. The master table specifies the kind of transfer operation to be performed, a set of objects to be transferred, operations to be performed on the objects as they are being transferred, and filters for selecting a subset of the objects. During execution of the transfer, the transfer mechanism maintains and updates state in the master table such that queries may be made on the master table to determine the current status of the operation and such that the transfer mechanism may restart the operation after it has been stopped either at the request of a client that is performing the operation or because of an error in the transfer. The master table'"'"'s persistence and the status information it contains permit the client that is performing the operation to detach from the operation without stopping the operation and later again attach to the operation to determine the operation'"'"'s status or to perform operations such as creating new files for the operation or changing the degree of parallelism with which the transfer operation is being performed. Another feature of the transfer mechanism is using an object'"'"'s metadata to determine the most efficient way of transferring the object.
177 Citations
57 Claims
-
7-1. The apparatus set forth in claim 1 wherein:
-
the control database object includes a specification of one or more parameters for the job, the transfer mechanism transferring the objects in the set as specified by the parameter.
-
-
8-2. The apparatus set forth in claim 7 wherein:
-
the parameter is an estimate only parameter, the transfer mechanism responding thereto by providing an estimate of the space required for the objects in the set without transferring the objects.
-
-
36. A set of files for transferring a set of database objects into a database management system, the set of files comprising:
-
at lease one file containing the objects belonging to the set thereof; and
a control object in the set thereof that specifies for each object belonging to the set the location of the object in the set of files and an order in which the database management system transfers object during the transfer. - View Dependent Claims (37, 38)
-
-
39. A method of transferring database objects to a destination, each database object having metadata that defines the database object'"'"'s type and the method comprising the steps of:
-
obtaining metadata for the object type using the metadata to make a determination of the composition of the objects of the type;
selecting a transfer technique for objects belonging to the type from a plurality thereof according to the determination; and
transferring the objects belonging to the type according to the selected transfer technique. - View Dependent Claims (40, 41, 42)
-
-
43. A method of performing a job that transfers a set of database objects into or out of a database management system that includes a transfer mechanism that transfers the database objects under control of a control database object in the database management system that represents the job,
the method comprising the steps of: -
defining the job'"'"'s control database object; and
executing the job by causing the transfer mechanism to transfer the set of database objects under control of the job'"'"'s control data base object. - View Dependent Claims (44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57)
-
Specification