> it almost looks as if the Stonehenge post and Image::Seek are using the same algorithm

I don't think so... wavelets are fare more sophisticated and reliable.

But it seems like the results of Merlyn's algorithm were already sufficient for you and you only need a good lookup strategy for your SQL-query.

For this approach you are calculating if sum of distances of 48 vectors are below a threshold. (BTW: could you please fix your OP by adding code-tags?)

succesive narowing

So start by only looking up the set of images were the first vectors distance is below the threshold.

Then you need to look up the images were 2. distance < threshold - 1. distance and so on.

grid approach

Grouping and indexing the vectors in a grid where the cells have the widths of the threshold should speed up the look up considerably.

Then two vectors can only have a smaller distance if they are in the same or neighboring cells!

Prefiltering over the 48 vecors like this would narrow the set of possible results considerably well, to allow a more detailed comparison.

I don't know the inner optimization of your DB server sufficiently well to formulate an optimal SQL query for this, but this would be off topic anyway and I hope you get the idea mow. :)

Cheers Rolf

(addicted to the Perl Programming Language and ☆☆☆☆ :)

In reply to Re^3: Comparing images to find similar images in a database (grid-search) by LanX
in thread Comparing images to find similar images in a database by walkingthecow

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.