Methods and apparatus for synchronizing network management data

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 database synchronizing application that when executed on the processor is capable of synchronizing databases on the computerized device by performing the operations of:
• receiving a dataset for storing in a staging database, the dataset containing storage area network (SAN) management data collected from a managed resource of a SAN wherein receiving the dataset comprises;
• serially receiving a plurality of partitions from an agent operating in a storage area network, each partition containing a respective portion of data for the dataset collected from the managed resource operating in the storage area network, the plurality of partitions received as partitions due to large amounts of data collected from the managed resource by the agent;
• storing the dataset in the staging database wherein storing the dataset in the staging database comprises:
• storing data from each partition into the staging database while the staging database is unsynchronized with the production database and the production database is in a read-only mode, and verifying success of storage of data from each partition to indicate completion of receipt of all data from the dataset;
• maintaining a changeset identifying changes made to the staging database during the step of storing the dataset;
• and
• synchronizing the staging database with the production database using the changeset wherein synchronizing the staging database with the production database comprises:
• determining that success from all partitions in the data has occurred indicating the an entirety of the dataset is present in the staging database prior to synchronizing the staging database with the production database wherein the production database is in a read-write mode during synchronization.

A computer program product including a computer-storage medium encoded with computer programming logic that when executed on a process in a computerized device provides database synchronization, the medium comprising:

• instructions for receiving a dataset for storing in a staging database, the dataset containing storage area network (SAN) management data collected from a managed resource of a SAN wherein receiving the dataset comprises;
• serially receiving a plurality of partitions from an agent operating in a storage area network, each partition containing a respective portion of data for the dataset collected from the managed resource operating in the storage area network, the plurality of partitions received as partitions due to large amounts of data collected from the managed resource by the agent;
• instructions for storing the dataset in the staging database wherein storing the dataset in the staging database comprises:
• storing data from each partition into the staging database while the staging database is unsynchronized with the production database and the production database is in a read-only mode, and verifying success of storage of data from each partition to indicate completion of receipt of all data from the dataset;
• instructions for maintaining a changeset identifying changes made to the staging database during the step of storing the dataset;
• and
• instructions for synchronizing the staging database with the production database using the changeset wherein synchronizing the staging database with the production database comprises:
• determining that success from all partitions in the data has occurred indicating the an entirety of the dataset is present in the staging database prior to synchronizing the staging database with the production database wherein the production database is in a read-write mode during synchronization.