The size of corporate databases has been swelling for years. Archiving software can keep them trim, but most companies won't even consider archiving unless it's fully supported by the database application vendor.
|Recent Funding to Storage Companies|
Giant Eagle, an Ohio supermarket chain, is experiencing 80% data growth for its PeopleSoft applications running on Oracle, edging up toward 800GB in total database size. "We keep on having to add disk space, and we don't want to do that continually," says Bob Kalik, support manager for PeopleSoft. He also worries about performance degradation.
Moving data offline is easy, but "where it gets tricky is bringing it back online," Kalik says. That's why he put off archiving some of database until he found one that specifically supported his applications--in his case, Princeton Softek's Archive for Servers PeopleSoft Edition. Giant Eagle plans to archive data older than one year plus current.
Similarly, Waterpik in Colorado Springs, CO, avoided cleaning up its Oracle applications database until it absolutely had to--in order to complete an upgrade to Oracle 11i from Oracle 10.7.
In the past, Waterpik dealt with its swelling database by buying "more memory and disk space," says Reggie Thurn, Waterpik business analyst. But converting a 10.7 database to 11i will increase its size by 50%, which means a lot more hardware. Instead, Waterpik decided to use OuterBay's Live Archive software to offload data to online "cheapo hardware," says Thurn. That trimmed Waterpik's database down to 40GB from 100GB, which should make it easier to upgrade to 11i, Thurn says.
"The fact that Oracle supported it was also huge," says Thurn, since using it won't nullify an Oracle support agreement. Waterpik also liked how Live Archive will allow them to maintain a consistent user interface between the 11i and archived 10.7 database. Users, therefore, will need "a little bit of education, but not too much."