JP3169596B2 - Database management device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Application Field] The present invention is used for a CAD system. In particular, it relates to the database management system.

〔Overview〕

According to the present invention, in the circuit diagram version number management means, it is possible to reproduce the generation change of the circuit by giving the version number to the circuit name in addition to having the version number for each page. It was made.

[Conventional technology]

Conventionally, in this type of database management system, data access when storing and managing a circuit diagram is performed in units of pages to be processed. The version number in the management data file is managed by a set of a circuit name, a page name and a version number, and the version number is managed by adding a version number to each page.

[Problems to be solved by the invention]

In such a conventional example, since the version number is added for each page, there is a disadvantage that the version number as a circuit cannot be managed. For example, a certain logic circuit is composed of two pages of circuit drawings, and pages 1 and 2 of the two-page circuit diagram are designed at the time of initial design, and each version is set to 1. Thereafter, when only one page is updated, the version number of one page becomes two. Thereafter, when the two pages of A are further updated, the version number of the two pages becomes two. At this time, there arises a drawback that a conventional database management system cannot cope with a request to reproduce a situation one generation before the circuit.

The present invention eliminates such disadvantages. In addition to providing a version number for each page, a version number is also provided for a circuit name, and the relationship between the version number of the circuit name and the version number of the page is provided. It is an object of the present invention to provide a database management device for holding version numbers in a management data file and performing version number management.

[Means for solving the problem]

The present invention provides a database storing all original data of a circuit diagram including a plurality of pages and revised data generated by executing revision of each page of the original data in different generations, and a data storage position in the database. A database management device comprising: a management data file in which management data capable of designating a management data file is stored; and a management unit for extracting data of one generation related to a desired circuit diagram by referring to the contents of the management data file. The management data includes circuit name data for each version having a pointer to the old version circuit name data, a pointer to the new version circuit name data and a pointer to the page name data, a pointer to the old version page name data, Page name data for each version having a pointer to page name data and a pointer to another page name data Doo is characterized in that it is a linked structure.

Here, it is preferable that the management unit has means for expanding the management data structure every time the circuit diagram is revised.

[Action]

The circuit diagram data with the version number is stored in the database in page units. The management data file stores data indicating the relation between the circuit name and the circuit version number, the relation between the circuit name and the page name, and the page name, the page version number, and the storage location as access information to the database. . Using this stored data, access data to circuit diagram data of a desired generation is generated.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of the database management system. The management unit 1 determines target user data from the management data file 7 and reads or writes the user data to the database 8. The user interface 2 exchanges data with an application, and includes a circuit name, a version number, and a page number. A management data control unit 3 for searching for target data from a name, a user data control unit 4 for controlling user data access, a management data access unit 5 for accessing management data, and a database access unit for accessing user data 6

FIG. 2 is a block diagram of the management data control unit 3 shown in FIG. 1. The contents of the management data file 7 are read into the version number management information unit 9, and the circuit name, the version number and the page passed from the user interface 2. The storage location of the target data is determined by the circuit version control unit 10 and the page version management unit 11 according to the name.

FIG. 3 shows the structure of the management data file 7. The circuit name data 12 consisting of the circuit name and the version number is a pointer 14 to the old version circuit name data and a pointer 16 to the new version circuit name data.
And a pointer 18 to the page name data. The page name data 13 composed of the page name and the version number is a page name pointer 15 of the old version, a page name pointer 17 of the new version, and a pointer 19 to the next page name data. Consists of

That is, in this embodiment, the database 8 that stores all of the original data of the circuit diagram composed of a plurality of pages and the revised data generated by executing revision of each page of the original data for different generations, and this database 8 A management data file 7 for storing management data capable of designating a data storage position in the management data file 7;
And a management unit 1 for extracting data of one generation related to a desired circuit diagram by referring to the contents of the above, wherein the management data is a pointer 14 to old-version circuit name data, a new-version circuit name Circuit name data 12 for each version having a pointer 16 to data and a pointer 19 to page name data, a pointer 15 to old version page name data, a pointer 17 to new version page name data 17 and another page name data The management unit 1 has a structure in which the management data control unit 3 is a means for expanding the management data structure every time a circuit diagram is revised.
Having.

 Next, the operation of this embodiment will be described.

New circuit name from application to database 8
When a circuit diagram consisting of three pages is stored in BLOCK-A, the operation is as follows. 1 page of circuit name BLOCK-A, circuit name BLO from the user interface 2 to the management data control unit 3
Data of two pages of CK-A and three pages of circuit name BLOCK-A are sent. The management data access unit 5 reads the data in the management data file 7 and reads the version number management information unit 9
However, since there is no circuit name data of the circuit name BLOCK-A, the circuit version number control unit 10 and the page version number control unit 11
Is newly created. At this time, the version number management information newly created includes a pointer 32 to the page name data of the circuit name data 20 having the circuit name BLOCK-A and the version number "1" as shown in FIG. Page name data 21 of "1" and version number "1"
, The page name data 21 indicates the page name data 22 of the page “2” and the version number “1”, and the page name data 22 is the page “3” and the page name data 23 of the version number “1”. Pointing to. Further, the pointer 24 to the old-version circuit name data and the pointer 28 to the new-version circuit name data of the circuit name data 20 do not point to anything. Similarly, page name data 2
The old version page name pointer and the new version page name pointer of each of 1, 22, and 23 do not point to anything. At the same time that the page name data is created, the storage location of the page data is determined, and the user data control unit 4 stores the data in the database 8 through the database access unit 6 according to the location.

Next, when updating the data of the first page and the second page of the circuit name BLOCK-A is as follows. The user interface 2 sends data of one page of the circuit name BLOCK-A and two pages of the circuit name BLOCK-A to the management data control unit 3. The management data access unit 5 reads the data in the management data file 7 and expands the data in the version number management information unit 9. The circuit version number control unit 10 and the page version number control unit 11 store the pages 1 and 2 of the circuit name BLOCK-A. Create a new version because the page name data for the page already exists. As shown in FIG. 5, the version number management information created by this update is that the pointer 40 to the page name data of the circuit name data 31 having the circuit name BLOCK-A and the version number "2" is page "1". , The page name data 32 of the version number “2”, the page name data 32 points to the page “2”, the page name data 33 of the version number “2”, and the page name data 33 corresponds to the page “3”. , The page name data 23 of the version number “1”. Furthermore, circuit name data 31
The pointer 34 to the old version of the circuit name data
-A indicates the circuit name data 20 of the version number "1", and the pointer 37 to the new version of the circuit name data does not indicate anything. at the same time,
The pointer 28 to the new version of the circuit name data of the circuit name data 20 is changed to point to the circuit diagram data 3. Similarly, the page name data 32 and 33 are linked to the page name data 21 and 22 by the old version page name data pointer and the new version page name pointer between the old version page name data, respectively. At the same time that the page name data is created, the storage location of the page data is determined, and the user data control unit 4 stores the data in the database 8 through the database access unit 6 according to the location.

Next, when reading two versions of data of the circuit name BLOCK-A, the operation is as follows. The user interface 2 sends the management data control unit 3 data of the second version of the circuit name BLOCK-A. The management data access unit 5 reads the data in the management data file 7 and expands the data in the version number management information unit 9. At this time, the structure similar to that shown in FIG. The circuit version number control unit 10 and the page version number control unit 11 obtain the page name data of the version number “2” on page “1” and the page number “2” on page “2” from the data of the second version of the circuit name BLOCK-A. "And page name data of version" 1 "for page" 3 ". The user data control unit 4 reads data from the database 8 through the database access unit 6 according to the storage position in the page name data, and passes the data to the application through the user interface 2.

That is, the version number can be managed by the circuit name and its version number, and the page and its version number, and access can be made by the circuit name and its version number and page.

〔The invention's effect〕

As described above, the present invention can hold a circuit name and its version number, and has an effect of enabling access from a circuit name and a version number.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention. FIG. 2 is a block diagram showing the configuration of a management data control unit in FIG. FIG. 3 is a configuration diagram of the management data file of FIG. FIG. 4 is a diagram showing a structure of the management data file according to the present invention when newly stored. FIG. 5 is a diagram showing a structure at the time of updating a management data file of the present invention. 1. Management unit 2. User interface 3.
Management data control unit, 4 ... User data control unit, 5 ...
Management data access section, 6 ... Database access section, 7 ... Management data file, 8 ... Database,
9 Version control information section, 10 Circuit version control section, 11
Page version control unit.

Claims (2)

(57) [Claims] 1. A database for storing all original data of a circuit diagram composed of a plurality of pages and all revised data generated by executing revision of each page of the original data in different generations, and storing data in the database. A database management device comprising: a management data file in which management data capable of specifying a position is stored; and a management unit that extracts one generation of data related to a desired circuit diagram by referring to the contents of the management data file. The management data is a pointer to the old circuit name data,
Circuit name data for each version having a pointer to the new version circuit name data and a pointer to the page name data, a pointer to the old version page name data, a pointer to the new version page name data, and another page name data A database management device having a structure in which page name data for each version number having a pointer of (1) are linked. 2. The database management apparatus according to claim 1, wherein said management unit has means for expanding said management data structure every time a circuit diagram is revised.