We have an existing application that allows us to search our database very fast, even if there are spelling mistakes. Its is a Fuzzy search with soundex etc. However it is dos based and we have lost the source code. We wrote it about 10 years ago!
Name address postcode phone number.
When the customer rings up the operator asks the customer for some data to find thier account. I.e. name and phone number. They just type that into the search box. i.e. Richard Harvey 123456670 and the system will find it in the database. It also shows the next best matches in a scroll box, upto 20 at a time.
We used a principal of taking all the search fields from the main table and then sotreing them in a binary string in another table. With the index key. The search system then only has to look at one field per record, this speeds the system up.
The developer will supply a program that takes the data from the main table and then inserts it in the search table. This will run on a scheduled task in windows once every 24 hours.
You will then provide a sample app. The required performance will be less than 2 seconds to find a record in a table with 300k rows.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
VB6 and MS SQL ONLY NO OTHER LANGUAGE WILL BE ACCEPTED