KR100238264B1 - Image database management system - Google Patents

Abstract

An image database management system is disclosed that enables intuitive and efficient management by displaying images to be input together with previously stored images on one screen.

An image database management system according to the present invention includes an image file input unit for inputting an image file; A database for storing image data; A database manager having a window for displaying an image file input through the image file input unit and image data read from the database, for inputting, updating, and modifying the database through the windows; And an open database connector for converting a query provided by the database manager into a query suitable for the database and providing the query to the database.

The image database management system according to the present invention has an effect of maximizing work efficiency by simultaneously expressing image files and image data stored in a database through several windows.

Description

Image database management system and method for inputting, updating and deleting image database suitable for this

1 is a block diagram showing the configuration of a conventional DBMS management system.

2 is a block diagram showing the configuration of an image DBMS management system according to the present invention.

FIG. 3 is a diagram for each function of the DB image manager shown in FIG.

4 shows an example displayed in the DB information registration window.

5 shows an example displayed in the image file window.

6 shows an example displayed in the DB image window.

FIG. 7 is a diagram showing a case where the image file window shown in FIG. 5 and the DB image window shown in FIG. 6 are displayed together on one screen.

8 is a flowchart showing an input method of an image database according to the present invention.

9 is a flowchart showing a method of updating an image database according to the present invention.

10 is a flowchart showing a method of deleting an image database according to the present invention.

The present invention relates to an image database management system, and more particularly, an image DBMS management system for enabling intuitive and efficient management by displaying an image to be input and a previously stored image together on one screen, and input of an image database suitable for the same. It relates to a method of updating and deleting.

The image database (hereinafter referred to as DBMS) management system can be widely used for personnel systems, management systems, engineer image management systems, and the like.

Conventional DBMS management systems include a method using 3GL, a method using 4GL, and the like as shown in FIG.

In the method using 3GL, image files are collectively stored in a DBMS using C, PASCAL, COBOL, etc., or the image data stored in the DBMS can be retrieved in record units.

The method using 4GL can store or retrieve image data individually or collectively in a DBMS using a dedicated tool created using 3GL.

All of these methods can input, update, and delete image data individually or collectively in a DBMS. In addition, structured query language (SQL) is used, so it is possible to specify conditions and order.

However, the method using 3GL is often used for the main purpose of batch processing, and it is difficult to individually check whether the desired image file has been correctly entered or modified in the DBMS. It is difficult. In addition, in the method using 4GL, the image data stored in the DBMS can be viewed at any time, but the image file can be viewed only at the point of time of an input or correction operation. Therefore, it is difficult to show the image file to be input together with the image data stored in the DBMS.

In addition, in the method using 3GL, it is possible to work only when the technical details of Open DBBase Connectivity (ODBC), the technical details of the image, etc. are known as well as the 3GL language. In addition, the method using 4GL requires knowledge of the DBMS scheme of the image and requires a considerable amount of training time for the worker.

In addition, since both 3GL and 4GL are often dependent on the structure of the DBMS, there is a problem that the modification of the software is inevitable in order to apply the data structure to other DBMSs.

An object of the present invention is to provide an image DBMS management system in which all image information required for a task is simultaneously displayed on one screen.

Another object of the present invention is to provide an efficient image database input method.

Another object of the present invention is to provide an efficient image database update method.

Another object of the present invention is to provide an efficient method for deleting an image database.

Image DBMS management system according to the present invention to achieve the first object

An image file input unit which inputs an image file;

A DBMS for storing image data;

A DBMS manager having a window for displaying an image file input through the image file input unit and image data read from the DBMS, for performing input, update, and correction to the DBMS through the windows; And

It characterized in that it comprises an open DBMS connector for converting the query (SQL) provided by the DBMS manager to a query suitable for the DBMS to provide to the DBMS.

The input method of the image database according to the present invention for achieving the above second object is

In a method of inputting an image file into an image database using a computer,

An image file input process of inputting an image file;

Displaying an image file input through the image file input process through a window;

Selecting an image file to be input into an image database from the image files displayed through the display process; And

And an image data input process of inputting an image file selected through the selection process into an image database.

The method of updating an image database according to the present invention which achieves the third object is

In the method of updating an image database using a computer,

An image data input process of accessing an image database and inputting image data;

Displaying image data input through the image data input process through a database image window;

Selecting an image file to be updated from among the images of the image data displayed through the second display process and adjusting the size, color, etc .; And

And an image data update process of inputting an image file selected through the selection adjustment process into an image database.

The method for deleting an image database according to the present invention which achieves the above fourth object

In the method of deleting an image database using a computer,

An image data input process of accessing an image database and inputting image data;

Displaying image data input through the image data input process through a database image window;

Selecting an image file to be updated from among the images of the image data displayed through the display process; And

And deleting the image data selected through the selection process from the image database. Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

2 is a block diagram showing the configuration of an image DBMS management system according to the present invention. The apparatus shown in FIG. 2 includes a DBMS 10, an open DBMS connector (hereinafter referred to as ODBC) 12, a DB image manager 14, an image file storage unit 16, and an image file input unit 18. .

The DBMS 10 stores image data and is implemented by a hard disk built in a personal computer, an external storage device, or the like. When implemented as an external storage device, the DBMS 10 is connected through a network.

The ODBC 12 converts the SQL provided from the DB image manager 14 into SQL suitable for the DBMS 10, and inputs, updates, and deletes the DBMS 10.

The DB image manager 14 reads image files from the image file storage unit 16 and provides them to the ODBC 12, or reads image data from the ODBC 12 and displays them together with the image file.

The image file input unit 18 inputs an image file and is implemented by a scanner, an image processing apparatus connected to a camera, or the like.

FIG. 3 is a diagram for each function of the DB image manager shown in FIG. As shown in FIG. 3, the DB image manager includes a menu selection process 30, a DB information registration process 32, an image file input process 34, a DB logon process 36, a DB menu selection process 38, An input process 40, an update process 42, a delete process 44, a DB image input process 46, and a DB logoff process 48 are performed.

In the menu selection process 30, an image file input process 34, a DB logon process 38, and a DB logoff process 52 are selected.

The DB information registration process 32 registers structure information for inserting, updating, and deleting the image table through the DB information registration window. A table containing an image must basically have a single key item, a title item, and an image item, among which the single key item and the title item may be the same.

4 shows an example displayed in the DB information registration window. In FIG. 4, image table information is registered in the subselect item. When the image table is linked with another table, a connection item is selected, and the table information linked with the image table becomes the main selection item.

The image file input process 34 reads an image file generated by a scanner or the like and shows it to the worker through the image file window. The read file can have several formats, including GIF, BMP, TIFF, and PCX.

The DB logon process 36 is a process of accessing the DBMS 10 through the ODBC 12 and guarantees safety through the identification of the worker.

The DB menu selection process 38 is a process of selecting one of an input process 40, a modification process 42, and a deletion process 44 using a mouse (not shown).

Since the input process 40 and the update process 42 show the image currently stored in the DBMS 10 through a mouse (not shown) and reflect the image of the area designated as the rectangle in the image file window to the DBMS 10. Is the same task. Thus, inputs and updates are automatically selected by the DB image manager.

The deleting process 44 deletes the image record selected in the DB image window with the mouse in the DBMS 10 and then replaces the image shown in the DB image window with a blank.

The DB image input process 46 is a process of reading the image data selected in the input process 40 and the update process 42 from the DBMS 10 via the ODBC 12 and displaying it in the DB image window.

The DB logoff process 48 is a process of leaving the DBMS through the ODBC 12.

5 shows an example displayed in the image file window. The title bar 52 at the top of the image file window 50 is a portion that displays information such as the name of the image file, the size of the image, the resolution, and the like. The moving bars 54 and 56 are used to move the displayed image to the desired portion. The selection box 58 indicates the portion to be inserted and updated in the DBMS. This selection box 58 can be adjusted to any size by the operator. The size of the partial image selected by the selection box 58 is automatically adjusted internally in accordance with the maximum size of the image to be registered in the DBMS 10.

In addition, since the selection box 58 is maintained at a predetermined aspect ratio, the aspect ratio of the image stored in the DBMS 10 is constant. There may be several such image file windows.

6 shows the case where three images are displayed as an example of the DB image window. Up to five image records shown at one time in the DB image window 60 are possible, and a selection box 64 is displayed on the image records currently selected by the operator.

The title bar 62 of the DB picture window 60 displays the number of selectable picture records and the number of the currently selected picture record.

FIG. 7 is a diagram showing a case where the image file window shown in FIG. 5 and the DB image window shown in FIG. 6 are displayed together on one screen. As shown in FIG. 7, the picture of the picture file and the picture stored in the DBMS 10 are displayed in a plurality of windows on one screen, thereby enabling simultaneous reference.

The operation for inputting or updating part or all of the image file in the DBMS 10 and the operation for deleting the image stored in the DBMS 10 are performed through menu and button selection using a mouse. Can work.

FIG. 8 is a flowchart showing an image input method into a database in the DB image manager shown in FIG. The process illustrated in FIG. 8 includes an image file input process (step 800), a display process (step 810), a selection process (step 820), and an image data input process (step 830).

The image file input process (step 800) inputs an image file through a scanner or the like.

The display process (step 810) displays an image file input through the image file input process (step 800) through an image file window as shown in FIG.

The selection process (step 820) selects an image file to be input into the image database from the image displayed through the display process (step 810) using a mouse.

The image data input process (step 830) inputs the selected image file to the image database through the selection process (step 820).

9 is a flowchart showing a method of updating an image recorder of a database in the DB image manager shown in FIG. The method shown in FIG. 9 includes an image data input process (step 900), a display process (step 910), a selection adjustment process (step 920), and an image data update process (step 930).

The image data input process (step 900) accesses an image database and inputs image data.

The display process (step 910) displays the image data input through the image data input process (step 900) through the database image window shown in FIG.

The selection adjustment process (step 920) selects an image file to be updated from among the images of the displayed image data through the display process (step 910), and adjusts the size, color, and the like.

The image data update process (step 930) inputs the selected image file to the image database through the selection adjustment process (step 920).

FIG. 10 is a flowchart showing a method of deleting an image recorder of a database in the DB image manager shown in FIG. The method shown in FIG. 10 includes an image data input process (step 100), a display process (step 110), a selection process (step 120), and an image data deletion process (step 130).

The image data input process (step 100) accesses an image database and inputs image data.

The display process (step 110) displays the image data input through the image data input process (step 100) through the database image window shown in FIG.

The selection process (step 120) selects an image file to be updated from the images of the image data displayed through the display process (step 110).

The image data deletion process (step 130) deletes the image data selected through the selection process (step 120) from the image database.

As described above, the image database management system according to the present invention has the effect of maximizing the work efficiency by simultaneously displaying the image file and the image data stored in the DBMS through several windows.

In addition, it is possible to easily input, update and delete image data by a selection operation using a mouse, thereby enabling an operator to easily and clearly work without special training.

Claims (10)

In a system for managing an image database using a computer, An image file input unit which inputs an image file; A DBMS for storing image data; A DBMS manager having a plurality of windows for displaying an image file input through the image file input unit and image data read from the DBMS to perform input, update, and correction to the DBMS through the windows; And And an open DBMS connector for converting the query word provided from the DBMS manager into a query word suitable for the DBMS and providing the same to the DBMS. The image database management system of claim 1, wherein the plurality of windows are simultaneously displayed on one screen. 2. The image database management system according to claim 1, wherein the window for displaying the image file further includes a title bar for displaying the title of the input image file. In a method of inputting an image file into an image database using a computer, An image file input process of inputting an image file; Displaying an image file input through the image file input process through a window; Selecting an image file to be input into an image database from the image files displayed through the display process; And And an image data input process of inputting an image file selected through the selection process into an image database. The image database input method according to claim 4, wherein the selection process displays a selection box in the selected image file. The image database input method according to claim 5, wherein the selection process adjusts the size of the selection box by an operator's operation. 7. The image database input method according to claim 6, wherein the selection process maintains a constant aspect ratio in adjusting the size of the selection box. 6. The image database input method according to claim 5, wherein the image data input process converts an image file of a portion included in a selection box into an appropriate size in an image database. In the method of updating an image database using a computer, An image data input process of accessing an image database and inputting image data; Displaying image data input through the image data input process through a database image window; Selecting an image file to be updated among the images of the image data displayed through the display process and adjusting a size, a color, and the like; And And an image data updating step of inputting an image file selected through the selection adjustment process into an image database. In the method of deleting an image database using a computer, An image data input process of accessing an image database and inputting image data; Displaying image data input through the image data input process through a database image window; Selecting an image file to be updated from among the images of the image data displayed through the display process; And And a deletion step of deleting the selected image data from the image database through the selection process.