In order to incrementally update tag-tag and image-image relations, we implement an efficient function to modify related tables.

Usage Guide:call the function: Add_NewTag($imageID, $flickrID, $tag)
(Please include the file "common/AddNewTag.php" first.)
You have to provide $imageID or $flickrID.
Besides, the name of added $tag is also needed.

Seven tables will be updated when one tag is added into an image.
Tag related tables:
* TBL_ImageTag
* TBL_InvertedFile
* TBL_TagTagMatrix
* TBL_TagRelationSVD

Image related tables:
* TBL_InvertedFileTrans
* TBL_ImageImageMatrix
* TBL_ImageRelation

All tables can be updated within 1~2 seconds.

- Chi-Yao

Rent Progress

Following items are finished.

Tag-Tag Relation
Image-Image Relation

Incremental Upate of adding new tags will be done soon.

Singular Value Decomposition

Reference Website: http://www.alglib.net/matrixops/general/svd.php

Final Image Categories in the Database

each type 500 images:

1. scenery
2. landscape
3. landmark
4. night

5. street
6. building
7. river
8. lake
9. beach
10. mountain
11. forest
12. sunset
13. sunrise
14. sky

The first 4 categories are somewhat general.