JP2923483B2 - Database system - Google Patents

Description

Description: BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for recording and managing various data. 2. Description of the Related Art When data is managed by a database system, when searching for data in a file, in addition to directly extracting specific data using an identification number (ID number) or other identification mark, This is extremely convenient because the operator can set various conditions for a character string or a numerical value serving as a search key, and can freely extract data meeting the conditions. [0003] However, in such a database system, specific data cannot be directly taken out unless an operator knows the ID number and other identification signs accurately in advance. Even if they do not know these, at least a character string or a numerical value as a key or its condition must be correctly input by an operator to perform a search. For this reason, in the case where the operator has to perform a search using only vague images due to the nature of the data to be managed, the conventional database system has a problem that the search operation becomes extremely difficult and time-consuming. Was. [0004] Further, in order to enable a somewhat ambiguous search, the key of each data may be set to have a hierarchical structure. However, since such a hierarchical structure is classified according to a unique criterion, if the criterion at the time of retrieval is slightly different, it is almost useless and inflexible. Further, in order to facilitate data retrieval, it is necessary to select an ID number or the like set based on a predetermined criterion without error according to the content of the data and to correspond to the input data. is there. For this reason, the work at the time of this data input is also very troublesome. SUMMARY OF THE INVENTION The present invention has been made in view of the above-mentioned conventional problems, and has as its object to make it easy to search for data, to easily input data, and to freely construct a database. It is to provide a possible database system. [0007] In order to achieve the above object, a database system according to the present invention has a data input means, and a data input means, which is provided with an identifier attached to an identifier and stored in a storage means. a data storage control means for storing the, test
A chart display means for displaying a chart for each search attribute on a screen ;
A position designation means for issuing position information according to a designated position by a position designation operation for designating a position on a chart , and at the time of data input, the position information and the input data given by performing the position designation operation are added to the input data. and the different creates a management table that associates over charts of search attribute management table storage control means for storing in the storage means identifier that, in the screen the chart is displayed, the position information stored in the management table A chart display control means for adding and displaying a sign at a corresponding position, and an identifier corresponding to the position information in the management table based on position information issued by performing the position specifying operation at the time of data search. And data retrieval control means for reading data corresponding to the obtained identifier from the storage means. [0008] In the database system having the above structure, for example, a system in which a map of Japan is drawn as a search chart, and, for example, a landscape image of each place is stored in a storage means as data. Will be described as an example. First, when, for example, “Sendai landscape image” is stored as new input data, this data is stored in the storage means with a new identification number given as an identifier. At this time, by designating the position of "Sendai" on the chart, position information corresponding to the designated position on the chart, for example, a coordinate signal is issued by the position designation means, and the correspondence between the position information and the identification number is determined. It is added to the management table and stored in the storage means. On the other hand, when the above data is read and displayed on a screen, for example, the position of "Sendai" is designated on the chart. At this time, a marker is displayed at a position corresponding to the data stored so far on the chart, and a marker corresponding to the position of "Sendai" is selected and designated. By such position designation, position information corresponding to the designated position is issued, and an identification number corresponding to the position information is searched in the management table. Next, the data corresponding to the obtained identification number, that is, the “Sendai landscape image” is read from the storage means and displayed on a screen, for example. As described above, at the time of inputting data, the position information corresponding to the data is sequentially stored in the storage means, and a database is constructed. The input of the data, and read, a position designation corresponding to the data, in <br/> carried out in the specified operation using a chart capable of visually grasping the two-dimensional positional relationship between each data It can be performed easily and without errors. In particular, in the position designation operation performed at the time of reading data, in the chart displayed on the screen, a mark is displayed at a position corresponding to the stored data based on the position information stored in the management table at that time. By doing so, there is no possibility that an error such as specifying a position where no data exists will occur, and desired data can be reliably and easily specified and read from the stored data. Further, according to the above-described data structure, when data is input, an operation of designating a plurality of positions with respect to the same data can be performed so that the same data can be read at different positions. To do, or, conversely,
By performing the operation of designating the same position for mutually different input data, it is possible to read out a plurality of data by designating one position. Can be built. The invention of the present application is not limited to the above-described scenery image of each place as storage data, but also has a mutual positional relationship on a two-dimensional or multidimensional chart. The present invention can be applied to a database system that stores and manages various types of data that have been recognized to some extent. An embodiment of the present invention will be described below with reference to FIGS. 1 to 5. In this embodiment,
It is assumed that the data to be managed is two-dimensional image data. As shown in FIG. 1, the hardware of the database system of this embodiment includes a keyboard 1, a mouse 2, an image input device 3 as data input means, an external storage device 4 as storage means, First image display device 5
And a second image display device 6 which constitutes position designation means together with the mouse 2 and functions as a chart display means.
And a processor unit 7 having functions as data storage control means, management table storage control means, chart display control means, and data search control means. The keyboard 1 is an input device for an operator to send commands and information to the processor unit 7. The mouse 2 is also an input device for the operator to send a command to the processor unit 7. Here, the mouse 2 is used to move a pointing mark displayed on the screen of the second image display device 6. The image input device 3 is an input device that reads an image drawn on a sheet or the like and generates image data. The external storage device 4 is a hard disk or another storage device for storing a database processing program, files processed by the program, patterns of charts, and the like. The first image display device 5 converts the two-dimensional image data into a CR.
This is a bitmap display displayed on the T screen.
The second image display device 6 is a bitmap display for displaying charts and markers on a CRT screen. The external storage device 4 stores a bit pattern of a chart generated using the image input device 3 or the like, and sends the bit pattern of the chart to the second image display device 6. As shown in FIG. 2, the chart is composed of a schematic white map of Japan and the characters "Autumn landscape" that describes the contents of the image data file. The external storage device 4 stores files to be processed together with the processing program of the database system. In this file, first, as an image data file, image data representing a Japanese autumn scenery photograph is stored in each record with an ID number attached thereto. Also, as shown in the table below, a management table file indicating coordinates on the chart by "X coordinate" and "Y coordinate" is provided. [Table 1] The numbers in the "X coordinate" and "Y coordinate" items correspond to the positions in the X-axis direction and the Y-axis direction on the table shown in FIG. 2, respectively, and both indicate the coordinates on the table. doing. The position indicated by the coordinates indicates the shooting location of the image data in each record on a map of Japan on a chart. Each coordinate is provided with an ID number of the image data on the image data file so that each coordinate corresponds to any autumn landscape photograph as attribute information. The first image display device 5 displays an autumn landscape photograph using the image data of the designated record. The second image display device 6 displays a chart sent from the external storage device 4 on a screen, reads each coordinate of the management table, and displays a point as a marker at a position indicated by the coordinate. Then, on the screen of the second image display device 6, as shown in FIG. 3, a number of points are superimposed on the map of Japan on the chart, and an autumn landscape photograph of the land where the points are displayed is displayed as an image. Indicates that it is prepared in the data file. A pointing mark is simultaneously displayed on the screen of the second image display device 6,
The pointing mark can be moved on the screen by operating the mouse 2 by the operator.
Then, when the operator presses, for example, a CR key on the keyboard 1 with the pointing mark superimposed on any point, the point is specified, and coordinates in the management table indicating the position of the point are specified. A search is performed, and a record of the image data file is automatically specified based on the ID number assigned to the searched coordinates. When the record of the image data file is specified, for example,
An autumn landscape photograph is displayed on the first image display device 5 together with the ID number of the record. The operation of the database system will be described with reference to the flowcharts of FIGS. First, in step 1 (hereinafter, step i is simply referred to as “Si”), the chart stored in the external storage device 4 is displayed on the screen of the second image display device 6. Next, each coordinate of the management table stored in the external storage device 4 is read, and a point is displayed at a position indicated by the coordinate in a manner superimposed on the previous chart (S2). When the operator specifies a point by operating the mouse 2 (S3), a search for coordinates indicating the position of the point is performed (S4), and a record in the image data file corresponding to the coordinates is specified. The image data in the record is the first image display device 5
Is displayed (S5). S to specify another point again
Returning to S3, if a search is performed using an attribute different from that of the autumn scenery using another chart, the process returns to S1, and the process ends when the search ends (S6). The operation of registering new image data in the database system will be described. First,
A new autumn landscape photograph is captured as image data into the database system by the image input device 3 or the like, a new record with an ID number is created in the image data file, and this image is displayed on the first image display device 5. (S11). Next, each point indicated by the coordinates of the chart and management table stored in the external storage device 4 is displayed on the screen of the second image display device 6 (S12). Then, when the operator
The position on the chart is designated by the operation of (S13). For example, if the image to be newly registered is a Sendai autumn landscape photograph, the position indicated by the operator points to the position of Sendai on the map of Japan on the chart. Then, the coordinates of the designated position are automatically read, and a record of the coordinates is added to the management table with the ID number attached thereto (S
14). S1 when registering the same image in another location
Returning to S3, the process returns to S12 when registering another image showing another attribute, and returns to S11 when registering another image. When the registration is completed, the process ends (S15). In the present embodiment, since the same image data does not have two or more coordinates on the same chart, the loop returning to S13 is not used. As described above, the database system according to the present invention comprises a data input means, a data storage control means for attaching an identifier to data input from the data input means and storing the data in the storage means, A chart display means for displaying a chart for each search attribute on a screen, a position specifying means for issuing position information according to a designated position by a position designation operation for designating a position on the chart , and a position designation operation for inputting data. The management table storage control means for creating a management table in which the position information issued by performing the operation and the identifier given to the input data are made to correspond over the charts of different search attributes and storing the management table in the storage means, and the chart is displayed. that the screen, the chart display control means for displaying by adding a label to a position corresponding to the position information stored in the management table, when the data retrieval, the upper Data search control for searching the management table for an identifier corresponding to the position information based on the position information issued by performing the position specifying operation, and reading data corresponding to the obtained identifier from the storage means. Means. Thus, data input and search can be performed by a position designation operation on a chart which allows the user to visually grasp the positional relationship between the respective data.
Information and identifiers across charts of different search attributes.
Because it has a management table that has been set, even for large-scale data,
Manage the unified correspondence between location information and data
You. Also, this management table allows the same data to be stored in different locations.
To be able to read each, or conversely, one
Multiple data can be read by specifying the position of
Free data can be easily input
It is possible to build a base, and it is possible to reduce the load on the system.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing a hardware configuration of a database system. FIG. 2 is a diagram showing a screen displaying a chart. FIG. 3 is a diagram showing a screen displaying a chart and a sign. FIG. 4 is a flowchart for explaining a search operation of the database system. FIG. 5 is a flowchart for explaining a registration operation of the database system. [Description of Signs] 1 Keyboard 2 Mouse (Position Specifying Means) 3 Image Input Device (Data Input Means) 4 External Storage Device (Storage Means) 5 First Image Display Device 6 Second Image Display Device (Chart / Table Display Means / Position Designation) Means) 7 processor unit (data storage control means, management table storage control means, chart display control means, data search control means)

────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Noriyoshi Kayoshi 22-22-22 Nagaikecho, Abeno-ku, Osaka-shi, Osaka Inside Sharp Corporation (56) References Shimada, Ejiri "Knowledge processing multimedia with Japanese interface Map Information Processing System GENTLE, ”Information Processing Society of Japan, Vol. 27, No. 12, 1986 (Showa 61-12-15), p. 1162-1173 (58) Field surveyed (Int.Cl. ⁶ , DB name) G06F 17/30 JICST file (JOIS)

Claims (1)

(57) [Claims] Data input means, data storage control means for storing data inputted from the data input means with an identifier attached to the storage means, chart display means for displaying a chart for each search attribute on a screen, and position on the chart Is different from the position information generated by performing the position specifying operation at the time of data input and the identifier assigned to the input data. a management table storage control means for storing the created storing unit management table that associates over charts search attributes, the screen in which the figure is displayed, labeled at a position corresponding to the position information stored in the management table And a chart display control means for adding and displaying the position information, based on the position information issued by performing the position designation operation at the time of data search. Database system, characterized in that an identifier corresponding to the location information and a the searching by the management table, read from the storage means the data corresponding to the obtained identifier to the data search control means. 2. 2. The database system according to claim 1, wherein one of the charts is a map.