Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Name Sundas Fatima Id F2017065292 Section W3

    Uploaded by

    SUNDAS FATIMA
    Sundas Fatima (ID: F2017065292) discusses data replication in her section. She defines data replication as storing data in multiple locations to improve availability. There are three main types of replication: transactional replication replicates transactions in real-time; snapshot replication copies entire snapshots at specific times; and merge replication allows both publisher and subscriber to independently modify data. Replication schemes include full replication of the entire database across all sites, no replication with each fragment at one site only, or partial replication where some fragments are replicated more than others.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Name Sundas Fatima Id F2017065292 Section W3

    Uploaded by

    SUNDAS FATIMA
    29 views3 pages
    Sundas Fatima (ID: F2017065292) discusses data replication in her section. She defines data replication as storing data in multiple locations to improve availability. There are three main types of replication: transactional replication replicates transactions in real-time; snapshot replication copies entire snapshots at specific times; and merge replication allows both publisher and subscriber to independently modify data. Replication schemes include full replication of the entire database across all sites, no replication with each fragment at one site only, or partial replication where some fragments are replicated more than others.

    Original Title

    Data replication

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Sundas Fatima (ID: F2017065292) discusses data replication in her section. She defines data replication as storing data in multiple locations to improve availability. There are three main types of replication: transactional replication replicates transactions in real-time; snapshot replication copies entire snapshots at specific times; and merge replication allows both publisher and subscriber to independently modify data. Replication schemes include full replication of the entire database across all sites, no replication with each fragment at one site only, or partial replication where some fragments are replicated more than others.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    29 views3 pages

    Name Sundas Fatima Id F2017065292 Section W3

    Uploaded by

    SUNDAS FATIMA
    Sundas Fatima (ID: F2017065292) discusses data replication in her section. She defines data replication as storing data in multiple locations to improve availability. There are three main types of replication: transactional replication replicates transactions in real-time; snapshot replication copies entire snapshots at specific times; and merge replication allows both publisher and subscriber to independently modify data. Replication schemes include full replication of the entire database across all sites, no replication with each fragment at one site only, or partial replication where some fragments are replicated more than others.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    NAME SUNDAS FATIMA

    ID F2017065292
    SECTION W3
    Data Replication:
    Data Replication is the process of storing data in more than one site or node. It is useful
    in improving the availability of data. It is simply copying data from a database from one server to
    another server so that all the users can share the same data without any inconsistency. The result
    is a distributed database in which users can access data relevant to their tasks without interfering
    with the work of others.
    Data replication encompasses duplication of transactions on an ongoing basis, so that
    the replicate is in a consistently updated state and synchronized with the source. However, in
    data replication data is available at different locations, but a particular relation has to reside at
    only one location.

    Types of Data Replication:

    1. Transactional Replication: In Transactional replication users receive full initial


    copies of the database and then receive updates as data changes. Data is copied in real time
    from the publisher to the receiving database(subscriber) in the same order as they occur
    with the publisher therefore in this type of replication, transactional consistency is
    guaranteed.

    2. Snapshot Replication: Snapshot replication distributes data exactly as it appears at a


    specific moment in time does not monitor for updates to the data. The entire snapshot is generated
    and sent to Users. Snapshot replication is generally used when data changes are infrequent.

    3. Merge Replication: Data from two or more databases is combined into a single database.
    Merge replication is the most complex type of replication because it allows both publisher and
    subscriber to independently make changes to the database.

    Replication Schemes:

    1. Full Replication:
    The most extreme case is replication of the whole database at every site in the distributed
    system. This will improve the availability of the system because the system can continue
    to operate as long as at least one site is up.
    2. No Replication:
    The other case of replication involves having No replication – that is, each fragment is stored at
    only one site.

    3. Partial Replication:
    In this type of replication some fragments of the database may be replicated whereas others may
    not. The number of copies of the fragment may range from one to the total number of sites in the
    distributed system. The description of replication of fragments is sometimes called the
    replication schema.

    You might also like