Was this helpful?
CDDS Example: Subset of Tables
To illustrate CDDS planning, consider the example of ’Round the Earth Publishing (R.E.P.). R.E.P. has a replicated database that is split up into several CDDSs. R.E.P. has its headquarters in New York City and has offices in San Francisco, Dallas, London, and Hong Kong. Most of R.E.P.’s data is in one main CDDS (CDDS 0), which is shared by all locations.
R.E.P.’s inventory information is located in New York, San Francisco, and London, so these locations share an inventory CDDS (CDDS 1).
London and Hong Kong also share an international sales CDDS (CDDS 5).
The following figure illustrates the location of each CDDS:
Last modified date: 11/28/2023