Maintenance Descriptions
Maintenance - Maintain descriptive data
To open the maintenance form choose Administration →
Database … →
Maintenance … from the menu and
select the 
Maintain descriptive data tab. In
the 
Descriptor status
data tab you may set or reset the
descriptor status of a categorical descriptor depending on its summary
data. In the 
Categorical summary
data tab you may shift and copy
categorical summary data to a different descriptor or delete values for
selected categorical states. In the 
Quantitative summary data tab you
may perform such operations concerning statistical measures. With
tab 
Description
project you may manage the
additional projects of your
description items. To find and delete corrupted descriptive data choose
the 
Clean descriptive
data tab. The
tab 
Find violation of
rules offers query functions to find
description items where rules concerning the descriptor usage are
violated.
Commonly used description selection options
In the sub-panels you may set a descriptor status and move or copy
categorical rsp. quantitative summary data. By default all descriptions
from the selected project will be searched that fulfill the specified
conditions, i.e. a certain categorical state or statistical measure. In
certain cases it is neccessary to restrict the possibly affected
descriptions by some additional conditions. For this purpose there is
the option to define a restriction and/or an exclusion list (see example
below).
By opening a query window (button
) you can generate a list of descriptions (see
image below) that shall be included in the search (Description
restriction) or excluded from the search (Description
exclusion).
The resulting numbers of restricted and excluded descriptions will be
displayed in the controls. You may check the selected items by
double-clicking the numbers (see images below).
Subsections of Descriptions
Maintenance Clean Descriptions
Maintenance - Clean descriptive data
Descriptive data, which can be summary or sampling data, are stored in
the database in several tables, that reference the corresponding
descriptor rsp. categorical state and hold some additional data.
Depending on the descriptor type - categorical, quantitative, text or
sequence - different tables are used to represent the descriptive data.
Although Diversity Descriptions does not allow to change the type of a
descriptor if descriptive data are present, in some cases it cannot be
assured that such an action is rejected. The resulting data are then
meaningless and will not be displayed within Diversity Descriptions. To
find, check and delete such kinds of corrupted descriptive data, select
the Maintain descriptive data tab and choose
the tab Clean descriptive data.
Select the Data type (“Summary data” or “Sampling data”), the
Entity type (i.e. the type of descriptive data in database:
“categorical”, “quantitative”, “text” or “sequence”) and the
Project. Click on Check for invalid data 
and all invalid data will be listed (see image below).
You may select or deselect all entries of the result list for the
database update by clicking the buttons 
Select all rsp. 
Select none. To delete
the selected entries from the database click on the
button. Instead of deleting the selecting
entries you may click Close form and check list in database
to return to the main program with the
affected descriptions.
You may open a table editor for the selected entries by clicking the
Open table editor 
button (see image
below). Here you may check the corrupted data to decide if further
measures are required.
Maintenance Description Projects
Maintenance - Description project
Description items belong to one basic projects, that determines the
terminology. Additionally they may be assigned to additionalprojects to make them accessible within
other contexts. To set or remove additional projects, select the
Maintain descriptive data tab and choose the
tab Description project.
Select the Project, Addtitional project and the requested
operation Set additional project, Remove additional project or
Swap projects to exchange the project and additional project. Click
on Check for project data and the matching
descriptions will be listed (see image below). The Description
restriction and Description exclusion lists may be used for
refinement of the description selection (see Maintain descriptivedata).
You may select or deselect all entries of the result list for the
database update by clicking the buttons
Select all rsp. Select none. To delete
the selected entries from the database click on the
button. Instead of deleting the selecting
entries you may click Close form and check list in database
to return to the main program with the
affected descriptions.
Maintenance Violations
Maintenance - Find violations of rules
With this form you ma easily search description items, that do not
fulfill certain requirements. With the 
Mandatory descriptors tab you may find
descriptions where data for mandatory descriptors are missing. With the
Exclusive
descriptors tab you may find descriptions
that contain multiple states for exclusive descriptors. In the
Applicability
rules tab you may descriptions that violate
rules administered in the Descriptorapplicability data. In the
Ambigious
descriptions tab you may search for ambigious
description titles.
Subsections of Maintenance Violations
Maintenance Ambiguous
Maintenance - Ambiguous description titles
In DiversityDescriptions the description titles may be ambiguous, even
within one project. It depends on the informal project strategies if
duplicate description titels shall be accepted, therefore there is no
kind of highlighting. With this form you can easily find all
descriptions with ambigious titles within a project.
After selecting the Project click on Check for violations
and all found description items are listed in
the table (see image above). If you select the option Ignore same
state, mutiple occurances of the same state, e.g. when modifier of
frequency values have been selected, will be ignored. By selecting an
entry and clicking the button Inspect dataset 
you may view that dataset in a separate window.
You may select or deselect all entries of the result list by clicking
the buttons Select all rsp.
Select none. To save the selected table
entries in a tab-separated text file click on the Export data
button. Click Close form and check list in
database to return to the main program with
the affected descriptions.
Maintenance Exclusive
Maintenance - Exclusive descriptors
If a descriptor is marked as “exclusive”, in each description item only
one categorical state value for this descriptor should be present. When
you are editing a description in the Contiuousview violations of this rule are
usually highlighted by a yellow background
color. With this form you can easily find all descriptions violating the
exclusivity condition.
After selecting the Project click on Check for violations
and all found description items are listed in
the table (see image above). If you select the option Ignore same
state, mutiple occurances of the same state, e.g. when modifier of
frequency values have been selected, will be ignored. By selecting an
entry and clicking the button Inspect dataset
you may view that dataset in a separate window.
You may select or deselect all entries of the result list by clicking
the buttons Select all rsp.
Select none. To save the selected table
entries in a tab-separated text file click on the Export data
button. Click Close form and check list in
database to return to the main program with
the affected descriptions.
Maintenance Mandatory
Maintenance - Mandatory descriptors
If a descriptor is marked as “mandatory”, in each description item a
value for this descriptor should be present. When you are editing a
description in the Contiuous view
those missing data as usually highlighted by a yellow background color. With this form you can
easily find all descriptions with missing mandatory descriptor data.
After selecting the Project click on Check for violations
and all found description items are listed in
the table (see image above). You may restrict the query to selected
Descriptor types. If you select the option Evaluate status data,
any present descriptor status, e.g. “To be checked” or “Data missing”,
will be treated as if descriptor data were present. By selecting an
entry and clicking the button Inspect dataset
you may view that dataset in a separate window.
You may select or deselect all entries of the result list by clicking
the buttons Select all rsp.
Select none. To save the selected table
entries in a tab-separated text file click on the Export data
button. Click Close form and check list in
database to return to the main program with
the affected descriptions.
Maintenance Summary Categorical
Maintenance - Categorical summary data
To shift and copy categorical summary data to a different descriptor or
delete values for selected categorical states, select the
Maintain descriptive data tab and choose the
tab Categorical summary data. In this panel
you operate on the categorical summary data of the descriptions. If
you want to shift or copy categorical states between descriptors, please
use Maintenance - Categoricalstates.
Select the Project and the Source descriptor. If you want to
select a Target descriptor that is different than the Source
descriptor, check the box before the Target descriptor and select
a value. Click on Show categorical state mapping
and all categorical state values of the
selected Source descriptor will be listed in the upper table (see
image below). Select the categorical states for which you want to modify
the summary data in column >>.
The following operations are available:
- Delete the summary data by leaving the Target state empty
- Move the summary data by selecting the Target state
- Copy the summary data by selecting the Target state and
selecting the New column
In case the summary data are moved or copied, all relevant data
including modifier and frequency values and notes will be processed.
After adjusting the required operations for the selected categorical
states click on Check for categorical states
and all affected summary data will be listed in the lower table (see
image above). The Description restriction and Description
exclusion lists may be used for refinement of the description
selection (see Maintain descriptivedata). For each affected
Description and State of the categorical summary data the
Action (DELETE, MOVE or INSERT) and New state are specified. If
you check the option No state selected, you may search for
descriptions that do not reference any state of the Source
descriptor and set a state of the selected Target descriptor (see
image below).
You may select or deselect all entries of the result list for the
database update by clicking the buttons
Select all rsp. Select none. To
perform the selected operations click on the
button. Instead of updating the database you may click Close form and
check list in database to return to the
main program with the affected descriptions.
Maintenance Summary Quantitative
Maintenance - Quantitative summary data
To shift and copy quantitative summary data to a different descriptor or
delete values for selected statistical measures, select the
Maintain descriptive data tab and choose the
tab Quantitative summary data.
Select the Project and the Source descriptor. If you want to
select a Target descriptor that is different than the Source
descriptor, check the box before the Target descriptor and select
a value. Click on Show statistical measure mapping
and the assigned statistical measures of the
selected Source descriptor will be listed in the upper table (see
image below). If you want so process all available statistical measures,
not only that ones assigned to the descriptors in the descriptor tree,
check Show all source measures rsp. Show all target measures.
Select the statistical measures for which you want to modify the summary
data in column >>.
The following operations are available:
- Delete the summary data by leaving the Target statistical
measure empty
- Move the summary data by selecting the Target statistical
measure
- Copy the summary data by selecting the Target statistical
measure and selecting the New column
In case the summary data are moved or copied, all relevant data
including modifier values and notes will be processed.
After adjusting the required operations for the selected categorical
states click on Check for statistical measures
and all affected summary data will be listed in
the lower table (see image above). The Description restriction and
Description exclusion lists may be used for refinement of the
description selection (see Maintain descriptivedata). For each affected
Description and Measure of the quantitative summary data the
Action (DELETE, MOVE or INSERT) an New measure are specified.
You may select or deselect all entries of the result list for the
database update by clicking the buttons
Select all rsp. Select none. To
perform the selected operations click on the
button. Instead of updating the database you may click Close form and
check list in database to return to the
main program with the affected descriptions.
Maintenance Summary Status
Maintenance - Descriptor status data
To set or reset a certain descriptor status for dedicated categorical
summary data, select the Maintain descriptive
data tab and choose the tab Descriptor
status data.
Select the Project, the Source descriptor and the Target
descriptor status. Depending on the Source descriptor type you
have different basic options to select the descriptions for which the
descriptor data status shall be modified. For quantitative, text and
molecular sequence descriptors, you may decide if the selected
Descriptor value shall be present (option Value is present) or
absent (option No value is present, see image below). This basic
restriction may further be refined by selecting Description
restriction and Description exclusion lists (see Maintaindescriptive data). Further
select the data status and if it shall be set or reset using Action
options.
After adjusting the required operations click on Check for descriptor
status and all affected summary data will be
listed in the lower table (see image above). For each affected
Description the Action (DELETE or INSERT) and the Status are
specified.
If you select a categorical Source descriptor, you have the basic
selection options to modify the descriptor data status for specific
Categorical state (option Specific state selected, see image
below). In this case use the combobox to adjust the selected state. If
you uncheck Specific state selected, you may search for descriptions
where any State is present or No state is present. In any case
the Description restriction and Description exclusion lists may
again be used for further refinement of the description selection (see
Maintain descriptive data).
You may select or deselect all entries of the result list for the
database update by clicking the buttons
Select all rsp. Select none. To
perform the selected operations click on the
button. Instead of updating the database you may click Close form and
check list in database to return to the
main program with the selected descriptions.
