TMG-L Archives

Archiver > TMG > 2002-01 > 1009894978


From: "Holly Hendricks" <>
Subject: [TMG] tmg with audit trail and rollback functions?
Date: Tue, 1 Jan 2002 09:22:58 -0500


Cheri's emails have brought to mind how much we invest in our databases.
Although I do have lots of backups on CD, restoring V3.5 silver backups
might be tedious and difficult. As Cheri points out, how do you keep track
of what changed when to analyze the errors and select the appropriate
rollback point? How do you figure out what you entered since then? Can
you change one thing without losing everything else? I see that some
people invest as much in their databases as they would in a full time job.

Would other people pay more for ecommerce level TMG with audit trails? I
would if it were an upgrade path from a standard version. Once I was sure
I was going to use TMG (took about 3 weeks for me) and had all my data
converted and cleaned up, I would have started saving up for the high end
version.

An e-commerce system (example: ATM machine) logs every transaction into a
separate file. You can "roll back" any transaction to any point. You can
keep all your audit trail logs as long as you wish, and you could use 3d
party file utilities to compare the logs or search for occurrences of
various strings. This would have required too much disk space before the
advent of affordable multi-gig hard drives, but could work in the current
environment.

I think if there were a series of security levels and a front-end management
system, some of us would find a way to pay significantly more for this level
of data integrity.

Bob seems to be very good at staying focused on his main priorities. But
there might be an opportunity here for a 3rd party company which has already
developed these types of transaction processing modules and a front end
management system for end users.

+----------------------------------------+
Holly Hendricks
Creative Web Development
+----------------------------------------+

This thread: