Database Audit System & Reporting
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.