Advance data replication useful to types of Application Systems - Oracle Replication

Q.  Advance data replication is useful to which types of Application Systems?
- Published on 12 Aug 15

a. Disconnected Environments
b. Failover Site
c. Distributing Application Loads
d. All of the above

ANSWER: All of the above
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - Advanced, symmetric data replication is useful for many types of application systems with special requirements.

    - Disconnected Environments
    - Advanced replication is useful for the deployment of transaction processing applications that operate using disconnected components.
    - For example, consider the typical sales force automation system for a life insurance company.
    - Each salesperson must visit customers regularly with a laptop computer and record orders in a personal database while disconnected from the corporate computer network and centralized database system.
    - Upon returning to the office, each salesperson must forward all orders to a centralized, corporate database.

    - Failover Site
    - Advanced replication can be useful to protect the availability of a mission critical database.
    - For example, a symmetric replication system can replicate an entire database to establish a failover site should the primary site become unavailable due to a system or network outage.
    - In contrast with Oracle's standby database feature, such a failover site can also serve as a fully functional database to support application access when the primary site is concurrently operational.

    - Distributing Application Loads
    - Advanced replication is useful for transaction processing applications that require multiple points of access to database information for the purposes of distributing a heavy application load, ensuring continuous availability, or providing more localized data access.

    - Information Transport
    - Advanced replication can be useful as an information transport mechanism.
    - For example, an advanced replication system can periodically off-load data from an update-intensive operational database to a data warehouse or data mart.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)