3 views (last 30 days)
I am interested in translating decision tree (regression/classification) to SQL Rule format. For example, the decision tree below, when rules are converted to SQL, it should output something like this.
I want to deploy the tree model in sql environment.
If x2 >= 3085.5 and x1 >= 115 then 14.375
If x2 >= 3085.5 and x1 < 115 then 19.625
If x2 < 3085.5 and x1 <89 and x2 <2162 then 33.3056
Until all rules/possible paths are completed.
The view(tree) function is not meeting my requirement.
Is there a code /function that does this? I would be ggrateful for help.
Arthi Sathyamurthi
Arthi Sathyamurthi on 27 May 2021
You can use the view(tree) to view your classification tree in SQL format. That allows you to display the model in SQL environment. Pl. provide more information on why that does not meet your requirement to clarify further.
BP205 on 28 May 2021
Thanks for your response. The result of the "View(tree) is not somethng one readily use in SQL environment, especially when the tree is big.

Sign in to comment.

Answers (1)

Rishik Ramena
Rishik Ramena on 31 May 2021
Currently there is no MATLAB function to parse the classification tree objects and print out the path to all the leaves. This specific use case can be built using the properties which the ClassificationTree class provides. Have a look at the properties of this class and use any of the algorithms to print all the root to leaf paths in a tree. A similar implementation for the same has been answered here.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!