Methods and apparatus for detection and recovery of database out of synchronization conditions
AssigneeEMC Corporation
InventorsRajesh K. Gandhi, Keith Alan Carson, Jr., Venkata R. Tiruveedi, Anoop George Ninan, Samuil Shmuylovich, Boris Farizon
Life of this patent
Estimating the term…
Abstract
A system detects an event suggesting a data discrepancy between a staging database and a production database that maintain network management data within a network management system. The staging database is logically separate from the production database. The system prevents modification to the production database, and replaces data in the staging database with data from the production database. The system then allows modification to the production database.
Claims20
A computerized device comprising:
- a memory;
- a processor;
- a communications interface;
- an interconnection mechanism coupling the memory, the processor and the communications interface;
- wherein the memory is encoded with a network management data recovering application that when executed on the processor is capable of recovering network management data on the computerized device by performing the operations of:
- detecting an event suggesting a data discrepancy between a staging database and a production database that maintain network management data within a network management system, the staging database logically separate from the production database;
- preventing modification to the production database;
- replacing data in the staging database with data from the production database;
- and
- allowing modification to the production database.
A computer readable medium encoded with computer programming logic that when executed on a process in a computerized device provides network management data recovery, the medium comprising:
- means for detecting an event suggesting a data discrepancy between a staging database and a production database that maintain network management data within a network management system, the staging database logically separate from the production database;
- means for preventing modification to the production database;
- means for replacing data in the staging database with data from the production database;
- and
- means for allowing modification to the production database.
A method for processing network management data, the method comprising:
- detecting an event suggesting a data discrepancy between a staging database and a production database that maintain network management data within a network management system, the staging database logically separate from the production database;
- preventing modification to the production database;
- replacing data in the staging database with data from the production database;
- and
- allowing modification to the production database.
The method of 18 wherein detecting that a database process is attempting to write data to the staging database during the step of replacing data in the staging database with data from the production database comprises:
- determining that the database process has attempted to acquire a lock on a staging table associated with the data that the database process is attempting to write to the staging database;
- and
- allowing the database process to wait to acquire the lock on the staging table.
The method of 18 wherein detecting that a database process is attempting to write data to the staging database during the step of replacing data in the staging database with data from the production database comprises:
- determining that the database process has not attempted to acquire a lock on a staging table associated with the data that the database process is attempting to write data to the staging database;
- and
- aborting the database process attempting to write data to the staging database;
- and
- invoking a database error during the attempt to write data to the staging database.
Dependencies are inferred from the claim text.