Hi, i've run the Apriori Node for my Market Basket Analysis and i'm able to get the rules.
I'm able to run new transactional data against the rules and get the prediction result and write directly to the database for my application front end to consume.
From the model nugget, i'm able to export to a file (text, pmml and html), However, if i want to export the Rules inside the model nugget into the Database (write), how do i do that?
There is no easy way to export the model itself to a database, but it can be done through scripting.
I have found that the easiest way to do that is to:
Export the model to a text file or an XML/PMML file
Import the file back into Modeler as a data set using the appropriate source node
Transform the text from the file as needed - this might depend on the settings used in the Apriori node that generated the model
Export the formatted data set with the rules to your database
For the most part, however, there really is no reason to have the rules themselves in the database as you probably just need to have the model applier to generate the predictions and these can be stored in the database.