JPH1049563A - System for imparting relation between graphic and character information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system capable of simply relating graphic data for CAD or the like to a character information data base and easily retrieving one data from the other. SOLUTION: When a user specifies a required graphic (g) displayed on a display device 50, a graphic specifying means 11 provides its positional information (a) to a graphic specification information acquiring means 12. When the means 12 sends a graphic specification information acquiring request command and the positional information (a) to a graphic processor 100, the processor 100 fetches the graphic specification information (b) of the graphic and sends the information (b) to the means 12. When the user searches the character data of the graphic from a character data column (f) in a data base 200 after acquiring the information (b) and specifies the data, a graphic specification information writing means 13 adds the information (b) to the character data of a line concerned.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for providing a relationship between graphic data by CAD and data of a database relating to the graphic data, an integrated management method of a graphic and a database, and an integrated management apparatus.

[0002]

2. Description of the Related Art As an example of graphic / image processing, CAD (Compute) using computer graphics (CG) technology for designing a car body, a building, and designing a logic circuit, etc.
r Aided Design) system and CA
Various systems are provided for the D system depending on the application field.

As an application example in recent years, the layout of office OA equipment and other equipment is managed for each room or each building scattered on the site by using a CA.
There is a management system created and managed by the D system. For example, in a growing company where organizational changes and additions are repeated many times a year, and in large companies where there is almost no organizational change as a whole but organizational changes are frequent in the lower part, each office associated with a change in staffing is required. Movement of desks, office automation equipment, and other equipment, and their rearrangement poses a problem.

[0004] Since these problems can be regarded as a problem of redistribution of human resources and physical resources in the company, computers are considered in terms of organization and labor productivity and management of goods (or assets). Some are oriented toward the construction of an office facility management system aimed at processing using equipment, but typical examples that have been proposed and commercialized at this time are:

(1) Regarding space management such as arrangement of OA equipment and other equipment, a drawing (hereinafter referred to as a layout drawing) in which figures representing their forms are arranged by CAD is created for each department (or room). A CAD database is used, and the equipments arranged in each layout diagram are assigned symbols, and the department, equipment name,
Create a database as a management ledger in which attributes such as size, specifications, manufacturer name, acquisition date, purchase price, etc. are registered, and when necessary, the person in charge displays the drawing of the department to be searched on the window and displays the code of the equipment or In some cases, the layout drawing and the device management ledger are centrally managed by referring to the corresponding equipment using the attribute as a search condition. In addition to this, there is also a device having a function of simulating a layout drawing at the time of relocation due to organization change.

(2) Further, in the system of the above (1), graphic information and character information (that is, information (graphics) such as layout drawing equipment stored in the CAD database and each equipment stored in the database). Attribute (information (characters)) is managed individually, and there is a disadvantage that character information cannot be extracted from a graphic or searched for graphic data from the character information. As a target, a layout drawing and a management information list are displayed on a screen, and when a desired figure (equipment) in the layout drawing is designated with a mouse or the like, a list of attribute data of the equipment is displayed or a management information list is displayed. When a desired item (equipment or its attribute) is designated, the corresponding figure (equipment) can be identified and displayed in the layout drawing (for example, emphasis, (Blink, reverse display, etc.).

[0007]

However, in the above system (2), character information can be extracted from a graphic and graphic data can be searched from the character information. However, the character information is special and exclusive data. Because it is constructed, it is difficult to use data other than the usage method assumed in advance, and the use of data depends on the program that constructs the management system, and it can not be used outside the scope of use assumed by the program Therefore, there is a problem that it does not satisfy the demand for building an office facility management system.

Taking a personal computer as an example, there are various management attributes such as desktop type or notebook type, CPU type, hard disk capacity, display size, lease term, lease price, and manufacturer. ) Is constructed. However, when trying to add a new parameter such as a memory capacity to this, unless the system of (2) has room,
There was a restriction that it could not be added.

At this time, the mainstream of the design concept of the management system using the computer device is the information management by hierarchy (or information disclosure by ex officio), that is,... The idea is to use the same part (or to use only that part). In the case of a company organization, data that can be used in common by people with different occupations and authority can be used in common but out of authority In order to satisfy the above-mentioned requirement of building an office facility management system, for example, the layout of people in each room is laid out in a layout drawing. Since it is necessary to divert data from the personnel management file in order to view it in correspondence with The accounting department can manage OA equipment by price or by manufacturer, but cannot grasp the usage status of equipment by position and predict the necessity of new purchases due to personnel transfers. As a result, the personnel department may not be able to sufficiently understand the number of days required for relocation due to the movement, and the like.

[0010] Further, such a problem is not a problem peculiar to the office facility management system, but a similar problem also exists in various other systems which use figures and character information in association with each other. Graphic data must be constructed as graphic data, and its management information must be constructed as dedicated data as character information. This is because data created for other purposes cannot be used interchangeably.

For example, in the case of product design (eg, a design management system) or purchase of parts (eg, a material management system or a purchase management system), a design drawing is obtained from a designer, and a quote is obtained from a delivery company. In the case of receiving, the drawing database and the material estimation database for the production drawings and the character information of the elements (graphics corresponding to the members constituting the drawings) are separate and are constructed as dedicated databases. Even if the design drawing data can be used, it is not possible to use the quote data as it is with the graphic data as it is, so it is necessary to manually input all the quote data again and associate it with the graphic Is also clear.

Here, taking the case of the above-mentioned design drawing as an example, simply specifying on the screen which material item of the estimate corresponds to the graphic on the design drawing, the estimate is simply or automatically obtained. Once the material items can be related to the corresponding figures on the design drawing, once the relations have been made, the material information related to that can be picked up by specifying the figure, and the corresponding figure can be picked up by specifying the material item. It is preferable because the search system can be configured to refer to Such association between the graphic and the character information can be expected to be used not only in a design management system but also in many systems using other graphics, for example, an office facility management system.

The present invention has been made based on the above idea in order to solve the problems of the above-mentioned conventional technology.
A graphic and / or partial element, which is a constituent element of a drawing, and a method for easily associating the attribute information and / or character information of the element with the graphic and character information, and the integrated management of the graphic and the database. It is intended to provide a method and an integrated management device.

[0014]

In order to achieve the above object, the present invention provides a method for assigning a relationship between a graphic and character information to a graphic designated by a graphic processing apparatus. Means for retrieving the specified figure specific information, and a database for storing a character information string including at least one character information item relating to the designated figure. Graphic specifying information writing means to be added to the character information string as an item. In this case, the graphic designating means includes individual graphic designating means for designating individual graphics, plural graphic designating means for designating a graphic group consisting of a plurality of graphics, and general designation for designating the whole graphic consisting of a plurality of graphics. It is desirable that the configuration is made up of a combination of some or all of the means. Alternatively, the graphic specification information may be configured to include information for specifying an entire graphic and information for specifying elements constituting the graphic. Good.

Further, the integrated management system for a graphic and a database according to the present invention is a graphic specifying information acquiring means for extracting graphic specifying information given by the graphic processing apparatus for a graphic designating a desired graphic created by the graphic processing apparatus. Character information acquiring means for extracting a character information string in which the graphic specific information is written from a database having a character information string including a character information item relating to the designated graphic based on the extracted graphic specific information; , Is characterized by having. Further, in the above, a graphic editing apparatus is provided which comprises display editing means for displaying the extracted character string and / or output editing means for printing and outputting, and sequentially stores the extracted graphic specifying information. Means,
A character that sequentially retrieves a character information string in which each figure specific information is written from a database having a character information string including a character information item related to a designated figure based on a plurality of stored figure specific information. It may be configured to include an information acquisition unit and a display editing unit for displaying a list of the plurality of extracted character information strings and / or an output editing unit for printing the list.

Further, the integrated management system for a graphic and a database according to the present invention comprises: a character information extracting means for extracting a desired character information string from a database having a character information string including character information items relating to the figure; When the information sequence contains graphic specifying information, it is preferable to have a graphic extracting means for extracting a desired graphic created by the graphic processing device based on the graphic specifying information. It is desirable to have an identification display means for displaying the displayed graphic in an identifiable manner.

Further, the integrated management apparatus for a graphic and a database according to the present invention is a computer apparatus having a graphic processing unit and a database unit for storing a character information string including at least one character information item related to the graphic, and An input unit that receives a command and sends the command to the main control unit, the graphic display control unit and / or the character display control unit, and processes a processing request to the graphic processing unit and a response of a processing result from the graphic processing unit. A first processing unit, a second processing unit that processes a processing request to the database unit and a response of a processing result from the database unit, and a graphic display that receives a command and graphic data from the input unit and controls display of the graphic. A control unit, a character display control unit for controlling display of the character information string received from the database unit, and first and second instructions based on a command from the input unit. Processing section, and having a main control unit that performs control for graphic display control unit, and a character display control unit. Further, in a preferred embodiment, the first
Has a conversion table for converting a graphic processing request from the input unit into an execution format of the graphic processing unit, and / or the second processing unit has accumulated a database reference request sentence from the input unit. Have a reference list. In the integrated database management device, the graphic processing unit and / or the database unit may be configured to be connected to a computer device via a communication line.

Further, it is desirable to use the following storage medium for implementing the present invention. That is, the control operation of the main control unit of the above-mentioned integrated management device is performed to perform the above-described association scheme between the graphic and the character information or the integrated management operation of the graphic and the database. A: a combination of the graphic and the character information described above; a graphic specifying information acquisition unit described in the method for providing a relationship between the graphic and the character information; and a graphic specification information writing unit. Figure specifying information obtaining means and character information obtaining means, c: the above-mentioned b plus display means and print output means, d: the above c plus a figure specifying information storage means, e: the above figure Character information extracting means and graphic extracting means described in the integrated management system for database and database; f: identification displaying means added to the above e.

[0019]

BEST MODE FOR CARRYING OUT THE INVENTION

(1) Assignment of Relevance between Graphic and Character Information FIG. 1 is a block diagram showing a basic configuration of a method for providing an association between a graphic and character information (hereinafter, simply referred to as an association providing method) according to the present invention. Is a main unit 10, a graphic processing device 100, and a database 20 for executing the association providing method.
5 is a timing chart showing the timing of data (or command) transfer during a period of 0.

<Basic Principle of Relevance Assignment of Graphic and Character Information> The relevancy providing method of the present invention specifies a graphic created by a graphic processing apparatus and specifies a graphic included in graphic data constituting the graphic. The information is extracted, and on the other hand, the character data corresponding to the graphic is displayed by referring to the database including the character data related to the graphic, and the extracted graphic specifying information is added to the character data to thereby form the graphic. Form relevance of textual information.

<Graph Specific Information> In the graphic processing apparatus 100 such as CG (computer graphic apparatus) or CAD, the display apparatus 50 is operated by the graphic processing system 110 of the apparatus.
Is drawn on the screen of. The drawing is created on the screen using a drawing command defined by the graphic processing system 110 and a pointing device (hereinafter, input device) such as a mouse.

To create a figure, a drawing command interpreted by an interpretation language of the figure processing system 110, vector information such as a position and a direction designated by a pointing device, a scalar amount, and a figure database 120
This is performed based on the graphic data from, and when the generation is completed, the graphic data constituting the generated graphic is stored in the graphic database 120.

In this case, in order to specify a certain figure, it is necessary to identify the figure in a part of the figure data and add an identifier (hereinafter, figure specifying information) for specifying the figure. Is given by the graphic processing system 110. For example, in the case of a layout drawing, the figure specifying information is given by a drawing number and a symbol (information) corresponding to a figure number given to each component (equipment such as a personal computer) constituting the drawing. The figure specifying information may be a number or a figure name.

<Database> As information relating to a figure, there are figure data necessary for creating a figure and character data including various character information relating to the figure. The graphic data is created and stored in the graphic processing device, while the character data is separately constructed as a database 200. The data structure of the database generally includes a prescribed item area for writing prescribed data items, an additional item area in which additional items can be written, and a spare area.

[0025] For the prescribed items and additional items, general write-inhibited items (for example, status, background, etc.) that allow specific persons to refer but are basically prohibited from writing, and refer to There are restricted write-inhibited items (for example, job titles and assignments) that allow but allow writing except by a specific person, and open items that allow both reference and writing. In some cases, permission or prohibition of reference and writing of these items can be set freely. Therefore,
Writing the above-mentioned graphic specifying information to the database is prohibited if writing to the database itself is prohibited,
This is possible unless there is no spare item available.

In FIG. 1 and FIG. 2, on the main unit 10 side, the graphic designating unit 11 is operated by the graphic processing apparatus 100 using a pointing device such as a mouse.
When the desired figure g displayed on the screen is designated, the position information a is given to the figure specifying information obtaining means 12 as coordinates (x, y), for example. You can do that).

When the figure specifying information obtaining means 12 converts the figure specifying information obtaining request command and the position information a (x, y) into a format that can be processed by the figure processing apparatus 100, it sends it to the figure processing apparatus 100 (P1). The graphic processing apparatus 100 extracts the graphic specifying information b from the graphic data of the corresponding graphic and sends it to the graphic specifying information acquiring means 12 (P2).

On the other hand, the database 200 stores character information items (for example,
If the shape is a personal computer, it is a desktop type or a notebook type,
CPU, hard disk capacity, display size, lease period, lease price, manufacturer, etc.), and has character data having a writable area. Character data related to the drawing is displayed in a window in a list format (P3). In this case, in addition to the input items, the graphic specification information b
It is desirable that a column for inputting and displaying is also secured (see FIG. 3).

After obtaining the graphic specifying information b, the user searches the character data field f displayed in the display window for character data relating to the relevant graphic, and clicks the mouse to open the graphic specifying information writing means 13. The description request c and the graphic specifying information b are sent to the database 200 so that the graphic specifying information b is added to the character data of the corresponding line.

The database 200 gives a response d indicating whether the graphic specifying information b has been added to the character data of the corresponding line to the graphic specifying information writing means 13. In the above configuration,
The graphic designating means 11 comprises an individual graphic designating means for designating individual graphics, a graphic group comprising a plurality of graphics (for example,
A part or all of a plurality of figure designating means for designating a partial figure in the drawing and a whole designating means for designating the whole figure composed of a plurality of figures (all figures for one drawing including each figure and partial figure). It is desirable to be constituted so that it may consist of a combination of. Further, information for specifying the entire graphic (for example, one drawing) having the graphic specifying information and information for specifying the elements (for example, the handle of the entire automobile when one of the graphics is shown as one of the graphics) constituting the graphic. May be included. Note that each of the above-described units is desirably configured by a program. Further, the graphic designating means 11 can be included in the graphic processing device 100, and some actual CADs have the function of the graphic designating means 11.

(2-1) Graphic / Database Integrated Management System (1) FIG. 5 is a block diagram showing a configuration example of a graphic / database integrated management system (hereinafter simply referred to as an integrated management system) of the present invention. FIG. 6 shows a main unit 10 that executes an integrated management method.
6 is a timing chart showing the timing of data (or command) transfer between the image processing apparatus 100 and the database 200.

<Basic Principle of Integrated Management System-1: Designating a Graphic and Automatically Searching for Corresponding Character Data> The integrated management system of the present invention designates a graphic created by a graphic processing apparatus to configure a graphic data. Is extracted, and character data corresponding to the graphic is displayed by referring to a database (characteristics already given) containing character data related to the graphic with the graphic specifying information.

In FIGS. 5 and 6, on the main unit 10 'side,
When the user designates a desired figure g displayed on the screen of the display device 50 by the figure processing apparatus 100 using a pointing device such as a mouse, the figure specifying means 11 specifies the position information a (x, y) as a figure. The information is given to the information acquisition means 12.

When the graphic specifying information obtaining means 12 converts the graphic specifying information obtaining request command and the position information a (x, y) into a format that can be processed by the graphic processing apparatus 100, the converted information is sent to the graphic processing apparatus 100 (P1). The graphic processing apparatus 100 extracts the graphic specifying information b (for example, a graphic number) from the graphic data of the corresponding graphic and sends it to the graphic specifying information acquiring means 12 (P2).

The character information obtaining means 21 outputs the figure specifying information b
Is searched in the database 200 using the search condition as a search condition, and the searched character data d is edited by the display editing means 23 and displayed on the screen as a list. If a "specific information table creation command" is input by the user, The extracted graphic specifying information is stored in the specific information table 22, and P1 and P2 are repeated to obtain the next graphic specifying information (P3 '), and it is specified whether the specified number of graphic specifying information has been stored in the specific information table 22. When there are no more figures, the figure specific information b1,..., Bn stored in the specific information table 22 are sequentially read out, and the searched and edited character data are used as search conditions by the display editing means 23 and displayed on the screen in a list. (Fig. P4 '). It should be noted that the output editing means 24 may be added to the above configuration so that the retrieved character data can be sequentially output or output as a list by the print output device 25. Note that each of the above-described units is desirably configured by a program.

(2-2) Integrated management system for figures and databases (2) FIG. 9 is a block diagram showing another configuration example of the integrated management system for figures and databases (hereinafter simply referred to as an integrated management system) of the present invention. FIG. 10 is a timing chart showing the timing of data (or command) transfer between the main unit 10 that executes the integrated management system of FIG. 9, the graphic processing apparatus 100, and the database 200.

<Basic Principle of Integrated Management Method-2; Automatic Search for Graphic Corresponding to Character Data> The integrated management method of the present invention is used when character data searched on the database side includes graphic specifying information. Then, a figure corresponding to the figure information is extracted by the figure processing apparatus.

9 and 10, the character information extracting means 41
Searches the database 200 under desired conditions, and extracts the figure specifying information j from the searched character data. If the searched character data includes the graphic specifying information j, the character information extracting means 41 outputs the graphic specifying information j.
Is given to the figure extracting means 42.

The figure extracting means 42 sends the figure specifying information j to the figure processing apparatus 100. The graphic processing apparatus 100 obtains the graphic specifying information j and displays the corresponding graphic on the screen. In this case, in order to identify and display a figure associated with the character data searched in the database 200 from among the plurality of figures displayed on the screen, the figure extracting means 42 uses the figure identification command h (for example, , Change the color, blink the specified figure, etc.)
May be transmitted together with the graphic specifying information j. Note that each of the above-described units is desirably configured by a program.

(3) Figure and Database Integrated Management Device FIG. 13 is a block diagram showing a configuration example of a preferred embodiment of a figure and database integrated management device (hereinafter, referred to as an integrated management device) of the present invention. In FIG. 13, the integrated management device 500 includes a main body 10, a graphic processing device 100, and a database unit 200 configured to store character data including at least one character information item related to a graphic so as to be searched in a predetermined system. I have.

The main body 10 controls the operation of the input unit 2 for receiving an input command given by the user operating a pointing device such as a mouse and the like and the integrated management apparatus 500, and also has an internal memory (not shown). A main control unit 3 for executing each program expanded in the system and performing execution control of a relation between a graphic and a database according to the present invention and execution of an integrated management method; a processing request to the graphic processing apparatus 100 and a request from the graphic processing unit 100; The first to process the response of the processing result
A processing unit 4 for processing a processing request to the database 200 and a response of a processing result from the database 200; and a first processing unit 4 for processing a graphic processing request from the input unit 2 by a graphic processing apparatus. And a second processing unit 6 for converting the input data into the input unit 2.
List 7 that accumulates database reference request statements from
And a graphic display control unit 8 which receives a command from the input unit 2 and graphic data from the graphic processing apparatus to control the display of a graphic, and a character display control unit 9 which performs display editing and the like of the character data received from the database 200. have.

Although not shown, the integrated management device 50
0 stores a RAM as an internal memory and a ROM as a non-volatile memory for storing a program such as an OS (operation system) or an IPL (Initial Program Loader) and expanding the program into the internal memory at the time of execution;
Figure designating means, figure-specifying information acquiring means, and character information acquiring means for executing the method for associating a figure with a database of the present invention, and figure designating for executing the integrated figure-database managing method of the present invention Means, figure specifying information obtaining means, character information obtaining means, display means, and printing output means, figure specifying information storing means, and printing output means, or character information extracting means, figure extracting means, and identification displaying means. A storage medium for storing each program means and expanding it to an internal memory at the time of execution, for example,
A storage unit for driving an FD or a magnetic disk and performing a read / write operation is provided.

Further, the main body 10 is provided with a communication interface 60 and communication control means (not shown) such as a well-known communication program as additional components, so that the graphics processing apparatus 101-
, 101-n and the information stored in the databases 200, 200-1,..., 200-m may be used. And / or an integrated management device 50 for connecting the data processing unit 200 via the communication line 300.
0 may be configured. As described above, if the graphic processing device and / or the database unit is connected to the computer device via the communication line, one can be used even if the graphic processing unit and the database unit are separated.

[0044]

【Example】

(1) Example of Adding Relevance of Graphic and Character Information Using Integrated Management Device 500 FIG. 3 is an explanatory diagram of the association of graphic and character information, and FIG. , Graphic processing unit 1
7 is a flowchart illustrating an example of a control operation between the control unit 00 and a database unit 200.

FIG. 3A is a diagram showing the relationship between the drawing data and the ledger data before the association between the figure and the character information is given. The figure data file includes a plurality of layout drawing data 121 for each office of a certain company. It is assumed that the ledger data file stores ledger data 221 including management information of equipment used in each office,
Although the drawing data 121 and the ledger data are associated with each other for each office, since there is no relation between the figure of each equipment on the drawing data 121 and each equipment information of the ledger data 221, mutual search is performed. It cannot be done.

Therefore, the graphic data file is set in the graphic processing unit 100 of the integrated management device 500, the ledger data file is set in the database unit 200, and the device 500 is started, and as shown in FIG. The drawing data and the ledger data are displayed in a window on the screen of the display device 50, respectively.

When the user points a graphic 701 (eg, personal computer) of a certain equipment on the screen with a mouse using the mouse, the main body 10 sends a graphic number request command to the graphic processing unit 100 together with the positional information (step S1). . The graphic processing unit 100 receives an interrupt by a graphic number request command from the main body 10, receives positional information of the selected graphic, extracts graphic data based on the positional information, and sends (responds) the graphic number to the main body ( Step S2).

The main unit 10 waits for a response from the graphic processing unit 100, and if there is a response, moves the cursor to the ledger data portion corresponding to the figure pointed to. In addition to the change (step S3), an update statement for adding the figure number responded to the corresponding ledger data is created (step S4), and a ledger data update request command and updated data are sent to the database 200, and the response result is obtained. (Step S5).

The database 200 accepts an interrupt from the update request command from the main unit 10, executes the update, and sends (responds) the result (updated or write-protected) to the main unit 10 (step S6). The above steps S1 to S1
By repeating S6, a relationship is given between the figure of each equipment on the drawing data 121 and each equipment information of the ledger data 221, and mutual search becomes possible.

(2) Example of Integrated Management of Graphic and Character Information Using Integrated Management Apparatus 500 (1) FIG. 7 is an explanatory diagram of an example in which a figure is specified to search for ledger data after the association is given. FIG. 8 is a flowchart showing an example of a control operation between the main body 10, the graphic processing unit 100, and the database unit 200 in that case.

First, a graphic data file is set in the graphic processing section 100 of the integrated management apparatus 500, a ledger data file is set in the database section 200, and the apparatus 500 is started. As shown in FIG. Is displayed on the screen of the display device 50 in a window.

When the user sequentially points a plurality of figures of a certain equipment in the drawing on the screen using the mouse, for example, two figures following the figure 701, the main body 10 sends a figure number request command together with position information to the figure. It is sent to the processing section 100 (step S11). In the figure processing unit 100, the main unit 10
And receives the position information of the selected figure, extracts the figure data based on the position information, and sends (responds) each figure number to the main body (step S12).

The main unit 10 waits for a response from the graphic processing unit 100. If there is a response of the graphic number, the data arrangement needs to be changed if necessary (step S13). And sends a temporary table creation request command and waits for a response result (step S14).

The database unit 200 accepts an interrupt from the temporary table creation request command from the main unit 10, creates a temporary table from the received graphic numbers, and notifies completion thereof (step S15). The main body 10 receiving this notification creates a query sentence for extracting ledger data corresponding to the temporary table (step S1).
6), requesting the database unit 200 to execute it (step S17). The database unit 200 receives the interrupt, collates the ledger data with the temporary table, extracts data corresponding to the desired graphic number, and transmits the result to the main body 10 (step S18).

The main body 10 receives the response (notification) from the database and the ledger table data, edits them into a display format, and as shown in FIG.
A list is displayed on the screen No. 0 (step S19). In addition,
In the above example, the ledger data table corresponding to the designated figure is created on the database 200 side, but the ledger data table may be created on the main body 10 side.

(3) Example of Integrated Management of Graphic and Character Information Using Integrated Management Apparatus 500 (2) FIG. 11 is an explanatory diagram of an example of searching for a corresponding graphic by specifying ledger data to which a relationship has been added. FIG. 12 shows the main body 10, graphic processing unit 100, and database unit 20 in that case.
It is a flowchart which shows the example of the control operation during 0.

First, the graphic data file is set in the graphic processing section 100 of the integrated management apparatus 500, the ledger data file is set in the database section 200, the apparatus 500 is started, and input of the inquiry condition by the user is waited (step S21). ). The second processing unit 6 creates a query statement that means to retrieve data that meets certain conditions (for example, OA equipment whose lease period expires by October of this year) from the ledger data, and creates the query in the database 200. An execution request command is sent and a response from the database 200 is waited (step S22).

The data processing unit 200 accepts an interrupt due to a request command from the main unit 10, searches for data under the conditions in the inquiry statement, and sends (responds) a search result to the main unit 10 (step 23).

The main body 10 checks the contents of the response from the database unit 200, and if there is data that satisfies the condition, receives and edits the data, and displays it on the screen of the display device 50 as shown in FIG. 11 is displayed as a list in the window of FIG.
As shown in (b), a graphic number is pointed and extracted, and a graphic number and a command for identifying the graphic are input to the graphic processing unit 10.
0 (step S24). The graphic processing unit 200 receives the graphic number, and displays the corresponding graphic 705, 706, 707 on the display device 50 so as to be distinguishable from other graphics as shown in FIG. (Step S
25). In this case, it is desirable to assign attribute codes such as color change, emphasis, blink, and reverse display to the command for identifying the figure.

(4) Example of Hardware Constituting Integrated Management Apparatus 500 FIG. 14 is an example of a computer apparatus having a configuration that can be used as the main body 10 of the integrated management apparatus 500.
The computer device may have a configuration of a general personal computer as shown in the figure. That is, the input device 401 (keyboard, mouse, tablet, etc.) as the input unit 2 and the CPU 40 as the main control unit 3
2, a display device 450, a print output device 460 such as a printer or a plotter, a RAM 414, a ROM 411, a hard disk 420 as a data storage device, or the like, and the first processing unit 4, the second processing unit 6, The graphic display control unit 8, the character display control unit 9, and the like can be configured as a control program.
The personal computer 400 is configured to be sequentially executed by the CPU 402 so that the
It can be used as 0. Although one embodiment of the present invention has been described above, the present invention is not limited to the above embodiment, and it goes without saying that various modifications can be made.

[0061]

As described above, according to the present invention, the existing database of graphics such as CAD and the existing database can be associated with each other and combined.
After the relevancy is assigned, a specific figure is specified and character information related to the figure is searched. Conversely, information that satisfies a desired condition is searched from a database storing character information related to a certain figure, and the related information is searched. It is also possible to extract a figure to be processed, and integrated processing of figure processing and character information can be performed.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a basic configuration of a system for providing a relationship between a graphic and character information according to the present invention.

FIG. 2 is a timing chart showing the timing of data transfer between the main unit, the graphic processing device, and the database that execute the association providing method of FIG. 1;

FIGS. 3 (a) and 3 (b) are illustrations of how to associate a graphic with character information.

FIG. 4 is a flowchart illustrating an example of a control operation between a main body, a graphic processing unit, and a database unit when a relationship between a graphic and character information is provided.

FIG. 5 is a block diagram showing a configuration example of an integrated management system of a figure and a database according to the present invention.

6 is a timing chart showing the timing of data transfer between a main unit that executes the integrated management system of FIG. 5, a graphic processing device, and a database.

FIG. 7 is an explanatory diagram of integrated management of graphic and character information;
Is a diagram of drawing data, (b) is a diagram of ledger data, and (c) is a diagram of edited ledger data.

FIG. 8 is a flowchart illustrating an example of a control operation among a main body, a graphic processing unit, and a database unit during integrated management of graphic and character information.

FIG. 9 is a block diagram showing another example of the configuration of the integrated management system for figures and databases according to the present invention.

10 is a timing chart showing the timing of data transfer between a main unit that executes the integrated management system of FIG. 9, a graphic processing device, and a database.

FIG. 11 is an explanatory diagram of integrated management of graphic and character information (a).
Is a diagram of ledger data, (b) is a diagram of edited ledger data,
(C) is the figure which displayed (b) on the drawing.

FIG. 12 is a flowchart illustrating an example of a control operation among a main body, a graphic processing unit, and a database unit during integrated management of graphic and character information.

FIG. 13 is a block diagram showing a configuration example of a preferred embodiment of the integrated management apparatus for figures and databases according to the present invention.

FIG. 14 is an example of a computer device.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Main body 2 Input device 3 Main control part 4 First processing part 5 Conversion table 6 Second processing part 7 Reference list 8 Graphic display control part 9 Character display control part 10 Main body device 11 Graphic designation means 12 Graphic specific information acquisition means DESCRIPTION OF SYMBOLS 13 Graphic specific information writing means 21 Character information acquisition means 22 Specific information table 23 Display editing means 24 Output editing means 25 Character information extracting means 32 Graphic extracting means 50 Display unit 100 Graphic processing device (graphic processing unit) 200 Database (database unit) A) Figure specific information

Claims (1)

[Claims] 1. A graphic specification information acquiring means for extracting graphic specification information given by a graphic processing device from a graphic created by a graphic processing device, and at least one character information item related to the specified graphic. Graphic specifying information writing means for writing the extracted graphic specifying information to the database storing the character information string including the character information string as an item of the character information string. Method for associating text with character information.