Application Types

Determining the type of Replication Server application you build determines, in part, the replication strategy you use.

Implementation Strategies discusses various replication scenarios.

Each of these application types differs in the way it updates primary data and in the way it distributes primary and replicated data within the replication system.

• Decision-Support Applications
  Decision-support clients and production online transaction processing (OLTP) clients use data differently. Decision-support clients execute lengthy queries that hold locks on tables to guarantee serial consistency.
• Distributed OLTP Applications
  Although some distributed transaction-processing applications maintain centralized primary data, others fragment primary data among replicate sites.
• Remote OLTP Using Request Functions
  Use replicated functions to execute transactions remotely.
• Standby Applications
  A warm standby application maintains a pair of databases from the same vendor, one of which functions as a standby copy of the other.