i need to retrace database changes by an specific application. The database is really big(~8GB) and contains over 300 tables, and some of the tables have > 100 columns. Another Problem is, that the database design isnt beautiful, as example most tables arent converted into the third normal form and columnnames are not meaningful. I only have a bit reverse experience with patching, debugging, and decompiling win32 PE Files.
Luckily i have a lot experience in manual malware analytics and understand x86_64(Linux) ASM and masm. Hopefully this knowledge will help me in this task.
so, my real question is, what are common approaches to understanding database changes and understanding what the different data mean?