Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Everything E3D

Splitting Data Across Multiple DBs

  • Last UpdatedAug 11, 2023
  • 1 minute read

Theoretically there need only be one 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.

  • Whilst the multiwrite 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 MDBs.

  • It allows specific DBs to be hidden from sub contractors.

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

Related Links