JP2002132562A - Database update system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database update system which allows updating data instantaneously between a plurality of servers having databases, respectively. SOLUTION: The system updates data of databases 14A-14D arranged in respective servers 1A-1D between the plurality of servers 1A-1D being connected through a network. The system starts up automatically when the data of a first database 14A in a first server 1A is updated to access the second server 1B. For the second database 14B of the second server 1B, data updating means 3A-3D are provided for executing data update corresponding to the data update of the first database 14A. Therefore, when there is data update in the first database 14A in the first server 1A, the data of the second to the fourth database 14B-14D in the second to the fourth servers 1B-1D are instantaneously updated. Accordingly, there are no time lag of the data update and disorder of data between respective servers 1A-1D and databases 14A-14D.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database update system capable of immediately updating data between a plurality of servers each having a database.

[0002]

2. Description of the Related Art Hitherto, a package system for a core business such as order management, inventory management, sales management and the like, which is executed by a general-purpose computer device, has been performed using one database in one computer device.

[0003] However, in each of operations such as order management, inventory management, sales management, and the like, as the data volume increases, it becomes impossible to manage with one device and one database. Therefore, a system in which a server and a database are provided for each of operations such as order management, inventory management, and sales management, and a core business is performed by a plurality of devices has been constructed.

[0004]

However, in a system using a plurality of servers and databases, a time lag may occur in updating data between each server and database. In addition, there is a possibility that data may be corrupted among a plurality of databases. For this reason, it was necessary to set 〆 days for each fixed period, and to adjust the data update status and errata on 〆 day. In addition, in the above-mentioned conventional system, each server exists independently of the system of the supplier or the like from which the update data is transmitted, so that the data to be updated is adapted from the data format of the supplier to this device. It was necessary to convert to the format to do.

[0005] The present invention has been made in view of such circumstances, and has as its object to provide a database update system capable of immediately updating data among a plurality of servers each having a database.

[0006]

To achieve the above object, a database updating system according to the present invention updates a database provided in each server among a plurality of servers connected via a network. An update system, which automatically starts up when a first database in a first server is updated and accesses a second server, and updates the second database of the second server to update the data of the first database. The point is that a data updating means for updating data corresponding to the above is provided.

That is, the database updating system of the present invention automatically starts up when the first database in the first server is updated, accesses the second server, and updates the second database of the second server. And data updating means for updating data corresponding to data updating of the first database. Therefore, when data is updated in the first database in the first server, the data in the second database in the second server is immediately updated. Therefore, there is almost no time lag in updating the data between each server and the database, and the data is not disordered among a plurality of databases. Therefore, unlike the related art, it is not necessary to set 〆 days for each fixed period and adjust the data update status and the irregularity on 〆 day.

[0008] In the database updating system of the present invention, there are three or more servers provided with a database,
When the database of each server can be sequentially updated, data can be updated immediately among three or more servers.

In the database updating system of the present invention, when the first server exists on the World Wide Web, the data format of the first server is unified with the data format of the system from which the update data originated. In such a case, it is not necessary to convert the data to be updated from the data format of the business partner or the like to a format compatible with this device.

In the database updating system according to the present invention, when servers other than the first server exist in the local area network, it becomes easy to carry out the core business using the existing server, and the system construction is improved. Initial investment is small.

In the database updating system according to the present invention, when a result transmitting means for transmitting an update result from the server whose data has been updated to the previous server is provided,
You can check the history of data updates between servers.

In the database updating system according to the present invention, the data updating means automatically starts when the data in the database is changed, and the update information reading means reads at least one of a data update location and data update content. In the case of including the means and the data rewriting means for rewriting the data of the next server based on the read update data, the data can be updated immediately among the plurality of servers effectively.

[0013]

Next, embodiments of the present invention will be described in detail.

FIG. 1 is a system configuration diagram showing an embodiment of a database update system according to the present invention. This system is compatible with the World Wide Web ("WWW").
) And second to fourth servers 1B, 1C, and 1D that exist in a local area network (hereinafter, referred to as “LAN”) and are connected to each other via a LAN. It has. The first server and the second to fourth servers 1B, 1C, 1D are connected via a communication line. The first server 1A also has W
The terminal device 2 existing on the WW is connected.

In the above system, the first server 1A is connected to the WW
It exists on W, and the data format of the first server 1A is unified with the terminal device 2 that originated the update data. By doing so, there is no need to convert the data to be updated from a data format of a business partner or the like to a format compatible with the device. In the system, the first server 1
Since the servers 1B to 1D other than A exist in the LAN, it becomes easy to perform the core business using the existing server 1, and the initial investment for the system construction is small.

Each of the servers 1A to 1D includes a keyboard, a mouse, and the like, and an input means for inputting data, commands, and the like, and a CPU, etc., for performing calculations on the input data and temporarily storing the data. An arithmetic unit;
It has a main storage device such as a main memory for expanding modules used in the central processing unit, and an auxiliary storage device such as a hard disk for storing the databases 14A to 14D.

Each of the servers 1A to 1D comprises a printer or the like, and outputs data processed by the central processing unit to a slip, a form, or the like;
And display means for displaying data input to the input means, data output to the output means, and the like. In addition, FD drive and C
It comprises a D-ROM drive or the like, and has an external storage device for storing modules and the like stored in the main storage device and the auxiliary storage device.

Further, like the servers 1A to 1D, the terminal device 2 includes an input unit including a keyboard and a mouse, a central processing unit including a CPU, and a main storage device including a main memory. An auxiliary storage device such as a hard disk, an output device such as a printer device, a display device such as a CRT device or a liquid crystal display, and an external storage device such as an FD drive or a CD-ROM drive are provided.

In the above system, when data is updated from the terminal device 2 to the first database 14A of the first server 1A, the data updating means 3A of the first server 1A automatically starts up. It accesses the second server 1B and updates the second database 14B of the second server 1B in accordance with the data update of the first database 14A of the first server 1A.
Thereafter, the data updating means 3 of the second server 1B is similarly operated.
B automatically starts and the third database 1 of the third server 1C
4C data is updated. Due to the data update of the third server 1C, the data updating means 3C of the third server 1C is automatically activated to update the data of the fourth database 14D of the fourth server 1D.

FIG. 2 shows a system configuration of the server 1.

In FIG. 1, reference numeral 10 denotes transmission / reception control means for controlling data transmitted / received to / from the terminal device 2 or another server 1. Reference numeral 12 denotes a program storage unit, which stores a main program for executing core tasks such as order management, inventory management, and sales management. Reference numeral 11 denotes a program execution unit that executes a program stored in the program storage unit 12 and executes core tasks such as order management, inventory management, and sales management.

Reference numeral 14 denotes a database, which stores data used in each core business such as order management, inventory management, and sales management as the database 14. Reference numeral 13 denotes a database management unit that performs search, change, recording, deletion, and the like of data stored in the database 14.

Reference numeral 3 denotes a data updating means, which is automatically started when data is updated in the database 14 of the server 1 and accesses the next server 1, and stores the data in the database 14 of the next server 1. On the other hand, data update corresponding to the data update of the database 14 of the server 1 is performed.

In the data updating means 3, an automatic starting means 15 automatically activates the data updating means 3 when the terminal apparatus 2 or the previous server 1 updates data in the database 14 of the server 1. To start. Reference numeral 16 denotes an update information reading unit, and the data update unit 3
Is automatically started, the update information such as the update location and the update content of the database 14 is read via the database management means 13.

An update result transmitting means 17 transmits the update information read by the update information reading means 16 as an update result to the terminal device 2 or the previous server 1 from which the data was updated. As described above, since the updated result is transmitted from the server 1 after the data update to the server 1 before the data update, the history of the data update between the servers 1 can be confirmed.

Reference numeral 18 denotes a server access unit, which accesses the next server 1 and prepares for updating data in the database 14 of the next server 1 before and after the update information is read by the update information reading unit 16. Reference numeral 19 denotes a data rewriting means which, after accessing the next server 1, extracts an updated portion of the database 14 of the next server 1 and rewrites the data of the extracted updated portion.

Next, the operation of the above system will be described with reference to the flowchart shown in FIG. In the figure, "S" means a step.

First, when data is updated by rewriting the data in the first database 14A of the first server 1A by the terminal device 2, first, the data updating means 3 is automatically activated by the automatic activation means 15 of the first server 1A. (Step 10). Next, the update information reading means 16
As a result, the update information such as the update location and the update content of the database 14 of the first server 1 is read (step 20).

Next, the update information transmitting means 17 transmits the update information read by the update information reading means 16 to the terminal device 2 from which the data is to be updated as an update result (step 30). Then, the update information reading means 16
Before and after the update information is read by the server, the server access means 18 accesses the next second server 1B and
Preparation for updating the data in the database 14 of the server 1B is made (step 40).

After that, the updated portion of the second database 14B of the second server 1B is extracted by the data rewriting means 19 (step 50), and the data of the extracted updated portion is rewritten (step 60).

In the second server 1B in which the data has been updated in this manner, the automatic updating means 15 automatically activates the data updating means 3 in the same manner as described above.
Updating of the data of the third server 1C is performed in the same procedure as in Step 60. Further, also in the third server 1C, the automatic update unit 3 automatically starts the data updating unit 3 by the automatic start unit 15, and performs the fourth operation by the same operation as in Steps 10 to 60.
The data of the server 1D is updated.

As described above, according to the above system, the first
When data is updated in the first database 14A in the server 1A, the data is immediately updated in the second to fourth servers 1B to 1D.
Are updated in the second to fourth databases 14B to 14D. Therefore, there is almost no time lag in updating data between the servers 1A to 1D and the databases 14A to 14D, and the plurality of databases 14A to 14D are not updated.
There is no data disorder between D. Therefore, unlike the related art, it is not necessary to set 〆 days for each fixed period and adjust the data update status and the irregularity on 〆 day.

In the above embodiment, the present invention has been described with an example in which data is updated by four servers 1A to 1D. However, the present invention is not limited to this, and the number of servers 1 may be three or less. However, the present invention can be applied to the case of five or more devices.

[0034]

As described above, according to the database updating system of the present invention, when data is updated in the first database in the first server, the data in the second database in the second server is immediately updated. Is done. Therefore, there is almost no time lag in updating the data between each server and the database, and the data is not disordered among a plurality of databases. Therefore, unlike the related art, it is not necessary to set 〆 days for each fixed period and adjust the data update status and the irregularity on 〆 day.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram showing an embodiment of a database update system of the present invention.

FIG. 2 is a block diagram showing a server used in the database update system.

FIG. 3 is a flowchart showing an example of the operation of the database update system.

[Explanation of symbols]

 1A to 1D server 3A to 3D data updating means 14A to 14D database

Claims (7)

[Claims] 1. A database updating system for updating data of a database provided in each server among a plurality of servers connected via a network, wherein the data is updated in a first database in a first server. Automatically accessing the second server to access the second server, and updating the second database of the second server in accordance with the data update of the first database. Update system. 2. The database updating system according to claim 1, wherein the database updating system has three or more servers provided with databases, and the database of each server can be sequentially updated. 3. The database updating system according to claim 1, wherein the first server exists on the World Wide Web. 4. The database update system according to claim 3, wherein the data format of the first server is unified with the data format of the system from which the update data originated. 5. The server according to claim 3, wherein a server other than the first server exists in a local area network.
Database update system as described. 6. The database updating system according to claim 1, further comprising a result transmitting unit for transmitting an update result from the server whose data has been updated to a previous server. 7. An automatic starting means for automatically starting when data in a database is changed, an update information reading means for reading at least one of a data update location and a data update content, and a read update means. The data base updating system according to any one of claims 1 to 6, further comprising data rewriting means for rewriting data of the next server based on the data.