Sorry, I'm relatively new to databases, so this may be a stupid question.

I want to create a database using MySQL. This database will consist of raw data that will need to be cleaned up: outliers will need to be replaced by best estimates, high frequency data will need to be averaged over various time intervals, etc. When doing the cleaning, I do not want to overwrite any old data. That is, I want to keep the original raw data and also the new cleaned up data, and I want this data to be all in the same database. In other words, I kind of want a database with a memory. Nothing ever gets erased or overwritten. If needs be, one can revert to the old state.

Does anyone here know of the most efficient way to do this using MySQL?

Thanks.

Mike