ADR (Atomic Delayed Replication) is a controllable replication manager implemented on top of commercial distributed relational databases. ADR's goal is to enable various welldefined trade-offs between database coherence, throughput and response time in large database networks, e.g. for telecom applications. By combining a strategy for distributed database design with a specific replication protocol, ADR preserves the ACID properties with a controlled relaxation of coherence between primary and secondary copies. We first discuss formal characteristics of ADR, and present the implementation techniques required to realize these formal characteristics on top of commercial distributed database technology. Then, after reviewing a validated analytical performance model for the approach, we demonstrate its flexibility by summarizing experiences with two industrial ADR applications in telecommunications management, both jointly developed with Philips Laboratories. One is database support for the integrated operation and evolution of Intelligent Network telephone services, where secondary copies are held within a distributed database system optimized for throughput and availability during schema evolution. The other concerns database support for mobile phones in a City-wide DECT setting (Digital Enhanced Cordless Telecommunications), where secondary copies are held in main memory caches outside the DBMS. Int. J. Coop. Info. Syst. 1999.08:15-45. Downloaded from www.worldscientific.com by MONASH UNIVERSITY on 02/02/15. For personal use only. The ADR Replication Manager 33the arrival rate. However, the overall throughput of the system is bounded by the capacity of the local sites, i.e. the utilization of the sites cannot exceed 100%. Therefore we derive the maximum throughput D by solving the equation X q ot % + A^o tal £ u = 1 for As lobal (A£ lobal n • X u + n • X q ) which results in D=(^-t q +(l + (n-l). r .k-ur)-Q-^-t u ) \ \ n v J n J
Integrating database design and operation for intelligent networkservices