Primary and Secondary Data Tables

The DATABridge data tables hold the cloned DMSII data. There are two types of DATABridge data tables:

  • Primary data tables, which are the relational database equivalent of the DMSII data sets. Primary table names are derived from the corresponding DMSII data set name by converting it to lowercase and replacing hyphens (-) with underscores (_).
  • Secondary data tables, which are additional tables that need to be generated to represent a DMSII structure that does not have a relational database equivalent (for example, items with OCCURS clauses, that are not flattened). Secondary table names are constructed using the primary table name with an appropriate suffix.