ChkDB |
Open Source Rule-Based Data Checking |
|
Home Contact Download Releases Open Source License Project Contributing The PL/SQL Using ChkDB Installation Read-Me Rule-Sets ChkDB Tables E-R Diagram
Tiny Sample External Links Data Quality and Data Profiling (a glossary) |
ChkDB ReleasesThis is the RELEASE.txt file that comes with a ChkDB distribution...
=================================================================
RELEASE.txt - ChkDB Releases and Contribution Credits
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Developers and Contributers
[BRM] Brian Marshall bmarshal@agt.net
Calgary
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Current Status
See the Rule-Sets page of the web-site:
http://www.chkdb.org/rulesets.htm
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Release History
Release Date Status Contributer
------- ----------- -------------- --------------
0.9.9 2004-01-27 Beta [BRM]
- fixed bug: now works on earlier versions of Oracle
- column CHKDB_RULE.COLUMN_TYPE_CNDO was COLUMN_TYPE_CND
- CHKDB_RULE.COLUMN_TYPE_CNDO optional if user owns table
0.9.8 2004-01-21 Beta [BRM]
This is a 'minor enhancements' release.
- OIL_GAS_WELL_1/WELL_HDR_BASIC - fixed rule KB_GRND_APART
- sample queries were improved
0.9.7 2003-11-24 Beta [BRM]
This is a 'minor enhancements' release.
- chkdb_software.sql:
- partial-foreign-key check sql improved
- insert into CHKDB_RULE_ERR if rule has no effect
- OIL_GAS_WELL_1/DST_BASIC - CHKDB_OGW1_DST_PERIOD:
- rule INIT_PRESS_BAD: NOT_NULL_YN is now null
0.9.6 2003-11-19 Beta [BRM]
- OIL_GAS_WELL_1 domain:
- many new rules for WELL_HDR_BASIC and DST_BASIC
- ruleset_id WELL_HDR_BASIC was WELL_BASIC
- README.txt was updated, usage examples were fixed
0.9.5 2003-11-14 Beta [BRM]
- OIL_GAS_SEIS_INV domain:
- multiple rulesets added
- info-item: DATA_VERSION was ITEM_VERSION
- phys-item: ITEM_SIZE, ITEM_DENSITY now varchar2
- added checks: COL_NOT_EQ_COL2_YN, COL_NOT_NE_COL2_YN
- added check: IS_A_NUMBER_YN
- remove_domain.sql: also remove, rulesets, rules, results
- improved sample queries
0.9.4 2003-11-01 Beta [BRM]
- database, software changed to specify keys in new way
- sample database/domain/ruleset now tests all check types
- added check types: MAX_LENGTH, NO_ILLEGAL_CHARS
- OIL_GAS_WELL_1 domain changed to specify keys new way
- ogw1 rulesets converted to use predefined checks
- ogw1_wellbasic_ruleset.sql: longitude check bug fixed
0.9.3 2003-10-21 Beta [BRM]
- New tables: CHKDB_KEY, CHKDB_KEY_COLUMN
- Table CHKDB_TABLE: removed column PRIMARY_KEY_SPEC
- Table CHKDB_RULE: new columns for predefined rules
- Improved ChkDB removal, domain and rule-set removal
- New rule-set for OIL_GAS_WELL_1: DST_BASIC
- Domain 1st draft: OIL_GAS_SEIS_INV (seismic inventory)
0.9.2 2003-09-11 Beta [BRM]
- Table CHKDB_RULESET renamed from CHKDB_RULE_SET
- Column RULESET_ID renamed from RULE_SET
- New tables: CHKDB_RULE_SQL, CHKDB_RULE_ERR
- New domain: OIL_GAS_WELL_1
- New ruleset for OIL_GAS_WELL_1: WELL_BASIC
0.9.1 2003-09-02 Beta [BRM]
- Revision: column DESCRIPTION add/renamed in tables
CHKDB_TABLE, CHKDB_RULESET, CHKDB_RULE
0.9.0 2003-09-02 Beta [BRM]
First release.
- PL/SQL Software for Oracle
- sample domain and rule-set
(no real-world domains or rule-sets, yet)
=================================================================
|