Professional Web Applications Themes

Matching Skillsets - MySQL

I've got a database which defines job candidates and jobs. Each candidate has a set of skills each with a ability score and a experience score. Each job has a required skillset. I need to match these two sets by returning the candidates which best match a job's required skillset based on both the number of relevant skills they have and their scores in those skills. The part I'm having trouble with is returning candidates that don't have all the skills. There's a number of ways of achieving this programmatically (it's part of a PHP application) or via a stored ...

  1. #1

    Default Matching Skillsets

    I've got a database which defines job candidates and jobs. Each
    candidate has a set of skills each with a ability score and a
    experience score. Each job has a required skillset.

    I need to match these two sets by returning the candidates which best
    match a job's required skillset based on both the number of relevant
    skills they have and their scores in those skills.

    The part I'm having trouble with is returning candidates that don't
    have all the skills. There's a number of ways of achieving this
    programmatically (it's part of a PHP application) or via a stored
    procedure, but is there a simpler technique I'm overlooking?

    Any help would be appreciated.

    battle.chris@gmail.com Guest

  2. #2

    Default Re: Matching Skillsets

    What sort of joins are you doing?

    com wrote: 
    Kim Guest

  3. #3

    Default Re: Matching Skillsets


    com wrote: 

    I guess your structure looks something like this (If it doesn't, I
    think it should!)

    candidates(candidate_id*,candidate)
    skills(skill_id*,skill)
    jobs(job_id*,job)
    candidates_skills(candidate_id*,skill_id*)
    jobs_skills(job_id*,skill_id*)

    Then I guess your query could look like this (untested)

    SELECT candidate_id from jobs_skills WHERE job_id = x
    LEFT JOIN candidates_skills USING skill_id

    You could then use the results of this query as the derived table of a
    subquery, allowing you to order by most suitable candidates for
    instance.

    strawberry Guest

Similar Threads

  1. Text Matching
    By Krysta_Starz@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 3
    Last Post: April 8th, 11:45 PM
  2. matching game !!help!!
    By gailw20 webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 2
    Last Post: December 8th, 05:47 AM
  3. matching
    By Eric Walker in forum PERL Beginners
    Replies: 5
    Last Post: November 18th, 04:37 PM
  4. and/or matching question
    By Eddie in forum PERL Miscellaneous
    Replies: 2
    Last Post: August 23rd, 07:54 PM
  5. string matching
    By kamal in forum PERL Miscellaneous
    Replies: 2
    Last Post: August 22nd, 01:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139