JPH1196209A - Method for editing shared data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make it possible to edit always a latest version without unnecessarily limiting the use of data by other persons by specifying an optional key by a key display mode at the start of edition to change the current mode to a reading mode, and after checking the contents of data, reading out the data again and locking them. SOLUTION: In the case of correcting data by a terminal PC1 e.g. a key display mode is set up at first and keys for respective data are listed up and displayed on a display of the terminal PC1 in order to read out optional data included in a data base 1. Then data 3 are read out based on a specified key, these read data are collectively displayed on the terminal PC1, data to be corrected are searched from the displayed data and the contents of the searched data are checked. When data to be correctively edited are specified and its key is specified, lock processing is started and the locked data are read out again from the data base 1 and displayed on the terminal PC1 to allow the edition of the data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for editing a shared database for adding or modifying data without any trouble when a plurality of users share the database.

[0002]

2. Description of the Related Art For example, in designing an integrated circuit, a circuit diagram in which a large number of circuit elements are combined is created using a CAD device or the like. In this case, the component information of the components mounted on the printed circuit board is extracted with reference to a database, and pasted on a design drawing or used for calculating design values.
Prior to the design of a product, all pieces of component information used for the product are registered as a library in the database.

If the target product has a complicated configuration, the new component library registered in this way and the correction processing of the component library registered so far become enormous.
Therefore, a database in which a component library is stored is simultaneously searched by a large number of operators, and the processing is advanced by each of the operators.

In such a case, when a plurality of operators try to correct one data, so-called processing conflict occurs. In this case, even if one operator saves the data after the predetermined correction processing,
If another operator competing and executing the correction processing resaves the data later, the immediately preceding correction result is wasted. In order to solve such a problem, when the correction processing is started, the data is locked so that another person cannot perform the correction work (Japanese Patent Laid-Open No. Hei 8-23).
No. 5233).

[0005]

However, the above-mentioned prior art has the following problems to be solved.
When a plurality of persons operate the shared database at the same time, the above-mentioned conflicts occur in various forms. However, it takes a considerable time before the contents of the database are read, the contents are examined, the correction is performed, and the data is stored again. Therefore, if the data is locked when the contents of the database are read in order to prevent another person from modifying the data, the data is locked for a long time. For example, we don't make any final adjustments,
During the browsing process, it may hinder others' correction work.

On the other hand, the contents of data are browsed slowly,
After that, when the data to be edited is determined and the editing process is started, another person may edit the data and change the content after reading the data. This makes it impossible to make changes to the latest data.

[0007]

The present invention employs the following structure to solve the above problems. <Structure 1> A key display mode for displaying a key of each data in order to read a plurality of data included in the database, and a browsing mode for displaying a plurality of data specified and read in the key display mode at a time A lock start mode for starting a lock operation for preventing rewriting of the corresponding data by another person for the key selected in the key display mode, and a lock operation target data after the lock operation is started. Re-read mode that reads from the database again and executes the lock if there is no lock by another person, edit mode that displays the re-read data and allows editing of the data, and the edited data to the database A lock release mode for writing and releasing the lock is sequentially executed. How to edit Yu database.

<Structure 2> A key display mode for designating a key of the corresponding data in order to add new data to the database, and a key specified in this key display mode is used by another person who uses the same key. Display the lock start mode to start the lock operation to prevent the addition of data, the additional lock mode to execute the lock when there is no lock by others after the start of the lock operation, and the items of the data to be added And an edit mode for permitting data input and an unlock mode for writing the edited data to the database to release the lock.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The embodiments of the present invention will be described below in order using specific examples. <Specific Example> FIG. 1 is a schematic diagram illustrating the system of the present invention. The system shown in the figure is configured to access the database 1 using, for example, a plurality of terminals PC1, PC2, and PC3 and edit the data 3. Each terminal is operated by a different operator. This database 1 registers, for example, a component library for integrated circuit design using CAD. The parts library is a data library of parts mounted on a printed circuit board so that the parts can be used in a CAD system. The parts library is composed of parts symbols, images, and other information on parts.

Data 3 contained in this database 1
Is configured to be searched by a predetermined key.
In the example of the figure, data 3 is information of A1, information of C1, and G
1, information of S1, information of T1, and the like. In the present invention, the data editing process is generally performed according to the procedure shown in the flowchart of FIG. For example, consider a case where data correction processing is executed using the terminal PC1. At this time, first, the key display mode shown in step S1 of the figure is executed. In this key display mode, in order to read arbitrary plural data included in the database 1, the keys of each data are listed up and displayed on the display of the terminal PC1.

In the next step S2, data 3 is read based on the key specified in the key display mode, and these are collectively displayed on the display of terminal PC1. In this way, the operator searches for data to be corrected, and confirms the content. In the next step S3,
Specify the data to be modified and edited, and specify the key. When the key is designated in this way, a lock process is started in order to prevent another person from editing the data. This is the lock start mode (step S3).

Next, the locked data is reread from the database 1 (step S4). By this re-reading, the editing process can be executed for the latest data. In the editing mode shown in the next step S5, the data is displayed on the display of the terminal PC1, and the editing process is performed. When the editing process is completed, step S
Proceed to step 6 to unlock the corresponding data. The above is the outline of the method of the present invention. The operation in each mode will be specifically described with reference to FIG.

FIG. 2 is an explanatory diagram of an operation screen in the key display mode. As shown in the figure, a screen called an LK screen is displayed in the key display mode. This screen is a screen that displays only codes (keys) of a plurality of data in the database. As shown in the figure, types of codes include an in-house code, a symbol code, an outer shape code, and the like. Elements A1, A2,... Are stored in association with each code. This data is, for example, a symbol code of AND, which is a data including a graphic image of an AND gate, its function, and other information, using an in-house name of the part as an in-house code.

When the shape, standard, and other characteristics of the circuit components constituting the AND gate are changed, or when a new gate circuit component is adopted for the next design, the registration is made in the database, Or correct some data and edit it again. In the case of such work,
In this key display mode, first, a key for reading data is displayed. And as shown in this figure,
Keys A1 to A4, C1 of data to be corrected or edited
When C4 to G4 to G4 are designated, the corresponding data is displayed in the next browsing mode, and the contents can be confirmed.

FIG. 3 is an explanatory diagram of an operation screen in the browsing mode. A screen as shown in this figure is called a TK screen, and data contents are displayed in a list format. In this browsing mode, correction or the like cannot be performed merely by displaying the contents of the data. After confirming the contents, the operator determines which data is to be edited and which data is to be added.

FIG. 4 is an explanatory diagram of an operation screen in the lock start mode. For example, as shown in this figure, the element of A2 is changed, the element of C3 is changed, the element of G1 is changed,
Suppose that a decision is made to add A5 / C5 / G5 data. In this case, the same LK screen as the operation screen shown in FIG. 2 is displayed, and a key to be changed is clicked using a mouse or the like. As a result, as shown in FIG.
In the portions of 2, C3 and G1, (Revision) is displayed.

Even if such a display is not made, the operator is informed of the state in which the change is designated, for example, by blinking the code A2. In the case of a new addition, keys such as A5, C5, and G5 are entered in blank fields. In this way, the operator selects an object to be changed or added on this operation screen. In the case shown in this figure, it is possible to freely specify different editing processes and the like for each code. For example, in addition to the above-described partial change processing, there is also a processing of creating new data by diverting the contents. In such a case, a revision is specified. The specification method is free.

FIG. 5 is an explanatory diagram of an operation screen in the reread mode. The key selected in the lock start mode is
Used again to read data from the database. Then, at that time, it is determined whether or not the corresponding data is locked. In addition, when newly adding data, it is verified whether or not an operation of adding data or the like has been started by another person using the same key as the key. As a result of such confirmation work, the target data is locked for the first time.

Therefore, at this point, data that has already been edited and locked by a third party is excluded from the data to be edited. In the example shown in this figure, all the operations selected in FIG. 4 are recognized. However, in some cases, for example, an operation such as renewal of C3 or addition of G5 is rejected, and the blinking display of this portion is stopped.

FIG. 6 is an explanatory diagram of an operation screen in the edit mode. In the edit mode, the reread data is displayed on the screen. This screen has exactly the same design as the TK screen shown in FIG. In addition, operations such as data correction, new addition, and diversion can be simultaneously performed on this screen.
That is, operability is improved by setting each operation to a common screen.

When entering the editing mode,
On the operation screen in the re-reading mode, a flag is set for each key determined to be locked. With reference to this flag, data rewriting after the end of the edit mode is executed. In addition, in the case of new addition, when locking is performed, the key is newly registered temporarily to prevent others from performing data addition work using the same key. The editing of the shared database is completed as described above.

FIG. 7 shows a flowchart of the operation at the time of data addition processing. In the data addition process, a mode having a procedure slightly different from that shown in FIG. 1 is executed. That is, first, in step S1, a key display mode as shown in FIG. 2 is performed. Further, in step S2, the browsing mode is executed. At this time, since the browsing mode is newly added,
There is no corresponding data. Accordingly, the process directly proceeds to the lock start mode (step S2). Then, a new key is registered in step S3, and the additional lock mode is executed.

Next, in step S4, the editing mode as described with reference to FIG. 6 is executed, and in step S5, when the addition of the edited data is completed, the unlock mode is executed. The schematic operation during the data addition processing is as shown in this figure.

Finally, the processing of the present invention will be described using a more specific flowchart. FIG. 8 is an operation flowchart of the system of the present invention. Steps S1 and S in the figure
Reference numeral 2 denotes a step of adding new data. In step S1, data is input to a blank area on the TK screen. That is, a new key or the like is input to a column of the TK screen shown in FIG. 3 where data has not been input yet. Thus, key registration of the newly added data is performed.

Next, in step S2, the LK screen shown in FIG. 4 is displayed, and the color of the corresponding code is changed. That is, here, for example, the key of the new input target is blinked. Thereafter, the process proceeds to step S5, and locking of the corresponding code is started in the state of the LK screen.

On the other hand, steps S3 and S4 are steps for editing the existing data. Step S3 is a process of designating a key or the like to be edited and reading the corresponding data from the database.
In step S4, a key is designated on the LK screen shown in FIG. 2, the TK screen shown in FIG. 3 is displayed, and a state in which the contents are examined is shown. In step S5, the LK screen is displayed,
Lock processing is started. In step S6, a corresponding key is selected for the editing process. As a result, the code on the screen blinks.

Step S7 is an operation for new input or the like.
Then, the user selects the lowermost row of the LK screen as shown in FIG. A step S8 selects a key of the read data after designating diversion in the diversion processing. This causes the corresponding code to flash. Step S9 is a process that does nothing.

These steps S6, S7, S8, S9
Subsequent to the process of step S10, step S10 is executed. In step S10, it is determined whether all new / revised locks have been applied to the color change codes. That is, when the operator selects keys one by one and requests locking, the system side determines the start of locking in response to the request. Here, it is determined whether or not the lock start has been recognized for all keys, and the processing from step S5 to step S10 is repeated.

When the locking process is started, first, in step S11, the re-read button is pressed. this is,
It is composed of command buttons and the like displayed on a display (not shown). When this button is pressed, step S
At 12, it is determined whether or not the data selected up to step S10 on the database is locked by another person.

Then, in step S13, the process branches depending on whether or not there is a lock from another person. If there is no lock, the process proceeds to step S14 to lock the corresponding code. As a result, the editing process of a third party is prohibited for the first time. If the lock is performed by another person, the flag is removed for the corresponding code. That is, it is excluded from the target of the editing process. Then, in step S16, the locked data proceeds to step S17, where the data is read into the TK screen and becomes editable.

In step S16, it is determined whether the data is to be edited. Then, in step S17, the editing is executed. In step S18, it is determined whether a new code has been added / changed in the state of the TK screen. That is, when newly adding data to the data at the time of the editing process, if it is specified here, the process proceeds to step S21.
When processing is performed only on data locked up to now, the process proceeds from step S18 to step S19,
Confirm termination. If it is determined in step S16 that editing is not to be performed, the process ends. It goes without saying that the data after editing is written to the database immediately before the confirmation.

In step S18, when a new code is added / changed, the process proceeds to step S21, a code name is added on the LK screen, and the process proceeds to step S22.
The color display of the code for which processing has already been completed is erased. That is, when new data to be processed occurs,
Proceeding to step S5 again, the operations so far are repeated.

[0033]

According to the above-described method for editing a shared database according to the present invention, when editing is started, an arbitrary key is designated in the key display mode, the mode is shifted to the browsing mode, and the data contents are confirmed. . Then, when editing is started, the corresponding data is read again and locked, so that the editing operation can always be performed on the latest version. In addition, since the content is not locked while browsing the contents of the data, unnecessary use of the data by another person is not restricted.

[Brief description of the drawings]

FIG. 1 is a schematic explanatory diagram of a system according to the present invention.

FIG. 2 is an explanatory diagram of an operation screen in a key display mode.

FIG. 3 is an explanatory diagram of an operation screen in a browsing mode.

FIG. 4 is an explanatory diagram of an operation screen in a lock start mode.

FIG. 5 is an explanatory diagram of an operation screen in a reread mode.

FIG. 6 is an explanatory diagram of an operation screen in an edit mode.

FIG. 7 is an operation flowchart at the time of data addition processing.

FIG. 8 is a system operation flowchart of the present invention.

[Explanation of symbols]

 1 database 3 data PC1 to PC3 terminal

Claims (2)

[Claims] 1. A key display mode for displaying a key of each data in order to read a plurality of data included in a database, and a browsing for collectively displaying a plurality of data specified and read in the key display mode. Mode, a key selected in the key display mode, a lock start mode for starting a lock operation for preventing rewriting of the corresponding data by another person, and data to be locked after the start of the lock operation. Re-reading from the database, a re-reading mode to execute the lock when there is no lock by another person, an editing mode to display the re-read data and allow editing of the data, And a lock release mode for releasing the lock by writing to the How to edit a shared database that you want to. 2. A key display mode for designating a key of a corresponding data in order to add new data to a database, and for a key designated in the key display mode, data of another person using the same key is used. Display the lock start mode to start the lock operation to prevent the addition, the additional lock mode to execute the lock when there is no lock by others after the start of the lock operation, and the data item to be added, And an unlock mode in which the edited data is written into the database and the lock is released by sequentially executing the edit mode.