JPS63201747A - Design data base exclusive control system - Google Patents

Abstract

PURPOSE:To handle in the same way an access from a computer in which a data base has been constructed, and an access from other computer on a network, and to execute a soft control, by executing an exclusive control by a password. CONSTITUTION:Areas Ai, Aj... for setting a reference/updating password are provided on each node Ni, Nj... of a design data base of a tree structure. In this state, when a reference/updating request to some node exists, a data base managing system checks whether the request concerned satisfies a prescribed condition or not, and when said condition is satisfied, the password is delivered to a request terminal, and the request terminal sets it to a password store area of the node concerned. In such a way, an access right to its node and its subordinate node is obtained, and an access from on other computer can also be handled in the same way, and also, a soft control can be executed.

Description

[Detailed Description of the Invention] [Summary] A method in which exclusive control is performed using a password generated by a database management system as a key in a large-scale database that manages all design data on a device-by-device or system-by-system basis.

[Industrial application field]

The present invention relates to a large-scale database management system, and particularly to a processing method that performs efficient exclusive control on access requests from a large number of terminals.

[Conventional technology]

Most design databases are based on a single medium or a panpackage of LSIs, but recently, with the aim of improving response and operability, design databases are shared using private databases on each engineering workstation. There is a lot to do.

In terms of operability, the use of workstations is certainly superior, but workstations have small capacity, so it is not possible to build large-scale databases on their own, and simulations, etc., are not limited to LSil chips, but are difficult to use on a device-by-device basis. For large-scale projects, large-scale computers with large-scale databases are used.

To build a large-scale database using workstation databases, the databases of each workstation must be integrated, but since the data is distributed, it is difficult to manage. The methods of integration are categorized by type, such as integrating implementation data to create an implementation database, integrating logical information to create a logical information database, integrating image data such as documents to create an image database, and further integrating these to create a document ( There is a plan to implement it as a multimedia database that collectively manages logical data (symbols).

If the databases of each workstation were integrated into a single large-scale database of a large computer, a more useful database would be obtained. In such an integrated database, each workstation accesses each database, so exclusive control is important. For example, while workstation A is using database a to design, another workstation B accesses database a,
If this is updated, the processing of workstation A will become abnormal, so it is necessary to prohibit another person from updating it while one person is viewing it. Furthermore, if a certain person is updating a certain database b and another person references it, this is a problem and must be prohibited.

A financial institution's database is also referenced and updated by a large number of terminals, but in this case, the time required for one transaction is extremely short, whereas in the case of a design database, the time required for one transaction is extremely long.

[Problem that the invention seeks to solve]

Conventional database exclusive control methods include ■methods that use the data management function of a computer system, and ■methods that turn on/off flags for the exclusive control management table in the database management system. It is difficult to deal with multi-level data structures, and (2) has the drawback of not being able to respond to requests from other online-connected computer systems (workstations, etc.).

The present invention provides efficient exclusion of large-scale databases by issuing a password for accessing the target data in response to a database access request, and permitting access only to access requests for which the password is known. It seeks to provide control.

[Means for solving problems]

In the present invention, each node (Ni, Nj.

In an exclusive control method for a large-scale design database in which databases are distributed in locations (...), each notebook has a password storage area (Ai, Aj, etc.).

......), and in response to a reference/update request for a certain node, the database management system specifies that if the request is a reference request, it will include the fact that no update password has been set for the node or higher nodes; In the case of an update request, if predetermined conditions are met, including that no update/reference password is set for nodes below the node, the password is passed to the requesting terminal, and the requesting terminal sets the password in the password storage area of the node. This is characterized in that the nodes below the node are accessed.

[Effect]

According to this method, in order to perform exclusive control using a password,
Access from the computer on which the database is constructed and access from other computers on the network can be handled in the same way, and flexible control can be performed.

〔Example〕

As shown in FIG. 1, in the present invention, areas Ai, Aj, . . . for setting reference/update passwords are provided for each node Ni, Nj . . . of a tree-structured design database. Then, when there is a reference/update request for a node, the database management system checks whether the request satisfies predetermined conditions, and if it does, it passes the password to the requesting terminal, and the requesting terminal stores it in the password storage of the node. Set to area.

This gives access rights to the node and nodes below it. Next, we will explain the conditions for passing the password.

As shown in FIG. 4, it is assumed that the illustrated design database DDE has been constructed in order to develop system X. Devices A and B in this figure are, for example, computer systems A and B as shown in FIG.
2. Equipped with T3.

Computer system A has a large-scale database DB, computer system B and terminals 1 to 3 also have small-scale databases (not shown), and terminal T1 is part P of system X.
, Q, the design of P out of terminal T2. It is assumed that T3 is in charge of designing Q. A specific example of FIG. 4 is shown in FIG. In this figure, MMu is a memory management unit, CPU is a central processing unit, CHP is a channel processor, and PKG is a printed board.

The nodes Ni, Njl, and Ni2 in Figure 1 are connected to system
1 Equipment A and B are in charge, and PKGAl is in charge of NKI and NK2.
, PKGA2 will be in charge.

As shown in FIG. 1, when terminal T1 issues an access request to device A to perform its own work, the check shown in FIG. 2 is performed if the request is a reference, and the check shown in FIG. 3 is performed if the request is an update. That is, in the case of a reference request, as shown in FIG. 2, it is checked whether an update password has been set for the requesting node Njl in this example, and if it is (No), this reference request is rejected.

If not (YES), next check whether the request is for the top node, and if YES, accept it and send it to terminal T.
1, but since this is No in this example, the process advances to the next decision block.

In the next judgment block, check whether you know (obtained) the password on Rubel, and if you know it (in this example, you have already obtained Ni's password), check it, and if OK, accept the request. do. When you don't know,
It is checked whether an update password has been set in all the upper nodes that can be traced from the request node Nj+, and if there is no update password, the request is accepted, and if it is set in any one node, the request is rejected.

When making an update request, as shown in Figure 3, it is checked whether any reference/update passwords are set in the nodes below the request node, and if NO, this request is rejected and YES.
If S, next check whether the request is for the top level. In this example, the answer is NO, so check whether you know the password on the next rubel, and if YES, check it, and if OK, accept the request, and if you do not know, the update password is set on the upper node. Check to see if there is one, and if not, accept the request.

Examples of the password format include an update/reference identification code, a unique name of the access-requested node, and a random number.

〔Effect of the invention〕

As is clear from the above explanation, according to the present invention,
Since exclusive control is performed using a password, accesses from the computer on which the database is constructed and from other computers on the network can be handled in the same way, and flexible control can be performed.

[Brief explanation of the drawing]

Fig. 1 is an explanatory diagram of the principle of the present invention, Figs. 2 and 3 are flowcharts showing the password generation procedure, Fig. 4 is an explanatory diagram of the design database, Fig. 5 is an explanatory diagram of the hardware, and Fig. 6 4 is an explanatory diagram showing a specific example of FIG. 4. FIG.

Claims (1)

[Claims] Each node (Ni, Nj,...) has a tree structure.
In the exclusive control method of a large-scale design database where databases are distributed on multiple nodes, each node has a password storage area (Ai, Aj,...
...) is added, and in response to a reference/update request for a certain node, the database management system will specify that if the request is a reference request, it will include the fact that no update password has been set for the node or higher, and if it is an update request, it will include the If predetermined conditions are met, including that the update/reference password is not set in any node below the node, the password is passed to the requesting terminal, and the requesting terminal sets the password in the password storage area of the node and transfers the password to the node. A design database exclusive control method characterized by accessing the following nodes.