When using data from a database, SQL code can be pushed back to the database for
execution, providing superior performance for many operations. For some nodes, SQL for the model
nugget can be generated, pushing back the model scoring stage to the database. This allows flows
containing these nuggets to have their full SQL pushed back.
For a generated model nugget that supports SQL pushback:
Double-click the model nugget to open its settings.
Depending on the node type, one or more of the following options is available. Choose one of
these options to specify how SQL generation is performed.
Generate SQL for this
model
Default: Score using Server Scoring Adapter (if installed) otherwise in
process. This is the default option. If connected to a database with a scoring adapter
installed, this option generates SQL using the scoring adapter and associated user defined functions
(UDF) and scores your model within the database. When no scoring adapter is available, this option
fetches your data back from the database and scores it in SPSS Modeler.
Score by converting to native SQL without Missing Value Support. This
option generates native SQL to score the model within the database, without the overhead of handling
missing values. This option simply sets the prediction to null ($null$) when a
missing value is encountered while scoring a case.
Score by converting to native SQL with Missing Value Support. For CHAID,
QUEST, and C&R Tree models, you can generate native SQL to score the model within the database
with full missing value support. This means that SQL is generated so that missing values are handled
as specified in the model. For example, C&R Trees use surrogate rules and biggest child
fallback.
Score outside of the Database. This option fetches your data back from
the database and scores it in SPSS Modeler.
About cookies on this siteOur websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising.For more information, please review your cookie preferences options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.