Does postgreSQL-IE perform indexing before searching for IMAGE data type?
I am developing a CBIR system for social media. i have xml files of about 1 million flickr images. if i get to know of a DBMS supporting indexing on searches my work would become alot easier. kindly help me if any1 has an idea
a asif
0
Newbie Poster
Recommended Answers
Jump to PostIndexing is in postgres, but I would not set an index on the image column itself, rather on it's name. Why would you want an index on the image itself ?
All 4 Replies
pritaeas
2,114
¯\_(ツ)_/¯
Moderator
Featured Poster
Indexing is in postgres, but I would not set an index on the image column itself, rather on it's name. Why would you want an index on the image itself ?
a asif
0
Newbie Poster
Actually i have the precomputed low level features of flickr images in xml files. now i need to store then in a DBMS so that i can perform an efficient search on them on the basis of their low level features. it would work this way:
-> the user would upload an image
-> its low level Mpeg-7 features will be computed
-> those features will be compared with the features of other images using distance function etc and similar images would then be listed
->smart n efficient search is what i want
pritaeas
2,114
¯\_(ツ)_/¯
Moderator
Featured Poster
If I had to do this, I'd use separate table columns for your low level features, so they can be used by your distance function. This would also make it easy to search for a particular feature, should you want to.
a asif
0
Newbie Poster
i'd b really thankful if u could explain it a bit more coz i need an efficient search
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.