Database copy apparatus, database copy method and recording medium recorded with database copy program
AssigneeFujitsu Limited
InventorsKazuo Ishihara, Hisayuki Enbutsu, Mitsuhide Nishino
Life of this patent
Estimating the term…
Abstract
A database copy apparatus, a database copy method and a recording medium recorded with a database copy program, which increases the generality of database copying irrespective of the database structure, by partitioning a copy source database into predetermined regions, and copying records and inter-record connection relations contained in the respective regions to a copy target database, and extracting from the copy source database the inter-record connection relations respectively contained in different regions, and duplicating the inter-record connection relations copied to the copy target database, based on the extracted connection relations.
Claims9
A database copy apparatus comprising:
- data copying means for partitioning a copy source database into predetermined storage locations, and copying records and inter-record connection relations contained in the respective storage locations to a copy target database;
- connection relations extraction means for extracting from said copy source database the inter-record connection relations respectively contained in different storage locations;
- and
- connection relations duplication means for duplicating the inter-record connection relations copied to the copy target database by said data copying means, based on the connection relations extracted by said connection relations extraction means.
A database copy method comprising:
- partitioning a copy source database into predetermined storage locations, and copying records and inter-record connection relations contained in the respective storage locations to a copy target database;
- extracting from said copy source database the inter-record connection relations respectively contained in different storage locations;
- and
- duplicating the inter-record connection relations copied to the copy target database by said data copying step, based on the connection relations extracted by said connection relations extracting.
A recording medium on which is recorded a database copy program performing a process comprising:
- partitioning a copy source database into predetermined storage locations, and copying records and inter-record connection relations contained in the respective storage locations to a copy target database;
- extracting from said copy source database the inter-record connection relations respectively contained in different storage locations;
- and
- duplicating the inter-record connection relations copied to the copy target database by said data copying function, based on the connection relations extracted by said connection relations extracting.
A database copy apparatus comprising:
- a data copying unit comprising a partitioning unit partitioning a copy source database into predetermined storage locations, and comprising a record copying unit copying records and inter-record connection relations contained in the respective storage locations to a copy target database;
- a connection relations extraction unit extracting from said copy source database the inter-record connection relations respectively contained in different storage locations;
- and
- a connection relations duplication unit duplicating the inter-record connection relations copied to the copy target database by said data copying means, based on the connection relations extracted by said connection relations extraction means.
A method of duplicating a database comprising:
- tracking relations between records in same storage locations of the database and also tracking relations between records in different storage locations of the database that are being copied by a database duplication process;
- and
- duplicating the database by applying to copies of the storage locations the tracked relations between records in same storage locations of the database and the tracked relations between records in different storage locations of the database.
A method of duplicating a database comprising:
- partitioning the database storage locations;
- copying the storage locations while the database remains online;
- after copying a given storage location and while copying other storage locations, determining and copying a resolved set of relations of records that are interrelated within the given storage location and are not related to records in another storage location;
- after copying the given storage location and while copying other storage locations, also determining and copying an unresolved set of relations of records that are related to records in another storage location;
- responsive to the database receiving an update to records in the given storage location that has been copied, modifying the resolved and unresolved sets of relations of the given storage location that are related to the records;
- and
- applying the copied storage locations, resolved sets, and unresolved sets, to create a copy of the database.
Dependencies are inferred from the claim text.