JPH08255168A - Method and structure for retrieval management of decentralized database, and integrated management database - Google Patents

Abstract

PURPOSE: To enable a client which belongs to a different department to easily access decentralized databases arranged in plural departments irrelevantly to the attributes of the structure formats, etc., of the decentralized databases. CONSTITUTION: The decentralized databases D1-Di which belong to the departments B1-Bi, clients W1-Wh, and Wi-Wn which belong to the decentralized databases D1-Di, and the integrated management database Dt stored with the kinds of retrieval contents stored in the respective decentralized databases D1-Di and the attributes of their structure formats, etc., are arranged; when one client makes a request for retrieval by sending retrieval contents to the integrated management database Dt, the integrated management database Dt selects a decentralized database matching the retrieval contents, makes the selected decentralized database to retrieve the retrieval contents, and sends the retrieval result from the decentralized database to the client, thus performing the retrieval from the decentralized database.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to distributed database search management of a distributed database that can be easily accessed by clients belonging to different departments regardless of attributes such as the construction format of the distributed database. The present invention relates to a method and an integrated management database used for the method.

[0002]

2. Description of the Related Art A conventional example will be described below with reference to the drawings. FIG. 6 is a block diagram of a distributed database management system. In this management system, the client W1
~ Wh and distributed database D shared by them
1 is integrated into a department B1, and the clients Wi to Wn and the distributed database D2 shared by them are integrated into a department B2, and a plurality of departments are independently constructed. .

[0003]

However, in the conventional management system described above, since the construction format of the distributed database environment of each department is usually independent, it is difficult for the client to know the construction format of different departments. is there. Also,
Accessing distributed databases of different departments by anticipating several construction formats does not necessarily mean that the predictions are correct. Therefore, there is a problem that the client repeats so-called wasteful work and wastes access time. is there. For example,
In FIG. 6, when the client Wn belonging to the department B2 accesses the distributed database belonging to the department B1, the client Wn repeatedly wastes the time.

On the other hand, in order to solve the above problems, it is conceivable to unify the information by integrating the departments into one department. For example, as shown in FIG. 7, the client W1
~ Wh, distributed database D1, client Wi ~ W
n, the distributed database D2 is one department B0. However, in order to unify the information, it is necessary to organize the information system of each department and build a comprehensive system that can be used by all departments. It takes time to build the integrated system because it takes time to adjust each department, and it is necessary to update it in response to changes in the situation of each department. For this reason, there is a problem that the completion time is delayed because the contents of the construction have to be changed according to the situation change even during the construction. In addition, there is a problem that the construction tends to be incomplete due to repeated changes.

Therefore, an object of the present invention is to enable a client belonging to a different department to easily access a distributed database arranged in each of a plurality of departments irrespective of attributes such as the construction format of the distributed database. That is.

[0006]

Therefore, according to the present invention, a distributed database belonging to a plurality of departments, a client belonging to each distributed database, and types of search contents stored in each distributed database are provided. And an integrated management database that stores attributes such as its construction format. When the client sends the search contents to the integrated management database and requests a search, the integrated management database is a distributed database according to the search contents. Select
Let the selected distributed database search the search contents,
The distributed database is searched by sending the search result from the corresponding distributed database to the client.

[0007]

With this configuration, even if the client side does not know the attribute such as the construction format of the distributed database of different departments, the distributed database between different department areas can be accessed through the integrated management database. Will be able to.

[0008]

Embodiments of the present invention will be described below with reference to the drawings. First Embodiment FIG. 1 is a block diagram of an integrated management system for distributed databases. In this integrated management system, the clients W1 to Wh and the distributed database D1 shared by them are integrated into a department B1, and the clients Wi to Wn and the distributed database Di shared by them are integrated together. Then, a plurality of departments are independently constructed so as to be the department Bi, and the integrated management database Dt is connected to the bus connecting the respective departments.
It should be noted that each distributed database preferably adopts a unified standard architecture.

As shown in FIG. 2, the integrated management database Dt is a distribution of the contents x stored in the distributed databases D1 to Di belonging to the departments B1 to Bi and the distributed construction of the distributed databases D1 to Di environment. It has a table for storing database attributes. The content x is
The contents are stored for each item function f (x) to which the contents belong. In addition to the table, a program for accessing the distributed databases D1 to Di from the integrated management database Dt according to the construction formats α, β, γ, etc. is stored in the integrated management database Dt.

Next, a search process of the integrated management system of the distributed database will be described. FIG. 3 is a block diagram illustrating the search process, and FIG. 4 is a flowchart of the search process. In the following description, for convenience of description, a case where the client Wn belonging to the department B2 receives the search result from the distributed database D1 belonging to the department B1 will be described.
Not limited to this, search results can be similarly received from other distributed databases between different departments. Sa1: The client Wn issues a search request Q to the integrated management database Dt as shown in FIG.
The search request Q is issued as Q (n → t) f (x). Here, the search item is f and the content is b, and is issued as Q (n → t) f (b). Sa2: The integrated management database Dt is the client W
When the search request Q from n is received, the table corresponding to the search request Q is searched, and the corresponding distributed database is selected from the table together with the attribute such as the construction format. Here, the distributed database D1 in which the content b is registered is selected from the table shown in FIG. 2 together with its construction format α. Sa3: As shown in FIG. 3, the integrated management database Dt indicates that there is a response of the result from the corresponding distributed database to the client Wn, the response A and the function D (f (x)) =
Using D1, ..., Di, A (t → n) D (f (x))
To send. In this case, A (t → n)
Send as D1. In addition, when there are a plurality of relevant distributed databases, for example, if the content is “a”, FIG.
Since the distributed databases D1 and D3 correspond from the table shown in (1), they are transmitted as A (t → n) D1 and D3. At the same time as this transmission, the integrated management database Dt, as shown in FIG. 3, is Q (n → 1) f (b) according to the construction format for each corresponding distributed database.
And the distributed database D1 is accessed directly from the client Wn. Sa4: The relevant distributed database D1 searches for the content b. During this search, the client Wn waits for a response from the distributed database D1 after receiving a response from the corresponding distributed database D1 in Sa3. When there are a plurality of relevant distributed databases, it is preferable to wait for all responses. This is for accurately processing the data in the client Wn. Also, if there is a distributed database that does not respond even after a certain period of time has passed, it may be transmitted to the integrated management database Dt for confirmation. Sa5: The corresponding distributed database D1 sends the result to the client Wn as A (1 → n) K (f (b)) as shown in FIG. When the client Wn receives all the search results, the process ends. Further, the relevant distributed database D1 may transmit the fact that the processing is completed to the integrated management database Dt. As a result, the integrated management database Dt can manage the search process until the end.

In the above processing, the case of accessing the distributed database of different departments has been described, but it is also possible to access the distributed database of the same department. For example, in the case of the content c, if the client Wn sends the search request Q to the integrated management database Dt, the integrated management database Dt will retrieve the distributed database D from the corresponding table.
1 and D2 are selected respectively. Then, the distributed database D1 is accessed as shown in FIG. 3, and the distributed database D2 is accessed as shown in FIG. Then, as shown in FIG. 3, the search result is sent from the distributed database D2 in the department B2 to the client Wn in the same department B2. As described above, the distributed database in the department may be accessed, or the distributed database in the department may be directly accessed as in the conventional case. This selection may be made by the client each time according to the usage form.

According to the first embodiment, the access to the distributed database between different department areas is performed through the integrated management database even if the client side does not know the attribute such as the construction format of the distributed database of the different department. You can In addition, the access to the distributed database in the same department area can be performed via the integrated management database even if it is accessed in the same department area in the same way as in the past, and it can be appropriately accessed according to the client's request. You will be able to choose. In particular, when there are many requests to the integrated management database, the distributed database within the same department area to which the client belongs is sent before the response result from the relevant database is sent after the access to the integrated management database. By directly accessing, both processes can be performed in parallel, and the request of the client can be appropriately met.

Further, as explained in the section of the problem to be solved by the invention, it takes less time than constructing a management system for a large distributed database in which all departments are integrated.
The integrated management database can be constructed, and when the contents of each department are changed, the integrated management database can be easily updated in response to the change.
Therefore, it is possible to centralize information in the distributed database with high certainty.

Further, access to the distributed database is
Since multiple integrated databases can be processed in parallel according to the instructions from the integrated management database, search results can be obtained in a shorter time than when the client individually accesses each distributed database. . In addition, compared to the case of accessing one distributed database individually from multiple departments, the distributed databases of different departments can be accessed via the integrated management database and On the other hand, it can be directly accessed. In this case, when there is a conflict in access to the distributed databases of different departments, the integrated management database waits in order and performs a sequential search process, and the distributed database in the same department competes with clients from other departments. Even in such a case, if the search process is prioritized for the clients in the same department, it is possible to prevent the client from waiting for the search process, so that the clients can be effectively used.

Embodiment 2 FIG. 5 is a block diagram of a distributed database integrated management system. This integrated management system is different from that of the first embodiment in that a client W0 outside the department which does not belong to any department is connected to a bus connecting each department B1 to Bi and the integrated management database Dt. By connecting in this way, the client W0 outside the department can use the distributed database similarly to the client inside the department described in the first embodiment. As a result, it is possible to obtain the effect of widening the usage of the distributed database.

The search processing procedure and the like other than the above-mentioned differences are the same as those in the first embodiment, and the description thereof is omitted. In the above embodiment, the search results are sent directly from each distributed database to the client.
The search result searched by each distributed database may be transmitted to the client via the integrated management database.

[0017]

As described above, according to the present invention, even if the client side does not know the attributes such as the construction format of the distributed database of different departments, the integrated management database can be used to access the distributed database between different department areas. The effect that can be done through is obtained. Therefore, it is possible to obtain an effect that a client belonging to a different department can easily access a distributed database arranged in each of a plurality of departments regardless of attributes such as a construction format of the distributed database.

[Brief description of drawings]

FIG. 1 is a block diagram of a distributed database integrated management system according to a first embodiment.

FIG. 2 is a table showing search contents f (x) and a construction format of each distributed database.

FIG. 3 is a block diagram illustrating search processing.

FIG. 4 is a flowchart of search processing.

FIG. 5 is a block diagram of an integrated distributed database system according to a second embodiment.

FIG. 6 is a block diagram of a conventional distributed database system.

FIG. 7 is a block diagram of a conventional integrated distributed database system.

[Explanation of symbols]

 B1-Bi department Dt integrated management database D1-Di distributed database W1-Wh, Wi-Wn client

Claims (5)

[Claims] 1. A distributed database that belongs to a plurality of departments, a client that belongs to each distributed database, and an attribute such as the type of search content stored in each distributed database and its construction format. When a client sends a search content to the integrated management database and requests a search, the integrated management database selects a distributed database according to the search content, and the selected distributed database The distributed database search management method is characterized in that the distributed database is searched by causing the client to search the search content and transmitting the search result from the corresponding distributed database to the client. 2. The integrated management database according to claim 1, wherein the distributed database name selected by the integrated management database is sent to the client who has made the search request, and the client is made to confirm that the search result is sent from the distributed database. A distributed database search management method. 3. A distributed database belonging to a plurality of departments, a client belonging to each distributed database, and an attribute such as the type of search content stored in each distributed database and its construction format are stored. When a client sends a search content to the integrated management database and requests a search, the integrated management database selects a distributed database according to the search content, and the selected distributed database A method for searching and managing a distributed database, characterized in that the distributed database is searched by causing the client to search the search contents and transmitting the search result from the corresponding distributed database to the client via the integrated management database. 4. An attribute such as a distributed database belonging to a plurality of departments, a client belonging to each distributed database, a type of search content stored in each distributed database, and a construction format thereof is stored. A distributed database search management structure characterized by the provision of an integrated management database. 5. An integrated management database having a table in which the types of search contents stored in each of the distributed databases of a plurality of departments and attributes such as their construction format are stored for each distributed database.