JP2769399B2 - Database system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for recording and managing data.

[0002]

2. Description of the Related Art Generally, when information is managed using a database system, specific data can be directly retrieved by using an identification (ID) number or other identification markers when searching data in a file. . Further, the operator can set various conditions for a character string or a numerical value serving as a search key, and freely extract data meeting the conditions.

In the above-described search using a character string or a numerical value as a key, an operator adds attribute information such as a character string or a numerical value to data in advance, and inputs one or more pieces of attribute information added as a search condition. Or by making a selection.

In a conventional database system, when inputting attribute information such as a character string or a numerical value to be added to data, after specifying one data to be added, a character string or a numerical value as an attribute is input. I was For example, an attribute input screen as shown in FIG. 13 is displayed for each specific data, and an attribute value such as a character string or a numerical value is input from a keyboard for each attribute item (type, model number, etc.), or the attribute value is displayed. Attribute input is performed by selecting from a list of types.

[0005]

However, in the above-mentioned conventional database, since the input of the attribute is performed for each data, the above-described procedure is used when adding the attribute to a plurality of data having the same attribute. Need to be repeated as many times as the number of data, so that a very complicated operation must be performed.

In addition, it is difficult to store what character string is given to which data at the time of attribute input using a character string (free word) that can be freely described. There is a problem in that a column is given, and there is data that cannot be searched with a free word at the time of search. For example, if two similar landscape image data A are added with a free word attribute of "landscape" and the landscape image data B is added with a free word attribute of "landscape", the key at the time of retrieval is "landscape"
In this case, since the free word “landscape” is not added to the data B, the data B cannot be searched even though the data B is a similar landscape image.

Further, when adding a numerical value as an attribute of data, it is necessary to input a character string as a meaning of the numerical value and a numerical value, for example, "height" = 135. When inputting a number, there may be a problem due to an operator's character string error.If a numerical value is input individually for each data, the relative It is difficult to grasp the difference between typical numerical values, and for accurate input, it is necessary to write the attribute numerical value corresponding to each data on paper in advance and input each numerical value for each data while looking at the paper There is a problem.

The present invention has been made in view of the above-mentioned problems in the conventional database system, and provides a database system which allows an operator to easily input data attributes.

[0009]

SUMMARY OF THE INVENTION The present invention relates to a method for identifying a specific attribute
And Diagrams generating means for generating a chart pattern based on chart data and a coordinate data, representing at a specific data genus
A label management means for managing a-labeled for chromatic and gender information and coordinate data, and the labeling pattern generating means for generating a label pattern indicating label based on the label of the attribute information and the coordinate data, Chart patterns and-labeled Day and a diagram input means for adding display any figure on the diagram search which is more formed
Database system, where the sign management means additionally displays
Compare the coordinate data of the figure and the coordinate data of the sign
Specified by the coordinate data of the additionally displayed chart
Charts added to the attribute information of the signs included in the area
This is achieved by a database system characterized by registering the attributes of . In addition, the database system described above
Stems, with or without markings in or
Additional sign moving means for moving or copying knowledge
The sign management means uses the coordinate data of the additionally displayed chart.
Of the sign moved or copied by the sign moving means
The attribute of the moved or copied sign is compared with the sign data.
Data characterized by registering or changing gender information
It is also achieved by the base system.

[0010]

[Action] Chart generating means have a a specific attribute and coordinate data
Generating a chart pattern based on chart data, label management means to representations of specific data attribute information and the coordinate data
Manage-labeled for chromatic bets, the labeling pattern generating means labeling
To produce labeled pattern indicating label based in the attribute information and the coordinate data, charts input means Chart patterns and-labeled
Add displays any figure on the diagram search which is more formed,
Sign moving means may be located inside or outside of the additionally displayed chart.
Move or copy the information, where the sign management means
Compare the coordinate data of the indicated chart with the coordinate data of the sign
Specified by the coordinate data of the additionally displayed chart
Figure added to the attribute information of the sign contained in the area
Register table attributes, and add coordinate data
Sign moved or copied by data and sign moving means
Signs moved or copied by comparing with the coordinate data of
Register or change attribute information.

[0011]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention;

FIG. 1 is a block diagram showing the configuration of an embodiment of a processing unit which is a main part of the database system of the present invention.

A processing unit 10 shown in FIG. 1 includes a bus 11 and a bus 11 which are transmission means for transferring data between processing modules.
When the search diagram is displayed on the image display unit 19 (see FIG. 2), the chart data in the memory 21 (see FIG. 2) is converted into an image format and the chart plane 27 (see FIG. 3) is connected. A chart generating unit 12 which is a chart generating means to be written into the memory; a sign which is connected to the bus 11 and writes a character string with a rectangular frame indicating the sign at an address of a sign plane corresponding to the coordinate data of each row of the sign management table in the memory 21 A sign pattern generation unit 13 serving as a pattern generation unit; a data update unit 14 connected to the bus 11 and constituting a part of a sign management unit for rewriting and updating the contents of the sign management table and the chart data on the memory 21;
A marker extracting unit 15 which is a marker extracting unit which is connected to 11 and detects only a line related to a marker corresponding to a specific coordinate condition among data in a marker management table on a memory 21;
The sign moving unit 16 which is part of a sign managing means for changing the display coordinates of the sign already displayed by information from a mouse 22 or a keyboard 23 (see FIG. 2) operated by an operator, 11, a chart drawing unit 17 which is a chart input unit for adding / changing a display diagram based on information from a mouse 22 or a keyboard 23 operated by an operator. Image display unit based on information from keyboard 23
It is constituted by a sign indicating part 18 which constitutes a part of a sign managing means for indicating and selecting a sign to be processed among the signs displayed in 19.

Next, each of the above components will be described.

A bus 11 is an internal bus of the processing unit 10 and is used for transferring data between internal processing modules.

When the search chart is displayed on the image display unit 19, the chart generator 12 transfers the file in which the chart data is recorded from the external storage device 20 (see FIG. 2) to the memory 21. After converting the chart data in the table into an image format, the chart data is written to the chart plane 27 (see FIG. 3).

The sign pattern generation unit 13 transfers the file in which the sign management table is recorded from the external storage device 20 to the memory 21, and the sign plane 26 (corresponding to the coordinate data of each row in the sign management table in the memory 21). A character string with a rectangular frame indicating a marker is written at the address shown in FIG. 3).

The data updating unit 14 rewrites and updates the contents of the marker management table and the chart data on the memory 21.

The sign extracting unit 15 detects only a line related to a sign corresponding to a specific coordinate condition from data in a sign management table on the memory 21.

The sign moving section 16 changes the display coordinates of the sign which has already been displayed, based on information from the mouse 22 and the keyboard 23 by the operation of the operator.

The chart drawing unit 17 adds and changes a displayed chart by adding and writing chart data to the chart plane 27 based on information from the mouse 22 and the keyboard 23 by the operation of the operator.

The sign indicating section 18 is provided with an image display section based on information from a mouse 22 and a keyboard 23 operated by an operator.
Indicate and select the sign to be processed among the signs displayed in 19.

The processing section 10 described above can be formed by, for example, a microprocessor or a peripheral circuit.

FIG. 2 is a block diagram showing the configuration of an embodiment of a database system provided with the processing unit of FIG.

The database system shown in FIG. 2 is connected to a processing unit 10 for managing and processing data and controlling other devices.
An image display unit 19 for displaying on a screen or the like is connected to the processing unit 10 and is connected to an external storage device 20 for storing a database processing program, each data processed by the program, a chart pattern, and the like, and a processing unit 10. A memory 21 for temporarily storing data such as images and graphics to be displayed on the image display unit 19 and data such as a management table to be described later, and a mouse connected to the processing unit 10 for an operator to send a command to the processing unit 10 22 and a keyboard 23.

Next, each of the above components will be described.

The processing section 10 is a section that manages and processes data and controls other devices as described above.

The image display section 19 is a bitmap display for displaying figures and tables on a cathode ray tube (CRT) screen or the like.

The external storage device 20 is a hard disk or other secondary storage device for storing a database processing program, various data processed by the program, a diagram pattern, and the like.

The memory 21 temporarily stores data such as images and graphics to be displayed on the image display unit 19 and data such as a management table described later, and is used as a work memory of the processing unit 10.

The mouse 22 is a device for the operator to send a command to the processing unit 10, and is used mainly for moving a pointing mark such as a mouse cursor displayed on the screen of the image display unit 19.

The keyboard 23 is configured so that the operator sends commands and information to the processing means 10 in the same manner as the mouse 22.

FIG. 3 shows the configuration of the image display section 19 of FIG.

The image display unit 19 includes a display screen 24, a cursor plane 25, a sign plane 26, a chart plane 27, and a bus 28.
It is constituted by.

The display screen 24 is a screen displayed on the image display unit 19. The display screen 24 displays image data drawn on the cursor plane 25, the sign plane 26, and the chart plane 27 in a specific priority order. The display is imposed.

The cursor plane 25 is an image memory for writing a figure interlocked with the mouse 22, such as a rectangle or a mouse cursor 29, and the sign plane 26 is for drawing a sign to be superimposed on each chart. The chart plane 27 is a memory for drawing a chart.

The cursor plane 25, the sign plane 26, and the chart plane 27 are connected to the processing unit 10 by a bus 28 (see FIG. 1).
The cursor plane 25 has the highest display priority in which the content is rewritten by the processing unit 10.

The figure written on the cursor plane 25 is always displayed on the display screen 24. Cursor plane 25
Pixels corresponding to coordinates where no figure is written
The pixel data drawn on the sign plane 26 or the chart plane 27 is displayed.

In the sign plane 26 and the chart plane 27, the sign plane 26 has a higher display priority. That is, of the image data drawn on the chart plane 27, the sign plane
Only the pixels not drawn on 26 are displayed on the display screen 24. The display coordinates are configured such that the X axis is set in the right direction and the Y axis is set in the downward direction, with the upper left on the display screen 24 as the origin (0, 0).

FIGS. 4 to 6 show examples of charts and markers (hereinafter, a set of charts and markers is referred to as a search chart) displayed on the image display means 19 of the database system described above.

In FIGS. 4 to 6, a character string accompanied by a rectangular frame indicates a sign, and its line, figure, character string, etc. indicate a chart.

FIG. 4 is a search diagram in which signs are classified by Venn diagrams, FIG. 5 is a search diagram in which signs are classified by a table, and FIG. 6 is a search diagram in which signs are classified by a graph. FIG.

Tables 1 to 3 are sign management tables for displaying and managing the signs exemplified in FIGS. 4 to 6. Table 1 is the sign management table of FIG. 4, and Table 2 is the sign of FIG. The management table and Table 3 show the sign management table of FIG. 6, respectively.

[0044]

[Table 1]

[0045]

[Table 2]

[0046]

[Table 3]

Each management table has an “ID number” for specifying data to be managed, a “character string” displayed as a sign,
The display coordinates “X, Y” of the sign representing the data, the attribute of the sign, and the character string and numerical value to be described are stored in a tabular form for each data.

Tables 4 to 6 are chart data for describing and managing the charts exemplified in FIGS. 4 to 6, wherein Table 4 is the chart data of FIG. 4, Table 5 is the chart data of FIG. Table 6 shows the chart data of FIG.

[0049]

[Table 4]

[0050]

[Table 5]

[0051]

[Table 6]

The figure data, drawing coordinates,
A character string or the like is described and managed and stored as one file. In the present embodiment, the format of the graphic element described in the chart data is as follows.

Format Table (x ₀ , y ₀ )-(x ₁ , y ₁ ): character string 1, column: (x ₂ , character string 2) (x ₃ , character string 3) ..., line: ( y ₂ , character string 4) (y ₃ , character string 5)... | The meaning of the above format is the coordinate range (x ₀ , y ₀ ) − (x ₁ ,
Draw a table with y ₁ ) as the outer frame. The title of the table is “character string 1”. The items of the column include “character string 2”, “character string 3”,..., And are separated by X coordinates x ₂ , x ₃ ,. Line items include “character string 4”, “character string 5”
Are separated by Y coordinates y ₂ , y ₃ .

[0054] rectangular rectangular _{(x 0, y 0) -} (x 1, y 1): line type, a character string _{(x 2, y} 2): String 1 | meaning described above, coordinate range _(x 0, y ₀₎ - _(x 1,
At y ₁ ), a rectangle is drawn with “line type”. The coordinates (x
₂ , y ₂ ), a character string “character string 1” to be added to the rectangle is drawn. The "line type" includes "thick line", "thin line", "dashed line" and the like, and "no line" where no line is drawn.

Format Vertical axis (y ₀ , y ₁ ): character string 1,
(Y ₂ , v ₀ ), (y ₃ , v ₁ )... | The meaning of the above format is to draw the vertical axis of the graph with the coordinates (y ₀ , y ₁ ) as the start point and end point. The name of the line segment is a character string 1, and the value of the coordinate y ₂ on the line segment is v ₀ , and the value of y ₃ is v _1.
・

Format Vertical axis (x ₀ , x ₁ ): character string 1,
(X ₂ , v ₀ ), (x ₃ , v ₁ )... | The meaning of the above format is to draw the vertical axis of the graph with the coordinates (x ₀ , x ₁ ) as the start point and the end point. The name of the line segment is character string 1,
The value of the coordinate _{x 2} on the line _v 0, the value of _{x 3} and _v 1 · · ·.

In addition to these graphic element description formats, arbitrary closed regions (circles, ellipses, polygons, etc.), line segments having an inclination, and the like can be similarly described.

The marker management table and the chart data exist for each search chart, and are stored and accumulated in the external storage device 20 (see FIG. 2) as independent files. Further, the sign management table and the chart data are transferred to the memory 21 (see FIG. 2) as needed, and are referenced and changed by the processing unit 10.

The operation of the database system of FIG. 2 will be described below with reference to the flowchart of FIG.

FIG. 8 shows a search chart before processing in this embodiment. The search chart corresponds to the sign management table shown in Table 7 and the chart data shown in Table 8.

As a first embodiment, a rectangle is drawn on the marker on the search diagram shown in FIG. 8, and the search diagram shown in FIG. 4 is created and displayed. By creating the data shown in FIG. 4, an attribute is additionally registered for each sign.

[0062]

[Table 7]

[0063]

[Table 8]

First, a chart corresponding to the search chart shown in FIG. 8 is displayed on the image display section 12 (step S1). Chart generator
After the diagram data file (Table 8) corresponding to 12 is transferred from the external storage device 20 to the memory 21 and converted into image data,
Write to chart plane 27. Next, a sign corresponding to the search chart shown in FIG. 8 is displayed on the image display unit 19 (Step S).
2). The sign pattern generating means 13 transfers the corresponding sign management table file (Table 7) from the external storage device 20 to the memory 21 and writes the same on the sign plane 26 as a character string with a rectangular frame. Further, in response to an instruction from the mouse 22 or the keyboard 23 by the operator, the chart drawing unit 17 additionally draws a chart on the search chart and draws the search chart shown in FIG. 4 (step S3).
Rectangle (50, 200)-(350, 450) that describes a rectangle drawn by drawing a bold rectangle and a character string "person" on the diagram plane 27 in response to the operation of the mouse 22 or the keyboard 23 by the operator. Bold line Character string (20, 380): person |

Subsequently, the data of the figure drawn in step S3 is added to the corresponding chart data (step S4). The data updating unit 14 adds the rectangular description data in the memory 21 to the chart data (Table 8) to create chart data shown in Table 4.

The sign displayed in the rectangle of the rectangle description data added in step S4 is extracted from the corresponding sign management table (step S5). The sign extracting unit 15 selects one of the rows in Table 7 whose X and Y values satisfy the following conditions.

50 <X <350 and 200 <Y <450 As a result, the label data of five rows shown in Table 9 is extracted.

[0068]

[Table 9]

Then, the attribute of the chart drawn in step S3 is added to the attribute of each line of the marker data extracted in step S5 (step S6). Data update unit 14
Thus, the character string "person" is added to the attribute item of each row of the sign data shown in Table 9 in the sign management table shown in Table 8 in the memory 21, and as a result, the sign management table shown in Table 1 is created. .

By the above-described processing, the attributes of the drawn figure are simultaneously added to a plurality of markers existing within the range drawn as the search diagram. That is, the same attribute is added to a plurality of data specified by the ID number by the same operation.

In this embodiment, attributes are added by drawing a rectangle. However, similar attributes can be added by drawing not only a rectangle but also an arbitrary closed area and a character string.

In the above embodiment, attributes are added to data by additionally drawing a closed area on a search diagram. However, a variety of attributes can be added by rendering a chart to be drawn into a table or a line segment.

Next, a case where an attribute is added to a marker displayed on the search diagram by drawing a table on the search diagram, that is, data corresponding to the marker will be described with reference to the flowchart of FIG. .

FIG. 9 shows a search diagram before processing in this embodiment. Table 5 corresponds to the search diagram of FIG. Since no chart is drawn on the search chart, no chart data exists.

[0075] In this embodiment, fill by adding the table to search diagram shown in FIG. 9, as well as create and display a search diagram shown in FIG. 5, to create a table 2 updates the table 10, the table By newly creating the data shown in FIG. 5, an attribute is additionally registered for each sign.

[0076]

[Table 10]

The chart corresponding to the search chart of FIG. 9 is displayed on the image display unit.
Although this is the step of displaying in FIG. 19, since there is no chart data corresponding to the search chart in this embodiment, the chart generating unit 12 deletes the contents of the chart plane 27 (step S1).

The sign corresponding to the search diagram of FIG. 9 is displayed on the image display unit.
19 is displayed (step S2). Sign pattern generator 13
However, the corresponding sign management table file (Table 10) is transferred from the external storage device 20 to the memory 21 and written into the sign plane 26 as a character string with a rectangular frame.

In response to an instruction from the mouse 22 or the keyboard 23 by the operator, the chart drawing unit 17 draws a chart additionally on the search chart, and draws the search chart shown in FIG. 5 (step 3). Operator's mouse 22 or keyboard 2
Line graphic indicating the table and character strings in the table according to the operation of 3 "gift", "within 10,000 yen", "within 20,000 yen", "within 30,000 yen", "30,000 yen or more", " OA "," AV "," health ", and" other "are drawn on the diagram plane 27, and data describing the drawn rectangle Table (20, 50)-(450, 450): gift, column (80, 1) within yen) (180, 20,000 within yen) (280,3 ten thousand within yen) (380,3 10,000 yen or more), the line (90, OA) (250, AV) (300, Health)
(370, other) is written to the memory 21.

The data of the figure drawn in step S3 is newly created as chart data (step S4).
The data updating unit 14 creates the chart data shown in Table 5 using the table description data in the memory 21 as chart data.

The sign displayed in the table of the tabular description data added in step S4 is extracted from the corresponding sign management table (step S5). By the sign extraction unit 15,
Among the rows in Table 10, those having X and Y values satisfying the following conditions are selected.

20 <X <450 and 50 <Y <450 As a result, the label data of all the rows shown in Table 10 is extracted.

The attribute of the chart drawn in step S3 is added to the attribute of each line of the marker data extracted in step S5 (step S6). By the data update unit 14, in the attribute item of each row of the marker data shown in Table 10 in the memory 21,
A character string is added by the following processing.

(A) The title of the table is added. A character string “gift” is additionally registered as an attribute of each row in Table 10.

(B) A character string corresponding to the column is added.
In each row of Table 10, when 80 ≦ X <180, the character string “within 10,000 yen” When 180 ≦ X <280, the character string “within 20,000 yen” When 280 ≦ X <380, the character string “3 If 380 ≦ X <450, add the character string “within 30,000 yen” as the attribute of the line.

(C) Add a character string corresponding to the line.
In each row of Table 10, when 90 ≦ Y <250, the character string “OA” When 250 ≦ Y <300, the character string “AV” When 300 ≦ Y <370, the character string “healthy” 370 ≦ Y <450 In case of, add the string "Other" as an attribute of the line.

In the above processing, as the numerical values used for determining the X and Y coordinates, the coordinate values for separating the rows and columns and the coordinate values indicating the display range of the table in the table description data are used.

With the above processing, the sign management table shown in Table 2 is created.

By the above-described processing, the attribute of the drawn figure is simultaneously added to the plurality of markers existing in the range of the table drawn as the search diagram, and the same attribute is added to the plurality of data specified by the ID number by the same operation. Is added.

Hereinafter, a case where an attribute is added to a marker displayed on the search diagram, that is, data corresponding to the marker by drawing a line segment on the search diagram will be described with reference to a flowchart of FIG. explain.

FIG. 10 shows a search chart before processing in this embodiment. The search chart corresponds to the sign management table shown in Table 11 and the chart data shown in Table 12.

In this embodiment, a line segment is drawn on the marker on the search chart shown in FIG. 10, and the search chart shown in FIG. 6 is created and displayed. By creating the data shown in FIG. 6, an attribute is additionally registered for each sign.

[0093]

[Table 11]

[0094]

[Table 12]

A chart corresponding to the search chart shown in FIG. 10 is displayed on the image display unit 19 (step S1). The chart generation unit 12
Save the corresponding chart data file (Table 12) to the external storage device 20.
After that, the data is transferred to the memory 21 and converted into image data, and then written in the chart plane 27.

The sign corresponding to the search chart shown in FIG. 10 is displayed on the image display unit 19 (step S2). The sign pattern generation unit 13 transfers the corresponding sign management table file (Table 11) from the external storage device 20 to the memory 21 and writes the same on the sign plane 26 as a character string with a rectangular frame.

In response to an instruction from the mouse 22 or the keyboard 23 by the operator, the chart drawing unit 17 in the processing unit 10 additionally draws a line segment on the search diagram, and draws the search diagram shown in FIG. 6 (step S3). A line segment, a line segment name “brightness”, and a value (0, 100) on the line segment are drawn on the chart plane 27 according to the operation of the mouse 22 or the keyboard 23 by the operator, and data describing the drawn rectangle. Axis (100, 450): Brightness (120, 0), (430, 1
00) | is written in the memory 21.

The data of the line segment drawn in step S3 is added to the corresponding chart data (step S4).
The data updating unit 14 adds the line segment description data in the memory 21 to the chart data (Table 12) to create chart data shown in Table 6.

The sign displayed in the coordinate range of the line segment description data added in step S4 is extracted from the corresponding sign management table (step S5). The sign extraction unit 15 of the processing unit 11 selects one of the rows in Table 7 whose X and Y values satisfy the following conditions.

100 <X <450 The coordinates used for the start and end points of the line segment in the line segment description data are used as the numerical values used in this determination. As a result, the label data of all the rows shown in Table 11 is extracted.

The attribute of the chart drawn in step S3 is added to the attribute of each line of the marker data extracted in step S5 (step S6). The data updating unit 14 adds attributes to the attribute items of all rows of the marker data shown in Table 11 in the memory 21 by the following processing.

[0102] (D) When the calculated value of the i-th row of X attribute value and _{X i, A i = {(} X i -x 2) × (v 1 -v 0) / (x 3 -x
₂ )｝ + v ₀ where x ₂ is a display x coordinate corresponding to the value v ₀ , and x ₃ is a display x coordinate corresponding to the value v ₁ .

In this embodiment, A _i = ｛(X _i −120) × (430−120) / (100−
0) Calculate the value Ai indicated by｝ ₊₀ for each row.

(E) Addition of attribute The value _Ai and the name of the line segment calculated above are additionally registered as attributes of each line. In this embodiment, adding a brightness = A _i as an attribute of that line.

With the above processing, the sign management table shown in Table 3 is created.

By the above-described processing, the character and numerical attribute of the drawn line segment are simultaneously added to the plurality of markers existing within the range of the line segment drawn as the search diagram, and the plurality of data specified by the ID number are added. A similar attribute is added by the same operation.

In the above embodiment, the attribute is added to the data by additionally drawing the horizontal axis on the search diagram. However, the same attribute addition is performed even if the line segment to be drawn is a line segment having a vertical axis or a slope. Can be.

Next, a process of adding or changing the attribute of a marker by moving or copying the marker on the already displayed search diagram will be described with reference to the flowchart of FIG.

FIG. 12 shows a search chart before processing in this embodiment. The search chart corresponds to the sign management table shown in Table 13 and the chart data shown in Table 4.

In the present embodiment, by moving the marker on the search chart shown in FIG. 12, the search chart shown in FIG. 4 is created and displayed, and the table 13 is updated to create the data shown in Table 1. By doing so, the attribute is additionally registered in the sign.

[0111]

[Table 13]

[0112] Of the markers on the search diagram shown in FIG. 12 displayed on the image display unit 19, the marker instructing unit 18 changes the display coordinates by the instruction from the mouse 22 or the keyboard 23 by the operator. Select (Step S1
0). In the present embodiment, a line in which the character string in Table 13 is “lecture” is specified.

The display position of the sign selected in step S10 is changed (step S11). The sign moving unit 16 moves the display of the sign selected by the instruction from the mouse 22 or the keyboard 23 by the operator, and changes the XY value in the corresponding sign management table. In the present embodiment, the XY values corresponding to “lecture” in Table 13 are changed to (X, Y) = (250, 300)...

For each figure element data in the chart data corresponding to the search chart shown in FIG. 12, it is determined whether or not the display coordinates of the sign changed in step S11 are within the range of each figure element. (Step S)
12). If there is no coordinate value of the sign in the graphic element range, the determination of the next graphic element is performed in the same manner by the processing from step S14 described later. If there is a marker in the range, the process shown in step S13 is performed.

The determination method differs depending on the type of each graphic element. In the present embodiment, the rectangle: the inside of the rectangle Table: the inside of the outer frame of the table Line: The determination is made based on whether or not the display coordinates of the sign are within the coordinate range of the start point and the end point of the line.

In this embodiment, two graphic elements (element 1) rectangle (20, 20)-(320, 290): thin line, character string (20, 20): landscape | (element 2) Rectangle (50, 200)-(350, 470): thick line, character string (20, 380): person | and the range of (element 1) (20, 200)-(320, 29)
In (0), there is no coordinate shown in equation (1), and only the coordinate shown in equation (1) exists in the range of (element 2). Therefore, the following processing is executed only for (element 2).

The attribute of the graphic element determined in step S12 is additionally registered by the data updating unit 14 as the attribute of the marker data moved in step S11 (step S12).
13).

The attribute to be added differs depending on each graphic element. In this embodiment, a rectangle: a character string, a table: a character string corresponding to a table title, a row, and a column item, a line segment: a line segment name, a character string and a numerical value are additionally registered in the same manner as in the above-described embodiments. .

In the present embodiment, a character string “person” corresponding to the element rectangle is added as an attribute corresponding to the display character string “lecture”, and the sign management table shown in Table 1 is created.

It is determined whether or not the processing in the steps S12 and S13 has been performed for all the graphic elements in the chart data (step S14). If there is a graphic element that has not been processed, the processing from step S12 is performed, and if processing has been performed on all graphic elements, the process ends.

By moving the sign within the range drawn as the search diagram by the above-described processing, the attribute of the figure is added to the specific sign, and the attribute is added to the data specified by the ID number by moving the sign. Is done.

In this embodiment, the attribute is added by moving a single sign. However, the attribute can be added by the above-described method not only when the sign is moved but also when the sign is copied or newly added.
By moving not only a single sign but also a plurality of signs at the same time, an attribute can be added to a plurality of corresponding signs by the processing of the above-mentioned steps S12 and S13.

[0123]

Effect of the Invention] database system of the present invention, specific
And Diagrams generating means for generating a chart pattern based on figure data having the attribute and coordinate data of a label management means for managing a target identification of organic and representing at a specific data and attribute information and the coordinate data, labeled a labeling pattern generating means for generating a label pattern indicating label based in on the attribute information and the coordinate data, and charts input means for adding display any chart in Chart patterns and search diagram which is more formed-labeled Equipped
Database system, wherein the sign management means
The coordinate data of the displayed chart and the coordinate data of the sign are added.
Compare and specify by the coordinate data of the additionally displayed chart
Is added to the attribute information of the sign contained in the
Runode register the attribute charts were, charts can attach visual attributes in a single operation into a plurality of data using, as a result,
The operation of adding an attribute can be easily performed.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of an embodiment of a processing unit which is a main part of a database system according to the present invention.

FIG. 2 is a block diagram showing a configuration of an embodiment of a database system including the processing unit of FIG. 1;

FIG. 3 is an explanatory diagram of a configuration of an image display unit in FIG. 2;

FIG. 4 is a diagram showing a display example of a search diagram in the image display unit of FIG. 2;

FIG. 5 is a diagram showing another display example of a search diagram in the image display unit of FIG. 2;

FIG. 6 is a diagram showing another display example of the search diagram in the image display unit of FIG. 2;

FIG. 7 is a flowchart showing a flow of processing by the processing unit of FIG. 1;

FIG. 8 is an explanatory diagram of a search chart display by the database system of FIG. 2;

FIG. 9 is an explanatory diagram of a search chart display by the database system of FIG. 2;

FIG. 10 is an explanatory diagram of a search chart display by the database system of FIG. 2;

FIG. 11 is a flowchart showing a processing process of the search chart of FIG. 10;
It is a chart.

FIG. 12 is an explanatory diagram of a search diagram display by the database system of FIG. 2;

FIG. 13 is an explanatory diagram of a screen display by a conventional database system.

[Explanation of symbols]

 10 Processing unit 11 Bus 12 Chart generating unit 13 Sign pattern generating unit 14 Data updating unit 15 Sign extracting unit 16 Sign moving unit 17 Chart drawing unit 18 Sign instructing unit

────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-1-189721 (JP, A) JP-A-63-311431 (JP, A) Iwasaki, Takakura, Asayama, Kobayashi, Kayoshi, “Personal image database Technology ”, Sharp Technical Report, NO. 48, 1991, P41-47, (Heisei 3-3-10) (58) Field surveyed (Int. Cl. ⁶ , DB name) G06F 17/30 JICST file (JOIS)

Claims (2)

(57) [Claims] 1. A particular attribute and coordinates and a chart generating means for generating a chart pattern based on chart data with the data, representing at a specific data mark for chromatic <br/> the attribute information and the coordinate data a label management means for managing the identification, the labeled pattern generating means for generating a label pattern indicating the signs on the basis of said label attribute information and the coordinate data, search the previous SL is more formed in Chart patterns and the-labeled A database system equipped with a chart input means for additionally displaying an arbitrary chart on a diagram
A stem, wherein the sign management means is additionally displayed
Compare the coordinate data of the chart with the coordinate data of the sign.
Specified by the coordinate data of the additionally displayed chart
The attribute information of the sign included in the
A database system for registering the attributes of a figure or table . 2. In or out of the additionally displayed chart
Sign moving means for moving or copying the sign
In addition, the sign management unit is configured to display the additional displayed figure.
Moved by the coordinate data in the table and the sign moving means
By comparing the copied sign data with the coordinates,
Register or change the attribute information of a copied or copied sign
The database system according to claim 1, wherein
M