List:Summer of Code« Previous MessageNext Message »
From:Sergei Golubchik Date:March 28 2008 6:17pm
Subject:Re: Mysql full text search feature for GSoC
View as plain text  
Hi!

On Mar 28, Andreas Sotirakopoulos wrote:
> Hi,
> 
> A year ago my employer asked me to deliver a search engine project in
> PHP that would search in Greek Law texts stored in a database and
> produce results depending on the key phrase he entered. I went for
> MySQL naturally and I found that it didn't have a critical feature.
> 
> When you search in full text search for, let's say, +danger* +wol* you
> get results like the following:
> 
> The dangerous wolves blah blah Dangerous blah blah blah wolves
> 
> This is not what I needed. I needed only the first case and under no
> circumstances the second one. This has to do with the fact that in Law
> texts, phrases are really important and as the results can be millions
> you need to be precise and avoid unnecessary results like the second
> case.
> 
> This is something that MS SQL does (by giving "danger wol*"). It would
> be great to add this feature in MySQL because in languages like Greek
> where verbs conjugate this feature is often invaluable. I had to go
> for MS SQL but PHP does not play so well with MS SQL 2000 and so I
> feel that GSoC is a great opportunity to amend this.
> 
> I think that it could be a great addition to MySQL and it can be
> combined, in case it is too small for a GSoC project, with unsafe
> optimizations in Full-Text Search in natural language mode (simple,
> can provide ~100+ times speedup) WL#1171). I would be very happy to
> undertake such a project.

Sounds good, did you submit an application already ?
 
Regards / Mit vielen Grüssen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Developer/Server Architect
/_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Dachauer Str. 37, D-80335 München
       <___/                  Geschäftsführer: Kaj Arnö - HRB
München 162140
Thread
Mysql full text search feature for GSoCAndreas Sotirakopoulos27 Mar
  • Re: Mysql full text search feature for GSoCSergei Golubchik28 Mar
    • Re: Mysql full text search feature for GSoCAndreas Sotirakopoulos30 Mar