ChkDB is rule-based data checking software for Oracle, plus files that define rule-sets and data domains (tables/views to be checked). The software is a PL/SQL package and some SQL scripts. There is currently no GUI front-end. For oil and gas data, there are domains and rulesets for well-header, drill-stem-test, and seismic-inventory data.
|Tags||Information Management Database|
|Operating Systems||OS Independent|
Release Notes: This release fixes a bug that caused errors when using early versions of Oracle 8 (or earlier). The database column CHKDB_RULE.COLUMN_TYPE_CNDO was renamed from COLUMN_TYPE_CND. Specifying the datatype of a column in a rule is now optional if the user owns the table being checked.
Release Notes: In this minor release, the SQL generated for partial-foreign-key checks has been improved and a rule for the CHKDB_OGW1_DST_PERIOD table has been tweaked. A rule with no effect will now cause a row to be inserted into the CHKDB_RULE_ERR table.
Release Notes: This release includes data-checking rules for oil and gas well-header and drill-stem-test data. The README.txt file was updated and the usage examples were fixed.
Release Notes: This release includes data-checking rules for oil and gas seismic inventory data. The following new check-types were added: COL_NOT_EQ_COL2_YN, COL_NOT_NE_COL2_YN, and IS_A_NUMBER_YN.
Release Notes: This release simplifies the way table keys are specified, extends the sample to test all types of checks, and adds the checks MAX_LENGTH and NO_ILLEGAL_CHARS.