More Detail

By Lisa Vaas  |  Posted 2006-04-24 Print this article Print

"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.
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.
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 time—an 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 advantages—security, reliability, scalability—that 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.

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel