November 22nd, 2011, 10:54 PM
How to structure a database for chatbot?
We are making a project name 127chatbot. Optimistically we are trying to make some thing like ALICE.
Alice is developed in xml extensions that is AIML, artificial intelligence markup language. However we are trying to model the chat bot system using database.
For now we have a problem with database handling and modeling the structure.
Lets say we make a table which stores keywords and resposes. Lets say user say "hi" that is a keyword and it will be searched in database for keywords and corresponding response that might be "hiya" is displayed to user. This is the most simple thing we can do.
Lets say if we want to model a structure which use m to m relationship between keywords and responses, how we should do that?
for example a list of similar keywords can have simialar responses like
"hi" "hello" "hey" can have any of "hi, how r u?" "hey, nice to meet you" .here we have 3 similar keywords and 2 responses to each keyword. response will be picked randomly for now. I want to ask how to model this structure in relation database.
if i couldnt convey the message well, Kindly ask for further explanation. Your help will be duely appreciated.
November 23rd, 2011, 05:11 AM
with a many-to-many relationship table
Originally Posted by wassay7
1009 hi, how r u
1037 hey, nice to meet you