JPH08227369A - Centralized management method for multiple databases - Google Patents

Abstract

(57) [Abstract] [Purpose] It is possible to centrally manage the distributed databases by establishing a method that treats the distributed databases on the network as one normalized database. It provides a unified management method for multiple databases. In a method of managing a plurality of databases connected on a network, a business use information 111, a database search program 112, and an information management database 11 including data item management information 113 are provided. Includes information for specifying the database search program 112 related to the information, and the database search program 112 includes information for specifying the data item management information 113 related to the information, The data item management information 113 includes information for identifying the databases 31 and 32 on the network. By tracing the business use information, the database search program, and the data item management information, the databases 31 and 31 on the network. To access.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an integrated management method for a plurality of databases connected on a network, and more particularly to operational management of databases and improvement of convenience when searching the databases.

[0002]

2. Description of the Related Art As a method of accessing a resource connected on a network, there are methods proposed in, for example, JP-A-1-166158 and JP-A-5-46569. Further, as a method for managing distributedly arranged databases, Japanese Patent Laid-Open No. 5-135113
There is a management system proposed in the publication
In this system, with regard to distributedly arranged databases, in particular, those in which data are arranged in duplicate are handled.

In addition, as a technique for database management / convenience, "Network Computing, 19
January 1993, Special Issue: Challenges for Verification and Distributed Systemization, p2
0 to 25 ": Build a purpose-specific database from a plurality of databases, and rebuild the database from usage information.・ Present information such as the location of the existing database to the user for convenience. Etc. are described.

[0004]

DISCLOSURE OF THE INVENTION Problems to be Solved by the Invention
In Japanese Patent Laid-Open No. 8 and Japanese Patent Laid-Open No. 5-46569,
Although it includes a database as a computer resource,
No specific method of accessing the database is disclosed. Further, Japanese Laid-Open Patent Publication No. 5-135113 deals with data in which data is redundantly arranged, but does not disclose a method for centrally managing distributedly arranged databases, and does not disclose an actual database. However, there is a problem that multiple database tables for management are required.

Further, in the above-mentioned "network computing", there is no concept of managing the whole of a plurality of scattered databases, so that duplicated items still exist in the scattered databases.
There are problems such as having to manage each database. Also, regarding the reconstruction of the database according to the frequency of use, no method has been proposed for reconstructing the original database, such as reconstructing the database constructed for each purpose.

The present invention has been made in view of such a situation, and establishes a method of recognizing a database distributedly arranged on a network as one normalized database apparently, thereby making a distributed arrangement. It is an object of the present invention to provide a unified management method for a plurality of databases that enables unified management of existing databases.

[0007]

SUMMARY OF THE INVENTION The present invention solves the above problems by constructing an information management database for managing a database distributed and arranged on a network, and providing information on the distributed database and the like. It is solved by accumulating in the database. That is, the unified management method for a plurality of databases according to the present invention is
A method for managing a plurality of databases connected on a network, which has an information management database including business usage information, a database search program, and data item management information, and the business usage information is a database related to the information. It contains information to identify the search program, the database search program contains information to identify the data item management information related to that information, and the data item management information identifies the database on the network. The information on the network is included, and the database on the network is accessed by tracing the business use information, the database search program, and the data item management information. Then, the management information of the data item includes the location information of the data item, the meaning of the data item, the explanation, and the search and use record.

[0008]

FIG. 1 is a diagram showing the relationship between an information management database and distributed real databases according to the present invention. The operation of the present invention will be described below with reference to this drawing. As shown in FIG. 1, the information management database 1
1 includes a business use 111, a database search program 112, data item management information 113, data item location information e, a data item meaning / commentary f, and a past search usage record g related to the data item. The information 114 is registered in association with each other. In the illustrated example, when performing the business use B, a, b, and c of the database search program 112 are registered as related programs. Further, the data items used in the data search program 112 are registered in association with the data item management information 113. Further, the location information e of the data item of the information 114 includes the corresponding real databases 31, 3 of the data item management information 113.
The location information of 2 is registered.

By constructing the information management database 11 having such a configuration, the business use 111,
By tracing the related network between the database search program 112, the data item management information 113, and the information 114 including the location information e of the data item, the meaning / commentary f, and the search usage record g, it is distributed and arranged on the network. The plurality of real databases 31 and 32 can be used as one logically normalized database corresponding to the business.

[0010]

[Embodiment] Next, as an embodiment of the present invention, the overall configuration, construction of an information management database, search using them, reconstruction of an actual database, construction of a database for each purpose,
And each usage example of creating a corporate data model will be described.

(1) Overall Configuration of Embodiment FIG. 2 is a block diagram showing the overall configuration of an embodiment of the present invention. In the figure, a database operation instruction device 8 is an interface for a user to handle a database,
At the same time as the user gave an instruction to search the database, reconstructed the actual database, constructed a database for each purpose, created a company data model, registered new information in the information management database, etc. It has a function to display the result. The contents instructed by the user by the database operation instruction device 8 are sent to the information management database operation / maintenance / management device (hereinafter referred to as management device) 5. Here, the instructed function is executed by referring to the contents of the information management database.

When searching a database,
The management device 5 interprets the contents of the information management database, creates a program for searching the real database, and passes it to the real database search device 3. The real database search device 3 searches the real database from the passed search program and returns the result to the management device 5. The management device 5 synthesizes the returned data and passes it to the database operation instruction device 8, and the database operation instruction device displays the result.

In the case of rebuilding the real database, the management device 5 collects data on the usage status of the real database from the information management database 11 and sends it to the real database rebuilding device 2. In the real database reconstructing device 2, unused items on the real database are deleted from the sent information.

When constructing a purpose-specific database, the database operation instructing device 8 selects an item of the database to be constructed. In the management device 5, the information management database 11 stores the location information of the selected item.
And sends it to the purpose-specific database construction device 7.
In the purpose-specific database construction device 7, based on the received information, the data of the designated item is loaded from the real database group 1 distributed and arranged on the network,
The purpose-specific database 6 is constructed.

In the case of creating a company data model, the management device 5 obtains from the information management database 11 information on the usage status of each item in the real database distributed over the network, and uses that information as the company information. It is sent to the data model creation device 9. The company data model creation device 9 creates a company model based on the sent information and displays it on the database operation instruction device 8.

(2) Construction Example of Information Management Database FIG. 3 is a diagram showing a construction example of the information management database. This figure is shown corresponding to the information management database of FIG. 1, and A, B, C, and D of the figure are layers 111, 112, 113, 114 of the information management database of FIG.
It corresponds to. Each layer A, B, C of this database
A storage area for collectively storing data is secured in D, and related data is linked by having a pointer pointing to the storage area in each layer. The data structure as shown in FIG. 3 can be realized by using an existing programming language.

In each storage area 111a of the A layer, a storage area for storing a usage department, a business name, a search condition, a usage record, and a pointer pointing to a related storage area of the B layer is secured. In each storage area 112b of the B layer,
A storage area for storing a search program name, a comment about the program, a search condition, a usage record, and a pointer that points to an item used in the search program is secured. A storage area for storing the item name and a pointer indicating the storage area of the D layer related to the item name is secured in each storage area 113c of the C layer. A storage area corresponding to the storage area of the C layer exists in the D layer, and a storage area for storing the machine name, the database name, the table name, the comment, and the usage record is secured in each of the storage areas 114d. ing.

In the data item management information 113, if the data items used in the non-normalized real databases distributed in the real database group 1 have the same data item name and the same data content, a representative The data item that becomes is selected and registered. That is, referring to the example of FIG. 1, although the management information 113 of the data item B is used in both the real database AA31 and the real database BB32, the information management database 11
Since the registration is the same item, the data location information of the data item a is defined to exist in the actual database AA31. Therefore, the information management database 1
By searching the actual database based on the various information registered in No. 1, even data items used in a plurality of databases are registered so that the data items do not overlap. By constructing the information management database 11 using the data and the data structure linked to each layer as described above, it is possible to easily search the database and reduce the registration of new work.

(3) Search Example Here, an actual database search algorithm using the information management database 11 will be described. (B) When specifying and searching an item FIG. 4 is a flowchart showing a search algorithm diagram (algorithm 1) when specifying and searching an item.
When the user selects an item to search, the user selects the item to be searched from the storage area of the C layer of the information management database (S30, S31). Next, the user sets search conditions, generates a search program (S31), and searches the actual database (S33). When there are a plurality of real databases to be used, a search is performed for each real database (S34), and the result is stored in the primary storage area (S35). When the search of all the actual databases is completed, the search results stored in the primary storage area are combined (S37), and the combined result is displayed (S38). Then, the usage record of each layer is counted up (S3
9). When registering the above series of searches as a business (S40), new storage areas are secured in layers A and B of the information management database (S41, S42). Enter the required data in the reserved area. The pointer of layer B is stored in the newly secured storage area of layer A (S4).
3) The item used for the search is searched from the C layer, and the C layer pointer is stored in the newly secured storage area of the B layer (S44).

(B) When Business is Already Registered FIG. 5 is a flowchart showing a search algorithm (algorithm 2) when business is already registered. If the business has already been registered, the business to be used is selected from the storage area of the layer A of the information management database 11 (S10). Information of a program used at the time of search (storage area of layer B) is linked to the storage area in which the information of the selected job is stored, and items used by the search program are stored in the storage area of layer B. Information (C layer, D
Layers) storage areas are linked, and the above links are followed. That is, the storage area indicating the B layer in the storage area of the A layer is searched (S11), the corresponding program is selected from the displayed programs of the B layer (S12), and the selected program is executed (S13). Next, the usage record of each layer is counted (S14), and then the search result is displayed (S15).

(4) Embodiment of Reconstructing Real Database Here, an algorithm for reconstructing the real database group 1 using the information management database 11 will be described with reference to FIGS. 2 and 3. FIG. 6 is a flowchart showing an algorithm for reconstructing the real database 1. From the usage record of the D layer of the actual database 1 accumulated in the information management database 11, an item having a low usage frequency is searched and listed out by the printing device (S50). Based on the usage status of each of the data items listed out, the unnecessary data items are selected in consultation with the database use department, and the database operation instruction device 8 to the management device 5 are selected.
It instructs to delete unnecessary items (S52). The instructed management device 5 creates a program for deleting unnecessary data items and passes the reconstruction program to the actual database reconstruction device 2 (S53). The real database reconstructing device 2 executes the reconstructing program to delete the item and returns the result to the management device 5. The management device 5 confirms the deletion of the unnecessary items, deletes the unnecessary items registered in the information management database 11, displays the deletion completion of the unnecessary items on the database operation instructing device 8, and displays one real database. Reconstruction is completed (S54).

(5) Example of Constructing Purpose-Specific Database Here, an algorithm for constructing the purpose-specific database 6 using the information management database 11 is shown in FIG.
And FIG. 3 will be described. FIG. 7 is a flowchart showing an algorithm for constructing a purpose-specific database. A necessary storage area for data items for constructing the purpose-specific database 6 is secured from the C layer of the information management database 11 (S60). Next, a program for loading the purpose-specific database 6 to be created is created (S61). As shown in FIG. 8, the purpose-specific database 6 to be created
The management device 5 sets the creation timing, the load program, and the machine names distributed in the network you want to build.
And a new storage area 115e is secured in the E layer of the information management database 11 and necessary information is input (S6).
2), a new storage area is secured in the B layer of the information management database 11, and the created program name is stored in association with the pointer of the storage area 115e of the E layer of the information management database 11 (S63). .

The management device 5 includes the information management database 1
The creation timing is obtained from the information of the E layer registered in No. 1, and the program for building the purpose-specific database 6 is passed to the purpose-specific database building device 7 (S64). If there are multiple real databases for construction of the purpose-specific database 6, the purpose-specific database construction device 7 executes each database (S65), stores the search results in a temporary storage area (S66), and stores all real databases. When the search is completed, the contents stored in the temporary storage area are combined (S6
7) Build the purpose-specific database 6 in the machines distributed in the instructed network (S68,
S69).

(6) Example of creating a corporate data model A corporate data model is defined as defining a relationship between data and work, and associating the data based on the usage record of the data. . Here, an algorithm for creating a company data model using an information management database will be described with reference to FIGS. 2 and 3. When the database operation instruction device 8 instructs the company data model creation support device 9 to create a company data model based on the usage department, A, B, C, D stored in the information management database 11 through the management device 5. By creating a company data model from the information and usage records of the layers and displaying it on the database operation instruction device 8, the relationship between the data items used in each department and the work and the sharing status of the program between the using departments are clarified. it can. In this way, the data model as shown in FIG. 9 is created.

On the other hand, when the database operation instructing device 8 instructs the company data model creation support device 9 to create a company data model based on an item, the management device 5 controls the A, B, C, and D layers of the information management database 11. By creating a company data model from the information and the usage record and displaying it on the database operation instructing device 8, the program name used for each data item, its comment, and the business name can be obtained. The situation, purpose of use, and utilization of data items in the database between each department are identified. In this way, the data model as shown in FIG. 10 is created.

[0026]

As described above, according to the present invention, there is an information management database including business usage information, a database search program, and data item management information. The database on the network is accessed by tracing the database search program and the data item management information. As a result, the databases distributed over the network can be regarded as one normalized database in appearance. Therefore, by searching the database through the information management database, the database to be searched Users can use the database as if they were searching a single database, even if they are scattered.
Therefore, the distributed databases can be easily managed, and the users can easily search the databases. In addition, by registering the usage record information for each item in the information management database, it is possible to avoid unnecessary item registration and duplication of items, and to reconstruct the actual database. it can. Further, a purpose-specific database corresponding to the purpose of the user can be automatically created by using various information in the information management database.

[Brief description of drawings]

FIG. 1 is a structural conceptual diagram of an information management database of the present invention.

FIG. 2 is a block diagram showing an overall configuration of an embodiment of the present invention.

FIG. 3 is a diagram showing a configuration example of an information management database of FIG.

FIG. 4 is a flowchart showing a search algorithm using an information management database in the embodiment of FIG.

5 is a flowchart showing a search algorithm using an information management database in the embodiment of FIG.

FIG. 6 is a flow chart showing an algorithm for reconstructing a real database using the information management database in the embodiment of FIG.

FIG. 7 is a flow chart showing an algorithm for constructing a purpose-specific database using the information management database in the embodiment of FIG.

FIG. 8 is a diagram showing another configuration example of the information management database of FIG.

FIG. 9 is a diagram of a company model for each utilization department created by using the information management database in the embodiment of FIG.

10 is a diagram of a company data model for each data item created by using the information management database in the embodiment of FIG.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Osamu Amzaki 8-27 Konan, Minato-ku, Tokyo NK Exa Co., Ltd.

Claims (2)

[Claims] 1. A method for managing a plurality of databases connected on a network, comprising an information management database including business usage information, a database search program, and data item management information, wherein the business usage information includes Information for specifying the database search program related to the information is included, and the database search program includes information for specifying the data item management information related to the information. The information includes information for specifying the database on the network, and the database on the network is accessed by tracing the business use information, the database search program, and the data item management information. Centralized management method for multiple databases. 2. The unified management method for a database according to claim 1, wherein the management information of the data items includes location information of the data items, meanings of the data items, explanations, and search usage records.