3 sql statements

IN PROGRESS
Bids
5
Avg Bid (CAD)
$48
Project Budget (CAD)
$30 - $50

Project Description:
Search engine database query optimization.
The search engine has mainly followin tables:

site[site_id_uniq, site_url]
page[link_id_uniq, site_id, content]
words#[word_id, link_id, weight ] where #=(0..32), there are words0 .. words32. the index tbl name is a simple hasshing as SUM(word_each_char) % 32
dict[word_id_uniq, word_text]

Need 6 sql statements with, limit, count_per_page, order by weight with/without distinct by site_id, to retrieve page.content by
queries providing:
a)1 word search (distinct and without distinct by site_id)
b)any words (distinct and without distinct by site_id)
c)all the words (distinct and without distinct by site_id)
The flow would be:
a) 'word' from dict get word_id ->from words[hash(word)] get link_ids ordered descending by weight, then show the links, limit, grouped, count. If word is not in
dict, use the suondex to pull closes soundex word
b) get the ids from dict, if a word from the provided set is not there use soundex. pull out link ids ordered by words weights, number of matches (how many of the words are in doc, descending by poderate weight of off the provided words)
c) as above but all the words should be in the link

The sphyder search php engine has similar database. I can provide sample database with sample data.

Skills required:
MySQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire LiveConnector
$ 50
in 0 days
$ 75
in 1 days
Hire sugengsuprayogi
$ 35
in 1 days
$ 44
in 1 days
Hire dhinojasl
$ 35
in 2 days