Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Querying a huge address table
Allen,
You could try a specialist addressing package like QAS from QuickAddress Software, which finds a UK address from a house number and postcode, or Sartori Software which handles US and Canadian addresses. The compoments are limited to a windows platform, I believe.
-----Original Message-----
From: allenh_at_starbase.neosoft.com (Allen)
[mailto:allenh_at_starbase.neosoft.com]
Posted At: Monday, April 09, 2001 11:18 PM
Posted To: misc
Conversation: Querying a huge address table
Subject: Querying a huge address table
The company I work for is getting ready to buy 100+ million street
addresses for a lookup table. The application will have users enter
part
of an address and then we need to return the closest matches. We'd like
to have it use fuzzy searches so that close spelling or sounding entries
will still be located. It looks like intermedia for Oracle will do the
trick. My question is if anyone else has done this already so I don't
have to reinvent the wheel. Any references much appreciated...
Allen Received on Tue Apr 10 2001 - 05:18:35 CDT