Database Archiving Best Practices: Advice from the Trenches: Page 2

Posted August 30, 2004

Drew Robb

Drew Robb

(Page 2 of 2)

Continued from Page 1

How to Archive:

8. Store data in classes appropriate to the age of data and its access/legal requirements.

9. "Use diagrams to map out data interdependencies and plot the optimum archiving path," said Larry Cuda, global data archiving and migration project leader at Kennametal Inc, a. metal cutting tool supplier based in Latrobe, PA. Kennametals SAP database almost crashed due to an explosion of data. eCONtext by IXOS helped solve the problem.

10. Relocate inactive data to the archive.

11. Strike while the iron is hot. "Archive before data volume creates a noticeable performance implications or necessitates unanticipated expenditures for storage, memory, etc.," said Adam Gwosdof, CTO of Applimation.

12. Enforce data retention based on a published central retention document.

13. "Retain application transparency for users regardless of where the data resides," said Howard.

14. Get your archiving methodology approved as legal in each country and by each agency concerned

15. Distinguish between archiving of original documents upon creation for legal/audit purposes and retirement of inactive data.

"We use optical imaging of certain documents at their point of creation," said Cuda. "Later, we retire data from the production database."

Optimization and Cost Reduction:

16. "Run the archive DB as a separate instance within one Oracle system, if possible, to reduce costs," said Hughes.

17. "Optimize your archive by removing very old data to another XML/XSD archive stored in a flat file that is application and database independent and is less expensive to store," said Howard.

18. "Make sure you backup your archive database after you archive, "said Cotrone.

19. Establish service level agreements with user community for access to active and inactive transactions.

Page 2 of 2

Previous Page
1 2

0 Comments (click to add your comment)
Comment and Contribute


(Maximum characters: 1200). You have characters left.