JPH10293707A - Method for utilizing updating data utilizing mass read dedicated storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To control the regeneration and redistribution of a mass storage medium that stores new updating data and updated index information and to quickly provide the information by using a network. SOLUTION: In a method which manages and distributes updated information, match processing of an updating data of a database is performed between a server machine and a client machine (step 112). If the update of information is performed on a sever side and it is not reflected to a client side, download data is extracted and downloaded to the client side (step 107). When information that is updated on the client side is used, information is read from an internal magnetic disk unit and presented (step 116) and in the case of information that is not updated, information is read from distributed CD-ROM and presented (step 117).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for managing information in a client-server system, and more particularly to a system for managing difference data such as data on a large-capacity read-only storage medium and data added or deleted on a large-capacity writable medium. It relates to a management method and a distribution method.

[0002]

2. Description of the Related Art In the computer industry, CD-RO
M is frequently used as a medium for storing a large amount of information. As the capabilities of computers have improved in recent years,
Information cannot be stored on a single CD-ROM and multiple CD-ROMs
-Information is being provided in ROM.

A method and a system for performing a search over a plurality of storage media in a stand-alone system are disclosed in Japanese Patent Application Laid-Open No. 7-219964, along with newly added information and an index for the search. Is stored in the newly created information storage medium, so that only the latest storage medium index is transcribed to the system side, and a plurality of storage mediums are stored. The index information that can be shared with the user can be easily updated, and management becomes easy.

[0004]

According to the prior art, when new information is added, the latest information and the index of the existing information are stored in a newly created storage medium. Therefore, there is a problem that the number of storage media increases and the management of the storage media becomes complicated.

In addition, since the latest information and the index of existing information are stored in a newly created storage medium and distributed, there is a problem that the information is not reflected until a medium storing the new information is provided.

A first object of the present invention is to suppress the re-creation and redistribution of an information storage medium by creating new additional data and updated index information and programs on a writable medium on a client machine. It is to provide a way to do it.

A second object of the present invention is to provide a method of instantly reflecting newly added data and updated index information and programs by using a network.

[0008]

In order to achieve the above object, according to the present invention, an operation column is provided in each table of a database in order to manage information on both a client machine and a server machine. Further, the client machine is provided with an environment value table for storing information such as update date and time. In the operation column, a time stamp which is a date set when the server-side database is updated, a valid flag for determining code table distribution, and the like are defined and used for database management. In the environment value table, a distribution ID, which is the date of the latest download, a machine ID for uniquely identifying a machine, a user ID for identifying a user who has performed an update, and the like are defined.

On the server machine side, the process of storing the newly added data and the updated index table on a storage medium in the server machine is executed as needed, and the time stamp of the operation column of the updated table is updated to a new one.

When the information system is started on the client machine side, the distribution ID of the environment value table of the client machine is compared with the time stamp of the operation column of the server machine. As a result of the comparison, if the values are the same, it means that the information has not been updated, and the information system is executed.

If the value of the time stamp of the operation column of the server machine is newer than the distribution ID of the environment value table of the client machine, the server machine downloads the operation column, the newly added data and table, and the updated index table. Create a file and distribute it to client machines. The distributed data is stored on a storage medium on the client machine side. The information system is executed after all distributions are completed.

[0012]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a flowchart showing an embodiment of a processing procedure when the present invention is applied to an information system. FIG. 2 is an information system using a CD-ROM in a client server system according to the present invention. It is a block diagram at the time of performing a certain pest diagnosis system. FIG. 3 shows the details of the code table in FIG. 2 and uses a disease name code as an example. FIG. 4 shows the details of the index table in FIG. 2, using a disease name code as an example. FIG. 5 shows details of the environment value table in FIG.

In FIG. 2, the server machine 10 has a built-in magnetic disk device 70 and performs update information management 30. In the built-in magnetic disk device 70, a server database 71 is constructed, and an index table 72 and a code table 73 indicating storage positions of various information.
(A plurality of code tables exist).
The download data extraction processing 40 is performed when the update information is downloaded to the client machine 20. The client machine 20 includes a CD-ROM device and a magnetic disk device 80. In the case where a large amount of audio files and image files are handled by this information system, information is first provided on the CD-ROM 60. A PC (client) database 61 is built in the distributed CD-ROM 60, and stores an index table 62 and a code table 63 indicating storage positions of various information. In addition, the distributed CD-ROM 60 stores audio files and image files 64. The data exchange processing 50 constructs the information distributed by the download processing from the server in the client machine 20. The information distributed by the data exchange process 50 updates the index file 82, the code table 83, and the environment value table 84 constructed in the PC (client) database 81 in the internal magnetic disk device 80. In the embodiment of the present invention, only one client machine 20 is shown, but actually, a plurality of client machines 20
And a network 90.

The details of the code table 63 in the CD-ROM in FIG. 2 will be described with reference to FIG. FIG. 3 is a disease name code table in which a disease name code, a disease name, a disease name classification (division of disease, pest, etc.) and the like are defined. In the disease name table, since the storage medium may be a CD-ROM and data cannot be updated, the operation column 210 does not exist and only the business column 200 exists. Commercial column 2
A disease name code 201 is a key of a disease name table, 202 is a disease name which is the name of the disease name code, and 203 is a classification of the disease name code. Reference numeral 204 denotes an update date.
The code table 63 in the CD-ROM is not updated.

Next, details of the index table 62 in the CD-ROM will be described with reference to FIG. FIG. 4 shows a disease name designation photo selection code, which defines a disease name code, an address of audio information, and the like, and is used as an index table. The disease name code 301 is a key code,
It is linked to the disease name code 201 in FIG. 302,3
Numeral 03 indicates a storage location of the photo file and the audio file 64. The update date 304 stores the date when the information was registered. An update flag 305 indicates an unupdated state when the update flag is “0”. The update flags 305 of the index table 62 in the CD-ROM are all "0". The index table 62 is not updated like the code table 63 in the CD-ROM.

The details of the code table 73 in the internal magnetic disk device 70 in the server machine in FIG. 2 will be described with reference to FIG. In the initial state, the business column 200 of the disease name table is the same as the contents of the disease name table in the CD-ROM, and has a configuration in which an operation column 210 is added thereto. The time stamp 211 obtains the server-side system date when updating the server-side database. The format is 15 digits of the year, month, day (8 digits), time (4 digits), and update counter (1 digit). The update counter circulates between "0" for a new record and "1" to "9" for an updated record. The validity flag 212 is a flag for determining whether or not to distribute data from the server machine 10 to the client machine 20. "0" indicates a distribution pending state, and "1" indicates a distribution possible state. .

Next, the details of the index table 72 in the internal magnetic disk device in the server machine will be described with reference to FIG. In the initial state, it is the same as the index table 62 in the CD-ROM. When the update process is performed,
The photograph address 302 and the voice address 303 are updated based on the disease name code 301 which is a key code, and the update date 30
4 is obtained from the system date of the server machine, and the update flag 305 is changed to “1”. In the case of new creation, a row is added. The audio file and the image file 74 do not exist in the initial state. When added, the storage location and the key code are linked and registered in the index table 72.

The details of the code table 83 in the internal magnetic disk device 80 in the client machine in FIG. 2 will be described with reference to FIG. In the initial state, the code table 83 does not exist in the internal magnetic disk device 80 in the client machine. Code table 73 on server machine
Are stored in the internal magnetic disk device 80 only after the download process is performed. Therefore, the content of the code table 83 in the client machine is the same as the code table 73 in the server machine. However,
Not all the code tables 73 existing in the internal magnetic disk device 70 in the server machine exist in the internal magnetic disk device 80 in the client machine, but only the downloaded ones.

Next, the details of the index table 82 in the internal magnetic disk device in the client machine will be described with reference to FIG. In the initial state, it is the same as the index table 62 in the CD-ROM. When the download processing is performed, the photograph address 302, the voice address 303, the update date 304, and the update flag 305 are updated using the disease name code 301 as a key. In the case of new creation, a row is added.

Next, details of the environment value table 84 will be described with reference to FIG. The distribution ID 401 is set on the client machine side. The format is updated with 12 digits of the year and month (8 digits) and the auxiliary number (4 digits). The date is obtained from the server machine when the download process is completed. The auxiliary number can be used from "0000" to "9999", and by setting this value arbitrarily, it becomes possible to partially extract specific update data. 402 is
403 is the identifier (4 digits) of each client machine
Is the user ID of the user who updated the data (6 digits)
It is.

Next, the operation of each unit will be described with reference to the flowchart of FIG.

In the server machine 10, processes such as addition and deletion of data are performed as needed. This is mainly performed by the administrator, and the business column 20 is used.
Work such as change, addition, etc. of the audio file, the audio file, the image file 74, etc. is performed (step 101). The index table 72 describes the storage location of a business code table, audio files, image files, and the like. After updating the code and name, when executing the data saving process, the system date is acquired from the server machine, and the update date 204 of the business column 200, the time stamp 211 of the operation column 210, and the update of the index table are updated. Day 30
4. Change the update flag 305 (step 103).

When the power of the client machine 20 is turned on, the information system is started by batch processing (step 111). In the case of the pest diagnosis system, the CD-ROM will not operate without the CD-ROM 60 already distributed, so the CD-RO
M must be inserted into the device.

Next, the distribution ID 401 of the environment value table 85 in the internal magnetic disk device 80 and the date of the time stamp 211 in all the code tables 73 of the server machine 10 are matched (step 112).

If the time stamp 211 of the code table 73 of the server machine 10 is newer than the distribution ID 401 of the environment value table 85 of the client machine 20, it is necessary to download the update data from the server machine 10, otherwise, Then, the processing is continued (step 113).

In the extraction of the download data, the time stamp 211 of the operation column 210 of the code table 73 of the server machine 10 is newer than the date of the distribution ID 401 of the environment value table 85 of the client machine 20 and the validity of the operation column 210 The flag 212 is "1"
To select the code table 73 in a distributable state, and the machine ID of the download destination together with the index table 72
One download file is created by adding information such as a password and a user ID (step 105).

The download file created by the download data extraction process is transmitted to the client machine 2
0 using the network 90 (step 1).
07). The distributed download file is transmitted to the PC by the data exchange process 50 of the client machine 20.
(Client) The index table 82, the code table 83, the audio file, and the image file 84 in the database 81 are updated and added. Then, the system date at the time of completion of the download is obtained from the server machine 10 (the reason why the system date is obtained from the server machine instead of the client machine is that there is a possibility that the system date of the client machine has an error). The distribution ID 401 of the environment value table 85 is updated to the latest date (step 114).

The processing up to this point is performed after the power of the client machine is turned on and before the business program of the information system is started. The time required for this process is proportional to the size of the download file. After the download process is completed, the business program of the information system starts.

When an operation for referring to certain information is performed in the information system, first, the index table 82 in the client machine 20 is referred to (step 11).
5). Update flag 305 of index table 82
Is “1”, the latest data is the client machine 2
0 is determined to be stored in the internal magnetic disk device 80, and the key code 301 and the photo address 30 are determined.
2. A search is performed in the code table 83, the voice, and the image file 84 based on the voice address 303 (step 11).
6). Update flag 305 of index table 82
Is "0", it is determined that the data has not been updated, and a search is made in the code table 63, audio, and image files 64 in the distributed CD-ROM 60 (step 117).

Finally, information is displayed (step 11).
8).

The embodiment of the present invention has been described above.
In FIG. 2, a CD-ROM is used as a large-capacity read-only device.
However, it is also possible to use a CD-R, DVD-ROM, or the like.

[0033]

As described above, according to the present invention, the update information is stored in the machine and the latest information is distributed using the network, so that the storage medium containing the additional information is recreated / reproduced. Management becomes easy without distribution. Also,
Delivery of the latest information can be performed quickly and without the user's awareness.

[Brief description of the drawings]

FIG. 1 is a flowchart showing an embodiment of a processing procedure of the present invention.

FIG. 2 is a system block diagram according to the present invention.

FIG. 3 shows details of a code table in FIG. 2;

FIG. 4 shows details of an index table in FIG. 2;

FIG. 5 shows details of an environment value table in FIG. 2;

[Explanation of symbols]

 10 server machine 20 client machine 60 CD-ROM 90 network.

Claims (2)

[Claims] A client server system having a server machine for managing information to be provided to a user, a terminal having a large-capacity read-only storage medium and a large-capacity writable medium, and connecting information processing terminals via a communication line. Distribute the newly added data created by the machine and the updated index to the large-capacity writable medium on the client machine side via the network, and store the update information once in the large-capacity writable medium. And management method. 2. The method according to claim 1, wherein the server-side and client-side update dates are compared, and if the client-side update date is older, the server-side new added data and the updated index are compared. A distribution method characterized by extracting data as download data, transmitting the data to a client, and adding or updating data and an index on the client.