JPH1055301A - Decentralized database device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a decentralized database which is improved in retrieval response characteristics and also provide a decentralized database device which can utilize a database through the server computer of its department even if a server computer at another position. SOLUTION: The LANs of departments A, B, and C are connected through a wide-area network 100. A server computer 104 of each LAN is stored with drawing data 110 and drawing attribute data 108 for retrieval. The drawing data 110 are stored in only the LAN of the department that the drawing data belong to, and the drawing attribute data 108 for retrieval of all drawing data of all the departments are stored in the respective LANs. A user can speedily access drawing data 110 of its department through the LAN and the drawing attribute data 108 for retrieval of all the drawing data are stored in the respective LANs, so the drawing data 110 can speedily be retrieved from a terminal device 112.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a distributed database, and more particularly to a distributed database on a wide area network constituted by connecting a plurality of local area networks via a wide area communication line.

[0002]

2. Description of the Related Art A network type database for providing data via a network is widely used.
In such a database, a method in which data to be provided is stored in one server and a user accesses the server intensively has been adopted for a long time.

However, in such a method in which all data is concentrated on one server, when the amount of data increases, an extremely large storage capacity is required for the server. In addition, if the central server is stopped, it becomes impossible to access all data. Furthermore, since all data is concentrated on a single server, there is a problem that resistance to data destruction is weak. Therefore, in recent years, a distributed database that distributes data to a plurality of bases has been widely used as a network-type database. According to such a distributed database, each base holding each data can independently provide data, and it is possible to disperse risks in the performance of the database. When it is necessary to refer to the data stored in the own department, it is sufficient that only the server device of the own department is operated, and the database is stored even when the server device at another base is stopped. It has the advantage of being available.

[0004] As described above, a distributed database apparatus that distributes data managed in a database to a plurality of servers on a network without concentrating the data at one location has various advantages, and is therefore widely used.

[0005] An example of such a distributed database device is disclosed in, for example, JP-A-3-278179. FIG. 10 is a block diagram showing the configuration of the distributed database apparatus disclosed in this publication. As shown in FIG. 10, the database described in the publication has a configuration in which a plurality of local area networks (hereinafter, referred to as LANs) are connected via a wide area network 10. In FIG. 10, three LAs are used.
N are interconnected by the wide area network 10. In the text, each LA
The department in which N is provided is called a department. For example, FIG.
LAN for department A, department B and department C
Are connected via a wide area network 10. As shown in FIG.
Is provided with a main computer 12, and the department A
The AN is connected to the wide area network 10 via the main computer 12. In the departments B and C, each LAN is connected to the wide area network 10 via the sub-computer 14. A terminal device 22 for using the database device is connected to each LAN.

[0006] Magnetic disk devices (16b, 18, 20) storing drawing data and search information managed by the database device are connected to the main computer 12 and the sub-computer 14, respectively. I have. The drawing data to be managed is distributed and stored by the magnetic disk devices 16b, 18, and 20.

As described above, in the distributed database shown in FIG. 10, the drawing data to be managed is distributed to each LAN, but the drawing attribute data for searching for the data is stored in the main computer. It is stored only in the magnetic disk drive 16 connected to the storage device 12. As described above, in the conventional example shown in FIG. 10, search attribute data is stored and managed in one place. By concentrating the search attribute data in one place as described above, even when data is searched from the terminal device 22 connected to the LAN of the department B or C, the data is connected to all LANs. Magnetic disk drive (16
It is said that it is not necessary to search all of the items b, 18, and 20), and data can be searched only by searching only one magnetic disk device 16, so that efficient database operation is possible.

[0010] As described above, according to the distributed database apparatus shown in FIG. 10, it is possible to operate the database very efficiently by concentrating search information of all drawing data in one place. Things.

[0009]

In the distributed database apparatus shown in FIG. 10, when all the drawing data are searched, the drawing attribute for the search in the magnetic disk 16 connected to the main computer 12 is always used. You need to refer to the data. Therefore, for example, in the section B, the magnetic disk drive 2 connected to the LAN of the section B
Also, when searching for drawing data stored in the main computer 12 of the department A via the wide area network 10,
In addition, it is necessary to refer to the magnetic disk device 16 connected thereto, and there is a problem that unnecessary traffic on the wide area network 10 increases. As described above, the increase in traffic on the wide area network 10 causes a decrease in search responsiveness. Further, according to the apparatus shown in this figure, since all searches are performed via the main computer 12, there is a problem that all functions of the database device are stopped when the main computer 12 is stopped. Was.

The present invention has been made in view of the above problems, and an object of the present invention is to provide a distributed database apparatus capable of reducing traffic on the wide area network 10 and improving search responsiveness. It is another object of the present invention to provide a distributed database apparatus that can use a database via a computer of the own department even when a computer of another department is stopped.

[0011]

According to a first aspect of the present invention, there is provided a communication system comprising: a plurality of local area networks; and a wide area communication line interconnecting the plurality of local area networks. Each of the local area networks stores local data storage means for holding data in the department to which the local area network belongs, and stores search attribute data used for searching all data managed by the distributed database. Attribute data storage means, and when the data searched using the search attribute data is stored in the local data storage means, reads out the data in the local data storage means, If it is not stored in the local area network, the other local A data reading means for reading the data in the data storage means is a distributed database system, which comprises a.

According to the present invention, the data to be managed by the database is held in a distributed manner in each local area network, but all of the search attribute data for searching the data are the attribute data in each local area network. It is stored in data storage means. Therefore,
Despite being a distributed database, data retrieval can be performed quickly.

According to a second aspect of the present invention, there is provided a distributed database apparatus according to the first aspect, wherein
A management server connected to the local area network or the wide area communication line, wherein the local area network stores data in the local data storage unit when data is updated in a department to which the local area network belongs. An update content transmitting unit for updating the content and transmitting the update content to the management server; and the attribute data storage unit based on the update content of data stored in the management server and belonging to another local area network. Attribute data updating means for updating the storage content of the, the management server,
Update content storage means for storing the update content of data in the section to which each local area network belongs; and update content collection means for storing the update content transmitted from each of the update content transmission means in the update content storage means. The attribute data updating unit reads the content of the update content storage unit at a predetermined timing, thereby updating the storage content of the attribute data storage unit based on the update content of the data in the department to which the other local area network belongs. A distributed database device characterized by updating.

The management server collects update information of data in each local area network and provides it to each local area network. In each local area network, the attribute data updating means updates the contents of the attribute data storage means in the local area network based on the provided update information. Therefore, the update of the data in one of the local area networks is reflected in the contents of the attribute data storage means of the other local area network.

According to a third aspect of the present invention, in the distributed database according to the second aspect of the present invention, the local area network includes a terminal device used by a user who uses the distributed database. The terminal device includes a data search unit that searches and reads the data to be displayed, a display unit that sequentially displays the data read by the data search unit, the data search unit, and the display unit. And a control unit that is driven asynchronously.

Since the data search means and the display means are driven asynchronously by the control means, it is possible to sequentially display each data read by the search means.

[0017]

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

FIG. 1 is a configuration diagram of a distributed database apparatus according to the present invention. As shown in FIG. 1, in the present embodiment, LANs provided in three departments A, B, and C are connected via a wide area network 100. The LANs provided in the respective departments A, B, and C basically have substantially the same configuration. That is, each LAN is connected to the server computer 104.
Is connected to the wide area network 100 via the Internet.
Further, storage devices storing the drawing attribute data for search 108 and the drawing data 110 are connected to the server computer 104, respectively. As described above, the distributed database device according to the present embodiment is a database device for managing drawing data, and the drawing data is stored in the storage device connected to the server computer 104 belonging to each LAN.

On the other hand, drawing search information is used as search drawing attribute data 108 for all drawing data in order to search for drawing data 110 stored in storage means connected to all server computers 104. It is stored in storage means connected to all server computers 104.

A feature of this embodiment is that drawing data created or mainly used in each of the departments A, B, and C is stored in the LAN of the department (A, B, and C). That is. With such a configuration, the drawing data frequently used in the own department can be accessed without passing through the wide area network 100, as compared with the case where the drawing data is stored in one computer in the database device. Can be improved. Further, compared to storing all the drawing data managed by this database device in each LAN, the capacity of the storage device is more effectively utilized.

On the other hand, as the drawing attribute data 108 for search, the drawing attribute data 108 for search of all the drawing data managed by the present database device is used for each LAN.
Are stored in duplicate. That is, when the drawing data 110 is searched from a certain department (for example, A), the drawing attribute data 108 for all the drawing data 110 can be accessed from the storage unit connected to the LAN of the own department. Therefore, the search speed is improved. Note that the drawing attribute data for search 108
Has an extremely small amount of information as compared with the drawing data 110, so that the capacity of the storage device is not significantly consumed even if each LAN is duplicated.

As described above, in the present embodiment, with respect to the drawing data 110, the L
Only the drawing data 110 of the department to which the AN belongs is stored. On the other hand, as for the drawing attribute data 108 for search, the attribute data of all the drawing data 110 managed in the database device (all the configurations shown in FIG. 1) is stored. , Each L
Added duplication for AN. As a result, according to the present embodiment, the speed of drawing data retrieval can be improved, and the drawing data 110 belonging to the own department can be accessed at high speed.

In the database device according to the present embodiment, search drawing attribute data 108 relating to all drawing data 110 managed in departments A, B, and C is provided.
Is duplicated in all departments A, B, and C, so that if a change occurs in the drawing data 110 in any department, the change is reflected in the search drawing attribute data 108 in another department. There is a need. Of course, it is necessary to update the search drawing attribute data 108 in the department where the change has occurred. However, since this processing is performed within the same LAN, each department can freely perform the processing.

The drawing attribute data 108 for search is stored in each section A,
In order to maintain the same data in B and C, changes in the drawing data 110 are performed via the management computer 102. A storage device that stores the drawing attribute update data 114 for search is connected to the management computer 102, and all management information related to drawing data is managed by the management computer 102. As shown in FIG. 1, this management computer 102 is connected to all departments A and A via a wide area network 100.
B and C are connected.

First, the search information (drawing drawing attribute data 108) of the drawing data added, deleted, and updated in each server computer 104 is stored in the management computer 102.
Once collected in a storage device connected to the The management computer 102 updates the collected data once
The data is separately stored as distribution data to the server computer 104 of each department. The accumulated search information is
It is obtained from each server computer 104 at an arbitrary timing. For example, in the database device according to the present embodiment, server computers 104 belonging to the respective departments acquire the search information of the previous day via management computer 102 before the start of a day's operation.
Then, based on the obtained search information, the search drawing attribute data 108 in the own department is updated. In this way, it is possible to reflect the update of the drawing data 110 of another department to the own department with a delay of one day.
In general, it is considered that access to the drawing data 110 is often made to the drawing data created or mainly used in the own department, and less to the drawing data 110 managed in another department. Therefore, even if the update of the drawing data 110 in the other department is reflected in the drawing attribute data 108 for search in the own department with a delay of one day, it is considered that there is not much inconvenience in operation. Needless to say, when an emergency is required, the drawing attribute update data 114 for search managed by the management computer 102 can be manually taken out by the operator at any time and reflected on the drawing attribute data 108 for search in the own department. .

Further, as shown in FIG. 1, in each department, a plurality of terminal devices 112 for using the database device are connected to the LAN.
The terminal device 112 can search the drawing data of the entire database device using the drawing attribute data for search 108 managed by the server computer 104 in the department. The display of the drawing data retrieved in this manner is performed by using reduced image data for high-speed turning (hereinafter referred to as preview data) or by using actual drawing data 110 data by dedicated display / editing software. There are two methods of displaying the information.

In the former high-speed turning method, the high-speed turning display and the transfer of display data are executed asynchronously.
The software in the terminal device 112 has been adjusted. That is, the display program of the acquired preview data and the program that retrieves the drawing data 110 and retrieves it from its own department or another department are driven by multitasking. As a result, the drawing data 110 managed by the server computer 104 of the own department and can be acquired at high speed via the LAN, and the drawing data 110 managed by the server computer 104 of another department and
Is mixed with drawing data 110 transferred at a low speed via the wide area network 110,
The data is displayed on the terminal device 112 sequentially from the drawing data obtained earlier. For example, when transferring the drawing data 110, 3
When there is one drawing that takes a minute (drawing data 110 of another department and drawing data obtained via the wide area network 100), if other drawing data can be transferred in three seconds (managed in the own department, 3 seconds after the display command is issued, the high-speed turning display is started from the drawing data that can be obtained earlier three seconds after the display command is issued. In this way, since the transfer can be displayed on the terminal device 112 at any time from the completed drawing, the user of the database device does not have to wait unfairly. After three minutes, all drawing data is acquired, and high-speed turning display can be performed on all drawings. Of course, it is optional to end the high-speed turning display even if transfer of all drawing data is not completed, such as when a target drawing is found by then.

As described above, in the database device according to the present embodiment, the response performance of the database device can be improved, and a highly convenient database device can be obtained. Also, in the present embodiment, the database device for managing the drawing data 110 has been described.
Since the preview data is separately provided as load information in addition to 0, the user can quickly check the contents of the drawing data 110 using the high-speed turning display.
Further, by configuring the distributed database apparatus in this way, as long as the server computer 104 of the own department operates, the server computer 10 of the other department can operate.
4 can be stopped, the drawing data 110 in the own department can be accessed. Further, the drawing data 11 is concentrated in one place using the wide area network 100.
Compared to the method of managing 0, transactions to other departments can be reduced, which contributes to improvement of the response and proposal of communication cost.
Further, since the search drawing attribute data 108 of the drawing data 110 managed in all departments is provided in each department, the search for the drawing data of the entire system is performed at high speed. The present invention provides a database device that can access drawing data even when the user does not know where the drawing data is stored. Note that a search screen for such drawing data 110 includes a GUI
It is preferable to utilize (graphical user interface).

Next, how an update is transmitted to another department via the management computer 102 when the drawing data 110 is updated in any department will be described.

For example, a registration request for drawing data 110 and drawing attribute data 108 is issued from a terminal device 112 in any department to the server computer 104 of the LAN to which the terminal device 112 belongs. Then, the server computer 104 stores the drawing data 1
10 is stored in the storage device, and the drawing attribute data for search 108 is stored in the storage device. Further, the server computer 104 outputs an update record of the drawing data 110 and the drawing attribute data 108 for search registered in the storage device as a log file. Then, at a certain time, or when the output log file exceeds the specified capacity, this log file will be
Management computer 1 via wide area network 100
02. The management computer 102 stores the transmitted log file as an update information file for another server in the storage device. This is the search drawing attribute update data 114 shown in FIG.
After transmitting the log file to the management computer 102, the server computer 104 deletes the contents of the output log file. Note that the transmission timing of the log file can be made by an explicit request from the terminal device 112.

The management computer 102 transmits the other server update information file stored as the search drawing attribute update data 114 to the server computer 1 belonging to each department.
04 and are stored. The management computer 102 transfers the other server update information file to the corresponding server computer 104 at a predetermined timing. If this transfer is not possible, for example, if the server computer 104 is not operating, the retry is repeated at a fixed cycle, and then the contents of the other server update information file are left as it is, and the transfer is temporarily suspended. If the transfer of the relevant other server update information file to the server computer 104 is successful, the content of the successful other server update information file is deleted.

When each server computer 104 receives its own server update information file, it updates the drawing data 110 and the search drawing attribute data 108 managed on the LAN to which the server computer 104 belongs. In this manner, the update of the drawing data 110 in any department is performed by the management computer 10.
2 is distributed to the server computers 104 in all the other departments via the network 2, so that the drawing data 110 updated in the server computers 104 in the other departments can be searched from the LANs of all the departments.

As described above, in the present embodiment, the drawing data of the search result can be turned at high speed, and in this case, so-called preview data for high speed display is used. Since the program for obtaining the corresponding drawing data 110 and the program for displaying the obtained drawing data 110 operate asynchronously, the user is allowed to wait unfairly by sequentially displaying the found drawing data. No more. When performing the high-speed page turning display, the transferred and acquired preview data is normally displayed, but the temporary data that has not been acquired is temporarily displayed. This provisional image is achieved, for example, by displaying a figure in which a part of the drawing is displayed in gray. Then, the drawing data is transferred via the wide area network 100 or the like,
The normal display is sequentially shifted from the acquired preview data. It should be noted that this temporary image is continuously displayed as the temporary image when, for example, the server computer 104 of the department in which the drawing data 110 exists is not operating. The drawing normally displayed in the high-speed turning display in this manner can be used as a normal display or as an edit target according to a user's selection instruction.

As described above, in this embodiment, the distributed database apparatus that handles drawing data has been described. In the present embodiment, the management computer 102 uses the performance of the system for updating the drawing data 110 and the like, but this management computer 102 may also serve as any of the department computers (server computers 104). When a wide area network is configured, for example, a backup computer or the like is often provided, but it is also preferable to use this backup computer as the management computer 102 in the present embodiment. Further, in the present embodiment, the drawing attribute data 108 for search is used as search data for the drawing data 110, but the content is often fixed character data such as the title, date, and creator of the drawing data. Would be.

FIG. 2 shows a server computer 104, which is a main configuration of the database device according to the present embodiment.
A functional block diagram showing functions of the management computer 102 and the terminal device 112 is shown. As shown in FIG. 2, the server computer 104 first has a drawing attribute data addition / deletion / update information accumulation processing function 104a for search.
Is provided. This function is actually a program that realizes this function (and a CP that executes the program).
U). All the following functions are also realized by the program and the CPU that executes the program. The search drawing attribute data addition / deletion / update information accumulation processing 104a is a function of accumulating update information of drawing data in the own department, and is a function of creating the above-described log file. The log file created here is transmitted to the management computer 102 by batch processing when a predetermined time comes later. The server computer 104 has a search drawing attribute data addition / deletion / update information transmission processing function 104b. This function is to transmit the log file created by the search drawing attribute data addition / deletion / update information accumulation processing function 104a to the management computer 102.

The server computer 104 has a drawing attribute data receiving / updating function 104c for search. This function is a function of receiving the update information of the drawing data 110 in the other department received from the management computer 102 and reflecting it as the contents of the drawing data 110 and the drawing attribute data 108 for search in the own department. In addition, the server computer 104 has a high-speed page display data transfer processing function 104d. This function is a process of transmitting so-called preview data to the terminal device 112, and is a function of causing the terminal device 112 to execute high-speed turning display.

As shown in FIG. 2, the management computer 102 adds / deletes / retrieves drawing attribute data for search.
It has an update information collection processing function 102a. This function is to receive the above-mentioned log file from the server computer 104,
This is a function for constructing an update information file for No. 4. In addition, as shown in FIG. 2, the terminal device 112 has a high-speed turning-over display processing function 112a. This feature
As described above, this is a function that displays preview data at high speed and enables the user to quickly grasp the contents of the drawing data 110.

Hereinafter, registration and update processing of the drawing data 110 in the distributed database apparatus according to the present embodiment will be described with reference to flowcharts.

FIG. 3 is a flowchart showing how the drawing data is registered in each department. As shown in the figure, first, step S3-1
In, the server computer 104 receives the registration data of the drawing data from the client (terminal device 112).

Next, in step S3-2, the storage volume and directory of the drawing data 110 in the storage device are determined.

In step S3-3, the terminal device 11
2 is transferred to the storage location. Thus, the drawing data 110 is stored in a predetermined storage device.

In step S3-4, the drawing attribute data and storage location information are stored in a predetermined storage device as search drawing attribute data 108. As described above, the name of the creator, the title of the drawing data, the host name where the drawing data is stored, a predetermined path name, and the like are registered as the drawing attribute data.

In step S3-5, a log file is created using this registration data as update information data.
The present embodiment is characterized in that the drawing data is registered as drawing data 110 in a predetermined storage device by the server computer 104 in the own department, and that the drawing attribute data 108 for search is stored not only in the own department but also in other departments. It is also reflected in. In step S3-5, the server computer 104 accumulates the update information data as a log file in order to reflect the drawing attribute data 108 for search in the other departments. This log file is registered as an update information data table. Then, as described above, this log file is transmitted to the management computer 102 by batch processing when a predetermined time has elapsed.

FIG. 4 is a flowchart showing how the server computer 104 transmits a log file to the management computer 102.

The flowchart in FIG. 4 is started, for example, when a day's work is completed, when the log file capacity reaches a specified capacity, or when a user's explicit request from the terminal device 112 is made. When it is performed, etc. can be considered.

First, in step S4-1, it is confirmed whether or not the plurality of server management computers (the management computer 102 is connected to the management computer 102 via the wide area network 100. This is the case even when the management computer 102 is not operating. Because it is possible.

In step S4-2, as a result of the connection confirmation in step S4-1, it is confirmed whether or not connection is possible. As a result, if the connection is not possible, the processing of the flowchart in FIG. 4 ends.

If it is determined in step S4-2 that connection with the management computer 102 is possible,
The update information data table (log file) is exclusively locked (step S4-3). The exclusive lock is a process for prohibiting writing to the log file and holding the contents.

In step S4-4, all the update information data is read, and a text file representing the contents is generated. This text file becomes the transmission data to the management computer 102.

Next, in step S4-5, the text format file generated in step S4-4 is stored in a plurality of server management computers (management computer 1).
02).

In step S4-6, it is checked whether the transmission in step S4-5 has been completed normally. As a result of this inspection, when the transmission is completed normally, the process proceeds to the next step S4-7, but when the transmission is not performed normally, the process proceeds to step S4-8 described later.

In step S4-7, since the transmission has been completed normally, all the update information data (the text file and the update information data table (log file) created in step S4-4) are deleted. This is because the content of the log file is no longer required because the update information has been successfully transmitted to the management computer 102.

In step S4-8, the exclusive lock of the update information data table (log file) is released.
This makes it possible to write the contents of the drawing data 110 to a log file when the drawing data 110 is newly updated.

In step S4-9, the generated text file is deleted.

As described above, the server computer 1
From 04, transmission of the update data to the management computer 102 ends.

FIG. 5 is a flowchart showing a process of storing update information in the multiple server management computer (management computer 102).

First, in step S5-1, repetitive processing is performed. This corresponds to step S5 described below.
-2 to the processing in step S5-5 are performed by the number of departments (server computer 104) in this database apparatus.
) Is repeated.

In step S5-2, a check is made to a certain server computer 104 to determine whether the extracted update information is update information for the server computer 104 or update information for another server computer 104. Is done. If the result of this check is that the update information is addressed to itself, step S5 described later
The process shifts to -6, and the process for the next server is started. This is because there is no need to send back the update information for the server computer 104 to the user. On the other hand, if it is determined in step S5-2 that the information is update information for another server, the next step S5-3.
In step S5-3, the process shifts to step S5-3, the update information storage file is locked for the corresponding server computer 104. This prohibits another server computer 104 from operating this update information storage file freely.

In step S5-4, the update information transmitted this time is added to the update information storage file for the corresponding server computer 104. That is, when the update information is transmitted from the server computer 104, the content of the update information is added to the storage file as needed.

In step S5-5, the update information storage file for the corresponding server computer 104 is unlocked. By this unlocking, the update information storage file is stored in the corresponding server computer 104.
Can be transmitted.

In step S5-6, the above processing is repeated by the number of server computers 104 provided in the database apparatus.

As described above, the update information storage file is created. When a predetermined log file is transmitted from any of the server computers 104 by such processing, the server computer 1 other than the server computer 104 that has transmitted the log file is transmitted.
The contents of the sent log file are sequentially added to the update information storage file for the file 04.

FIG. 6 is a flowchart showing an operation in which the server computer 104 receives update information. The reception of the update information is performed by the server computer 104 accessing the management computer 102 at the end of the day's work as described above, but may be performed at any time by an explicit operation from the terminal device 102. It is possible.

First, in step S6-1, it is confirmed whether or not a connection has been established with a plurality of server management computers (management computer 102). This is shown in FIG.
Has the same meaning as in step S4-1.

In step S6-2, it is confirmed whether or not the connection with the management computer 102 has been established.
If not, the operation of the flowchart shown in FIG. 6 ends. If the connection with the management computer 102 is possible, the process proceeds to the next step S6-3.

In step S 6-3, an update information reception request is transmitted from server computer 104 to management computer 102.

In step S6-4, the update information is transmitted from the management computer 102 in response to the request in step S6-3. Then, the transmitted update information is received by the server computer 104.

In step S6-5, the contents of the received update information are checked to determine whether or not there is newly updated data. If there is no newly updated drawing data as a result of this check, the operation in FIG. 6 ends. This means that the drawing data 110 in another department has not been updated, and there is no need to update the contents of the search drawing attribute data 108. On the other hand, step S6-5
If the update data exists in step, the process proceeds to the next step S6-6.

In step S6-6, the database function in server computer 104 is locked. This restricts the use of the database function from the terminal device 112 because the drawing attribute data 108 for search of the drawing data 110 will be updated from now on.

In step S6-7, based on the update information sent from the management computer 102, the drawing attribute data 108 for search in the department is updated. In step S6-8, the database function in the server computer 104 is unlocked. By this unlocking, the use of the database function from the terminal device 112 is resumed.

FIG. 7 is a flowchart showing the operation of the multiple server management computer transmitting update information in response to a request from the server computer 104. The transmission of the update information corresponds to the operation of the server computer 104 shown in FIG. In other words, the flowchart shown in FIG. 7 is a flowchart when transmission and reception of update information is viewed from the multiple server management computer side, and a flowchart in FIG. 6 is a case where transmission and reception of update information is viewed from the server computer 104 side It is a flowchart of FIG.

First, in step S7-1, a transmission request for update information is received. This is a step corresponding to step S6-3 in FIG. 6 described above, and a request for transmitting update information is sent from the server computer 104.

In step S7-2, the server update information storage file is locked. this is,
This is to prevent the contents of the update information to be transmitted from being changed until the transmission is completed.

In step S7-3, the server update information storage file is transmitted. In response to this transmission, the server computer 104 receives the update information in step S6-4 in FIG.

In step S7-4, it is checked whether the transmission has been completed normally. As a result of this inspection, when the transmission has been completed normally, the process proceeds to the next step S7-5, and when the transmission has not been completed normally, the process proceeds to step S7-5.
The processing shifts to 6.

In step S7-5, since the transmission has been normally completed, the server update information storage file is emptied.

In step S7-6, the update information storage file for the server is unlocked, that is, unlocked. As a result, writing of the contents to the update information storage file for the corresponding server is permitted. If the transmission has not been normally completed in step S7-4, the process proceeds to step S7-6 without emptying the file in step S7-5. This is in consideration of sending the update information again in response to a request from the server computer 104 because the transmission was not performed normally.

As described above, each server computer 104 obtains the update information of the graphic data in the other department until yesterday by sending an update information reception request to the management computer 100 at the start of a new job, for example. It is possible. Therefore, the contents of the drawing attribute data for search 108 in the own department can be reflected in an update of the graphic data 110 in another department which is not real time, and the user
This makes it possible to retrieve the graphic data 110 even if the user does not know the storage location. In the present embodiment, the drawing attribute data 108 is updated, for example, at the start of a job, but it is also preferable to update the drawing attribute data 108 at any time in response to an explicit request from the terminal device 112.

FIG. 8 shows an example of the contents of a file ledger and a disk ledger in the server computer 104 of the department A of the database apparatus according to the present embodiment.
FIG. 8A shows a table representing a state of the file ledger of the server computer 104 of the department A. FIG.
As shown in (a), each file is a file id, a system node to which the file belongs, a machine name in which the substance of the file exists, a logical volume id, and a substance of the substance of the file. The full path name is
Each file is managed in the form of a table. The belonging system node indicates a department in FIG. 1 and indicates to which department the drawing data belongs. Further, the machine name having the substance of the file means the name of the actual server computer 104. In the example shown in FIG. 1, since each section has one server computer 104, A system node,
It matches the actual machine name. For example, in the file of the file id “103”, the belonging system node is the department A, and the actual machine name is “bumonA”.
It is. The logical volume id is a logical volume id of the storage device in which the file is stored. For example, when each server computer 104 has only a single volume id, as shown in FIG. For department A, “1” is set as the logical volume id,
Department 2 is assigned “2” as a logical volume id. Further, as shown in FIG. 8A, for each file, the actual full path name of the file is stored in the file register. This is, for example, u
This is performed by describing the path name in the ix.

FIG. 8B shows the state of the storage device 200 for storing the drawing attribute data 108 for search.
An explanatory diagram showing a state of a storage device that stores the drawing data 110 is shown.

FIG. 8C shows the storage contents of each storage device, that is, the disk ledger indicating the usage status of the hard disk in the form of a table. As shown in FIG. 8C, each storage device has a logical volume i.
d is assigned, which machine is used for each logical volume id, and unix (unix
Is a registered trademark of X / Open Corporation).
A system node id is set for each logical volume id.

FIG. 9 shows a table representing the contents of the preview data ledger in department A. This figure 9
As shown in (1), the file id and the corresponding logical volume id and unix file name are registered for each file representing each preview data. Further, the file name representing the preview data corresponding to the actual graphic data 110 is the graphic data 110.
Is registered for each entity. For example, file i
The file name of the preview data corresponding to d “103” is “f103.tif”.

The storage contents of the file ledger, the disk ledger, and the preview data ledger for the section A have been described above with reference to FIGS. 8 and 9, but such storage contents are almost the same for the sections B and C. .

As described above, according to the database apparatus of the present embodiment, the user can search for drawing data in another department without being conscious of where the drawing data is stored. It is possible. Also,
Since the drawing data belonging to each section can be distributed for each section, access to the drawing data for the own section can be improved. Even when the server computer 104 in another department is stopped, the database function can be used by the server computer 104 in the own department.

In this embodiment, the update information of the drawing data 110 is stored in the management computer 1 when the work is completed.
02, but may be performed at any time as long as the database service is free. In the present embodiment, the preview data is treated as information accompanying the drawing data 110. However, since the preview data has a small amount of information, it is also preferable to include the preview data in the drawing attribute data 108 for search. By including the preview data in the search drawing attribute data 108, the preview data can be displayed at a high speed at the time of the search, and the database can be searched very quickly. Further, when the preview data is included in the drawing data 110, it is preferable to cache the preview data inside the server computer 104. Since the information amount of the preview data is small, the preview data of the drawing data 110 accessed once can be stored in the cache, and the preview data cached when the same drawing data 110 is to be searched next time can be referred to. A quick search of the drawing data is performed.

[0086]

As described above, according to the first aspect of the present invention, while utilizing the characteristics of a distributed database, such as being less susceptible to the influence of other bases and being able to disperse risks, data can be obtained. And a distributed database device capable of quickly performing the search.

According to the second aspect of the present invention, since the management server centrally manages data updates in each local area network and provides data update information to other local area networks, It is possible to efficiently update attribute data in the local network.

According to the third aspect of the present invention, the process of retrieving and reading data and the display process are performed independently, so that the user does not have to wait unnecessarily, and the data can be quickly processed. Is obtained.

[Brief description of the drawings]

FIG. 1 is a configuration diagram illustrating a configuration of a distributed database device according to a preferred embodiment of the present invention.

FIG. 2 is a functional block diagram illustrating functions of a server computer, a management computer, and a terminal device in FIG.

FIG. 3 is a flowchart showing an operation of the server computer 104 when registering drawing data.

FIG. 4 is a flowchart showing an operation of the server computer 104 when transmitting a log file to the management computer 102.

FIG. 5 is a flowchart illustrating an operation of the management server when receiving a log file.

FIG. 6 is a flowchart illustrating an operation when the server computer 104 receives update information from the management computer 102.

FIG. 7 is a flowchart showing an operation when the management computer 102 transmits update information to the server computer 104.

FIG. 8 is an explanatory diagram showing a state of storing a file ledger, a disk ledger, and a disk in department A.

FIG. 9 is an explanatory diagram showing storage contents of a preview data ledger of department A;

FIG. 10 is a configuration diagram illustrating a configuration of a conventional distributed network device.

[Explanation of symbols]

100 wide area network, 102 management computer, 104 server computer, 108 drawing attribute data for search, 110 drawing data, 112 terminal device,
114 drawing attribute update data for search, 104a addition / deletion / update information storage function for drawing attribute data for search, 1
04b Search drawing attribute data addition / deletion / update information transmission processing function, 104c Search drawing attribute data reception / update processing function, 104d High-speed turning display data transfer processing function, 102a Search drawing attribute data addition / deletion / update information Collection processing function, 112a High-speed turning processing function.

Claims (3)

[Claims] 1. A local area network comprising: a plurality of local area networks; and a wide area communication line interconnecting the plurality of local area networks. Each of the local area networks includes data in a department to which the local area network belongs. Local data storage means for holding attribute data; attribute data storage means for storing search attribute data used to search all data managed by the distributed database; and data searched using the search attribute data. However, when stored in the local data storage means, read the data in the local data storage means, when not stored in the local data storage means,
Data reading means for reading data in the other local data storage means via the wide area communication line. 2. The distributed database device according to claim 1, further comprising: a management server connected to the local area network or the wide area communication line, wherein the local area network belongs to a department to which the local area network belongs; When the data is updated, the content stored in the local data storage means is updated, and the update content transmitting means for transmitting the updated content to the management server; and another local area network stored in the management server. And an attribute data updating unit that updates the storage content of the attribute data storage unit based on the update content of the data to which the local area network belongs. Update content storage means for performing Update content collection means for storing the update content transmitted from the content transmission means in the update content storage means, wherein the attribute data update means reads the content of the update content storage means at a predetermined timing, A distributed database apparatus, wherein the storage content of the attribute data storage unit is updated based on the update content of data in a department to which the other local area network belongs. 3. The distributed database according to claim 2, wherein the local area network includes a terminal device used by a user who uses the distributed database, wherein the terminal device is the data to be displayed. And a display means for sequentially displaying the data read by the data search means, a control means for asynchronously driving the display means, and a control means for asynchronously driving the display means. Distributed database device.