Image Retrieval

ü  Image retrieval in the Image database system

  1.“direct query”

- the user specifies the query by directly picking colour from the colour palette

  2.“image query”

- the user asks for images similar to a given image or containing given image.

              3.“textual query”

- the user specifies a textual description of the search image.

              4.combination of all of the above.

Creating the Image Database

ü  Creating image database in MySQL

–     Create a MySQL database called Database_Image.

–     Create a table called images with two rows

•      Imageid

•      Description.

–     Query

CREATE TABLE  Images

( imgid          INT                 NOT NULL AUTO_INCREMENT ,

  description LONGTEXT   NOT NULL ,

  PRIMARY KEY ( imgid ) );