Group similar product

Hi,

i have make a search with sony+hx100v and search this in mysql:

CAM DIG.SONY HX100V 16.2 PRETO S/GARANT 0
CAM FOTO SONY DSC-HX100V/B 16.2M WHITE
CAM. FOTO SONY DSC-HX100V 16.2MP NEGRO
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M pp
CAM FOTO SONY DSC-HX100V/B 16.2M p
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M BLACK

How i can create a search to give me how much is similar my search with the
result with SE?

thanks

--

Hi,

I am using plugin elasticsearch-river-jdbc-master to index the data from
mysql

Em quarta-feira, 5 de dezembro de 2012 15h05min09s UTC-2, Houssan A. Hijazi
escreveu:

Hi,

i have make a search with sony+hx100v and search this in mysql:

CAM DIG.SONY HX100V 16.2 PRETO S/GARANT 0
CAM FOTO SONY DSC-HX100V/B 16.2M WHITE
CAM. FOTO SONY DSC-HX100V 16.2MP NEGRO
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M pp
CAM FOTO SONY DSC-HX100V/B 16.2M p
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M BLACK

How i can create a search to give me how much is similar my search with
the result with SE?

thanks

--

Something like curl localhost:9200/_search?q=+sony%20+hx100v could work.

Or something like curl localhost:9200/_search -d "{
"query" : {

"query_string" : {
"default_field" : "content",
"query" : "+sony +hx100v"
}
}

}"

But it depends on your mapping.

David.

Le 5 décembre 2012 à 18:07, "Houssan A. Hijazi" hussanhijazi@gmail.com a écrit
:

Hi,

I am using plugin elasticsearch-river-jdbc-master to index the data from
mysql

Em quarta-feira, 5 de dezembro de 2012 15h05min09s UTC-2, Houssan A. Hijazi
escreveu:

Hi,

i have make a search with sony+hx100v and search this in mysql:

CAM DIG.SONY HX100V 16.2 PRETO S/GARANT 0
CAM FOTO SONY DSC-HX100V/B 16.2M WHITE
CAM. FOTO SONY DSC-HX100V 16.2MP NEGRO
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M pp
CAM FOTO SONY DSC-HX100V/B 16.2M p
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M BLACK

How i can create a search to give me how much is similar my search with
the result with SE ?

thanks

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

Hi,

thank you for your answer but i have this problem.

I index my products from many shops and some shops call name of products
different than other shops.
example:

shop a: Cel. Iphone 5 16GB White
shop b: Mobile Iphone 5 16 GB W.
shop c: Iphone5 16GB White
shop d: Iphone 5 16GB Whi

i have many names to same product, can i solve this with elasticsearch ?
maybe similarity?

Thanks

Em quarta-feira, 5 de dezembro de 2012 15h24min32s UTC-2, David Pilato
escreveu:

Something like curl localhost:9200/_search?q=+sony%20+hx100v could work.

Or something like curl localhost:9200/_search -d "{
"query" : {

"query_string" : {
"default_field" : "content",
"query" : "+sony +hx100v"
}
}

}"
But it depends on your mapping.

David.

Le 5 décembre 2012 à 18:07, "Houssan A. Hijazi" <hussan...@gmail.com<javascript:>>
a écrit :

Hi,

I am using plugin elasticsearch-river-jdbc-master to index the data from
mysql

Em quarta-feira, 5 de dezembro de 2012 15h05min09s UTC-2, Houssan A.
Hijazi escreveu:

Hi,

i have make a search with sony+hx100v and search this in mysql:

CAM DIG.SONY HX100V 16.2 PRETO S/GARANT 0
CAM FOTO SONY DSC-HX100V/B 16.2M WHITE
CAM. FOTO SONY DSC-HX100V 16.2MP NEGRO
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M pp
CAM FOTO SONY DSC-HX100V/B 16.2M p
CAMERA DIGITAL SONY DSC-HX100V 16.2 MEGA PIXELS 3.
CAM FOTO SONY DSC-HX100V/B 16.2M BLACK

How i can create a search to give me how much is similar my search with
the result with SE ?

thanks

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

Hi Houssan,

the data model you use has no canonical forms. You need to do some
normalization beforehand so that each shop refers to the same product ID.
There are many ways to perform data normalization but they are outside of
Elasticsearch.

Best regards,

Jörg

--

Ok,

i undestrand, but how i can do the automatic normalization ? can you
suggest something?

thanks

Em quarta-feira, 5 de dezembro de 2012 16h01min57s UTC-2, Jörg Prante
escreveu:

Hi Houssan,

the data model you use has no canonical forms. You need to do some
normalization beforehand so that each shop refers to the same product ID.
There are many ways to perform data normalization but they are outside of
Elasticsearch.

Best regards,

Jörg

--