Convert artificial intelligence program to use database engine

Completed Posted Jan 7, 2005 Paid on delivery
Completed Paid on delivery

Zabaware creates an artificial intelligence software known as Ultra Hal Assistant. Ultra Hal Assistant is a program capable of holding intelligent conversations with a user and assisting them with various organizational tasks. A detailed description of the software can be found at [url removed, login to view] Currently, Ultra Hal uses many text files for its database. This method works alright with for a desktop version of Hal, but is unacceptable for a server environment. We would like to convert Hal to use a single database file and a database engine instead of many small text files. It should be compatible with several database engines including Access, MS SQL, and mySQL. This project will be divided into smaller projects, this being the first step. Currently, each text file the software uses as its database is a seperate table. Each text file has 2 fields for each record: a question and an answer. Both are English sentences. The program compares a user sentence (the question) with all the questions in the database and responds with the answer associated with the question. As decribed in detail under the deliverables, we want the program to use a database engine instead of these text files to perform this function.

## Deliverables

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).

What we need is an ActiveX control (written in either Visual C++ or VB6, no .NET) that will perform the following functions:

1. A method or property that will tell the ActiveX control which database engine to use.

2. A method that will tell the ActiveX control the name and location of the database. This method should return True if the database has been found and loaded and false if it doesn't exist.

3. A method that will create a new database should the previous method show that the database does not exist.

4. A method that will check to see if a table exists or not.

5. A method that will take as an input the path of a text file and a table name. The method will add all records contained in the text file into the table in the database.

6. A method that will take as an input a question (string), an answer (string), and a table name and add that record to the table.

7. The most important method in this project: Take as an input a string containing a question and the name of a table. It will also take as input 2 empty string arrays by reference to store results in. A query will be run that compares the question in the input with all the questions in the table. The query will calculate how many words are the same in both the input search string and the record. The query should only return the top 100 hits. The top 100 hits should be recorded in the 2 string arrays that were provided. One array will be for the question and the other will be the answer associated with the question. This function *MUST* be as fast or faster than the current code the program uses. A compiled form of the current code or parts of the source code will be provided for comparison.

[url removed, login to view] ActiveX control should be capable of running several concurrent instances without any collisions and corruption in the database.

## Platform

This ActiveX control should be able to run on all Windows 32-bit platforms, Windows 98 and newer.

C Programming Database Administration Engineering Microsoft Microsoft Access MySQL PHP Software Architecture Software Testing SQL Visual Basic Windows Desktop

Project ID: #3507663

About the project

21 proposals Remote project Active Jan 11, 2005

Awarded to:

excellisoft

See private message.

$680 USD in 30 days
(8 Reviews)
5.2

21 freelancers are bidding on average $517 for this job

ksil

See private message.

$425 USD in 30 days
(144 Reviews)
7.7
vlexvw

See private message.

$510 USD in 30 days
(66 Reviews)
7.4
mihaiscortaru

See private message.

$637.5 USD in 30 days
(160 Reviews)
6.0
michaeldstephens

See private message.

$510 USD in 30 days
(96 Reviews)
5.8
aliviu2003

See private message.

$425 USD in 30 days
(48 Reviews)
5.6
snowsoftvw

See private message.

$637.5 USD in 30 days
(30 Reviews)
5.4
laacgroup

See private message.

$425 USD in 30 days
(21 Reviews)
4.6
milonov

See private message.

$467.5 USD in 30 days
(10 Reviews)
4.4
brahmasolutions

See private message.

$552.5 USD in 30 days
(12 Reviews)
3.7
adrianmos

See private message.

$425 USD in 30 days
(7 Reviews)
3.2
individize

See private message.

$425 USD in 30 days
(4 Reviews)
3.2
exceliier

See private message.

$425 USD in 30 days
(2 Reviews)
2.5
bonjomatic2005

See private message.

$425 USD in 30 days
(4 Reviews)
2.1
bhavien

See private message.

$497.25 USD in 30 days
(4 Reviews)
1.9
jocleppo

See private message.

$620.5 USD in 30 days
(0 Reviews)
0.0
mdgryn

See private message.

$595 USD in 30 days
(1 Review)
2.5
ujica

See private message.

$425 USD in 30 days
(0 Reviews)
0.0
qbicdev

See private message.

$425.85 USD in 30 days
(0 Reviews)
0.0
cyberizenvw

See private message.

$637.5 USD in 30 days
(0 Reviews)
0.0
rostvw

See private message.

$680 USD in 30 days
(0 Reviews)
0.0