The partial or full duplication of data from a source database to one or more destination databases. Replication may use any of a number of methodologies including mirroring or shadowing, and may be performed synchronous, asynchronous, or point-in-time depending on the technologies used, recovery point requirements, distance and connectivity to the source database, etc. Replication can if performed remotely, function as a backup for disasters and other major outages. (Similar Terms: File Shadowing, Disk Mirroring)
A process of creating and managing duplicate versions of databases. A DBA defines data sets that need to be duplicated at separate sites. These data sets may consist of all of the tables in a datbase, some of the tables in a database, or even just specific columns in some of the tables in a database. There is always at least one source database (called the Master Site) and one target database (called the Slave or Snapshot Site).
The process of reproducing a database so that two or more copies (replicas) of the same database can stay synchronized. Changes to the data in a replicated table in one replica are sent and applied to the other replicas in the replica set. .