Contents Index Publication design for Adaptive Server Enterprise Conditions for valid articles

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Publication design for Adaptive Server Enterprise

Design issues overview


Each subscription must be a complete relational database 

A remote database shares with the consolidated database the information in their subscriptions. The subscription is both a subset of the relational database held at the consolidated site, and also a complete relational database at the remote site. The information in the subscription is therefore subject to the same rules as any other relational database:

Transaction integrity must be maintained in the absence of locking 

The data in the dispersed database (which consists of the consolidated database and all remote databases) must maintain its integrity in the face of updates at all sites, even though there is no system-wide locking mechanism for any particular row.

These key features of relational databases must be incorporated into the design of your publications and subscriptions. This section describes principles and techniques for sound design.


Contents Index Publication design for Adaptive Server Enterprise Conditions for valid articles