Two (Database) Runs, No Errors - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
8/31/2005
12:00 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

Two (Database) Runs, No Errors

New database error-checking software from GoldenGate is undergoing trials at the Montefiore Medical Center.

Ensuring that the information in two continuously updated databases remains synchronized is the bane of many a database administrator. GoldenGate Software Inc. claims to have the answer to that problem with its new product, Veridata, which compares large volumes of data in active databases.

In a 4-terabyte database, as many as 3,000 records may be changing every second. If the information in two such databases shows discrepancies, are they the result of out-of-sync data or just a slow update process? Veridata can answer the question "nonintrusively," says Carl Baylis, assistant director of the Emerging Health Information Technology unit of Montefiore Medical Center in the Bronx, one of New York's largest hospitals. The unit supplies IT services to the hospital.

Montefiore has employed Veridata on a two-month trial basis to watch for discrepancies in its Hewlett-Packard NonStop databases, which power its IDX Systems Corp. CareCast hospital-management system. It plans to put Veridata into full production in two months.

The databases contain "100% of all physician orders and 100% of all patient medical data. We're talking life and death here," Baylis says. Consequently, Veridata acts as an automated watchdog. If discrepancies are detected, they're reported to a database administrator or system user. In case of a system outage, Veridata watches the database restarts and detects whether any data has fallen out of sync, he says.

Before installing Veridata, Baylis relied on the comparison of database log files to detect discrepancies, an automated, after-the-fact process. What he likes about Veridata is it brings his check-ups for discrepancies "closer to real time."

Many companies solve the issue of database synchronization through replication, which calls for a clearly designated master database to update secondary databases. Sami Akbay, senior director of marketing at GoldenGate, says Veridata can check for discrepancies between two masters, each of which is being updated continuously.

Veridata can check two servers running Oracle databases or two Tandem NonStop databases at a price of $90,000. Additional platforms will be covered, such as Microsoft's SQL Server and NCR Corp.'s Teradata, by the end of the year, Akbay says.

Oracle says it does the same thing through utilities in Oracle Streams data management, part of the Oracle database system. IBM says it can check for discrepancies between two running DB2 databases through its WebSphereMQ Information Integrator, Replication Edition.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
Commentary
If DevOps Is So Awesome, Why Is Your Initiative Failing?
Guest Commentary, Guest Commentary,  12/2/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll