Abstract: Embodiments of the invention relate to systems, methods, and computer program products for a high performance data copy utility that is operable to dynamically copy data from a source database to a target database in an object-relational database environment. High performance is realized by defining, prior to copying the data, performance boundaries of the source and target environment, such as the quantity of data (i.e., commit points) and quantity of parallel processes (i.e., parallel threads) applicable to a copy job. Moreover, the copying schema of the present invention allows for data to be copied from one database to another database without the need higher level privileges, such as database administrator (DBA) or data definition language (DDL), which would otherwise require changing the structure of the database. In this regard, embodiments of the present invention rely solely on lower-level data manipulation language (DML) privileges configured for inserting, updating and deleting data structures.

Abstract: Embodiments of the invention relate to systems, methods, and computer program products for a high performance data copy utility that is operable to dynamically copy data from a source database to a target database in an object-relational database environment. High performance is realized by defining, prior to copying the data, performance boundaries of the source and target environment, such as the quantity of data (i.e., commit points) and quantity of parallel processes (i.e., parallel threads) applicable to a copy job. Moreover, the copying schema of the present invention allows for data to be copied from one database to another database without the need higher level privileges, such as database administrator (DBA) or data definition language (DDL), which would otherwise require changing the structure of the database. In this regard, embodiments of the present invention rely solely on lower-level data manipulation language (DML) privileges configured for inserting, updating and deleting data structures.