我有一个大型简历数据库（Cv），我希望通过技能从我的数据库恢复搜索。 [英] I Have A Large Database Of Resumes (Cv) And I Want Search Resume From My Database By Skills.

问题描述

我有一个大型的简历数据库（CV），我希望通过技能从我的数据库中搜索简历。

我的数据库很大。所有简历都以二进制格式保存在我的数据库中。无论我们输入什么技能，它都应该通过与该技能相关的简历。

例如如果我在该列表中输入C ++，那么它应该搜索并释放具有C ++技能的简历。





示例：C ++ Resume。

在文档c ++中查找并显示

I have a large database of resumes (CV) and i want search resume from my database by skills.
My database is large. All resumes are saved in binary format in my database. Whatever skill we enter, it should pass resumes related with that skill.
For e.g. If I enter C++ in that list then it should search and presnt that resume which has C++ skill.


Example:C++ Resume .
Find in document c++ and display list of

推荐答案

的列表最好的方法是在表格中手动输入相关技能，以便简历与各种技能相关：

表 - 客户

The best way to do this is to manually enter the relevant skills into a table so that the resume is associated with a variety of skills:
Table - Clients

ID         Int with Identity, or Guid
Resume     Binary
other info on client.

表 - 技巧

Table - Skills

ID        Int with Identity, or Guid
Skill     Text

表 - ClientSkills

Table - ClientSkills

Id        Int with Identity, or Guid
ClientID  Foreign key to Clients table
SkillID   Foreign key of Skills table

所以id你有已知技能：

技能：

So id you have "known" skills:
Skills:

1     C++
2     C#
3     VB
4     Cobol

你有客户

And you have Clients

1     Resume.docx     Mike Smith
2     MyResume.docx   John Doe

然后你会有ClientSkills：

Then you would have ClientSkills:

1     1     1
2     1     3
3     2     2
4     2     3

然后你会发现所有C ++程序员都有一个简单的JOIN：

You then find all C++ programmers with a simple JOIN:

SELECT c.* FROM Clients c
JOIN ClientSkills cs ON cs.ClientID = c.ID
JOIN Skills s ON cs.SkillID = s.ID
WHERE s.Skill = 'C++'

这篇关于我有一个大型简历数据库（Cv），我希望通过技能从我的数据库恢复搜索。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！