In-database processing: Difference between revisions

Revision as of 20:14, 7 July 2020

Revision as of 19:44, 21 August 2020

Line 16:

===Translating models into SQL code===

In this type of in-database processing, a predictive model is converted from its source language into SQL that can run in the database usually in a [[stored procedure]]. Many analytic model-building tools have the ability to export their models in either SQL or [[PMML]] (Predictive Modeling Markup Language). Once the SQL is loaded into a stored procedure, values can be passed in through parameters and the model is executed natively in the database. Tools that can use this approach include SAS, SPSS, R and KXEN.

===Loading C or C++ libraries into the database process space===