Subsetting

A subsetting is a functionality that allows you to extract a certain part of the data from the total data set, with the aim of creating a smaller, more specific database, which is then easier to work with. It is the process of retrieving just the parts of large database which are of interest for a specific purpose. A database subset allows users in the field to work with a small subset of a database.

A subsetting can be managed trough Menu options:

Table of contents
Subset definitions
Subset table filters
Execution history

Subset definitions

Subset definition is a set of tables that will be completely copied or just a part of data will be copied from the source database to the target database.

Subset table filters

The subset table filter option is where user creates rules that exclude/include all or part of data. Rules defined here apply to all subset definitions.

Execution history

All subset executions can be viewed on Subest execution history screen. It contains a table with name of user who made changes, process status and date and time process started and ended.