DB2 for Z/Os V8 and Fuzzy Search

Jeffrey Schade

DB2 for Z/Os V8 and Fuzzy Search
I have an application developer who is interested in a fuzzy search
function in our current DB2 Version 8 NFM environment. She thinks that
the Version 9 SOUNDEX function will provide her some of what she is
interested in but of course she cannot wait for our upgrade schedule
which is later this year. I did find a SOUNDEX UDF but it looks like it
may not perform well enough for our environment.



Are there any other options for us to implement some form of fuzzy
search in our current environment?



Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering


ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
[login to unmask email] <mailto:[login to unmask email]>



This email is intended for the recipient only. If you are not the intended recipient please disregard, and do not use the information for any purpose.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Richard Fazio

Re: DB2 for Z/Os V8 and Fuzzy Search
(in response to Jeffrey Schade)
Depending upon how many UDF Calls you are performing, yes the
performance issues can add up ( 1,100 years if I remember correctly ).
I'm guessing that the UDF code you have is assembler or a 3GL. SQL UDFs
move into the DB2 engine in V9; the extra task switches to the SPAS are
no longer needed. This means you can develop now and take a performance
hit until V9 is in house. Ideally if you package it correctly...you
could swap out the DB2 Soundex call for a code version of the Russell
soundex. Thus, eliminating a code dependency.



There are other hash algorithms, but I thing you are still at the mercy
of imbedding program code inside your SQL.



If you would like to discuss your requirements in more detail off-line,
send me a note...I may have an idea or two.

faz



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Schade, Jeffrey
Sent: Monday, January 28, 2008 7:27 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for Z/Os V8 and Fuzzy Search



I have an application developer who is interested in a fuzzy search
function in our current DB2 Version 8 NFM environment. She thinks that
the Version 9 SOUNDEX function will provide her some of what she is
interested in but of course she cannot wait for our upgrade schedule
which is later this year. I did find a SOUNDEX UDF but it looks like it
may not perform well enough for our environment.



Are there any other options for us to implement some form of fuzzy
search in our current environment?



Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering


ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
[login to unmask email] <mailto:[login to unmask email]>



This email is intended for the recipient only. If you are not the
intended recipient please disregard, and do not use the information for
any purpose.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Carol Anne Sutfin

Re: DB2 for Z/Os V8 and Fuzzy Search
(in response to Richard Fazio)
Jeff

Add your own SOUNDEX column to search on. There's the old DFHPHN macro
still in CICS.
I have a COBOL version if you want it.

We used this about 20 years ago on a large (100M) item ADABAS database to
search names.

You can contact me offline if you wish.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



"Schade, Jeffrey"
<[login to unmask email]>
Sent by: DB2 Data To
Base Discussion [login to unmask email]
List cc
<[login to unmask email]
ORG> Subject
[DB2-L] DB2 for Z/Os V8 and Fuzzy
Search
01/28/2008 07:27
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-l.org>






I have an application developer who is interested in a fuzzy search
function in our current DB2 Version 8 NFM environment. She thinks that the
Version 9 SOUNDEX function will provide her some of what she is interested
in but of course she cannot wait for our upgrade schedule which is later
this year. I did find a SOUNDEX UDF but it looks like it may not perform
well enough for our environment.

Are there any other options for us to implement some form of fuzzy search
in our current environment?

Jeff
_________________________________________
Jeffrey Schade
Systems Consultant, Technology Engineering

ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
[login to unmask email]



This email is intended for the recipient only. If you are not the intended
recipient please disregard, and do not use the information for any purpose.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at www.idug.org under the
Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no
cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms