lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lance Norskog <goks...@gmail.com>
Subject Re: one to many denormalization approach
Date Wed, 30 Jun 2010 03:51:15 GMT
Solr supports multi-valued fields. You can add various skills to one
field and it will store all of the values in order. You can search on
any of the values. For numbers, you might want a subtype_value
convention: skillYears1_9 as one of the values for the skillYears
field.

Lance

On Mon, Jun 28, 2010 at 1:58 AM, Michael Delaney <mickdelaney@gmail.com> wrote:
> Hi,
>
> I have an architectural question about using apache solr/lucene.
>
> I'm building a solr index for searching a CV database. Basically every CV on
> there will have some fields like:
>
> rate of pay, address, title
>
> these fields are straight forward. The area I need advise on is, skills and
> job history. For skills, someone might add an entry like: Ruby - 5 Years,
> Java - 9 Years
>
> CV:
>
>    John Smith
>    27
>    Skills:
>        Java, 5 Years
>        Sql, 4 Years
>        Lucene, 1 Year
>    Jobs:
>        1998-2004 Acme Search Ltd, Senior Java Developer, New York City, US
>        2004-2009 Software Labs Ltd, Technical Architect, San Francisco, CA,
> US
>
> So there's essentially N number of skills, each with a string name and a int
> no of years. I was thinking I could use a dynamic field, *_skill, and
> possibly add them like so:
>
> 1_skill: Ruby, 2_skill: Java
>
> But how can I index the years experience? would I then add a dynamic field
> like:
>
> 1_skill_years: 5, 2_skill_years: 9
>
>
> How would i fit these into the index?
> Any help greatly appreciated?
>
> Regards
>



-- 
Lance Norskog
goksron@gmail.com

Mime
View raw message