databene

 
  • Increase font size
  • Default font size
  • Decrease font size

DB Sanity (english)

English Version     Deutsche Version

Your Concern

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.

 

Our Solution

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.

 

Supported systems

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

 

QA Process

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
 

Further Information

Documentation

 

Important Addresses

 

History

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.12010-10-15
Proof of concept
0.22010-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.72011-03-21
Versioning
 0.8 2011-06-16
Predefined check types
 0.8.12011-06-29
Bug fixes
 0.8.22011-09-11
Bug fixes
0.8.4
2011-10-21

Automatic version number retrieval,
report size reduction

 0.9.02011-10-31

More predefined check types,
client-side checks

 0.9.12011-11-11
small report fixes and enhancements
 0.9.22011-11-29Tag cloud, hierarchy mechanism
 0.9.32012-12-08
improved report navigation
 0.9.42012-04-11
additional check types
 0.9.52012-08-05
supporting CUBRID, range check