Audit Requirement - EBC + ETL + Compare XMLs

Hi All,

I am trying to meet below requirement for an audit requirement any pointers on the dodgy areas will be helpful.

1. We capture two XMLs before and after for every transaction coming to UCM Transaction Manager. Essentially this is snapshot of customer before the transaction and right after the transaction.(Query using standard thin IO to get XMLs)

2. These two XMLs along with other information are stored in staging table(EBC), we have created two CLOB column as XMLs may be huge [Dodgy 1]

3. ETL/Java/Shell script reads data from EBC and compare XMLs to identify Insert/Update/Delete operations and basically New/Old values. [Dodgy 2]