Software

by Michael Zeller on 07/14/2009, Many databases currently allow for data mining and analysis. SQL Server, for example, benefits from SQL Server Integration Services (SSIS) and Oracle from Oracle Data Miner. MySQL users, on the other hand, have in general used tools such as R and SPSS for data mining and to build statistical models. There is even an R package that builds an interface between R and MySQL (called RMySQL). Both R and SPSS (as well as a host of other statistical tools) are able to export PMML (Predictive Model Markup Language) which is the standard way to represent data mining models (for more on PMML, click here).

We have recently shown that one can easily deploy predictive models from SQL Server on the Amazon Cloud in a matter of minutes by using a script task in SSIS and the ADAPA Scoring Engine (see SSIS/ADAPA posting here). This time, we would like to make a similar case for MySQL.

http://smartdatacollective.com/Home/20124