Database Management
Reference Manual
Introduction to Database Concepts
:
Project
: Splitting Data Across Multiple DBs
Splitting Data Across Multiple DBs
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.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
