Software Puts Database Backups to Use

By Matthew Hicks  |  Posted 2002-04-15 Print this article Print

Oracle Corp., Quest Software Inc. and Solid Information Technology Corp. are each rolling out software that not only enhances database backup but also helps make the stored data more useful.

Oracle Corp., Quest Software Inc. and Solid Information Technology Corp. are each rolling out software that not only enhances database backup but also helps make the stored data more useful.

Oracles Release 2 of its 9i database will include the capability to use previously idle backup data. The upgrade, due June 1, features an enhanced Data Guard function that lets businesses use the secondary data for read-only procedures such as reporting.

That could also reduce the load on the main database during times of heavy reporting activity, such as the end of a quarter, according to Oracle officials in Redwood Shores, Calif.

In addition to Data Guard, Oracle9i Release 2 will make the transfer of data more efficient by shipping SQL statements, rather than logs of data, from primary to backup databases, thus saving bandwidth.

Separately, Quest this week will announce an upgrade to its SharePlex for Oracle software, which already lets IT departments set up secondary databases to perform reporting. New in Version 4.0 are features that reduce the latency between updates from a primary to a backup database, speed failover when a disaster occurs and enable multiple transactions to be updated at once.

For its part, Solid Information next week will release the third generation of its distributed data management software, Solid FlowEngine, which will let networking software and hardware makers add database replication and failover capabilities to their products.

Enterprises that have increased their focus on disaster recovery since the Sept. 11 terrorist attacks are now looking to go beyond simple backup and restore to make use of their backup databases. Being able to use a secondary database to offload reporting that can often slow performance on a production database is compelling, said Kimberly Floss, database administrator team leader at Quaker Food and Beverage, a division of PepsiCo Inc.

"[Having] multiple purposes helps you cost-justify [your database]," said Floss, in Chicago. "For someone who is looking for this functionality, it would be a key reason to upgrade."

Despite all the improvements to database disaster recovery, Steve Rin said he isnt likely to rush to upgrade from Oracle8i to 9i.

"With the economy the way it is, theres not the resources we had before," said Rin, a database administrator at manufacturer Indian Motorcycle Co., of Gilroy, Calif. "So [real time] is nice to have, and we wish we could have it, but we cant."

Matthew Hicks As an online reporter for, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.

Submit a Comment

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

Rocket Fuel