Audit Database

You can use this function to resolve some data integrity issues in your geological database. Audit Database checks that data meets the validation requirements defined in the database definition file, and that the integrity of the downhole samples is intact, in relation to overlapping samples and missing intervals.

To run this function: Choose Database > Database > Audit, or...

In the Function Chooser, type AUDIT DATABASE, and press ENTER.

This function does not check the validity of the values stored in the database. To ensure the integrity of stored data you can use techniques such as double entry of data, to check for errors, or manual validation of data entry.

Fields on the Audit Database form

Field	Description
Database	The name of the table. This field is display only.
Define the log file for results
Report file name	The name and location of the report file.
Report format	The format for the report file. File types available are; .not, .csv, .htm, .html, .rtf, .pdf, .ps or .log.
Report error limit	The maximum number of error messages written to the report log file. Note: Audit database continues to run after the maximum number of errors is reached but no report is made of further errors.
Audit options
Exceed maximum depth in collar	Selected: Audit database checks the depth field values for the survey table, and any interval and point tables in the database, against the maximum depth field of the collar table for the drillhole. Cleared: The tables are not checked for maximum depth.
Exceed maximum depth in survey	Selected: The depth field values in any interval and point tables in the database are checked against the maximum depth of the downhole surveys in the survey table for the database. Cleared: The tables are not checked for maximum depth.
Validate constraints in .DDB file	Selected: All tables in the database are checked against the validation characteristics defined in the database definition file. These validation criteria are: lower, upper or mixed case for character fields, upper and lower bounds for integer and real fields, and set of acceptable values for character fields. Cleared: The tables are not checked against the database definition file.
Check samples for overlaps	Selected: The depth field values of any non-time dependent interval and point tables are checked for overlaps. Cleared: The tables are not checked for overlaps.
Check collar IDs for leading/trailing whitespace	Selected: The ID string for each hole is checked for whitespace (space, tab, carriage return or newline character) at the beginning and end of the string. Cleared: ID strings are not checked for whitespace.
Recalculate stored downhole XYZ	Selected: If the downhole X, Y and Z values, of the survey, interval and point tables,are stored values, they are recalculated using the downhole survey details stored in the survey, interval and point tables of the database. Cleared: The X, Y and Z values are not recalculated.
Check tables for valid collar IDs	Selected: The ID fields of secondary tables are checked for invalid collar IDs. A collar ID is invalid when it exists in the secondary table but there is no corresponding ID in the primary collar table .You can select Check all survey, interval and point tables to check all tables in the database or Select individual tables to check a specified list of tables. If you choose Select individual tables the Table name list identifies the tables you have selected. Cleared:The ID fields of secondary tables are not checked.
Check for missing intervals	Selected: For the tables you select, Audit Database checks whether each drillhole has a continuous range of values from the collar (that is, a depth of zero) to the maximum depth value of the drillhole. If a part of the drillhole is missing data, it is reported as a ‘missing interval ’. You can select Check all interval tables to check all interval tables in the database or Select individual tables to check a specified list of tables. If you choose Select individual tables the Table name list identifies the tables you have selected. Cleared: Interval tables are not checked for missing intervals.

Output

A report is created which contains details of the validation checks.