Member Sign In

Tickbox Data Systems

Database Management, Consultancy, Systems Integration

Database Audit System & Reporting

Database Audit System & Reporting header image

The Challenge

User's data changes fired SQL Triggers which ran code to recalculate metrics etc. Triggers can be awkward - apart from being potentially recursive, their "hidden" execution should be tracked somehow. An audit system on trigger calls and data updates could log data values before and after for comparisons which would show both changes and process.

The Results

Vastly more confidence and transparancy in the system - full traceability of changes including knock-on impact. Users and managers can verify productivity, review and improve processes.