SYSTEM AND METHOD FOR PRODUCING DATA REPLICA

Abstract

In a method of producing a data replica, data processing requests are issued from application programs running in application servers. Data processing corresponding to each of the data processing requests is executed in each of database servers, and a result of the data processing is replied as a response to one of the application programs which has issued the data processing request. The supply of the data processing requests to the database servers is controlled to keep the process order of the requests between the database servers.

Description

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a block diagram showing the configuration of a conventional data replica producing system;

FIG. 2 is a diagram of the problem of the conventional data replica producing system.

FIG. 3 is a block diagram showing a configuration of a data replica producing system according to a first embodiment of the present invention;

FIGS. 4A to 4E are a flow chart showing an operation of the data replica producing system in the first embodiment of the present invention;

FIG. 5 is a block diagram showing the configuration of the data replica producing system according to a second embodiment of the present invention;

FIGS. 6A to 6G are a flow chart showing an operation of the data replica producing system in the second embodiment of the present invention;

FIG. 7 is a block diagram showing the configuration of the data replica producing system according to a third embodiment of the present invention;

FIGS. 8A to 8D are a flow chart showing an operation of the data replica producing system in the third embodiment of the present invention;

FIG. 9 is a block diagram showing the configuration of the data replica producing system according to a fourth embodiment of the present invention;

FIGS. 10A to 10G are a flow chart showing an operation of the data replica producing system in the fourth embodiment of the present invention;

FIG. 11 is a block diagram showing the configuration of the data replica producing system according to a fifth embodiment of the present invention;

FIGS. 12A to 12I are a flow chart showing an operation of the data replica producing system in the fifth embodiment of the present invention;

FIG. 13 is a block diagram showing the configuration of the data replica producing system according to a sixth embodiment of the present invention;

FIGS. 14A to 14G are a flow chart showing the operation of the data replica producing system in the sixth embodiment of the present invention;

FIG. 15 is a block diagram showing a modification in a 1 to N configuration;

FIG. 16 is a block diagram showing modification in an N to 1 configuration;

FIG. 17 is a block diagram showing a modification in an N to M configuration;

FIG. 18 is a block diagram showing a modification of a chain configuration; and

FIG. 19 is a block diagram showing a modification in mutual configuration.

Claims

1. A method of producing a data replica, comprising: issuing data processing requests from application programs running in application servers;executing data processing corresponding to each of said data processing requests in each of database servers;replying a result of the data processing as a response to one of said application programs which has issued said data processing request; andcontrolling supply of said data processing requests to said database servers.

2. The method according to claim 1, wherein said issuing comprises: trapping the issued data processing requests; andmultiplexing the trapped data processing request in response to process permission,said controlling comprises:requesting process permission of the trapped data processing request; andgenerating said process permission based on previous data processing requests in response to the request of said process permission.

3. The method according to claim 2, wherein said executing comprises: converting said multiplexed data processing request into a data processing request peculiar to a database management system of each of said database servers, andsaid replying comprises:converting the data processing result into a data processing response as the response to said application program which has issued said data processing request.

4. The method according to claim 1, wherein said controlling comprises: detecting that one of the data processing requests reaches each of said database servers; andsupplying a next one of the data processing requests to said database servers when it is detected that said one data processing request reaches each of said database servers.

5. The method according to claim 1, wherein said controlling comprises: receiving the data processing result as the response from each of said database servers to said application program which has issued said data processing request; andsupplying a next one of the data processing requests to said database servers when the responses are received from said database servers.

6. A data replica producing system comprising: one or more application servers; anddatabase servers,wherein each of said database servers comprises:a storage configured to store data; anda database management system configured to manage data of said storage, execute a data processing request to reply a processing result as a data processing response,each of said application servers comprises an application program executed to issue the data processing request,said data replica producing system further comprises:an order control section configured to control supply of the data processing requests to said database servers such that a process order of the data processing requests is same between said database servers.

7. The data replica producing system according to claim 6, wherein said order control section permits the supply of the data processing requests to said database servers one by one in response to completion notices from said database servers.

8. The data replica producing system according to claim 7, wherein each of said application servers further comprises: a middle ware section configured to generate a permission request to said order control section when each of said data processing requests is received, transfers the completion notices from said database servers to said order control section, and supplies one of the data processing requests corresponding to supply permission from said order control section to said database servers, andsaid order control section controls said application servers by issuing the supply permission.

9. The data replica producing system according to claim 8, wherein said middle ware section further comprises: a database connecting section provided for each of said database servers to convert the data processing request corresponding to the supply permission into a data processing request peculiar to the database management system of said database server, and to convert the data processing response from said database server into a response to said application program which has issued said data processing request.

10. The data replica producing system according to claim 8, wherein each of said database servers further comprises: a database connecting section configured to convert the data processing request corresponding to the supply permission into a data processing request peculiar to the database management system of said database server, and to convert the data processing response from said database server into a response to said application program which has issued said data processing request.

11. The data replica producing system according to claim 7, further comprising: a request control section provided for said application servers to generate a permission request to said order control section when each of said data processing requests is received, transfers the completion notices from said database servers to said order control section, and supplies one of the data processing requests corresponding to supply permission from said order control section to said database servers, andsaid order control section controls said application servers by issuing the supply permission.

12. The data replica producing system according to claim 11, wherein said middle ware section further comprises: a database connecting section provided for each of said database servers to convert the data processing request corresponding to the supply permission into a data processing request peculiar to the database management system of said database server, and to convert the data processing response from said database server into a response to said application program which has issued said data processing request.

13. The data replica producing system according to claim 11, wherein each of said database servers further comprises: a database connecting section configured to convert the data processing request corresponding to the supply permission into a data processing request peculiar to the database management system of said database server, and to convert the data processing response from said database server into a response to said application program which has issued said data processing request.

14. The data replica producing system according to claim 6, wherein said order control section comprises negotiating sections provided for said application servers, respectively, said negotiating section negotiates with the other negotiating sections to permit the supply of the data processing requests to said database servers one by one in response to completion notices from said database servers.

15. The data replica producing system according to claim 14, wherein each of said application servers further comprises: a middle ware section configured to generate a permission request to said order control section when each of said data processing requests is received, transfers the completion notices from said database servers to said order control section, and supplies one of the data processing requests corresponding to supply permission from said order control section to said database servers, andsaid order control section controls said application servers by issuing the supply permission.

16. A computer-readable software product for realizing a method of producing a data replica, wherein said method comprising: issuing data processing requests from application programs running in application servers;executing data processing corresponding to each of said data processing requests in each of database servers;replying a result of the data processing as a response to one of said application programs which has issued said data processing request; andcontrolling supply of said data processing requests to said database servers.

17. The software product according to claim 16, wherein said issuing comprises: trapping the issued data processing requests; andmultiplexing the trapped data processing request in response to process permission,said controlling comprises:requesting process permission of the trapped data processing request; andgenerating said process permission based on previous data processing requests in response to the request of said process permission.

18. The software product according to claim 17, wherein said executing comprises: converting said multiplexed data processing request into a data processing request peculiar to a database management system of each of said database servers, andsaid replying comprises:converting the data processing result into a data processing response as the response to said application program which has issued said data processing request.

19. The software product according to claim 16, wherein said controlling comprises: detecting that one of the data processing requests reaches each of said database servers; andsupplying a next one of the data processing requests to said database servers when it is detected that said one data processing request reaches each of said database servers.

20. The software product according to claim 16, wherein said controlling comprises: receiving the data processing result as the response from each of said database servers to said application program which has issued said data processing request; andsupplying a next one of the data processing requests to said database servers when the responses are received from said database servers.