Well, there are two ways to do this. The first, as suggested above, is to compile the data into a single database. The problem with this is the single database is essentially a mirror of all the existing data, and will have to be kept constantly updated if you want real-time searching. The second is to write a query for each database and then just output all the results on one page. Which method you use largely depends on the number of searches vs the number of updates and how time-sensitive the data is. If you have a large number of global searches, the single database will be more efficient. If there's fewer searches and a lot of updates (and the number of databases is under a few dozen), the multiple-query method may work better. It's hard to give advice without knowing a lot more about your data.

In reply to Re: Best way to aggregate many silos of data into a search form by TJPride
in thread Best way to aggregate many silos of data into a search form by MyMonkName

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.