nice justin, i think it's a histogram analysis
i'm thinking about a new index feature, like full text, but using mariadb, ideas are wellcome :)

for example

select * from table where image_match(table_image_blob_field,"some other image, maybe using base64","histogram")>50

or others functions, the main feature is create a nice index to speed this features, i don't know if this exist or could be created, just checking what we have before planning something new

some links related that we could use to 'search images':

histogram/template/feature match:
http://docs.opencv.org/doc/tutorials/imgproc/histograms/template_matching/template_matching.html
http://docs.opencv.org/doc/tutorials/imgproc/histograms/histogram_comparison/histogram_comparison.html

http://docs.opencv.org/doc/tutorials/features2d/feature_flann_matcher/feature_flann_matcher.html

barcode:

http://zbar.sourceforge.net/

exif (image meta data)

http://pt.wikipedia.org/wiki/Exchangeable_image_file_format (exif information)

and others algorithms, search faces, thumb, hands, eyes, etc

2014-08-05 17:34 GMT-03:00 Justin Swanhart <greenlion@gmail.com>:

Hi,

I wrote software to do something like this a long time ago, when I worked at a usenet provider an we needed to track spam images. I broke each image down into smaller square images, and downsampled each to 8 bit, then calculated a "color average" of all the pixels in each sample. If one image matched enough samples to another image they were considered the same.

It didn't work for what i needed though, because it would find similar images (a person moved an arm, but everything else was the same for example). Unfortunately, I don't have the source available.

On Tue, Aug 5, 2014 at 11:40 AM, Roberto Spadim <roberto@spadim.com.br> wrote:

hi guys, does anyone know anything about querying images?
for example, i have a database with images files (.jpg for example), and i have another image (for example my gmail picture), i want to search images similar or "near" to my image

some points that i'm thinking about... images have many data, including meta data, maybe not only querying images (faces for example) but search a barcode or a ocr text, and many others features (i know some features when i worked with some opencv projects)

ideas and informations and experiences are wellcome :)

--
Roberto Spadim

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp

Roberto Spadim
SPAEmpresarial

Eng. Automação e Controle