JP2006164075A - Application system and synchronizing method of distributed data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To improve execution speed by reducing a load on a database server in a hierarchical web system. <P>SOLUTION: An application system comprises the database server 1 for managing database which memorizes master data, one or numerous EJB server 3 which is connected with the database server 1 and performs transaction of business, and a plurality of web servers 5 which is connected with the business transaction server 3 and performs processing of a user interface. Each web server 5 provides a cache memory 55 which memorizes copy data of the master data. The EJB server 3 comprises a DB updating section 33 for updating the master data in response to a data updating request to the database server 1 when one of the web servers 5 receives the data updating request from a user terminal 9, and a synchronous processing section 32 for updating the copy data memorized in the cache memory 55 of the web server 5 so as to coincide with the updated master data. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a technique for improving the processing speed of a hierarchical Web system.

  In a Web system that provides services to many users via the Internet, there is a system consisting of three layers: a Web server that handles a user interface, a business server that executes various application processes, and a database server that manages master data. It's being used.

  Here, the database server often uses relatively expensive and highly reliable hardware, but the business server is usually one to a dozen or so, and the web server is a few to dozens of ordinary personal computers. Often composed. In this manner, load distribution is performed by using a plurality of relatively inexpensive hardware, and the processing performance of the entire Web server is improved while suppressing costs.

When the configuration as described above is adopted, load can be distributed to the business server and the Web server, but the processing is concentrated on the database server. Thus, master data managed by a database server is cached in a Web server or business server to improve processing speed (for example, Patent Document 1).
JP 2004-240575 A

  The data that is cached and used in the Web server or business server is mostly data that is not updated, that is, data that is referred to. This is because, in order to synchronize all the data cached in a plurality of Web servers and business servers, work by an administrator is required.

  Therefore, an object of the present invention is to reduce the load on the database server and improve the processing speed in a hierarchical Web system.

  Another object of the present invention is a technique for continuing processing in a hierarchical Web system without losing consistency even if data cached in a user interface or a server that performs business processing is updated. Is to provide.

  An application system according to an embodiment of the present invention includes a database server that manages a database that stores master data, one or more business processing servers that are connected to the database server and perform business processing, and the one or more business operations A plurality of user interface devices connected to the processing server and performing processing related to the user interface; Each of the plurality of user interface devices includes a storage device that stores copy data of the master data, and an interface unit that provides a user interface screen to the user terminal device based on the copy data stored in the storage device. And comprising. In addition, when one of the plurality of user interface devices receives a data update request from the user terminal device, the one or more business processing servers each receive the master in response to the received data update request from the database server. Master updating means for updating data, and synchronization means for updating copy data stored in the storage devices of the plurality of user interface devices so as to match the updated master data.

  In a preferred embodiment, each of the plurality of user interface devices may validate the copy data updated by the synchronization unit of the business processing server from the time determined by the synchronization unit.

  In a preferred embodiment, when the synchronization means cannot match the copy data stored in the storage device of any one or more user interface devices with the updated master data, the master update means May roll back the update of the master data.

  In a preferred embodiment, each of the one or more business processing servers may cause the processing by the master update unit and the processing by the synchronization unit to be executed as one transaction.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a configuration of a Web system according to the present embodiment. This system is a so-called Web three-tier system for providing a predetermined service to a user terminal device 9 via the Internet 7, and includes a database server (hereinafter referred to as a DB server) 1 that manages master data and a business server. One or a plurality of EJB (Enterprise JavaBeans; Java is a registered trademark) server 3 and a plurality of Web servers 5 that operate a Java servlet and handle a user interface.

  Each of the DB server 1, the EJB server 3, the Web server 5, and the user terminal device 9 is constituted by, for example, a general-purpose computer system. Individual components in the servers 1, 3, 5, and 9 described below Alternatively, the function is realized, for example, by executing a computer program.

  The DB server 1 manages a database that stores master data used by the system.

  The Web server 5 accepts a request from the user terminal device 9 as a user interface device and returns a response thereto. Further, the Web server 5 makes a request corresponding to the request from the user terminal device 9 to the EJB server 3.

  This system includes a plurality of web servers 5, and the load balancer 6 assigns requests from the user terminal device 9 to any web server 5. The configuration of each Web server 5 is common. Accordingly, FIG. 1 shows only one internal configuration of the Web server 5.

  The Web server 5 includes an HTTP (Hyper Text Transfer Protocol) request processing unit 51 and a cache system 53 having a cache memory 55.

  The cache system 53 manages data stored in the cache memory 55. For example, the cache system 53 receives a data read request in the cache memory 55 and reads the data. Further, when a request to store new data in the cache memory 55 is received or a request to update data in the cache memory is received, the cache system 53 performs processing according to each request. The cache memory 55 stores a copy of master data managed by the DB server 1 in units of objects, and is referred to when responding to a request from the user terminal device 9. Here, the copy data stored in the cache memory 55 of each Web server 5 is common. Accordingly, the load balancer 6 allocates the request from the user terminal device 9 to any one of the Web servers 5, but since all the Web servers 5 store the same data in the cache memory 55, which Web server 5 sends the request. Even if accepted, the same processing is executed. Further, when any of the Web servers 5 receives a data update request from the user terminal device 9, the master data and the cached data on all the Web servers 5 are simultaneously updated and synchronized. Processing for synchronizing this data will be described later.

  The request from the user terminal device 9 is made in, for example, an HTTP request format. The HTTP request processing unit 51 executes a predetermined process in response to the HTTP request from the user terminal device 9. For example, if the request from the user terminal device 9 is a reference to data stored in the cache memory 55, the HTTP request processing unit 51 acquires the data from the cache memory 55 and generates a predetermined interface screen. To the user terminal device 9. In addition, when referring to data that does not exist in the cache memory 55 or updating data, the HTTP request processing unit 51 requests processing to the EJB server 3 by calling a predetermined function.

  The EJB server 3 receives a request from the user via the Web server 5 and executes a predetermined business process. In the example of FIG. 1, the present system is configured by two EJB servers 3, but may be one, or three or more.

  The EJB server 3 includes a transaction management unit 31, a synchronization processing unit 32, a DB update processing unit 33, and an object definition storage unit 34 that stores object definition information.

  The transaction management unit 31 executes predetermined processing such as database reference and update as a transaction. For example, the transaction management unit 31 holds a plurality of functions for executing a transaction in advance. Examples of the function include a function for updating master data managed by the DB server 1 and a function for referring to master data. Then, a function called from the HTTP request processing unit 51 of the Web server 5 is executed.

  When the synchronization processing unit 32 receives a database update request from the transaction management unit 31, the synchronization processing unit 32 instructs the database update processing unit 33 to update the master data, and the updated master data contents are used as the cache memory 55 update request. The data is distributed to all the Web servers 5 and the copy data in the cache memory 55 is synchronized.

  For example, when receiving a master data update request from the transaction management unit 31, the synchronization processing unit 32 refers to the object definition storage unit 34, recreates the object, and specifies the object to be updated. Then, the DB update processing unit 33 is instructed to update the object to be updated, and the master data is updated. When the update of the master data is completed, the synchronization processing unit 32 acquires the updated object data from the DB server 1 and notifies all the Web servers 5. At this time, the application time for validating the data to be notified here is also notified. When this application time comes, each cache system 53 validates the notified data. Then, the HTTP request processing unit 51 can refer to the updated data thereafter. This application time ensures that the contents of the cache memory 55 of all the Web servers 5 are always the same without being affected by transfer or processing delay.

  When the updated data is notified, each Web server 5 updates the cache memory 55 based on this data, and matches the contents of the master data and the cache memory 55. When the update of the cache memory 55 is completed, each Web server 5 sends the update completion to the synchronization processing unit 32. Note that, as described above, the contents updated here are not valid until the application time arrives, and at the application time, the above update is simultaneously valid for all Web servers 5 at that time. If the request received before that time has not been processed, the cache at the time the request is received is still valid, and the cache data is updated when the request is completed. To do. As a result, the consistency of the cache data is guaranteed for the request until the processing is completed.

  At this time, the synchronization processing unit 32 determines that the data in all the cache memories 55 do not match when the update completion notification is not received from all the Web servers 5. Then, the transaction management unit 31 rolls back the update of the master data and abnormally ends the transaction. Thereby, in this system, the data distributed on all the cache memories 55 is always synchronized with the master data.

  Based on the instruction from the synchronization processing unit 32, the DB update processing unit 33 instructs the DB server 1 of the object to be updated and the update content, and updates the master data. Note that master data may be stored for each application time. If the master data is held for each application time, when a new Web server is added, it can be set up with the same configuration as other Web servers.

  Next, a processing procedure when updating the master data will be described with reference to the flowchart of FIG.

  First, the Web server 5 receives a master data update request from the user terminal device 9 in the HTTP request format (S11). This HTTP request includes the item name to be updated and the update content.

  Based on this HTTP request, the Web server 5 notifies the EJB server 3 of an update of the master data (S12). In the present embodiment, the HTTP request processing unit 51 calls a function for updating master data in the transaction management unit 31. At this time, the item name to be updated and the update content are set as arguments of the function.

  In the EJB server 3, the transaction manager 31 executes the called function. At this time, the synchronization processing unit 32 recreates the object, and identifies the object including the item name to be updated, which is notified from the transaction management unit 31, as the update target object (S13). Then, the DB update processing unit 33 instructs the DB server 1 to update the master data of the update target object (S14).

  When the update of the master data is completed, the synchronization processing unit 32 notifies the updated master data to all the Web servers 5, and the cache system 53 of each Web server 5 accepts this notification and updates the cache memory 55. (S15). Each cache system 53 returns an update completion notification to the synchronization processing unit 32 when the data update for the broadcast notification is completed.

  The synchronization processing unit 32 receives an update completion notification from the cache system 53 of each Web server 5. Here, it is determined whether or not the update completion notification has been received from all the Web servers 5 (S16). When the above update completion notifications are received from all the Web servers 5 (S16: Yes), the transaction management unit 31 ends the transaction normally and returns a master data update success to the request transmission source (S17). ). On the other hand, when the update completion notification is not received from any one of the Web servers 5 (S16: No), the transaction management unit 31 rolls back the update of the master data (S18). Then, the transaction is terminated abnormally, and a master data update failure is returned to the request transmission source (S19).

  Thereby, the copy data distributed and stored in the cache memory 55 always matches the master data of the DB server 1. This system can improve the processing speed of the entire Web three-tier system by always matching with the master data while being distributed to the Web server 5.

  The above-described embodiments of the present invention are examples for explaining the present invention, and are not intended to limit the scope of the present invention only to those embodiments. Those skilled in the art can implement the present invention in various other modes without departing from the gist of the present invention.

  For example, in the above-described embodiment, the case where the Web server has the cache memory has been described. However, in the same manner when the EJB server has the cache memory, the master data and the data on the cache memory are synchronized. Can be taken.

1 is a configuration diagram of a Web system according to an embodiment of the present invention. It is a flowchart which shows the process sequence of this embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... DB server, 3 ... EJB server, 5 ... Web server, 6 ... Load balancer, 9 ... User terminal device, 31 ... Transaction management part, 32 ... Synchronization processing part, 55 ... Cache memory.

Claims (6)

A database server that manages a database that stores master data, one or more business processing servers that are connected to the database server and perform business processing, and are connected to the one or more business processing servers and perform processing related to a user interface A plurality of user interface devices to perform,
Each of the plurality of user interface devices is
A storage device for storing copy data of the master data;
Interface means for providing a user interface screen to a user terminal device based on copy data stored in the storage device,
Each of the one or more business processing servers is
When one of the plurality of user interface devices receives a data update request from the user terminal device, a master update unit that causes the database server to update the master data according to the received data update request;
An application system comprising: synchronization means for updating copy data stored in storage devices of the plurality of user interface devices so as to match the updated master data. Each of the plurality of user interface devices includes:
2. The application system according to claim 1, wherein the copy data updated by the synchronization unit of the business processing server is validated from a time determined by the synchronization unit.   When the synchronization means cannot match the copy data stored in the storage device of any one or more user interface devices with the updated master data, the master update means The application system according to claim 1, wherein the update is rolled back.   4. The application system according to claim 1, wherein each of the one or more business processing servers causes the processing by the master update unit and the processing by the synchronization unit to be executed as one transaction. 5. A database server that manages a database that stores master data, one or more business processing servers that are connected to the database server and perform business processing, and are connected to the one or more business processing servers and perform processing related to a user interface In an application system comprising a plurality of user interface devices to perform,
Storing copy data of the master data in a storage device included in each of the plurality of user interface devices;
When one of the plurality of user interface devices receives a data update request from the user terminal device, the database server updates the master data in response to the received data update request;
The one or more business processing servers update the copy data stored in the storage devices of the plurality of user interface devices so as to coincide with the updated master data, and synchronize the distributed data Method. A database server that manages a database that stores master data, one or more business processing servers that are connected to the database server and perform business processing, and are connected to the one or more business processing servers and perform processing related to a user interface When executed on an application system with a plurality of user interface devices to perform,
Storing copy data of the master data in a storage device included in each of the plurality of user interface devices;
When one of the plurality of user interface devices receives a data update request from the user terminal device, the database server updates the master data in response to the received data update request;
The one or more business processing servers update the copy data stored in the storage devices of the plurality of user interface devices so as to match the updated master data. Computer program for.

Images