|
Re: decision tree in Oracle DB [message #447961 is a reply to message #33471] |
Thu, 18 March 2010 13:42   |
marlon_loyolite
Messages: 66 Registered: July 2006
|
Member |
|
|
Hi Friends,
Can anyone please explain me to have a decision tree (Quesion & answer type) in Oracle database with some sample data?
And based on answers select by the user, we determine some decision.
Regards,
carlos
|
|
|
|
|
|
|
|
|
Re: decision tree in sql [message #447990 is a reply to message #447978] |
Thu, 18 March 2010 23:42   |
marlon_loyolite
Messages: 66 Registered: July 2006
|
Member |
|
|
No..
Hi. I've been tasked with finding how to convert a decision tree to Oracle tables. It's used for a user help center: If caller answers Question A with Answer 1, then ask Question C, else ask Question B, etc. And they'd like to record the user's responses along the way. The subject-matter experts are developing the questions/typical answers and we in IT have to now build a web-based system to guide people through this decision tree.
How do you create such a thing in a relational database? Your guidance is much appreciated.
Thanks.
|
|
|
|
Re: decision tree in sql [message #448014 is a reply to message #447990] |
Fri, 19 March 2010 02:01  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Like a parent-child relationship as in the emp table.
If it is a tree (not a network) then it is possible to do it like that.
Of course it depends on your specific case and requires a couple hours to think about it, so it is not something we can design in a forum.
Regards
Michel
|
|
|