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

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