IPC분류정보
국가/구분 |
United States(US) Patent
등록
|
국제특허분류(IPC7판) |
|
출원번호 |
UP-0477026
(2006-06-28)
|
등록번호 |
US-7689565
(2010-04-23)
|
발명자
/ 주소 |
- Gandhi, Rajesh K.
- Carson, Jr., Keith Alan
- Tiruveedi, Venkata R.
|
출원인 / 주소 |
|
대리인 / 주소 |
|
인용정보 |
피인용 횟수 :
12 인용 특허 :
4 |
초록
▼
A system receives a dataset for storing in a staging database. The dataset contains network management data collected from a managed resource. The system stores the dataset in the staging database, and maintains a changeset identifying changes made to the staging database during the step of storing
A system receives a dataset for storing in a staging database. The dataset contains network management data collected from a managed resource. The system stores the dataset in the staging database, and maintains a changeset identifying changes made to the staging database during the step of storing the dataset. The system synchronizes the staging database and the production database with each other using the changeset.
대표청구항
▼
What is claimed is: 1. A method of synchronizing a staging database with a production database, the method comprising: 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 receivin
What is claimed is: 1. A method of synchronizing a staging database with a production database, the method comprising: 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. 2. The method of claim 1 wherein storing the dataset in the staging database comprises: invoking transaction processing to begin a transaction of transmitting the dataset at the staging database; identifying that the dataset is comprised of the plurality of partitions; for each partition within the plurality of partitions, performing the steps of: invoking partition processing to begin transmission of the partition to the staging database; upon successful completion of the partition processing, invoking commit partition processing to commit the partition to the staging database; upon successful completion of the commit partition processing for each of the partitions within the plurality of partitions, invoking commit transaction processing to commit the transaction of receiving the dataset at the staging database; detecting an error associated with the partition process; invoking abort partition processing to terminate the partition processing; and invoking abort transaction processing to terminate the transaction processing of receiving the dataset at the staging database. 3. The method of claim 1 wherein the staging database is comprised of a plurality of staging tables and wherein storing the dataset in the staging database comprises: storing a data record, from the dataset, in at least one staging table from the plurality of staging tables; recording at least one changeset record in a changeset table, the at least one changeset record associated with the data record stored in the at least one staging table, the changeset table tracking changes made to the at least one staging table in the staging database; and recording a transaction record in a transaction table, the transaction record associated with the at least one changeset record, the transaction table tracking a status of the at least one changeset record in the changeset table. 4. The method of claim 3 wherein recording at least one changeset record in a changeset table comprises: for each staging table in the plurality of staging tables where a data record has been stored, invoking a changeset processing that begins the process of recording the at least one changeset record in the changeset table. 5. The method of claim 3 wherein recording a transaction record in a transaction table comprises: for each of the at least one changeset records recorded in the changeset table, invoking transaction record processing that begins the process of recording the transaction record in the transaction table, the recording of the transaction record including: i) a transaction identifier identifying the at least one changeset record, and ii) a transaction status indicating the process of storing the dataset in the staging database is in progress. 6. The method of claim 1 wherein the staging database is comprised of a plurality of staging tables and wherein synchronizing the staging database with the production database using the changeset comprises: identifying a hierarchy among the plurality of staging tables, the hierarchy defined by relationships between managed resources in a storage area network from which the dataset is collected; identifying a sequential order in which to synchronize the dataset from the staging database to the production database based on the hierarchy; and copying the dataset from the staging database to the production database according to the sequential order. 7. The method of claim 6 wherein the plurality of staging tables includes at least one first table and at least one second table, and wherein identifying a hierarchy among the plurality of staging tables comprises: identifying a primary key in the at least one first staging table within the plurality of staging tables; identifying the primary key in the at least one first staging table is a foreign key in the at least one second staging table; and based on a relationship of the primary key and the foreign key, identifying that the at least one second staging table maintains a higher position than the at least one first staging table within the hierarchy among the plurality of staging tables. 8. The method of claim 7 wherein copying the dataset from the staging database to the production database according to the sequential order comprises: identifying, in the dataset, a data record to be deleted from a second staging table in the production database; deleting the data record from a first staging table in the production database; and following the deletion of the data record from the first staging table in the production database, deleting the data record in the second staging table in the production database. 9. The method of claim 7 wherein copying the dataset from the staging database to the production database according to the sequential order comprises: identifying, in the dataset, a data record to be inserted into a first staging table in the production database; inserting the data record in a second staging table in the production database; and following the insertion of the data record in the second staging table in the production database, inserting the data record in the first staging table in the production database. 10. The method of claim 6 wherein the plurality of staging tables includes at least one first table and at least one second table, and wherein identifying a hierarchy among the plurality of staging tables comprises: identifying a self-referencing relationship between staging tables by: identifying a primary key in the at least one first staging table is a foreign key in the at least one second staging table; and identifying a primary key in the at least one second staging table is a foreign key in the at least one first staging table. 11. The method of claim 10 wherein copying the dataset from the staging database to the production database according to the sequential order comprises: identifying, in the dataset, a data record to be updated in a first staging table in the production database; nullifying the foreign key in the at least one second staging table; nullifying the foreign key in the at least one first staging table; updating the data record in the first staging table in the production database; following the updating of the data record in the first staging table in the production database, setting the foreign key in the at least one second staging table to the primary key in the at least one first staging table; and setting the foreign key in the at least one first staging table to a primary key in the at least one second staging table. 12. The method of claim 1 wherein synchronizing the staging database with the production database using the changeset comprises: invoking changeset table processing that identifies at least one transaction status associated with at least one transaction record in a transaction table, the at least one transaction record associated with a data record copied from the staging database to the production database, the transaction status indicating the process of storing the data record in the production database is in progress; deleting at least one changeset record in a changeset table, the at least one changeset record associated with the at least one transaction record having a transaction status; and modifying the transaction status to include at least one of i. a success indicating a successful copying of the data record from the staging database to the production database; and ii. an error indicating an unsuccessful copying of the data record from the staging database to the production database. 13. 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. 14. The computerized device of claim 13 wherein the staging database is comprised of a plurality of staging tables and wherein when the computerized device performs the operation of storing the dataset in the staging database, the computerized device is capable of performing the operation of: storing a data record, from the dataset, in at least one staging table from the plurality of staging tables; recording at least one changeset record in a changeset table, the at least one changeset record associated with the data record stored in the at least one staging table, the changeset table tracking changes made to the at least one staging table in the staging database; and recording a transaction record in a transaction table, the transaction record associated with the at least one changeset record, the transaction table tracking a status of the at least one changeset record in the changeset table. 15. The computerized device of claim 14 wherein when the computerized device performs the operation of recording a transaction record in a transaction table, the computerized device is capable of performing the operation of: for each of the at least one changeset records recorded in the changeset table, invoking transaction record processing that begins the process of recording the transaction record in the transaction table, the recording of the transaction record including: i) a transaction identifier identifying the at least one changeset record, and ii) a transaction status indicating the process of storing the dataset in the staging database is in progress. 16. The computerized device of claim 13 wherein when the computerized device performs the operation of synchronizing the staging database with the production database using the changeset, the computerized device is capable of performing the operation of: invoking changeset table processing that identifies at least one transaction status associated with at least one transaction record in a transaction table, the at least one transaction record associated with a data record copied from the staging database to the production database, the transaction status indicating the process of storing the data record in the production database is in progress; deleting at least one changeset record in a changeset table, the at least one changeset record associated with the at least one transaction record having a transaction status; and modifying the transaction status to include at least one of i) a success indicating a successful copying of the data record from the staging database to the production database; and ii) an error indicating an unsuccessful copying of the data record from the staging database to the production database. 17. 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. 18. The method of claim 1, wherein the staging database is comprised of a plurality of staging tables, a changeset table, and a transaction table, and wherein storing the dataset in the staging database comprises: storing a data record, from the dataset, in at least one staging table from the plurality of staging tables; recording at least one changeset record in the changeset table, the at least one changeset record associated with the data record stored in the at least one staging table, the changeset table tracking changes made to the at least one staging table in the staging database; and recording a transaction record in the transaction table, the transaction record associated with the at least one changeset record, the transaction table tracking a status of the at least one changeset record in the changeset table; and wherein synchronizing the staging database to the production database using the changeset comprises: identifying a hierarchy among the plurality of staging tables, the hierarchy defined by relationships between managed resources in a storage area network from which the dataset is collected; identifying a sequential order in which to synchronize the dataset from the staging database to the production database based on the hierarchy; and invoking changeset table processing that identifies at least one transaction status associated with at least one transaction record in a transaction table, the at least one transaction record associated with a data record copied from the staging database to the production database, the transaction status indicating the process of storing the data record in the production database is in progress; copying the dataset from the staging database to the production database according to the sequential order; deleting at least one changeset record in a changeset table, the at least one changeset record associated with the at least one transaction record having a transaction status; and modifying the transaction status. 19. The method of claim 18, comprising: periodically deleting records in the transaction table that have a success status indicating a successful copying of the data record from the staging database to the production database; and periodically deleting records in the transaction table that have an error status indicating an unsuccessful copying of the data record from the staging database to the production database.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.