JP2002182965A - Drawing data management system and database management device therefor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the usability of drawing data and also responsiveness to drawing lending requests while maintaining high security. SOLUTION: This system is provided with a main data base 10 in which all the drawing data utilized in the system are registered, a sub data base 20 in which only highly frequently used drawing data are registered, a management device 30 for managing both data bases and a plurality of terminals 40 connected to the device 30 by a network N, which is also connectable to the sub data base. At the time of receiving the request of the drawing data not registered in the sub data through registered in the main data base from the terminal, the management device requests the main data base to transfer the drawing data to the sub data base, confirms the incoming of the drawing data to the sub data base and then transmits the information of that effect to the terminal.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a drawing data management system using, for example, CAD, and a database management device therefor.

[0002]

2. Description of the Related Art Conventionally, as a drawing data management system, for example, one described in Japanese Patent Application Laid-Open No. 7-271839 is known. A block diagram of this system is shown in FIG. In this system, the server 1 has a master database (database is abbreviated as DB unless otherwise required).
1a, a delivery DB 1b, and a transmission / reception history DB 1c.
2a, 2a, and these DBs and client terminals 3,
3 are connected by a network 4. However, logical connection between the server 1 and the client terminals 3 and 3 (broken line portion in the figure) is not normally performed. In such a configuration, the client terminals 3 and 3 issue a data registration or transfer request to the subservers 2 and 2, and the server 1 accesses the subservers 2 and 2 at regular time intervals and requests data registration or transfer. The connection and the processing of each DB are performed based on. In addition, 2
b and 2c are files to be transferred, and 5 and 5 are sub-networks. In this system, after the server 1 reads a data registration or transfer request and determines the request,
Since the system is connected to the network 4 to register and rent a drawing, the security of the drawing data is high.

[0003]

The above-mentioned conventional system has the following problems. (1) Basically, all drawings are registered only in the master DB 1a, so that a user who intends to use drawing data issues a data transfer request to the sub server 2 by the client terminal 3 each time. Must. Therefore, even for frequently used drawing data, a data transfer request must be issued by the client terminal 3 to the sub server 2 each time the drawing data is used.
The operation is complicated. Further, since the master DB must be searched every time for all drawing data, the search speed is relatively low. (2) Since the server 1 accesses the presence or absence of the request at regular intervals, the response to the drawing lending request is poor.

In order to improve the response, the ID
Drawing management system by publication (Japanese Patent Laid-Open No. 8-263513)
However, in this system, since the master DB must be searched for all the drawing data every time, the search speed is relatively slow. Japanese Patent Application Laid-Open No. 11-96050 discloses a utilization database that stores frequently used CAD component data and a warehouse database that stores infrequently used data (frequently used data is stored). There is disclosed a system for managing data in the utilization database. However, in this system, when attempting to use data in the utilization database, the utilization database cannot be directly accessed by the terminal device, and only through the data management unit. Lack of convenience because it cannot be used.

SUMMARY OF THE INVENTION An object of the present invention is to solve the above problems, improve the usability (convenience) of drawing data while maintaining high security, and also improve the response to drawing lending requests. It is to provide a drawing data management system.

[0006]

According to one aspect of the present invention, there is provided a drawing data management system comprising: a main database in which all drawing data used in the system are registered; A sub-database that is connectable, and in which only frequently used drawing data among the drawing data registered in the main database are registered; a database management device that manages the main database and the sub-database; A plurality of terminal devices connected to the management device via a network and connectable to the sub-database, wherein the database management device is
When receiving a request for drawing data registered in the main database but not registered in the sub-database from the terminal device, the main database can be requested to transfer the drawing data to the sub-database. And it is possible to confirm the arrival of the drawing data to the sub-database, and after the confirmation,
It is a device capable of transmitting information to the effect that the incoming call has been confirmed to the terminal device. According to a second aspect of the present invention, there is provided a database management apparatus in which all drawing data used in the system according to the first aspect are registered, and a main database which is connectable to the main database and which is registered in the main database. A database management device that manages a sub-database in which only frequently used drawing data among registered drawing data is registered, and is connected to a plurality of terminal devices via a network, and is registered in the main database. However, when a request for drawing data not registered in the sub-database is received from the terminal device, it is possible to request the main database to transfer the drawing data to the sub-database, and It is possible to check whether data has arrived at the sub-database, Later, characterized in that to the terminal device, it is possible to transmit information to the effect that was confirmed by the incoming call. According to a third aspect of the present invention, in the drawing data management system according to the first aspect, the terminal device is a device that cannot directly access the main database.

[0007]

The drawing data management system according to the first aspect has a main database in which all drawing data used in the system are registered, and is connectable to the main database and registered in the main database. A sub-database in which only frequently used drawing data among registered drawing data is registered, a database management device for managing the main database and the sub-database, and a sub-database connected to the database management device via a network, A plurality of terminal devices that can also be connected to the database management device, when the database management device receives a request for drawing data registered in the main database but not registered in the sub-database from the terminal device. , Against the main database It is possible to request the transfer of the drawing data to the sub-database, and to confirm the arrival of the drawing data to the sub-database, and, after confirming the information, inform the terminal device that the receipt has been confirmed. Since it is a device that can transmit the data, it is used as follows, and the operation and effect corresponding thereto can be obtained. That is, according to this system, frequently used drawing data among the drawing data registered in the main database is registered in the sub database, and a plurality of terminal devices are provided so as to be connectable to the sub database. The user of each terminal device can directly access the sub-database on the frequently used drawing data and use the desired drawing data. Therefore, for drawing data that is frequently used, unlike the conventional system, the terminal device can directly access the sub-database without issuing a data transfer request to the sub-server and use desired drawing data. Therefore, the usability of the drawing data is remarkably improved. Moreover, since the number of drawing data registered in the sub database is significantly smaller than the number of drawing data registered in the main database, the drawing data (frequently used drawing data) in the sub database is The search speed has also improved significantly,
The usability of drawing data is significantly improved. Also, in the sub-database, only the drawing data that is frequently used among the drawing data registered in the main database is registered, and the main database cannot be directly accessed depending on the terminal device. , High security will be maintained. On the other hand, when the user of each terminal device wants to use drawing data not registered in the sub-database, the request is transmitted to the database management device using the terminal device.
Upon receiving the request from the terminal device, the database management device (or the operator thereof) requests the main database to transfer the drawing data to the sub-database and confirms the arrival of the drawing data to the sub-database. Then, information indicating that the incoming call has been confirmed is transmitted to the terminal device. This allows the user of the terminal device to know that the drawing data requested by the user has been transferred to the sub-database, so that the terminal device can directly access the sub-database and use the desired drawing data. You can do it. Therefore, according to this system, unlike the conventional system, it is not necessary for the server to come to the presence or absence of the request at regular time intervals, so that the response to the drawing lending request increases. As described above, according to the drawing data management system of the present invention,
While maintaining high security, it is possible to improve the usability of drawing data and also improve the response to drawing lending requests. According to a second aspect of the present invention, there is provided a database management apparatus, wherein a main database in which all drawing data used in the system according to the first aspect are registered, and which can be connected to the main database.
And a database management device that manages a sub-database in which only frequently used drawing data among the drawing data registered in the main database is registered, and is connected to a plurality of terminal devices via a network,
When a request for drawing data registered in the main database but not registered in the sub-database is received from the terminal device, transfer of the drawing data to the sub-database is performed on the main database. The request can be requested, the incoming of the drawing data to the sub-database can be confirmed, and after the confirmation, information indicating that the incoming has been confirmed can be transmitted to the terminal device. 1 is suitably realized. According to the drawing data management system of the third aspect, in the drawing data management system of the first aspect, since the terminal device is a device that cannot directly access the main database, high security is maintained as described above. The Rukoto.

[0008]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a conceptual diagram showing an embodiment of a drawing data management system according to the present invention.

As shown in FIG. 1, the system comprises a main database 10, a sub-database 20 connectable to the main database 10, and a database management system connectable to the main database 10 and the sub-database 20 and managing these databases. Device 30
And the database N
(For example, LAN), and the sub-database 20 also includes a plurality of terminal devices 40, 40, 40,.

In the main database 10, all the drawing data used in this system are registered. In the sub database 20, only the drawing data which is frequently used among the drawing data registered in the main database 10 is registered. Is registered. For example, the main database 10 is arranged in a department that controls and manages all drawing data used in all departments of a certain company, and all the drawing data used in all departments are registered. Also,
For example, the sub-database 20 is arranged for each specific department in a certain company, and only the drawing data frequently used in the specific department is registered. The main database 10 and the sub-database 20, and the main database 10 and the database management device 30, for example, can be connected online, respectively.

The database management device 30 and the terminal device 40
Can be composed of personal computers, for example,
Like the sub-database 20, it is arranged for each specific department. The terminal device 40 is a device capable of directly accessing the sub-database 20 and searching for and displaying desired drawing data in the sub-database 20 (see FIG. 1). For drawing data registered in the main database 10 but not registered in the sub-database 20, the request is sent to the database management device 3.
This device is capable of transmitting data to 0 (see the figure). Note that the terminal device 40 is connected to the main database 10.
Is a device that cannot be directly accessed.

The database management device 30 can request the main database 10 to transfer the drawing data to the sub-database 20 when the above-mentioned request (see the figure) is received from the terminal device 40 (see the figure). ),
In addition, it is possible to confirm the incoming of the drawing data to the sub-database 20 (see the figure), and after the confirmation, it is possible to transmit information indicating that the incoming is confirmed to the terminal device 40 (see the figure). Device.

The above system is used as follows, and the operation and effect corresponding thereto are obtained. That is, according to this system, drawing data that is frequently used among drawing data registered in the main database 10 (for example, drawing data that is frequently used in the department where the sub-database 20 is installed) is stored in the sub-database 20.
, And a plurality of terminal devices 40 are provided so as to be connectable to the sub-database 20, so that the user of each terminal device 40 can use the terminal device 40 for frequently used drawing data. Direct sub-database 20
To access the desired drawing data (see the figure). Therefore, unlike the conventional system, the drawing data frequently used is different from the terminal device 40.
Accordingly, desired drawing data can be used by directly accessing the sub-database 20 without issuing a data transfer request to the sub-server, thereby greatly improving the usability of the drawing data. Moreover,
Since the number of drawing data registered in the sub database 20 is significantly smaller than the number of drawing data registered in the main database 10, the sub database 2
Drawing data in 0 (frequently used drawing data)
For, the retrieval speed is significantly improved, and the usability of drawing data is further improved. Further, only the frequently used drawing data among the drawing data registered in the main database 10 is registered in the sub database 20, and the main database 10 cannot be directly accessed by the terminal device 40. Overall, high security is maintained. On the other hand, when the user of each terminal device 40 wants to use drawing data that is not registered in the sub-database 20, the user transmits the request to the database management device 30 using the terminal device 40 (see the figure). Upon receiving the request from the terminal device 40, the database management device 30 (or its operator, hereinafter the same) requests the main database 10 to transfer the drawing data to the sub-database 20 at any time (in the figure). reference). Upon receiving a request from the sub database 20, the main database 10 stores the drawing data in the sub database 2.
0 (see FIG. 3). After that, the database management device 30 starts the sub-database 20 of the drawing data.
After confirming an incoming call to the terminal device 40 (see the figure), the terminal device 40
, Information indicating that the incoming call has been confirmed is transmitted (see the figure). As a result, the user of the terminal device 40 can know that the drawing data requested by the user has been transferred to the sub-database 20, and, as with the frequently used drawing data, directly sends the sub-database to the terminal device 40. 20 can be used and desired drawing data can be used (see the figure). Therefore, according to this system, unlike the conventional system, it is not necessary for the server to come to the presence or absence of the request at regular time intervals, so that the response to the drawing lending request increases. As described above, according to the drawing data management system, it is possible to improve the usability of the drawing data and to improve the response to the drawing lending request while maintaining high security.

Although the embodiments of the present invention have been described above, the present invention is not limited to the above embodiments, and can be appropriately modified and implemented within the scope of the present invention.

[0015]

[Brief description of the drawings]

FIG. 1 is a conceptual diagram showing an embodiment of a drawing data management system according to the present invention.

FIG. 2 is an explanatory diagram of a conventional technique.

[Explanation of symbols]

 Reference Signs List 10 main database 20 sub-database 30 database management device 40 terminal device N network

Claims (3)

[Claims] 1. A main database in which all drawing data used in this system are registered, and a main database connectable to the main database and frequently used among the drawing data registered in the main database. A sub-database in which only drawing data is registered, a database management device for managing the main database and the sub-database, and a network connected to the database management device,
And a plurality of terminal devices connectable to the sub-database, wherein the database management device sends a request for drawing data registered in the main database but not registered in the sub-database to the terminal device. When receiving from the terminal device, it is possible to request the main database to transfer the drawing data to the sub-database, and to confirm the arrival of the drawing data to the sub-database. For
A drawing data management system, which is a device capable of transmitting information indicating that an incoming call has been confirmed. 2. A main database in which all drawing data used in the system according to claim 1 are registered, and a main database which is connectable to the main database and which is registered in the main database. A database management device that manages a sub-database in which only frequently used drawing data is registered, and is connected to a plurality of terminal devices via a network, wherein the sub-database is registered in the main database. When receiving a request for drawing data that is not registered from the terminal device, it is possible to request the main database to transfer the drawing data to a sub-database, and to the sub-database for the drawing data. Incoming call can be confirmed, and after the confirmation, Te, database management system, characterized in that it is possible to transmit the information of the confirmed call. 3. The drawing data management system according to claim 1, wherein the terminal device is a device that cannot directly access the main database.