Projects / ChkDB


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.

Operating Systems

Recent releases

  •  28 Jan 2004 01:18

    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.

    •  25 Nov 2003 01:02

      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.

      •  19 Nov 2003 10:30

        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.

        •  15 Nov 2003 01:30

          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.

          •  02 Nov 2003 12:28

            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.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.