Designing concatenated databases

<< Click to Display Table of Contents >>

Navigation:  Administration > Database Administration > Concatenating Databases >

Designing concatenated databases

When large databases are split into multiple databases and then concatenated for ease of maintenance, all databases can be created with the same structure. The following Concatenated Database Sample table illustrates how this architecture is created.

As the administrator, this database design serves both you and the reviewer. The generic naming of the primary database prevents confusion for the reviewers because they can simply launch the primary database (Columbia.dcb) without having to be concerned about multiple databases. The design also benefits you because databases are similarly named and the structure allows for ease of maintenance when indexing or reindexing is needed.