JP2000112807A - Local data base delay updating system and its method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To surely execute the updating of a local data base and the confirmation of consistency even when a server side stops its operation. SOLUTION: A job function part 11 stores the updating information of a host data base(DB) 13 in a local DB 14. After a host side local DB updating control part 12 confirms a communication state, it transmits the stored updating information to a server side local DB updating control part 21. The control part 21 updates a local DB 22 by the transmitted updating information. A client side packaging function part 3 executes a reference only as of the local DB 22. Updated data are blocked and the blocked data are transmitted together with serial number indicating the updating order or the block. Consistency confirmation data can be inserted into an optional position of the updated data independently of the block.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a local database delayed update system, and more particularly, to transferring update information held in a host database to a local database on a server, regardless of the operation state of the server.
The update information is temporarily stored as an update data file in a storage device installed on the host side. If the server is in an operation stop state, the stored update information is resent to the server when the operation is started. A local database deferred update system.

[0002]

2. Description of the Related Art Hitherto, a system that reflects updated contents of a host-side database in a server-side database and obtains data consistency between the two is roughly classified according to the requirements imposed on the system. It was divided into two types. One of the requirements is, contrary to the above function,
This is a case where the updated contents of the server side database need to be reflected in the host side database.
The method adopted in the technique for updating the distributed database disclosed in Japanese Patent No. 4843 is a typical example. Incidentally, the above requirements are the most commonly imposed conditions for a data processing system.

However, in a special case where it is not necessary to reflect the updated contents of the server-side database in the host-side database, the above requirements are greatly relaxed. In general, if some data in the server-side database is updated, it is natural that the host-side database having the same data item also generates an update request due to the consistency relationship. In such a case, it may be considered that none exists.

[0004] However, if it is promised that the server-side database will not receive updates other than the update request from the host side, the above requirements are relaxed. In this case, as a well-known example, Japanese Patent Application Laid-Open No. 7-225
There is a database update system disclosed in Japanese Patent Application Laid-Open No. 709, and a delayed update processing system disclosed in Japanese Patent Application Laid-Open No. 4-102134. In particular, Japanese Unexamined Patent Publication No.
As described later, the delayed update processing method disclosed in Japanese Patent Publication No. 4 is a technology that is established on the premise of a requirement condition further relaxed than the above requirement condition, and the system according to the present invention also has such a configuration. It is satisfied according to the requirements.

[0005] The above-mentioned relaxed requirement condition is a case where the update time of the database on the server side does not necessarily have to be the same as the update time of the database on the host side, and a time delay is allowed. By the way, there are many tasks to which such a case applies in actual tasks. A typical example is that the database on the host side frequently receives real-time updates from business requests, and the database on the server side is later referred to only for statistical processing of its contents. The update method applied in this case is also referred to as a local database delayed update processing method or a local database delayed online update method.

[0006] As a specific example, there is a distinction between an account-based process such as a deposit / saving business in a banking business and an information-based process for providing strategic information.

Incidentally, the above-mentioned Japanese Patent Application Laid-Open No.
The delayed update processing method disclosed in Japanese Patent Application Laid-Open Publication No. H10-209400 is one example of a database update processing method having such a purpose. Conventionally, as shown in the block diagram of FIG. As shown in the block diagram of FIG. 4B, the database update processing performed by one computer is performed by using two computers, that is, a host computer 53-1 and a host computer 53-2. , To reduce the system load.

[0008]

The local database delay update system transmits the same update information as the update information obtained when the business application updates the host database to a database controlled by a server or a client computer. It must be possible to guarantee that it will be sent completely.

[0009] However, the conventional local database delay update system has the following problems. The first problem is that if there is a failure in the server-side implementation function, the local database update data is lost, so that consistency cannot be guaranteed.

[0010] The second problem is that the processing on the host side cannot be stopped in the middle, so that the update processing on the local database and the confirmation of the above-mentioned consistency are not performed.
This cannot be done if the server has stopped operating. In other words, the local database delay update system does not need to be at the same time even if it is called a delay, and when the server wants the server to receive the same update data as the update data in the host-side database, Arrives without interruption due to circumstances. But,
Conventionally, if the server is not in operation at the above time, there is a problem that the server cannot necessarily receive the above-mentioned update data. It was a solution.

A third problem is that the above-mentioned consistency check process cannot be performed at any time during the updating process.

In order to solve the above-mentioned problems, the local database delay update system according to the present invention has a function of managing update data serial numbers in communication between a host and a server, and an optional process for confirming the consistency. The function performed at the time of is also provided.

The present invention has been made in view of the above-mentioned problems in the conventional local database delay update system, and even if the operation of the server is suspended,
It is an object of the present invention to provide a local database delayed update system capable of surely performing local database update and consistency check.

[0014]

To achieve the above object, a local database delay update system according to a first aspect of the present invention comprises a host-side database, a server-side local database, and the host-side database. A local database updating means for transmitting update information for updating the file or its edit result to the server side and delay-update the local database on the server side with the update information or its edit result, and referencing only the local database. A local database update unit having a client-side business execution unit that performs update processing for updating the host-side database or a result of editing the update information in the local database update data file. Database update data storage means, communication possibility determining means for confirming whether communication between the host side and server side is possible, and communication possibility with the server side determined by the communication possibility determining means. In this case, the local database update data stored by the local database update data storage unit is transmitted to the server side, and when it is determined that communication with the server side is impossible by the communication possibility determination unit, Holding the transmission temporarily, after a predetermined interval, and updating the local database on the host side with the transmitted local database update data; And a local database update control unit on the server side.

Here, the local database update data storage means blocks the update information for updating the host-side database or the editing result thereof into blocks which are the minimum update units, and is cut out by the blocking. Each block may have a local database update data storage unit that stores the local database update data file in the order of the serial number indicating the update order.

Further, the local database update control means on the host side requests the next block which matches the update order among the blocks cut out by the blocking means, or a request from the local database update control means on the server side. Block transmission means for transmitting the block thus set to the server side together with a serial number corresponding to the block may be provided.

Further, the local database update control means on the server side receives the block in the local database update data file transmitted together with the serial number, and the received serial number is a block to be updated next in the local database. A serial number confirming means for confirming whether or not the serial number corresponds to the serial number, and if confirmation is obtained by the serial number confirming means, update the block in the local database corresponding to the serial number with the received block. If the above confirmation is not obtained, the received block is ignored and a serial number corresponding to the next block to be updated in the local database is transmitted to the local database update control means on the host side. You may make it have a block update means.

Further, the local database update control means on the host side, before or after the transmission of an arbitrary block in the local database update data file, makes a connection between the database on the host side and the local database on the server side. The server further includes a consistency check data transmitting unit that can transmit consistency check data for checking the consistency of contents to the server side, and the local database update control unit on the server side includes the consistency check unit. When receiving the data for verification, the data in the current local database is verified using the data for consistency check, and the integrity verification data corresponding to the data for consistency check is read from the local database on the host side. You may make it have the consistency verification data transmission means which transmits to an update control means.

The local database delayed update method according to a second aspect of the present invention provides a host-side database, a server-side local database, and update information for updating the host-side database or an edit result thereof. A local database updating step of delaying and updating the local database on the server side with the update information or the editing result thereof by transmitting to the server side, and a client-side business execution step of performing only reference on the local database. In the delayed update method, the local database update step stores local database update data for storing update information for updating the host-side database or an edit result thereof in a local database update data file. Step, a communication possibility determining step for confirming whether communication between the host side and the server side is possible, and if it is determined that communication with the server side is possible by the communication possibility determining step, Transmitting the local database update data accumulated in the local database update data accumulation step to the server side, and temporarily suspending the transmission when the communication possibility determination step determines that communication with the server side is impossible; West,
A host-side local database update control step of repeatedly trying the transmission at predetermined intervals, and a server-side local database update for updating the server-side local database with the transmitted local database update data And a control step.

Here, in the local database update data accumulating step, the update information for updating the host side database or its editing result is divided into blocks which are the minimum unit of update, and the blocks are cut out by the blocking. Each block may include a local database update data storage step of storing the local database update data file in the order of the serial number indicating the update order.

[0021] The local database update control step on the host side comprises: blocking data in the local database update data file in update units;
A blocking step of storing the blocks cut out by the blocking in the order of serial numbers indicating the update order; and, of the blocks cut out by the blocking step, the next block that matches the update order, or the server side And transmitting a block requested from the local database update control step to the server together with a serial number corresponding to the block.

The local database update control step on the server side receives the block in the local database update data file transmitted together with the serial number, and the received serial number is a block to be updated next in the local database. A serial number confirming step for confirming whether or not the serial number corresponds to the serial number, and if confirmation is obtained by the serial number confirming step, update the block in the local database corresponding to the serial number with the received block. If the above confirmation is not obtained, the received block is ignored and a serial number corresponding to the next block to be updated in the local database is transmitted to the local database update control step on the host side. A block update step may be provided.

Further, the local database update control step on the host side includes, before or after the transmission of an arbitrary block in the local database update data file, the connection between the host side database and the server side local database. A data transmission step for confirming the consistency of the contents, the data transmission step for consistency confirmation being capable of transmitting the data for consistency confirmation to the server side, wherein the local database update control step on the server side comprises the consistency confirmation When receiving the data for verification, the data in the current local database is verified using the data for consistency check, and the integrity verification data corresponding to the data for consistency check is read from the local database on the host side. Having an integrity verification data transmission step for transmitting to the update control step Unishi may be.

[0024]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing an overall configuration of a local database delayed update system according to an embodiment of the present invention.

The local database delayed update system according to the present embodiment includes a host-side implementation function unit 1 including a host-side database 13 and a local database update data file 14, and a server-side local database 2
2 and a client-side mounting function unit 3 mounted on a terminal.

The host mounting function unit 1 includes a host-side database 13 and a local database update data file 1.
And a local database update control unit 12 for transferring update data in the local database update data file 14 to the server.

The server-side mounting function unit 2 includes a local database update control unit 21 that controls writing of update data to the local database 22.

The client-side mounting function 3 includes a client input / output control unit 31 for controlling when referring to data on the local database 22 and a client business function unit 32 for performing a client-side task by referring to the data. It has.

The business function unit 11 writes the update data itself that has updated the host-side database 13 or the result of editing the update data into the local database update data file 14 as local database update data.

The local database update control unit 12
The state of the local database update data file 14 is monitored at regular intervals, and if there is data to be transmitted, the local database update data is transmitted to the local database update control unit 21 of the server-side mounting function unit 2. .

The local database update control unit 21
The local database 22 is updated using the received local database update data as a transaction.

The client input / output control unit 31 performs input / output control on the local database 22, but allows only reference, and updates are performed by the local database update control unit 21 to the extent that it gets tired. The client business function unit 32
An interface with the terminal user is performed, and a request for referencing the local database to the client input / output control unit 31 is also performed based on the input contents.

The functions of the above components will be described in more detail.
The business function unit 11 updates the host-side database 13 according to the contents of the online transaction. At this time, the local database update data is also output to the local database update data file 14 at the same time.

At the time of the above output, the update information for updating the host-side database 13 or the editing result thereof is divided into blocks that are the minimum update units, and the blocks cut out by the blocking are updated in the update order. Are stored in the local database update data file 14 in the order of the serial numbers indicating

The local database update control unit 12
The local database update data file 14 is periodically monitored, and when there is local database update data to be transmitted, the local database update data is transmitted to the local database update control unit 21 in the server-side mounting function unit 2. At this time, if the operation of the server-side implemented function unit 2 is suspended, a transmission start instruction is not responded to the server-side implemented function unit 2, and the transmission is suspended.

When the local database update data can be received from the local database update controller 12 of the host-side implemented function unit 1, the local database update controller 21 of the server-side implemented function unit 2 transmits the received local database update data. The local database 22 is updated according to the contents. In addition, the data to be received can include data for consistency check,
The consistency of the database between the servers can be confirmed using the consistency confirmation data.

With the above-described mechanism, even when the server-side mounting function unit 2 is stopped, the local database update data is stored in the local database update data file 14 on the host side. To maintain the integrity of the database between the host and server.

FIG. 2 is a procedure chart showing a communication procedure between the host and the server in the local database delay update system according to the embodiment of the present invention. Hereinafter, the communication procedure between the host and the server will be described using the procedure chart shown in FIG. 2 with reference to FIG.

The local database update data edited by the business function unit 11 is output to a local database update file.

The update data stored in the local database update file is stored in a predetermined order for each serial number. The serial number guarantees the update order.

The local database update control unit 12 on the host side monitors the local database update data file at regular time intervals, extracts the stayed local update data, and sends it to the local database update control unit 21 on the server side. Try. Prior to the attempt, the local database update control unit 12 sends a communication start instruction to the server-side local database update control unit 21 in step S1. If a start response corresponding to the start instruction is not returned from the local database update control unit 21 on the server side to the local database update control unit 12 in step S2, the local database update control unit 12
Determines that the server is in operation suspension, and temporarily suspends communication with the local database update control unit 21 on the server. Local database update control unit 21
Transmission of the above-mentioned start instruction can be repeatedly performed with a predetermined interval time if necessary.

The start response from the local database update control unit 21 corresponding to the above start instruction can include a serial number indicating a block to be updated next. When communication between the host and server is established, step S3
Then, the local update data is transmitted together with the serial number from the local database update control unit 12 on the host side to the local database update control unit 21 on the server side.

The local database update control unit 21
When the local update data is received, the transmitted serial number is compared with the latest updated message serial number, and if the transmitted serial number is the next serial number following the latest updated serial number,
The local database 22 is updated with the local update data. However, if the serial number attached to the local database update data transmitted from the host is larger than the serial number next to the latest updated message serial number, the transmitted local database update data is discarded, and at step S4 The local database update control unit 12 on the host side requests local database update data of the serial number next to the updated message serial number. Also, above,
If the serial number of the local database update data sent from the host is smaller than the updated message serial number, the local database update data is continuously discarded until the updated message serial number, and the local number is changed from the time when the next message number following the updated message serial number is sent. Update the database.

The above-described communication process between the host and the server is performed until all the local database update data in the local database update data file is exhausted, observing the serial number indicating the update order.

In the above communication procedure, a request for consistency check may be inserted into the local database update data in response to a request from the business function unit 11.
The local database update control unit 21 processes this in the same manner as conventional local database update data. When performing the consistency check request process, the local database update process is temporarily stopped and the local database 2
2 (for example, balance information), and after the tally is completed, the local database update process is restarted. The total result of the contents of the local database 22 is stored in the business function unit 1
1 and the business function unit 11 compares the result with the tally result.

The client input / output control unit 31 refers to the contents of the local database in response to a request from the client business function unit 32. Update processing is performed by the local database update control unit 21.
The client promises not to renew.

In the present embodiment, it is assumed that the host-side mounting function unit 1 and the server-side mounting function unit 1 exist on the same computer system. Is, as shown in the block diagram of FIG.
Both may exist on different computer systems. Also, the client computer can be installed independently of the above two computers.

[0048]

As described above, according to the local database delay update system according to the present invention, the host side does not stop at the operation stop state of the server side.
Update processing of the local database can be performed. Further, since the host side and the server side perform the serial number management of the update data and transmit and receive the local database update data, it is possible to prevent the serial numbers from being missed and to improve the reliability of the consistency assurance. Further, since the consistency check process can be requested at any time, the reliability of the consistency assurance can be further improved.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an overall configuration of a local database delayed update system according to an embodiment of the present invention.

FIG. 2 is a procedure chart showing a communication procedure between a host and a server in the local database delay update system according to the embodiment of the present invention.

FIG. 3 is a block diagram showing another overall configuration of the local database delayed update system according to the embodiment of the present invention.

FIG. 4 is a block diagram of a conventional delay update processing method disclosed in Japanese Patent Application Laid-Open No. 4-102134.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 Host-side implementation function unit 2 Server-side implementation function unit 3 Client-side implementation function unit 11 Business function unit 12 Local database update control unit 13 Host-side database 14 Local database update data file 21 Local database update control unit 22 Local database 31 Client input Output control unit 32 Client business function unit

Claims (10)

[Claims] 1. A host-side database, a server-side local database, and update information for updating the host-side database or an edited result thereof are transmitted to the server side to obtain the update information or the edited result. A local database update unit that delay-updates the local database on the server side; and a local database delay update system that includes a client-side business execution unit that performs only reference to the local database, wherein the local database update unit includes the host-side database A local database update data storage unit for storing update information for updating the file or its edit result in a local database update data file; and a communication possibility determination for confirming whether communication between the host side and the server side is possible. hand When the communication possibility determination unit determines that communication with the server is possible, the local database update data stored by the local database update data storage unit is transmitted to the server side, and the communication is enabled. If the gender judging means judges that the communication with the server is impossible, the transmission is temporarily suspended, and after a predetermined interval time, the local database update control means on the host side which repeatedly tries the transmission. And a server-side local database update control means for updating the server-side local database with the transmitted local database update data. 2. The local database update data accumulating means divides update information for updating the host-side database or its edit result into blocks each serving as a minimum unit of update, and cuts out each of the blocks cut out by the blocking. 2. The local database delay update system according to claim 1, further comprising: a local database update data accumulation unit that accumulates the blocks in the order of a serial number indicating an update order in the local database update data file. 3. The local database update control means on the host side receives a request from the local database update control means on the server side or a block which matches the update order among the blocks cut out by the blocking means. 3. The local database delay update system according to claim 1, further comprising: a block transmission unit configured to transmit a block to the server together with a serial number corresponding to the block. 4. The local database update control means on the server side receives a block in the local database update data file transmitted together with a serial number, and the received serial number is a block to be updated next in the local database. A serial number confirming means for confirming whether or not the serial number corresponds to the serial number.If the serial number confirming means confirms, a block in the local database corresponding to the serial number is updated with the received block. If the above confirmation is not obtained, the received block is ignored and a serial number corresponding to the next block to be updated in the local database is transmitted to the local database update control means on the host side. The block updating device according to claim 1, further comprising: a block updating unit. Cal database delay update system. 5. The local database update control means on the host side, before or after transmission of an arbitrary block in the local database update data file,
The host-side database and the server-side local database, including a consistency-confirmation data transmission unit that can transmit consistency-confirmation data for confirming the consistency of the contents to the server side; The server-side local database update control means:
When receiving the consistency check data, the data in the current local database is verified using the consistency check data, and the consistency verification data corresponding to the consistency check data is transmitted to the host. The local database delay update system according to any one of claims 1 to 4, further comprising consistency verification data transmission means for transmitting the data to the local database update control means on the side. 6. A host-side database, a server-side local database, and update information for updating the host-side database or an edit result thereof are transmitted to the server side to obtain the update information or the edit result. A local database update step of performing a delayed update of the server-side local database; and a local database delayed update method having a client-side business execution step of performing only reference to the local database, wherein the local database update step includes: Storing local database update data in the local database update data file to store update information for updating the file or the editing result thereof, and communication for confirming whether communication between the host side and the server side is possible. Performance determination step, and when it is determined that communication with the server is possible by the communication possibility determination step, the local database update data stored in the local database update data storage step is transmitted to the server side. If the communication possibility determination step determines that communication with the server is impossible, the host temporarily suspends the transmission, waits for a predetermined interval, and repeatedly attempts the transmission. A local database update control method, comprising: a database update control step; and a server-side local database update control step of updating the server-side local database with the transmitted local database update data. 7. The local database update data accumulating step, wherein update information for updating the host-side database or an editing result thereof is divided into blocks each serving as a minimum unit of update, and each of the cut-out blocks is extracted. The local database update data storage method according to claim 6, further comprising: a local database update data storage step of storing blocks in the local database update data file in order of a serial number indicating an update order. 8. The local database update control step on the host side includes, among the blocks cut out in the blocking step, blocks that match the update order;
Or a block transmission step of transmitting a block requested from the local database update control step on the server side to the server side together with a serial number corresponding to the block, the local block according to claim 6 or 7, wherein Database deferred update method. 9. The server-side local database update control step includes: receiving a block in the local database update data file transmitted together with a serial number, and setting the received serial number to a next block to be updated in the local database. A serial number confirming step for confirming whether or not the serial number corresponds to the serial number.If the serial number confirming step confirms, a block in the local database corresponding to the serial number is updated with the received block. If the above confirmation is not obtained, the received block is ignored and a serial number corresponding to the next block to be updated in the local database is transmitted to the local database update control step on the host side. A block updating step; and Local Database delay updating method according to 6 or 8. 10. The host-side local database update control step includes, before or after the transmission of an arbitrary block in the local database update data file, the connection between the host-side database and the server-side local database. A data transmission step for transmitting consistency check data for confirming the consistency of the contents to the server; and a local database update control step on the server side, wherein the consistency check is performed. When receiving the data for verification, the data in the current local database is verified using the data for consistency check, and the integrity verification data corresponding to the data for consistency check is read from the local database on the host side. Having an integrity verification data transmission step for transmitting to the update control step; Local Database delay updating method according to any one of claims 6 to 9, wherein.