The company on April 24 will announce the availability of Optim 4.0. Optim is technology that lets enterprises apply business rules for managing application data at each point in the lifecycle of a transaction.
For example, it behooves businesses to keep orders that have been recently booked and paid for in a primary database environment, so that new transactions with new data get stored in the best environment, with plenty of resources dedicated to their care and feeding, said Lise Neely, manager of product marketing for Princeton Softech, in Princeton, N.J.
As data gets older, it still needs to be saved for regulatory compliance and reporting purposes, particularly if it pertains to a financial transaction, but it doesnt require all that much love.
Christopher Carriero, chair of the OAUG (Oracle Applications Users Group) Archive/Purge Special Interest Group, pointed out that the field of archiving and purging is a growing field in which people are increasingly interested, particularly since their databases are growing at such a fast clip.
"They find production databases growing immensely," he said. "Especially because of the [Oracle E-Business Suite 11i] onset. It broadened the size of the data model for business applications. To be able to downsize that a bit so people arent having to continually buy disks and increase CPU processing power" is getting ever more attention, Carriero said.
In fact, the OAUG is awarding the Archive/Purge SIG a certificate of distinction at this years Collaborate 06 conference in Nashville, Tenn., April 23-27, in recognition of the growing importance of the topic and the work the SIG has done to shine a spotlight on it, he said.
As far as Princetons new Optim version goes, the update allows users to sort transactions by criteria such as age or business value and thus to apply an appropriate level of resources to maintain it, Neely said.
Princeton offers the solution with out-of-the-box adapters for many of the most popular ERP (Enterprise Resource Planning) packages, as well as JDE, PeopleSoft and Siebel applications.
In situations where this type of sorting and archiving isnt automated, businesses tend to save entire copies of their application databases, Neely said.
Then, when they run into audit situations, where theyre asked to produce transaction records spanning multiple years, they have to slog through the work of restoring backup data.