JPH11327977A - Distributed data base management device and system therefor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make a distributed data base connectable to the DBMS(data base management system) of another company specially and to make it retrievable without depending on the function of a certain specified DBMS. SOLUTION: In this distributed data base management device composed of plural computers distributed on a network and the plural data base management systems(DBMS) connected to the respective computers for which data are distributed, the respective computers are provided with an input device 1 such as ten keys and a keyboard, etc., a link information management means 2 for managing link information in the network of the distributed data base and an output device 3 such as a display device, a printer and a facsimile, etc., The computer provided with the data base is composed of a communication management means 4 for managing network communication, a DB operation means 5 for performing a direct operation to the DBMS 6 and the DBMS 6 for storing actual data and performing the operation to the data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a distributed database management method and a distributed database management apparatus, and more particularly to a distributed database management method and a distributed database management apparatus operable as if they are a single database. And its control method.

[0002]

2. Description of the Related Art Conventionally, a distributed database (Distribute
d Database) is a network that combines geographically dispersed databases over a network to create a single integrated database. A distributed database system is a logical database that connects existing different databases over a network. , And a bottom-up type that manages and maintains it, and a new logical database,
Effectively combined database in each network,
There is a top-down type that is divided into independent computer systems that are geographically separated.

In a conventional computer system, a method of constructing a system by flexibly combining a group of programs and a group of data (hereinafter referred to as a group of parts) and a method of managing the group of parts for that purpose are described. Object-oriented programming techniques have become useful means, and in object orientation, the concept of an object is one object of a capsule in which a program (method) and data (instance) are paired.

A link sensor management method in such a distributed database processing system is disclosed in Japanese Patent Application Laid-Open No. 5-1892.
No. 90 is disclosed. In this publication, as shown in FIG. 6, a terminal 2-4 connected to a network 1 constitutes a distributed database processing system.
Each has a database. Further, the terminal 3 holds a link sensor 5 including a link sensor A and a link sensor B. The terminal 4 has a role of a management center, includes a link sensor registration file 6, and performs registration, deletion, reference, and the like of the link sensor in response to a request from each terminal. The registered information associates the identification name of the link sensor with the identification number of the terminal holding the link sensor. If a terminal that defines and holds a link sensor permits (discloses) use to other terminals,
Request the management center terminal 4 to register the link sensor in the link sensor registration file 6. What is registered is at least the command for identifying the link sensor and the terminal number that defines the link.

[0005] A terminal wishing to integrate and process a database distributed to each terminal, as to whether or not there is a link sensor for integrating the distributed data, or, if it exists, information about a terminal holding the link sensor. When a request is made to the terminal 4 and the identification number of the terminal holding the link sensor is obtained, the link sensor is transferred from the target,
The respective data for which the link relationship is defined by the link sensor are accessed for processing. Link sensors include:
Link data that defines a hierarchical data structure, relational link data that defines the relationship between tables,
It includes grouping data for controlling a plurality of data as one group, operation link data for defining an operation between a plurality of operand data, and the like.

In the network configured as described above,
(A) The terminal 3 defines a link sensor A and a link sensor B, each of which collects a plurality of data. (B) The terminal 3 requests the management center terminal 4 to register the link sensor A and the link sensor B, and the management center terminal 4 registers the link sensor in the link sensor registration file 6 and releases the use to any terminal in the network. (C) When the terminal 2 issues a processing request of the calculation X = A + B between the link sensor A and the link sensor B, the terminal 2 knows that the link sensors A and B are not in its own terminal,
(D) Terminal 2 sends link sensors A and B to management center terminal 4
(E) The management center terminal 4 searches the link sensor registration file 6 and returns the identification number of the terminal 3 holding the link sensors A and B. (F) The terminal 2 knows the terminal 3 from the answered identification number, and the link sensors A and B
(G) the terminal 3 transfers the data of the link sensors A and B to the terminal 2, and (h) the terminal 2
The operation result X is output using B.

In this manner, by accessing an arbitrary link sensor defined and held by another terminal in the network via the management center terminal, a plurality of data distributed to each terminal in the network can be obtained. Can be easily used as a single link sensor.

[0008]

However, as in the case of the above-mentioned management center terminal, the distributed database uses a specific DBMS (Data-Base Management Sys- tem).
tem), and could not be connected to any other company's DBMS.

The present invention provides a distributed database operating method that solves the above problems.

[0010]

SUMMARY OF THE INVENTION The present invention solves the above-mentioned problems, and comprises a plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter, referred to as "database management systems") connected to each computer. DBM
S), wherein each of the computers includes an input device such as a numeric keypad and a keyboard, a link information management means for managing link information in a distributed database network, and a display. A computer having an output device such as a device, a printer, and a facsimile, and having a database includes a communication management unit that manages network communication, and a DB operation unit that performs a direct operation on a DBMS (Data-Base Management System). , And a DBMS for storing actual data and performing operations on the data.

Further, the present invention comprises a plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter referred to as DBMS) connected to each computer. In the database system, each of the computers includes an input device such as a numeric keypad and a keyboard, a link information management unit that manages link information in a distributed database network, an output device such as a display device, a printer, and a facsimile. Communication management means to manage, and DBMS (Data-Base Manage
ment System), and a DBMS for storing actual data and performing an operation on the data.

Further, the present invention comprises a plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter referred to as DBMS) connected to each computer. In a database system, an operation target of an operation input from an input unit is a DBMS on any computer.
Link information management means for determining whether the information is stored in the
A communication management unit for requesting the DB operation unit of the computer to perform an operation, a DB operation unit for executing the requested operation on the DBMS, and transmitting the operation result returned from the DBMS to the communication management unit. It is characterized by comprising DB operation means, communication management means for returning the operation result to the link information management means, and link information management means for outputting the operation result to an output device.

Still further, the present invention comprises a plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter, DBMS) connected to each computer, in which data is distributed. In the control method of the distributed database system, it is determined on which computer the operation target of the operation input from the input unit is stored in the DBMS, and the operation is requested to the DB operation unit of the computer, and the requested Executing an operation on the DBMS, returning the operation result returned from the DBMS to the link information management unit by the communication management unit, and outputting the operation result to an output device; And

[0014]

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

[First Embodiment] (Configuration of this Embodiment) Referring to FIG. 1, in this embodiment, an input device 1 such as a numeric keypad or a keyboard, and link information for managing link information in a distributed database network Management means 2, an output device 3 such as a display device, a printer, a facsimile, etc., a communication management means 4 for managing network communication, and a DBMS (Data-Base Management Sys- tem) provided in each of a plurality of computers.
tem) and a DB operation means 5 for directly operating the data, and a D for storing actual data and operating on the data.
BMS6. Each computer may be any of a large computer database, a workstation, a personal computer (PC), etc., and each computer may hold a database,
You don't have to. Although FIG. 1 does not show a network, the network is formed by a plurality of personal computers.
An output device 3 and link information management means are provided. At least one personal computer is provided with a communication management means 4 for communicating with a personal computer having a distributed database among a plurality of personal computers. FIG. 3 illustrates a form in which the management unit virtually manages the information.

Note that what kind of database the network has is, for example, each personal computer, and the link information management means 2 holds a table as shown in FIG.

The link information management means 2 determines which data
Information on which record of which computer's DBMS is stored is stored in advance.

The database operating means 5 of each computer
Is transmitted to the link information management unit 2 via the communication management unit 4.
Means for receiving a data operation instruction from the server, and converting the operation instruction into an instruction for the DBMS 6 to which it is connected;
There is provided a means for converting the operation result returned from the BMS 6 into a format understandable by the link information management means 2. (Description of Operation of the Present Embodiment) Next, the operation of the present embodiment will be described in detail with reference to FIGS. FIG. 2 shows a table managed by the link information management means 2,
FIG. 3 shows a flowchart for searching the database, and FIG. 4 shows an example table of the database held by the DBMS 6.

A command "search 1" meaning search of ID1 of the link information management means 2 is input from the input device 1 (301). The link information management means 2 searches the table of FIG. 2 to determine whether or not it manages ID1 (30).
2, 303). If the search is not successful, an unsearchable output is output to the output device 3 (312). If the search is successful, the corresponding machine name and key are extracted (304), and the search target is converted from ID1 to the corresponding key 1000 (305). The converted search command is transmitted to the machine name machine-A corresponding to ID1 by the communication management means 4 (306).

The DB operation means 5 of the computer corresponding to the machine name machine-A converts the search command received from the communication management means 4 into a search command unique to the connected DBMS, and requests the DBMS 6 to execute. (307). For example, the DBMS 6 uses standard SQL (Structured Query L).
(language: query language of the database), and the table configuration is composed of ID, name, and affiliation as shown in FIG.
Name affiliation from employee where ID = 1000 ”D
The B operation means 5 returns the result of the search (308) by the DBMS 6 to the link information management means 2 via the communication management means 4 (310). The link information management means 2 outputs the search result to the output device 3 if the search is successful from the returned search result (311), and outputs a search impossible output to the output device 3 if the search is not successful. (312).

Next, when the command input from the input device 1 is "search 2", the link information management means 2 searches for the machine name machine-B and the key ABCD. As a result, it requests machine-B to search ABCD.

In the first embodiment of the present invention, the case where two different databases are used has been specifically described, but the number of databases is not limited. Further, the same database may be used. Although only the search has been described, data can be updated or newly inserted.

[Second Embodiment] Next, a second embodiment of the present invention will be described in detail with reference to the drawings.

Referring to FIG. 5, this embodiment is characterized in that the link information management means 2 is a table in which the DBMS 6 shown in FIG. 1 is provided with link information.

Normally, similarly to the operation of the normal DBMS 6, when the ID "1000" is searched, "Taro Yamada" and "Fifth Development Department" are returned as a result.

However, when the ID "7777" is searched, the link information management means 2 branches the process from the content of the link information item. In this case, since "http://www.aa.bb/cc.html" is detected, a WWW (World Wide Web) browser is started and its URL (Uniform Resource Locator: information such as files distributed on the Internet) Notation method for uniquely specifying the storage location of the resource). This link information is based on HTTP (Hyper Text Transfer Protocol:
W to exchange hypertext on the Internet
An arbitrary protocol can be defined in addition to a protocol (a native protocol used in a WW server). Only what kind of processing is performed for which protocol may be incorporated in the link information management means 2. Here, the case where the description format of the link information is URL has been described, but any other description format may be used. By adopting such a configuration, the system of the present invention can be arbitrarily connected to the same system of another machine, and can be easily linked to the conventional system.

[0027]

According to the present invention, firstly, since the part for operating each database and the part for the user to operate are made independent, by preparing one virtual table, various distributed The ability to operate the database.
As a result, it is possible to uniformly handle a conventional database using a large computer, a database such as a workstation or a personal computer, and it is also easy to replace individual databases.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of a distributed database according to an embodiment of the present invention.

FIG. 2 is a virtual table of a distributed database according to an embodiment of the present invention.

FIG. 3 is an operation flowchart of a distributed database according to the embodiment of the present invention.

FIG. 4 is a holding table of a distributed database according to the embodiment of the present invention.

FIG. 5 is a holding table of a distributed database according to the embodiment of the present invention.

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

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Input device 2 Link information management means 3 Output device 4 Communication management means 5 DB operation means 6 DBMS

Claims (7)

[Claims] 1. A plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter referred to as DBMs) connected to each computer.
S), wherein each of the computers includes an input device such as a numeric keypad and a keyboard, a link information management unit that manages link information in the network of the distributed database, and a display. A computer having an output device such as a device, a printer, and a facsimile, and having a database includes a communication management means for managing network communication, and a DBMS (Da
A distributed database management apparatus comprising: a DB operation unit for directly operating a ta-Base Management System; and a DBMS for storing actual data and performing an operation on the data. 2. The computer according to claim 1, wherein each of the computers is a database of a large computer, a workstation, a personal computer, or the like, and the link information management unit includes a memory table representing the contents of the database, and is as if it were one database. 2. The distributed database management device according to claim 1, wherein the distributed database management device is operable as if. 3. A plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter referred to as DBMs) connected to each computer.
S), a distributed database system in which data is distributed, wherein each of the computers includes an input device such as a numeric keypad and a keyboard, link information management means for managing link information in a distributed database network, and a display device. Output devices such as printers, printers and facsimile devices, communication management means for managing network communication, and DBMS (Da
A distributed database system, comprising: a DB operation unit for directly operating a ta-Base Management System; and a DBMS for storing actual data and performing an operation on the data. 4. The computer according to claim 1, wherein each of the computers is a database, a workstation, a personal computer, or the like using a large-sized computer, the link information management unit includes a memory table representing the content of the database, and the communication management unit includes 4. The distributed database system according to claim 3, further comprising data conversion means for converting the data format between the link information management means and the DB operation means. 5. The system according to claim 3, wherein the DB operation means is prepared according to the type of the DBMS, so that different DBMSs are virtually operated as if they are one database. Distributed database system. 6. A plurality of computers distributed on a network and a plurality of identical or different database management systems (hereinafter referred to as DBMs) connected to each computer.
S), in a distributed database system in which data is distributed, link information management means for determining on which DBMS the operation target of the operation input from the input means is stored, and Communication management means for requesting the DB operation means to perform an operation, DB operation means for executing the requested operation to a DBMS, and the DBM
The DB operation means for sending the operation result returned from S to the communication management means, the communication management means for returning the operation result to the link information management means, and the link information management for outputting the operation result to an output device Means, a distributed database system comprising: 7. A plurality of computers distributed on a network, and a plurality of identical or different database management systems (hereinafter referred to as DBMs) connected to each computer.
S), wherein in the control method of the distributed database system in which data is distributed, it is determined on which computer the operation target of the operation input from the input means is stored in the DBMS, and the DB operation of the computer is performed. Requesting an operation to the means, executing the requested operation on the DBMS, returning the operation result returned from the DBMS to the link information management means by the communication management means, wherein the link information management means comprises: A control method for a distributed database system, wherein the operation result is output to an output device.