"Its a very manual and cumbersome and expensive process," Neely said. "Sites spend hundreds of thousands of dollars to respond to audit requests" when they have to resort to this manual data restoration, she said. By enabling Oracle E-Business Suite, for example, to segment data, data for General Ledger can be kept in the production database for up to three months, whereas transactions that are four to 36 months old can be kept in a reporting database so users can run queries and generate reports off them.The update allows Optim to track a more granular level of transaction detail, including, for example, customer name, item bought, invoice amount, bank account information and other types of reference numbers. Such reference details make up reference snapshots that let the archives stand alone over timean important aspect that allows users to report holistically on business activities, Neely said. This is important in situations where enterprises upgrade from application version to application version. In spite of upgrading, users need to access information from previous application versions, and Optims reference snapshots allow this. Princeton is also launching an accelerator methodology for Optim and Oracle E-Business Suite. Both Optim and the Princeton Softech Optim and Oracle E-Business Suite Solution Accelerator are being released at the OAUG Collaborate 06 conference. Ziff Davis Media eSeminars invite: Join us April 28 at 2 p.m. and discover how small and midsized companies can enjoy the same advantagessecurity, reliability, scalabilitythat larger enterprises enjoy by deploying Linux technology. Accelerator is a field-tested methodology that streamlines Optim implementation in Oracle E-Business shops, leading users through the stages of planning, designing, building, deploying and maintaining the applications. "If a site is looking to automate data retention and to have better processes for defining business rules for what kind of resources to apply, and what kind of service levels, retention policy and so forth, this will define industry best practices," Neely said. "We capture it into a methodology and bring it to the site of the client." Check out eWEEK.coms for the latest database news, reviews and analysis.
Older transactions can be saved for compliance purposes and categorized so theyre easy to pinpoint when requested in an audit, thus cutting down on the time and effort needed to restore and search through backups.