Contents Index Sharing rows among several subscriptions Solving the problem

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Sharing rows among several subscriptions

The Policy example


The Policy database illustrates why and how to partition tables when there is a many-to-many relationship in the database.

Example database 

Here is a simple database that illustrates the problem.

The Policy table has a row for each of a set of policies. Each policy is drawn up for a customer by a particular sales representative. There is a many-to-many relationship between customers and sales representatives, and there may be several policies drawn up between a particular rep/customer pair.

Any row in the Customer table may need to be shared with none, one, or several sales representatives.


Solving the problem
The publication

Contents Index Sharing rows among several subscriptions Solving the problem