JP3012592B2 - Image information database management method and system using web browser - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing apparatus and, more particularly, to a database management system capable of displaying image information stored in a database as an image information sequence as it is when searching for data.

[0002]

2. Description of the Related Art Conventionally, information that can be stored in each column of a database such as a relational database is only text information such as character strings and numerical values, as shown in FIG. Therefore, the image information cannot be directly used as the database information.

For this reason, after searching and acquiring database information, it is necessary to associate the acquired information with the image information.

A computer that handles text information, audio information, and image information is disclosed in, for example, Japanese Patent Application Laid-Open No. 9-2514.
No. 08 publication describes the number of colors, size, resolution,
Attribute information whose content is determined by the data, such as the sound quality, level, stereo / monaural, and length of the audio data, is displayed in a display format such as a figure that intuitively understands the content according to the content of the attribute.
There is disclosed a method of displaying a file in association with a file name or the like. However, this method cannot be applied to a database that can store only text information and cannot store image information.

[0005]

As described above, in the conventional database management system, there is a problem that only text information such as a character string and a numerical value is used, and image information cannot be directly used as database information. have. Therefore, the image information cannot be displayed as it is in the display field of the database search result.

SUMMARY OF THE INVENTION Accordingly, the present invention has been made in view of the above-mentioned problems, and an object of the present invention is to provide a system for storing image information in a database and displaying an image in an image field when searching. To provide.

[0007]

In order to achieve the above object, according to the present invention, when storing image information, an image file name is stored in an arbitrary column in a database on a Web server side, and the image file is stored in an arbitrary column. To the database
Separately from the storage device, an HTML (Hyper Text Markup L) for returning database information obtained by searching the database to the client in response to a data search request from the client in advance.
anguage) When creating a document, it is determined whether the database information is text information or image information. If the database information is image information, the database information is registered in the storage device.
Said with reference to the image file that, HTML for image display
By creating a document, the image information is displayed on a Web browser of the client.

[0008]

Embodiments of the present invention will be described. According to the present invention, a field (column) for image information is provided in a table or the like of a relational database, and an image file name is stored in the column (“Apple.jpg”, “Ora.jpg” in FIG. 1).
Etc.), when displaying database information on a Web browser, normal text information (character strings and numerical values) is displayed as it is, and the image field information is stored in the corresponding field based on the image file name. It is intended to be displayed.

In the embodiment of the present invention, since the image data is included in the data returned from the database in response to the search request, there is no need to combine images after returning the search result as in the conventional method. .

An embodiment of the present invention will be described with reference to the drawings. An example in which the present invention is applied to a case where database information is acquired on a Web browser using a database access function of a Web server provided in an operating system will be described.

According to the present invention, in a system in which a client connects to a server device having a Web server function via the Internet, a database (5) on the server side stores an image file name in an arbitrary column when storing image information. Is stored, and the image file is registered in the storage device (6) in advance, and the server-side data processing device (4) having a Web server function responds to the data search request from the client (1). Means for accessing a database, and means for creating an image information display HTML document by referring to the image file if the result of the determination as to whether or not the search result is image information is image information. The Web browser of the client displays the image information from the image information display HTML document.

The acquired database information is displayed on a client Web browser, so that the Web browser can recognize the HTML (Hyper Text Markup Language).
e) Return in language. At that time, in the conventional method, an HTML language is created and returned so that all information (character strings and numbers) in the database can be displayed as it is.

In the embodiment of the present invention, when an HTML language for returning database information is created, the return information of the database search result is an ordinary character string / numeric value.
It is determined whether it is image information, and if it is image information, image display is performed. However, since information stored in the database as image information is an image file name, the image file (6) must be registered in advance when displaying the image information.

[0014]

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

FIG. 3 is a diagram showing the configuration of one embodiment of the present invention. Referring to FIG. 3, one embodiment of the present invention provides a Web server on a client terminal connected to the Internet.
a web server function 3 for controlling communication between the input / output device 1 (client browser 1) which is a b browser, the Internet line 2, and the client browser 1,
From the web server function 3, CGI (Common Gateway Interface)
ace; common gateway interface) includes a data processing device 4 to be activated, a database storage device 5 for storing database information, and an image file storage device 6 for storing image data.

The data processing device 4 includes client request reception processing means 41 for receiving a request from a client,
A database access processing unit 42 for accessing a database based on the received request; an image information field determination processing unit 43 for analyzing information received from the database for each field to determine whether the information is image information; HTML when is not image information
HTML creation processing means 44 for creating a language, image field HTML creation processing means 45 for creating an HTML language when field information is image information, HTML return processing means 46 for returning the created HTML to a client browser, It has. The functions of each of the above units can be realized by program control executed by the data processing device 4.

FIG. 4 is a flowchart for explaining the processing flow of one embodiment of the present invention. The operation of this embodiment will be described in detail with reference to FIGS.

The client browser 1 issues a database access request. When a database access request is made, it is connected to the Web server function 3 of the designated computer via the Internet line 2.
After the connection, the Web server function 3 in the designated computer activates the data processing device 4 by CGI.

After startup, the client request reception processing means 41 analyzes a database access request from the client. The result of the analysis is passed to the database access processing means 42. The database access processing means 42 accesses the database as requested (step A1).

After accessing the database, it is determined by the database access processing means 42 whether or not the result has been obtained normally (step A2). If the result from the database cannot be obtained normally, step A8
To notify the client browser 1 of an error that results cannot be obtained.

If the result from the database has been normally obtained, it is checked in step A3 whether the obtained field is an image information field. To determine whether the field is an image information field, information is received from the client browser 1 together with a database access request, and the field is compared with the information.

If the result of the determination is not an image information field, an HTML for text display is created by the HTML creation processing means 44 (step A4). If it is an image information field, an image display HTML is created by the image field HTML creation processing means 45 (step A).
5).

After creating the HTML, the image information determination processing means 43 determines whether or not the next field exists (step A6).
Return to 3 and repeat the process.

When the HTML of all the fields is created, the HTML is sent to the client browser 1 by the HTML return processing means 46.

In the client browser 1 receiving the return result, an image is displayed in the image field, and a normal field (character string / numerical value) is displayed in text.

Next, another embodiment of the present invention will be described.

Referring to FIG. 4, in the first embodiment, the determination as to whether or not the field is an image information field is made based on information from the client browser 1. As a second embodiment of the present invention, in the client browser 1,
Image display can be realized without considering whether the field is an image information field.

In the second embodiment of the present invention, information indicating whether a field is image information is provided in a table definition of a database, that is, image information is set as field option information of the table definition.

The image field determination processing means 45 of the data processing device 4 reads the image information in the field option information and determines whether the information is image information.

As a third embodiment of the present invention, when it cannot be set as field option information, a specific character string representing image information is used for a field name, and the data processing device determines whether or not the image information is image information. , And may be configured.

As a fourth embodiment of the present invention, in the first embodiment, only a still image file is targeted. However, in addition to an image file, a moving image file, an audio file, and other multimedia files are targeted. It is good also as a structure which performs.

[0032]

As described above, according to the present invention,
Even in a database that can store only text information such as character strings and numerical values, images can be displayed as database information, and visual information can be incorporated into the database information, thereby expanding the range of use. To play.

[Brief description of the drawings]

FIG. 1 is a diagram for describing an embodiment of the present invention.

FIG. 2 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 3 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 4 is a flowchart showing a processing flow of an embodiment of the present invention.

FIG. 5 is a diagram for explaining a conventional method.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Client browser 2 Internet 3 Web server 4 Data processing device 5 Database storage device 41 Client request reception processing means 42 Database access processing means 43 Image field determination means 44 HTML creation processing means 45 HTML creation processing means for image fields 46 HTML return processing means

──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-1-276334 (JP, A) Motoda, et al. “Special Feature, Trend of Intranet Application Development Technology, WebBASE: Intranet Application Construction Environment” NTT Technology Journal, Vol. 8, No. 10, 1996, pp. 60-63 (Heisei 8-10-1) Okayama, Katayama, "UNIX Tool Box 18, How to Write World Wide Web, HTML (5)", UNIX MAGAZ INE, Vol. 11, No. 4, 1996, p. 48-71 (Heisei 8-4-1) "Building a multimedia database on IBM 3081's SQL / DS, searching from a personal computer as if it were a card" Nikkei Electronics, 1987.11.1.2 (No. 433) , P. 88-90 (58) Field surveyed (Int. Cl. ⁷ , DB name) G06F 17/30 G06F 12/00 546 JICST file (JOIS)

Claims (9)

(57) [Claims] When storing image information, a file name of an image file is stored in an arbitrary column (field) of a table of a database on a Web server side in a text format, and the image file is stored separately from the database.
An HTML (HyperText Margin) for registering in advance in a storage device on the Web server side and returning database information obtained by searching the database in response to a data search request from a client to the client.
When creating a kup language) document, it is determined whether the database information is text information or image information. If the database information is image information, the database information is registered in the storage device.
And above with reference to image files, HT for image display
By creating an ML document, the client-side Web
A database management method for image information using a Web browser, wherein the image information is displayed on a browser b. 2. The method according to claim 1, wherein information as to whether the image information is image information is provided as field option information in the table definition of the database, and whether or not the image information is image information is determined from the information in the field option information. 2. The database management method for image information using a Web browser according to claim 1. 3. When image information is stored in a database,
2. The image information database management method using a Web browser according to claim 1, wherein whether or not the field name is image information is determined by using a specific character string representing image information. 4. An image file storing the image information,
2. The image information database management method using a Web browser according to claim 1, wherein the method includes at least one of a still image file, a moving image file, an audio file, and a multimedia file. 5. In a client-server type database management system, a file name of an image file is stored in a text format in a server-side database having a Web server function when storing image information. Is registered in advance in the storage device on the server side separately from the database, and the server accesses the database according to a data search request from a client and determines whether or not the search result is image information. Means for creating an image information display HTML document by referring to the image file when the image information is image information. The Web browser of the client transmits the image information display HTML document from the image information display HTML document. database management system and displaying the image information 6. In a client-server type database management system, when storing image information, an image file name is stored in a predetermined field in a server-side database having a Web server function, and the image file is stored in a predetermined field. ,
Aside from the database, the information is previously registered in a storage device on the server side, the server accesses the database according to a request receiving unit that receives and analyzes a request from a client, and according to a data search request from the client. Database access means, image field determination means for determining whether the database information returned from the database access means is text information or image information, and if the database information is text information, an HT for displaying the text.
Means for creating an ML document; means for creating an HTML document for displaying image information by referring to an image file corresponding to the image information from the storage device if the information is image information; the and means for returning to the clients, Web browser of the client, the database management system, characterized in that, for displaying the image information from the image information display HTML documents. 7. An information as to whether or not image information is provided as field option information of a table definition in the database, wherein the image field determining means determines whether or not the information is image information based on the information in the field option information. 7. The database management system for image information using a Web browser according to claim 6, wherein: 8. An image file storing the image information,
7. The image information database management system using a Web browser according to claim 6, wherein the system includes at least one of a still image file, a moving image file, an audio file, and a multimedia file. 9. When storing image information, an image file name is stored in an arbitrary column in a database on the Web server side, and the image file is stored in the database.
A server having a Web server function, which is registered in advance in a storage device on the Web server side separately from the server, (a) accesses the database according to a data search request from a client, and the search result is image information. Means for determining whether or not the image file is image information; and means for creating an image information display HTML document by referring to the image file when the image information is image information. In a system for displaying image information from an HTML document for image information display, a recording medium recording a program for causing each of the means (a) and (b) to function in a data processing device on a server side.