DB Sanity (english)
Quite often production data contains many inconsistencies and faults which can even contradict your current system requirements. This can be caused by historic bugs, data migration problems and aborted processes.
If you are lucky the system will ignore these bad sets of data (e.g. and consider them incomplete) but if you are unlucky they will act as ticking timebombs ready to explode when an unfortunate use case trips on one of these sets (e.g. a postal system that causes the wrong postage costs). A lot of time can be spent on finding work arounds or manually cleaning the data in question.
DB Sanity is a tool to define and verify individual data requirements as and when they are needed. It can also be used to systematically clean the production system when appropriate.
Have a look at these PDF presentation slides that introduce you to data issues and the way DB Sanity is resolving them.
DB Sanity is supposed to work on
- any system that supports Java 6 or newer, e.g. Windows XP, Vista, 7, Mac OS X, Linux, HP-UX, Solaris
- with any database for which a JDBC driver exists, e.g. Oracle, DB2, MS SQL Server, MySQL, HSQL, H2, Derby, Firebird, CUBRID
- with any web browser, e.g. Frefox, Internet Explorer, Chrome, Safari
Each release of DB Sanity is tested
- with Java 6 on Windows XP and Mac OS X
- on Oracle and HSQL databases
- with Mozilla Firefox, Internet Explorer, Safari and Chrome
- Report Modules
- So, what to check with DB Sanity?
- Getting Started
- File Syntax
- Command Line Arguments
- Environment Files
- What's new in DB Sanity 0.9.0
- Developer Documentation
The first steps in this methodology resulted from BjÃ¶rn Kellermann's idea to verify database data by writing queries, which search for error conditions and return the erroneous data. The approach was realized using SQLUnit, but quickly was limited by the tool's abilities. So it was time for a more practicable tool and I developed DB Sanity.
|Version||Date ||Main Topics|
|0.1||2010-10-15 ||Proof of concept |
|0.2||2010-10-29 ||Hierarchical check suites |
|0.3 ||2010-11-10||Improved Visualization|
|0.4 ||2010-11-15 ||Inofficial release |
|0.5 ||2010-12-13||Impact analysis |
|0.6 ||2011-01-03 ||Correction process support |
|0.7||2011-03-21 ||Versioning |
|0.8||2011-06-16||Predefined check types|
|0.8.1||2011-06-29 ||Bug fixes |
|0.8.2||2011-09-11 ||Bug fixes |
|0.8.4 ||2011-10-21 |
Automatic version number retrieval,
More predefined check types,
|0.9.1||2011-11-11 ||small report fixes and enhancements |
|0.9.2||2011-11-29||Tag cloud, hierarchy mechanism |
|0.9.3||2012-12-08 ||improved report navigation |
|0.9.4||2012-04-11 ||additional check types |
|0.9.5||2012-08-05 ||supporting CUBRID, range check |