Archiving Databases: Throwing the Baby Out with the Bathwater

By Mary Caplice

When archiving data from relational databases for either compliance or performance reasons, it is standard practice to archive at the business transaction level of granularity rather than at the table, block or partition level.  In most cases it’s very straightforward to model a transaction for archiving so that the transaction is moved intact without leaving parts of it behind, except where there are many-to-many relationships where transactions become ‘chained’ to other transactions.

For example, you could have an application containing customers, invoices and payment information. At first it may look like all invoices with a status of ‘CLOSED’ older than one year can be archived. However, several payments can be linked across invoices, and in some cases partial payments are keeping some of these invoices ‘OPEN’. All invoices across the chain of payments must be considered. Any part of a chain that is open should disqualify the entire chain. Without support for chaining the integrity of the application can be compromised.

Unless your archiving solution can chain these transactions together correctly, you could be left with dangling transactions! 


| ‎01-20-2010 03:19 AM

Thanks very much. it’s what i’m looking for.

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the Community Guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Showing results for 
Search instead for 
Do you mean 
About the Author

Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.