System and method for replicating external files and database metadata pertaining thereto
AssigneeInternational Business Machines Corporation
InventorsRobert David Goldring, Joshua Wai-Ho Hui, Inderpal Singh Narang
Life of this patent
Estimating the term…
Abstract
A system and method for replicating files in a source file system that is linked to a source DBMS which stores metadata pertaining to files in the source file system. The files and metadata are replicated to a target system having a target file system linked to a target DBMS. File references are also mapped from the source to the target. Also, only the most recent consistent version of files that have changed at the source and that have had insert or update references in the source DBMS are copied over to the target file system, thereby minimizing unnecessary replications.
Claims21
A computer program product having computer usable means thereon executable by a digital processing apparatus to replicate files from a source file system linked to a source DBMS to a target file system linked to a target, comprising:
- computer readable code means for replicating at the target file system only a latest consistent version of a file at the source file system, only if the file has been changed at the source file system and an INSERT or UPDATE is performed on a column in the source DBMS referencing the file.
A computer program product having computer usable means thereon executable by a digital processing apparatus, comprising:
- computer readable code means for mapping at least one file reference in a source DBMS to a target linked to a target file system;
- and
- computer readable code means for replicating at the target file system only a latest consistent version of a file at the source file system, only if the file has been changed at the source file system and an INSERT or UPDATE is performed on a column in the source DBMS referencing the file.
A computer-implemented method for replicating data in at least one source system having a source file system linked to a source DBMS to at least one target system having a target file system linked to a target, comprising the acts of:
- identifying a changed file in the source file system, the changed file having an associated file reference stored in the source DBMS;
- replicating the changed file to the target file system and mapping the associated file reference to the target;
- and
- replicating at the target file system only a latest consistent version of a file at the source file system, and only when:
- the file has been changed at the source file system;
- and
- an INSERT or UPDATE is performed on a column in the source DBMS referencing the file.
A computer-implemented method for replicating data in at least one source system having a source file system linked to a source DBMS to at least one target system having a target file system linked to a target, comprising the acts of:
- identifying a changed file in the source file system, the changed file having an associated file reference stored in the source DBMS;
- replicating the changed file to the target file system and mapping the associated file reference to the target;
- generating a mapping of at least one file reference in the source DBMS to the target using at least one table, wherein the act of generating further includes:
- accessing at least a first mapping table, the first mapping table including at least a server mapping identifier column, a source name column, and a target name column;
- and
- accessing at least a second mapping table, the second mapping table including at least a server mapping identifier column, a source file column, and a target file column.
A computer system, comprising:
- at least one source file system;
- at least one source DBMS linked to the source file system to provide management thereof;
- least one target file system;
- and
- at least one target linked to the target file system to provide management thereof, changes in the source file system and underlying changes in the source DBMS being replicated to the target file system and target, respectively in synchronization;
- and
- at least one user program replicating at the target file system only a latest consistent version of a file at the source file system, only when:
- the file has been changed at the source file system;
- and
- an INSERT or UPDATE is performed on a column in the source DBMS referencing the file.
Dependencies are inferred from the claim text.