JPH07141241A - Decentralized data base system management system - Google Patents

Abstract

PURPOSE:To perform the identification of a data base and determine its period, data by data, independently, asynchronously, and automatically and to make it possible to perform efficient decentralized data base management by providing an update permissible value for each data and making data base identical when the data reaches its update permissible value. CONSTITUTION:This device has update information transmitting means 12 and 15 which send the IDs of data bases 1 and 2 and the ID of updated data, identification data information receiving means 13 and 16 which receives the ID of date for identification, etc., and is provided with a data base identification automatic management system 7 which is connected to plural data base management systems. Consequently, the IDs of the data bases 1 and 2 and the ID of the updated data are received, the updating degree of the updated data is calculated, and it is decided whether or not the degree of updating reaches the update permissible value. When the degree of updating reaches the update permissible value, updating data information is sent to other data base management system to make the data base identical.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a distributed database system management apparatus for managing a distributed database system in which a plurality of database management systems each have a database having the same data.

[0002]

2. Description of the Related Art An example of a conventional distributed database system is shown in FIG. The conventional distributed database system uses a method of ensuring that all databases of a plurality of database management systems have the same data content (identification of databases) during a period arbitrarily decided by a system administrator. Further, as this kind of distributed database system, in Japanese Patent Laid-Open No. 121953/1989, each changed database is sent to a processing section dedicated to maintenance, where the maintenance is collectively executed, and each distributed machine is again executed. The technology for arranging the data is described. Further, in Japanese Laid-Open Patent Publication No. 3-102544, in a system consisting of a master and distributed nodes, in order to maintain the sameness of data, when distributed data is changed among nodes, the distributed data is distributed according to a uniform procedure. A technique for simultaneously changing data is described.

[0003]

According to the above-mentioned conventional method, the trigger for making the data identical is the system administrator's discretion, and the maintenance is started or the distributed data is simultaneously changed. Since there is no description about the trigger of (2), no consideration was given to immediately identify only important data when important data was updated, and the freshness of the data was not reliable. In view of the above problems, an object of the present invention is to automatically perform database identification independently and asynchronously for each data, and to automatically repeat the period with a necessary period in between. .

[0004]

[Means for Solving the Problems] The above-mentioned object is, as a plurality of database management systems, an update data information transmission means for transmitting the ID of a database and an ID of updated data, and a data transmission means for the same data. A database identical automatic management system is provided which has an identical data information receiving means for receiving an ID and a file management means for searching / updating the data in the database, and which is connected to the plurality of database management systems. As this database identification automatic management system, in a certain database, update data information receiving means for receiving the ID of the database and the ID of the updated data, update degree calculating means for calculating the update degree of the update data, and update data Update degree check means for determining whether the update degree has reached the update allowable value, It is achieved by having an identical data information transmitting means for transmitting the update data information to another database management system when the newness reaches the update allowable value (the higher the priority is, the lower it is). It

[0005]

According to the present invention, the database identification in the distributed database system can be automatically performed independently and asynchronously for each data, and the database identification can be performed for a certain period of time. It can be repeated automatically.

[0006]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a system configuration diagram of the present embodiment, FIG. 2 is a flowchart showing the operation of the distributed database system management apparatus in the present embodiment, and FIG. 3 is an operation example of the update degree calculating means in the present embodiment. It is the figure shown. However, although FIG. 1 shows the configuration of the distributed database system of the present invention having two database management systems, the present invention also applies to a distributed database having three or more database management systems. Bring the action and effect.

The system configuration of this embodiment will be described with reference to FIG. Reference numerals 1 and 2 are databases, and 3 and 4 are distributed database management systems, which are update data information transmitting means 12 or 15 and identical data information receiving means 13, respectively.
Or 16, the file management means 14 or 17. Reference numerals 5 and 6 are terminal devices, and 7 is a database identification automatic management system, which comprises an update data information receiving means 8, an update degree calculating means 9, an update degree checking means 10, and an identical data information transmitting means 11. Reference numeral 18 is update degree information data. The file management means 14 or 17 retrieves / updates the data in the database 1 or 2. The updated data information transmission means 12 or 15 transmits the ID of the data updated by the file management means 14 or 17 and its database ID to the database identification automatic management system 7. Identified data information receiving means 13 or 1
6 receives the ID of the data transmitted from the database identification automatic management system 7. Further, the update data information receiving means 8 uses the ID of the data updated by the distributed database management system 3 or 4 and the ID of the database.
To receive. The update degree calculation means 9 calculates the update degree of the data updated by the distributed database management system 3 or 4. The update degree checking means 10 determines whether the update degree calculated by the update degree calculating means 9 has reached the update allowable value. When the update degree calculated by the update degree calculating means 9 reaches the update allowable value by the determination of the update degree checking means 10, the identicalized data information transmitting means 11 sends the update data of the distributed database management system 3 to the distributed database. The same data information that reflects the updated data of the distributed database management system 4 to the management system 4 or the distributed database management system 3 is transmitted.

Next, the operation of the distributed database system management apparatus according to this embodiment will be described with reference to the flowchart of FIG. Now, data D1 of database 1
If the file is updated by the file management means 14, the update data information sending means 12 sends the ID of the database 1 and the ID of the data D1 to the update data information receiving means 8. When the information of the data D1 is transmitted to the update data information receiving means 8, the update degree calculating means 9 updates the update degree K of the data D1.
To calculate. When the calculated value of the update degree K reaches the update allowable value M, the update data transmitting means 11 sets the I of the data D1.
D is transmitted to the identical data information receiving means 16 of the database management system 4. When the ID of the data D1 is transmitted to the unified data information receiving means 16, the file management means 17 corresponds to the data D of the database 2 corresponding to the data D1.
Make 2 the same as D1. Also, the identical data information receiving means 16 notifies the terminal device 6 that the data D2 has been identical. If the value of the update degree K has not reached the update allowable value M, the update data transmitting means 11 does nothing.

Next, the processing of the update degree calculating means 9 will be described in detail with reference to FIG. In FIG. 3, the update degree table a and the update allowance value table b of the update degree information table
Are stored in the update degree information data 18. Now, assuming that the data D1 of the update data ID3 is updated by the data of the database 1, the update degree calculating means 9 uses the database ID 1 and the update data ID 3 as the update data information.
To receive. Then, the update degree calculating means 9 retrieves the current update degree 19 and the update allowance value 20 of the update data D1 from the update degree table a and the update allowance value table b based on the update data information. After retrieving the update degree and update allowance,
The value 20 obtained by adding 1 to the update degree is set as the latest update degree. Figure 3
In the example, since the latest update degree has reached the update allowable value, the data of ID3 of the database 1 and the database 2 will be made identical. However, in the present embodiment, the update degree is the number of updates and the allowable update value is the total number of updates. Here, the lower the update allowance value, the higher the priority of data (the degree of giving priority to the one with a high degree of use). The update allowable value may be set in consideration of the degree of use and importance of data.

As described above, according to this embodiment, since it is determined whether or not the latest update degree has reached the update allowance value, the data having a low update allowance value, that is, the data having a high priority is frequently the same. In the meanwhile, data having a low priority is subjected to data unification for an appropriate period. As a result, the data identification according to the present embodiment is
The data is automatically and repeatedly executed for a required period corresponding to the priority of each data, and is automatically executed independently and asynchronously with respect to other data.

[0011]

As described above, according to the present invention,
In a distributed database system, database identification can be performed automatically for each data independently and asynchronously, and the database identification time can be automatically repeated with a necessary period in between. , Since each database always holds the same content data, efficient distributed database management becomes possible, and the newness of data can be made reliable.

[Brief description of drawings]

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

FIG. 2 is a flowchart showing the operation of the distributed database system management apparatus in this embodiment.

FIG. 3 is a diagram showing a process of an update degree calculating means in the present embodiment.

FIG. 4 is a diagram showing an example of a conventional distributed database system.

[Explanation of symbols]

 1, 2 database 3, 4 distributed database management system 5, 6 terminal device 7 database identification automatic management system 8 update data information receiving means 9 update degree calculating means 10 update degree checking means 11 identification data information transmitting means 12, 15 update Data information transmitting means 13, 16 Identified data information receiving means 14, 17 File management means 18 Update degree information data

Claims (3)

[Claims] 1. A distributed database system in which a database having data of the same contents is developed in a plurality of database management systems, and an update allowance value is set for each data, and when the data reaches the update allowance value, the database becomes identical. A distributed database system management apparatus, characterized in that a database identification automatic management system for automatically and independently synchronizing is provided, and the database identification automatic management system is connected to the plurality of database management systems. 2. The database management system according to claim 1, wherein the database ID and the updated data I
Having update data information transmitting means for transmitting D, identical data information receiving means for receiving the ID of data transmitted for identification, and file management means for searching / updating data in the database A distributed database system management device characterized by: 3. The database identification automatic management system according to claim 1, wherein the update data information receiving means for receiving the ID of the database and the ID of the updated data in a certain database, and the update degree of the update data are calculated. Update degree calculation means, update degree check means for determining whether or not the update degree of the update data has reached the update allowable value,
A distributed database system management device comprising: an identical data information transmission means for transmitting update data information to another database management system when the update degree reaches an update allowable value.