New Tools Lighten Database Load

By Lisa Vaas  |  Posted 2002-11-18 Print this article Print

Oracle, expand beyond, DataMirror, Quest debut management products.

Database administrators can look forward to help managing databases from Oracle Corp. and other developers with the release of tools announced by Oracle, Expand Beyond Corp., DataMirror Corp. and Quest Software Inc. at OracleWorld last week in San Francisco.

Oracle, of Redwood Shores, Calif., set the tone with the release of EM (Enterprise Manager) 4.0, database management software that provides a user-centric, end-to-end system view.

EM 4.0 does this through an HTML-based console that lets DBAs view and manage performance levels on every infrastructure component that affects end-user experience, from URLs down to desktops. One goal is to reduce end-user calls to the help desk by keeping the DBA better informed on the health of corporate applications, Oracle officials said.

Separately, Chicago-based Expand Beyond promised more manageability from PocketDBA 2.0. The new version may interest heterogeneous shops running a mix of databases, since the mobile software for real-time database administration now supports Microsoft Corp.s SQL Server and IBMs DB2 databases, in addition to Oracles namesake database, which it supported in earlier versions.

PocketDBA runs on wireless laptops, tablets or PDAs (personal digital assistants), in addition to the desktop. It allows monitoring and managing of an unlimited number of supported databases. Besides real-time access, new features include the capability to tweak the interface so that it shows only those features that relate to the database versions to which users devices are connected.

Entertainment Earth Inc., a wholesaler and retailer of action figures, toys and collectibles, beta tested PocketDBA. Chief Technology Officer Aaron Lipman said the software recently helped ensure that the companys Web site accurately reflected stock levels for this holiday seasons expected hot toy: action figures from "The Simpsons" TV show. Lipman accessed its SQL Server database over his PDA to remotely tweak it so the toys showed up as in-stock to online viewers.

"Thats when it hit home that [this capability] was really crucial," said Lipman, in North Hollywood, Calif. "Thats a lot of bottom line."

Meanwhile, DataMirror, of Markham, Ontario, rolled out a new version of iReflect, a log-based replication tool that mirrors Oracle database transactions from the primary system to the recovery system in real time. New features include e-mail and messaging alarms and alerts, along with automation of actions based on conditional events, such as when mirroring latency exceeds threshold. An enhanced graphical workflow monitor offers operational control over all iReflect mirroring processes in one screen, enabling DBAs to spot and resolve network issues before they cause latency problems, officials said. In addition, automated checkpoint processing simplifies administrative tasks such as offline tape backups on recovery systems.

Finally, Quest Software, of Irvine, Calif., updated Quest Central for Oracle, a database management tool set. Release 2.5, due this month, records database processes as they occur, enabling playback on demand and context-sensitive advice for resolution.

Raymond Lefebvre, manager of database administration at Stride Rite Corp., in Lexington, Mass., said Quest Central for Oracle 2.5s snapshot and replay capabilities will save his company the cost equivalent of employing three DBAs. "Previously, you had to catch a problem as it was happening," Lefebvre said. "[The snapshot capability] allows you to see who was in there and how it was affecting performance of a database. Without tools [like this], wed probably need twice as many [DBAs] to do the same amount of work."

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