0

YouTube Video: Scoring Data from MySQL in ADAPA using KNIME and PMML

The idea for this demo is to show how easy one can easily move a predictive model from the scientist's desktop to the IT operational environment. When training a model, scientists rely on historical data, but when using the model on a regular basis, the model is moved or deployed in production where it presented with new data. ADAPA provides a scalable and lightning fast scoring engine for models that live in production. And, although KNIME data mining nodes are typically used by scientists to build models, its database and REST nodes as well as PMML-enabled nodes can simply be used to create a flow for passing models and data for scoring in ADAPA.

Use-cases are:

  1. Read data from a flat file, use KNIME for data pre-processing and building of a neural network model. Export the entire predictive workflow as a PMML file and then take this PMML file and upload and score it in ADAPA via its Admin Web Console.
  2. Read data from a database (MySQL, SQLServer, Oracle, ...), build model in KNIME, export model as a PMML file and deploy it in ADAPA using its REST API. This use-case also shows new or testing data flowing from the database and into ADAPA for scoring via a sequence of KNIME nodes. The video also shows a case in which one can use KNIME nodes to simply read a PMML file produced in any PMML-compliant data mining tool (R, SAS EM, SPSS, ...), upload it in ADAPA using the REST API and score new data from MySQL in ADAPA also through the REST interface. Note that in this case, the model has already been trained and we are just using KNIME to deploy the existing PMML file in ADAPA for scoring.

0 comments

Post is closed for comments.