Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 21822 invoked from network); 10 Dec 2007 15:22:47 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 10 Dec 2007 15:22:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D69207D6A21; Mon, 10 Dec 2007 16:22:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19725-04; Mon, 10 Dec 2007 16:22:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50C987D6941; Mon, 10 Dec 2007 16:22:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 10 Dec 2007 15:35:38 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4AF7A7D6B62 for ; Mon, 10 Dec 2007 15:35:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00424-01 for ; Mon, 10 Dec 2007 15:35:38 -0500 (EST) Received: from mx02.il.proquest.com (mx02.il.proquest.com [192.195.245.52]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE1117D6B60 for ; Mon, 10 Dec 2007 15:35:37 -0500 (EST) X-ASG-Debug-ID: 1197318935-62fb02ea0000-JbYmij X-Barracuda-URL: http://spam.il.proquest.com:8000/cgi-bin/mark.cgi Received: from AABO-EXCHANGE04.bos.il.pqe (localhost [127.0.0.1]) by mx02.il.proquest.com (Spam Firewall) with ESMTP id 423273E8101 for ; Mon, 10 Dec 2007 15:35:35 -0500 (EST) Received: from AABO-EXCHANGE04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.208]) by mx02.il.proquest.com with ESMTP id w5fE29tFBWqrQU8Z for ; Mon, 10 Dec 2007 15:35:35 -0500 (EST) X-ASG-Whitelist: Client Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.202]) by AABO-EXCHANGE04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.3959); Mon, 10 Dec 2007 15:35:35 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C83B6C.373664E0" X-ASG-Orig-Subj: Various soundex algorithms implementations in 10g? Subject: Various soundex algorithms implementations in 10g? Date: Mon, 10 Dec 2007 15:35:34 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Various soundex algorithms implementations in 10g? From: "Bobak, Mark" To: "oracle-l" X-OriginalArrivalTime: 10 Dec 2007 20:35:35.0101 (UTC) FILETIME=[3756EED0:01C83B6C] X-Barracuda-Connect: aabo-exchange04.bos.il.pqe[172.24.3.208] X-Barracuda-Start-Time: 1197318935 X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at il.proquest.com X-archive-position: 3820 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-to: Mark.Bobak@il.proquest.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C83B6C.373664E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 I've just had a query from a developer about soundex algorithms in Oracle 10gR2. I know about the soundex() function, which is an implementation of the Russell soundex (described by Knuth in TAOCP). The developer seems to think that there are some gaps in the Oracle implementation, though. (working on getting details/specifics of what he means by gaps in the implementation). Also, he's asked about some other algorithms, namely, Daitch-Mokotov and Double Metaphone. Anyone have any experience with either of these on Oracle? Anyone have PL/SQL implementations they'd be willing to share? J For now, I think I'm looking to code this in PL/SQL, and we won't be using any Oracle Text features. =20 Finally, these are US Census names that we'll be searching, and from what I read, there's an algorithm called Jaro-Winkler which was specifically written for US Census name data, *and* Oracle has an implementation of that one in UTL_MATCH on 10gR2. So, I've asked the developer about this algorithm and whether he's considered it. =20 I guess I'm just looking for any folks that have any experience implementing any of the above algorithms, any thoughts or things to look out for, pointers to public implementations of any of these implementations, etc..... =20 -Mark =20 -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@il.proquest.com =20 www.proquest.com =20 www.csa.com =20 ProQuest...Start here.=20 =20 ------_=_NextPart_001_01C83B6C.373664E0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I’ve just had a query from a developer about = soundex algorithms in Oracle 10gR2.  I know about the soundex() function, = which is an implementation of the Russell soundex (described by Knuth in = TAOCP).  The developer seems to think that there are some gaps in the Oracle = implementation, though. (working on getting details/specifics of what he means by gaps = in the implementation).  Also, he’s asked about some other = algorithms, namely, Daitch-Mokotov and Double Metaphone.  Anyone have any = experience with either of these on Oracle?  Anyone have PL/SQL implementations = they’d be willing to share? J  For now, I think I’m looking to code this in PL/SQL, and we = won’t be using any Oracle Text features.

 

Finally, these are US Census names that we’ll = be searching, and from what I read, there’s an algorithm called = Jaro-Winkler which was specifically written for US Census name data, *and* = Oracle has an implementation of that one in UTL_MATCH on 10gR2.  So, = I’ve asked the developer about this algorithm and whether he’s considered = it.

 

I guess I’m just looking for any folks that = have any experience implementing any of the above algorithms, any thoughts or = things to look out for, pointers to public implementations of any of these = implementations, etc…..

 

-Mark

 

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann = Arbor MI 48106-1346
+1.734.997.405= 9  or +1.800.521.0600 x 4059
mark.bobak@il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start = here.

 

------_=_NextPart_001_01C83B6C.373664E0-- -- http://www.freelists.org/webpage/oracle-l