Skip to Content
0

What is the Best Approach to Address Matching with Fuzzy Search?

Apr 24 at 08:41 PM

16

avatar image
Former Member

There is a currently a script written in Perl which which performs address matching from two different HANA tables. It first reads one table and then loops through all the records to perform a SELECT query with a CONTAINS clause to perform a fuzzy search on multiple columns. It works great but I do suspect there might be a SQL only approach that could work just as well and scale even better. The CONTAINS function does not allow multiple table columns to be referenced so a JOIN with a CONTAINS will not work. What would be a suggested SQL only approach to doing address matching in 2 HANA tables? Loops? An example would help.

Here are the example tables:

TABLE ONE columns ID_ONE, STREET_NUMBER, STREET_NAME, ZIP_CODE

TABLE TWO columns ID_TWO, STREET_NUMBER, STREET_NAME, ZIP_CODE

MATCHED RESULTS TABLE columns ID_ONE, ID_TWO, FUZZY_SCORE

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers