Splitting Data Across Multiple Databases

Theoretically there need only be one Database (DB) of each DB type. The main reasons for there being more are:

• DBs are used as a fundamental means of access control. DBs are allocated to Teams, and only team members can modify a DB.

• While the multi-write facilities allow many writers per DB, it eases contention if the writers are not all accessing the same DB.

• The easiest way to run a Global project is to have different DBs writable at different locations.

• The granularity of propagation and distribution in Global is per DB

• It allows different permutations of Multiple Databases (MDBs).

• It allows specific DBs to be hidden from sub contractors

• Inclusion in other projects is done on a DB basis.