JPH10240598A - Data updating method for database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data updating method for a database which reduces the communication cost by reducing the amount of data transmitted from a remote database device to a center database device and can make good use of the latest necessary data at the center database device. SOLUTION: Of the database system wherein a center data output person 4 requires all the data of the center and respective remote places and a remote data output person 10 requires only remote data, a remote database device B set importance flags by data inputted to a remote data input means 7 according to an input-person's judgement. A data processing means 8 adds sent data to a center data storage means 3 provided in the center database device A immediately after adding the data to a remote data storage means 9 when the importance flag of the sent data is 1. When the importance flag is 0, the data are added to the remote data storage means 9 and an altering process is performed for the center data storage means 3 in nighttime or on a holiday.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a data updating method for a database system.

[0002]

2. Description of the Related Art Conventionally, in a database system which requires only input data at a remote location in a remote location and requires data of the entire remote location in a central location, a location remote from the central database device is required. There are a plurality of data input means and data output means, and a data storage means is provided for each data input means. Data can be added from each data input means to the central database device immediately after adding data to the respective remote data storage means, or the data stored in the remote data storage means can be added to the central database device at a predetermined time. Update method.

[0003]

In the above-mentioned conventional database system, data is added to the central database every time data is input at each remote location. In this method, when one data is updated many times, the amount of communication data increases and communication cost increases. Further, in the method of performing an update process on the central database device at a predetermined time, urgent data cannot be output from the central database device immediately after being input to the remote database device.

An object of the present invention is to reduce the amount of data transmitted from a remote database apparatus to a central database apparatus to reduce communication costs and to use the latest data required by the central database apparatus. The purpose of the present invention is to provide a data update method.

[0005]

SUMMARY OF THE INVENTION An object of the present invention is to provide a central database apparatus having data input means, data storage means, and data output means, and one or more remote database apparatuses having the same configuration as the central database apparatus. In a data updating method of a database system in which these database devices can exchange data via a line, when data is input to a remote database device, an importance flag is added to each input data, Immediately after the data having a high degree is input to the remote database device, the data is added to the central database device and the transfer flag is set to be transmitted. Other data can be achieved by adding the data to the central database device at a time when the use of the database device is small such as at night or on holidays and the communication cost is low.

As described above, only the data of high importance is reflected in the central database immediately after the data is added to the remote data storage means, so that new data updated at the center can be used and transferred to the central database. Since the data to be transmitted is the last data changed several times in the remote database device, the amount of data transmitted from the remote database device to the central database device is minimized, and the data transmitted from the remote database device to the central database device is minimized. No more changes to the same data. As a result, it is possible to reduce the communication cost when the data is additionally processed in the central database device.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention is shown in FIG.
3 will be described.

FIG. 1 is a block diagram showing an embodiment of the present invention, FIG. 2 is a flowchart showing a flow of data addition,
FIG. 3 is a flowchart showing the addition of data from the remote database device to the central database device.

In FIG. 1, 1 is a central data input person who inputs data (data in the central portion) to the central database device A, 2 is central data input means, 3 is central data storage means, 4 is a central data input device. A central data output person who outputs all data at each remote place, 5 is a central data output means, 6 is a remote place data input person who inputs data (data at a remote place) to the remote place database apparatus B, and 7 is a remote place data input part. Location data input means, 8 is a data processing device, 9 is remote location data storage means, 10 is a remote location data output person who outputs data of each remote location, and 11 is remote location data output means. Although FIG. 1 shows only one remote database device B and one device installed in the remote database device B, two or more data input means and data output means are provided in many remote locations. It can be installed and connected to a central database device. In the central database device A, the central data input person 1 inputs data by the central data input means 2.
The input data is added to the central data storage means 3. On the other hand, in the remote place database apparatus B, the remote place data input person 6 inputs data by the remote place data input means 7. At this time, a significance flag is set for each data according to the judgment of the remote data input person 6. This importance flag includes data having a high degree of urgency (importance flag 1) and data to be transmitted at night and on holidays (importance flags 2).
Attached to classify. The data to which the importance flag is added by the remote data input means 7 is transmitted to the data processing device 8. The data processing device 8 determines the importance flag of the transmitted data. If the importance flag is 1, the data processing device 8 adds the data to the remote data storage means 9 and immediately adds it to the central data storage means 3 and transmits the transfer flag. Done. If the importance flag is 2, the information is temporarily added to the remote data storage means 9. Thereafter, additional processing is performed on the central data storage means 3 at night or on holidays when the number of users is small and the communication cost is low for each importance flag. The central data storage means 3 stores the data inputted by the central data input means 2 and the data inputted by the remote data input means 7, and the remote data storage means 9 receives the data inputted by the remote data input means 7. Only data that has been stored is stored. The central data output unit 4 outputs the central data and all the remote data stored in the central data storage unit 3 by the central data output unit 5. The remote data output person 6 outputs only the data stored in the remote data storage means 9 by the remote data output means 7.

In order to add data from the remote data input means 7 to the central data storage means 3 and the remote data storage means 9, data is first input by the input means as shown in FIG. 2 (S1). An importance flag is added to the input data according to the judgment of the input person (S2). A transfer flag 0 is added for each data to which the importance flag has been added (S3). The data to which the importance flag and the transfer flag are added are transmitted to the data processing device (S4). The importance flag of the data transmitted by the data processing device is checked (S5). If the importance flag is 1, data is added to the remote data storage means (S6) and then added to the central data storage means (S6). S
7) The transfer flag is set to 1 (S8). If the importance flag is 0, data is added to the remote storage means (S9) and the process is terminated.

In order to periodically update the data from the remote data storage means 9 to the central data storage means 3, search for data whose transfer flag is 0 as shown in FIG. 3 (T1). A decision is made (T2), and if not, the process is terminated. If it exists, its importance flag is determined (T
3) If the transmission is performed at night, the data with the importance flag 2 is searched, and if the transmission is performed on a holiday, the data with the importance flag 3 is searched. Each search data is added to the central data storage means (T4, T6), and the transfer flag is updated to 1 (T5, T7). Thereafter, the process returns to T1 and repeats until there is no more data.

[0012]

As described above, only the data of high importance is reflected in the central database immediately after the data is added to the remote data storage means, so that new data updated in the center can be used and the central database can be used. Since the data transferred to the remote database device is the last one changed several times in the remote database device, the amount of data transmitted from the remote database device to the central database device is minimized, and Will not repeat changes to the same data. As a result, it is possible to reduce the communication cost when the data is additionally processed in the central database device.

[Brief description of the drawings]

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

FIG. 2 is a flowchart showing a flow of data addition.

FIG. 3 is a flowchart showing data addition from a remote database device to a central database device.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Central data input person 2 Central data input means 3 Central data storage means 4 Central data output person 5 Central data output means 6 Remote data input person 7 Remote data input means 8 Data processing device 9 Remote data storage means 10 Remote place Data output person 11 Remote data output means A Central database device B Remote database device

Claims (3)

[Claims] 1. A central database device having data input means, data storage means and data output means, and one or more remote database devices having the same configuration as the central database device, and these database devices are connected to a line. In a data updating method of a database system in which data can be transmitted and received via a remote server, when data is input to a remote database device, an importance flag is added to each input data, and data having a high importance is transmitted to a remote site. A data updating method for a database system, wherein the data is immediately added to the central database device immediately after the data is input to the database device, and low-importance data is periodically added to the central database device. 2. A central database device having data input means, data storage means, and data output means, and one or more remote database devices having the same configuration as the central database device. In a data updating method of a database system in which data can be transmitted / received via a database, when data is input to a remote database device, an importance flag and a transmission flag are added for each input data, and data having a high importance is added. Is to add the data to the central database device immediately after the data is input to the remote database device, and to add the less important data to the central database device at night when the communication cost is low from the transmission flag by transmitting flag. Data update method. 3. A central database device having data input means, data storage means, and data output means, and one or more remote database devices having the same configuration as the central database device. In a data updating method of a database system in which data can be transmitted and received via a remote server, when data is input to a remote database device, an importance flag is added to each input data, and data having a high importance is transmitted to a remote site. The database system is characterized in that the data is immediately added to the central database device after the data is input to the database device, and other data is added to the central database device at night and holidays when the communication cost is low for each importance flag for each of the importance flags. Data update method.