Extract Families

The original database is known as the primary (Master) Database (DB). The primary database is the parent of the first level of extracts. If a more complex hierarchy of extracts is created, the lower level extracts will have parent extracts which are not the primary.

A primary DB may have up to 191 extract DBs. The user can create an extract from another extract, forming a hierarchy of extracts. All the extracts derived from the same primary are described as an Extract Family.

The extracts immediately below an extract, are known as Extract Children.

If a hierarchy of extracts is created, the parent extracts for an extract, up to and including the primary DB, are known collectively as the Extract Ancestors.

The following diagram illustrates an example of an extract family hierarchy:

In this example:

The Children of PIPE are PIPE_X1 and PIPE_X2.

PIPE and PIPE_X1 are the Ancestors of PIPE_X10.

Write access to extracts is controlled in the same way as any other database:

• The user must be a member of the team owning the extract. Extracts in the same family can be owned by the same team or by different teams.

• The user must select an Multiple Database (MDB) containing the extract.

• Data Access Control (DAC) can be applied.

  Extract families enable several users' work to be combined into another higher-level extract, which can then be approved before updating the primary.