Distributed-processing database-management system

• US 7,143,082 B2
• Filed: 04/01/2002
• Issued: 11/28/2006
• Est. Priority Date: 03/30/2001
• Status: Expired due to Fees

• Current Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Original Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Inventors: Fujihara, Mutsumi, Kamimura, Shuichi
• Primary Examiner(s): Coby, Frantz
• Assistant Examiner(s): Nguyen, Cindy
• Application Number:
  US10/109,640
• Publication Number:
  US 20020184198A1
• Time in Patent Office: 1,702 Days
• Field of Search: 707/204, 707/200, 707/202
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A database-management system easy for system integration and flexible to functional modifications, etc., is provided. A database stored in each main-memory area of a plurality of computers connected via network is managed as follows: a first computer storing original data of at least a piece of data of the database is designated as a base host. At least one second computer storing replica data of the original data is designated as a replica host. A retrieving procedure is performed to receive data to be stored in a third computer from the base host storing the original data or the replica host storing the replica data in startup of the third computer, and store the received data in the main-memory of the third computer.

Claims

1. A method of managing a database stored in each main-memory area of a plurality of computers connected via a network, the database including at least one lexicon set configured to have at least one lexicon, the method comprising:

designating a first computer storing original data of data of the database as an original site;

designating a second computer storing replica data of the original data as a replica site;

performing a retriever function to receive data to be stored in a third computer from the original site storing the original data or the replica site storing the replica data on startup of the third computer, and to store the received data in the main-memory of the third computer, the retriever function being performed by the lexicon set;

setting a list data configured to include the lexicon set and the lexicon to be stored in each computer, the original site storing original data of the lexicon set, and sites to which each computer is to make a request for performing the retriever function for each computer;

storing the list data as original data of a system-administration lexicon set in an original site of the system-administration lexicon set; and

transmitting the system-administration lexicon set to the third computer in startup of the third computer from the original site of the system-administration lexicon set or a replica site storing replica data of the system-administration lexicon set.

2. The method of managing a database according to claim 1, further comprising:

deciding at least one site to which a request for performing the retriever function is to be made from a list data of the lexicon set and the lexicon to be stored in each computer, an original site storing original data of the lexicon set, and sites to which each computer is to make the request, the list being registered in the original site, storing a system-administration lexicon set;

determining whether there is a response from the decided site;

if no response, determining whether a computer that is making the request is the original site storing the system-administration lexicon set;

when the computer that is making the request is the original site, making resident data of the list at the computer that is making the request whereas forming a null system-administration lexicon set at the computer that is making the request if no data exists in the system-administration lexicon set.

3. The method of managing a database according to claim 1, further comprising a transcription procedure to maintain uniformity between the original data at the original site and the replica data at the replica site when all data have been resident in the main-memory area of each computer, and when alteration has been made to the resident data.

4. The method of managing a database according to claim 3, wherein when a predetermined data is resident at each computer and each computer is running, further comprising:

updating data in the system-administration lexicon set at the original site; and

transmitting the updated data in the system-administration lexicon set to each computer to add data to be resident at each computer.

5. The method of managing a database according to claim 3, wherein when predetermined data is resident at each computer and each computer is running, further comprising:

requesting the original site for altering the original data of data of the system-administration lexicon set from the replica site storing the replica data of the system-administration lexicon set;

transmitting the altered data from the original site to each computer to maintain uniformity of information on data to be resident at each computer.

6. A computer readable medium containing an executable program for managing databases including at least one lexicon set configured to have at least one lexicon, the program comprising instructions for;

designating a first computer storing original data of data of a database stored in each main-memory area of a plurality of computers connected via a network, as an original site;

designating a second computer storing replica data of the original data as a replica site;

performing a retriever function to receive data to be stored in a third computer from the original site storing the original data or the replica site storing the replica data on startup of the third computer, and to store the received data in the main-memory of the third computer, the retriever function being performed by the lexicon set;

setting a list data configured to include the lexicon set and the lexicon to be stored in each computer, an original site storing original data of the lexicon set, and sites to which each computer is to make a request for performing the retriever for each computer;

a storing the list data as original data of a system-administration lexicon set in an original site of the system-administration lexicon set; and

transmitting the system-administration lexicon set to the third computer in startup of the third computer from the original site of the system-administration lexicon set or a replica site storing the replica data of the system-administration lexicon set.

7. The computer readable medium containing an executable program according to claim 6, further comprising instructions for:

deciding at least one host to which a request for performing the retriever function is to be made from a list data of the lexicon set and the lexicon to be stored in each computer, an original site storing original data of the lexicon set, and sites to which each computer is to make the request, set at each computer, the list being registered in the original site, storing a system-administration lexicon set;

determining whether there is a response from the decided site;

if no response, determining whether a computer that is making the request is the original site storing the system-administration lexicon set;

when the computer that is making the request is the original site, making resident data of the list at the computer that is making the request whereas forming a null system-administration lexicon set at the computer that is making the request if no data exists in the system-administration lexicon set.

8. The computer readable medium containing an executable program according to claim 6, further comprising instructions for a transcription procedure to maintain uniformity between the original data at the original site and the replica data at the replica site when all data have been resident in the main-memory area of each computer, and when alteration has been made to the resident data.

9. The computer readable medium containing an executable program according to claim 8, wherein when a predetermined data is resident at each computer and each computer is running, further comprising instructions for:

updating data in the system-administration lexicon set at the original site; and

transmitting the updated data in the system-administration lexicon set to each computer to add data to be resident at each computer.

10. The computer readable medium containing an executable program according to claim 8, wherein when predetermined data is resident at each computer and each computer is running, further comprising instructions for:

requesting the original site for altering the original data of the system-administration lexicon set from the replica site storing the replica data of the system-administration lexicon set;

transmitting the altered data from the original site to each computer to maintain uniformity of information on data to be resident at each computer.

11. A database-management system comprising:

at least two computers connected via a network, the computers having main-memory areas storing databases, each database including at least one lexicon set configured to have at least one lexicon as a unit of data to be processed, either of the computers being designated as an original site for storing the original of the data, the other computer being designated as a replica site for storing replica of the data, each computer including;

a resident-data-state setter configured to set a list of at least one computer at which the data is to be resident, the original site storing the original data of the data, and at least one site to which the computer at which the data is to be resident makes a request for a retriever function, the retriever function being performed by the lexicon set; and

a retrieved-data manager configured to transmit the request to the one site in accordance with the setting performed by the resident-data-state setter, the data being transmitted to the computer that is making the request from the original site or the replica site by the retriever function,

wherein the resident-data-state setter includes;

a lexicon-set resident setter configured to set a list of at least one lexicon-set name to be accessed, at least one computer name at which the lexicon set of the data is to be resident, and a retrieving-site name to be used for making the data resident at the one computer;

a lexicon resident-plan setter configured to set the lexicon to be resident at each computer and the lexicon set; and

a lexicon resident-status setter configured to determine whether a lexicon is resident at each computer in accordance with the setting performed by the lexicon-set resident setter.

12. The database-management system according to claim 11, further including a transcription processor configured to maintain uniformity between the original data at the original site and the replica data at the replica site when all data have been resident in the main-memory area of each computer, and when alteration has been made to the resident data.

13. The database-management system according to claim 11, wherein a list of the lexicon set and the lexicon to be resident at each computer, the original site storing the original data of the lexicon set, and at least one site to which each computer makes a request for the retriever function is set per computer, the set data being stored at an original site as original data of a system-administration lexicon set, in startup of each computer, the system-administration lexicon set being transmitted to each computer from the original site storing the original data of the system-administration lexicon set or a replica site storing replica data of the system-administration lexicon set.

14. The database-management system according to claim 13, wherein when predetermined data is resident at each computer and each computer is running, data in the system-administration lexicon set is updated at the original site storing the original data of the system-administration lexicon set, and the updated data in the system-administration lexicon set is transmitted by the transcription processor to each computer.

15. The database-management system according to claim 13, wherein when predetermined data is resident at each computer and each computer is running, data of the system-administration lexicon set is updated at a computer different from the original site storing the original data of the system-administration lexicon set, the updated data being transmitted to the original site storing the original data of the system-administration lexicon set by the transcription processor, the updated data being further transmitted from the original site to each computer to maintain uniformity of information on the lexicon set and lexicon to be resident at each computer.