After building your data mining model on a training dataset, you typically wish to score all your customers or other subjects with the model. And maybe even put the model into production and calculate scores on a monthly, weekly or daily basis. Unless you have built the model in an integrated solution such as Oracle Data Mining or SQL Server Data Mining, you may find that deploying your model into a production setup can be quite challenging.
The PMML file...
Many of the data mining tools today (but not all) have an option to export the model into a PMML file (XML format) that contains all the relevant information for your model. Unfortunately most ETL databases do not have an "Import PMML file" functionality - so even with the PMML output file, we are not quite there yet...
PMML2SQL.com could be your solution...
With pmml2sql.com you can establish that crucial connection between the model (in the form of a PMML file) and any database - simply by parsing the PMML code into a more datawarehouse friendly SQL format.
But what are the benefits...?
Translating the PMML file into a SQL script completes the data mining proces by enabling scoring of your model on any SQL driven database. More importantly it gives you freedom to choose virtually any data mining tool - including free or inexpensive software suites such as Rattle or KNIME - without compromising model quality or ease of implementation. And finally you are able save money because you are not forced to invest heavily in any of the rather expensive ETL integrated solutions.
What is the price..?
PMML2SQL is still in beta: new models are being added and bugs are being fixed - so for now it is free!
Which model types are covered..?
Currently linear regression models, logistic regression models, neural nets, decision trees and kmeans clustering models are included from some of the most used software suites. Work is ongoing to include new model types.
Which data mining software suites are covered..?
Currently models from Clementine/PASW, Rattle and KNIME are included.
What if my model is not included..?
You can request a new model - see details under "Contact" menu! New models will be developed in order of popularity.
What if I find a bug..?
Hopefully you won't - but should you find a bug in translated SQL, please click here and provide the details stated in the list.