optimized name-address-zipcode-region design

Whether thin-client with round-trip cycles to the db or a rich-client
loading look-up data into memory on application startup, what is a solid
optimized database design for customer location search functionality. USPS
zip data has about 75K records.
Any articles on this? Thanks. -Greg
**** ** Application supplied data *******
1. First Name (PrimaryContactID)
2. Last Name
3. Client Name
4. Address (AddressID)
****** Vendor supplied data
zipinfo.com,/www.zip-codes.com,www.buyzips.com,etc. *******
5. City (CityID)
6. Region (State,Province, etc) (RegionID)
7. Postal Code. (PostalCodeID)
8. Area Code (AreaCodeID)
an optimized search that would return all customers (within a second) for
any of the following:
1. a given zipcode/postalcode
2. a given State/Region,
3. a given City
4. a given Area Code
5. a given match on name or substring of address."hazz" <hazz@.sonic_net> wrote in
news:ejBkMi7bGHA.3908@.TK2MSFTNGP02.phx.gbl:

> Whether thin-client with round-trip cycles to the db or a rich-client
> loading look-up data into memory on application startup, what is a
> solid optimized database design for customer location search
> functionality. USPS zip data has about 75K records.
> Any articles on this? Thanks. -Greg
> **** ** Application supplied data *******
> 1. First Name (PrimaryContactID)
> 2. Last Name
> 3. Client Name
> 4. Address (AddressID)
> ****** Vendor supplied data
> zipinfo.com,/www.zip-codes.com,www.buyzips.com,etc. *******
> 5. City (CityID)
> 6. Region (State,Province, etc) (RegionID)
> 7. Postal Code. (PostalCodeID)
> 8. Area Code (AreaCodeID)
> an optimized search that would return all customers (within a second)
> for any of the following:
> 1. a given zipcode/postalcode
> 2. a given State/Region,
> 3. a given City
> 4. a given Area Code
> 5. a given match on name or substring of address.
>
>
Here is a link to an article I read this w on ASP FAQ
How do I create a store locator feature?
http://www.aspfaq.com/show.asp?id=2527
- Jose|||Thank you for that link Jose. That is not exactly what I was after but that
is interesting. The vendor db's do have latitude and longitude so this is a
good example of how that info is useful. -Greg
"Jose Hernandez" <acmp_dev@.yahoo.com> wrote in message
news:Xns97B98A2952D76acmpdevyahoocom@.207
.46.248.16...
> "hazz" <hazz@.sonic_net> wrote in
> news:ejBkMi7bGHA.3908@.TK2MSFTNGP02.phx.gbl:
>
> Here is a link to an article I read this w on ASP FAQ
> How do I create a store locator feature?
> http://www.aspfaq.com/show.asp?id=2527
>
> - Jose|||You can also get the postal code database from several vendors such as
http://www.zipcodeworld.com.