Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e8CJrxS09773 for ; Tue, 12 Sep 2000 15:53:59 -0400 (EDT) Received: from [206.169.43.135] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1088345; Tue, 12 Sep 2000 12:53:54 -0700 Message-ID: <39BE8933.85875E2@agliodbs.com> Date: Tue, 12 Sep 2000 12:51:15 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: Mitch Vincent , sqllist Subject: Re: Weighted Searching References: <005901c01cd5$9b67b250$0200000a@doot> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/82 Mr. Vincent, > I emailed the list a while back about doing some weighted searching, asking > if anyone had implemented any kind of weighted search in PostgreSQL.. I'm > still wondering the same thing and if anyone has, I would greatly appreciate > a private email, I'd like to discuss it in detail.. I have several ideas but > most of them are pretty dirty and slow.. You really need to do this in PLSQL, Perl or C because there isn't any good way to implement weighting in pure SQL -- weighting is a procedureal thing. I'm currently in the process of designling an HR app that will use quite elaborate weighting scheme. Candidates are compared against job openings and the matches are weighted according to the degree of similarity (e.g. Job A requires 5 years of experience and the candidate has 4 or -20% for a weight of -1 but he is in the right location for a weight of +2 etc.) with the summary of weights to be fudged by the user according to what s/he considers most important for the job (location, skills, etc. I'm not done but I expect this function to be 4-5 pages of PL-SQL. Fuzzy logic eats processing power. I'll be open-sourcing the program in December, but you probably can't wait that long. I'd be interested to hear from anyone who's written a web search engine. It seems to me that the algorithm for, say, google should be fairly similar to what I'm doing for HR. -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small businesses fax 436-0137 and non-profit organizations. pager 338-4078 San Francisco