Predictive analytics scoring with MySQL and ADAPA
In this blog post, we outline how to use a MySQL database as a client to the ADAPA Scoring Engine by leveraging the ADAPA REST API to execute a predictive analytics model based on the Predictive Model Markup Language (PMML) industry standard.
We assume that:
- MySQL and cURL are installed
- Necessary MySQL tables are already created
- A PMML model for the data is deployed and available through the ADAPA
- REST API.
Simply using SQL and UDFs, the above enables us to easily execute complex predictive analytics models directly from one of the most commonly used databases, score the records, and write the results back into a database table.
A step-by-step tutorial, including installing MySQL-UDF-HTTP and writing functions and triggers, is available in this video.