Data Validation Tool
From ICISWiki
This is the TDM for Version 5.3
Contents |
Introduction
The ICIS Data Validation Tool is an application that tests the database structure of ICIS for data errors that might render it meaningless. This is useful in making sure that published data are always of excellent quality.
It is so simple to use! Just choose the tests you want to execute and click on the "Run tests" button.
The ICIS Data Validation Tool was developed using Visual Basic 6.
Central Database Queries
Under the Central Database Queries tab is the options for checking the Central Database related data checks. Toggle the checkboxes of queries that you want to execute.
Invalid parent references
definition
Circular references
If germplasm A has germplasm B as one of its parent and if germplasm B has germplasm A as one of its parent, then we have a circular reference situation. That is, A references B and B references A.
This query also checks for two-level circularity. That is, A references B and B references C and C references A.
Invalid method
definition
Deleted parent references
Let us say germplasm A is replaced with germplasm B as shown in the GERMPLSM.GRPLCE database column. All germplasm that references germplasm A should be corrected to germplasm B.
Foreign Key references
The ICIS database has no foreign key constraints enabled so we need to check manually if the foreign key definition is violated.
Local Database Queries
Under the Local Database Queries tab is the options for checking the Local Database related data checks. Toggle the checkboxes of queries that you want to execute.
option name
definition
option name
definition
option name
definition
IRRI-GRC Queries
Under the GRC Queries tab is the options for checking the IRRI GRC related data checks. Toggle the checkboxes of queries that you want to execute.
check GID-Accession link
Each germplasm ID must link to one GRC accession. Each GRC accession must link to one germplasm ID. This one-to-one correspondence must be enforced at all times.
check germplasm dates
The creation date (GERMPLASM.GDATE) of an offspring cannot precede the parent's. For example, If germplasm A is a parent of germplasm B, then germplasm B must not precede the creation date of germplasm A.
