9
New Features
SQL generation enhancements. The Aggregate node now supports SQL generation for date, time,
timesta mp, an
d string data types, in addition to integer and real. With IBM Netezza databases, the
Sample node sup ports SQL generation for simple and comple x sampling, and the Binning n ode
supports SQL generation for all binning methods except Tiles.
In-database model scoring. For IBM DB2 for z/OS, IBM Netezza and Teradata databases, it is
possible to enabl e SQL pus hback of many of the model nuggets to carry out model scoring (as
opposed to in-database mining) within the database. To do this, you can install a scoring adapter
into the database. When you publish a model for th e scoring adapter, the model is enabled to use
the user-defined function (UD F) capabilities of the database to perform the scoring.
A new configuration option, db_udf_enabled in options.cfg, causes the SQL generation option
to generate UDF SQL by default.
New format for database connection in batch mode. The format for specifying a database connection
in batch mode has changed to a single argument, to be c onsistent with the way it is s pecified in
scripting .
Enhancements to SPSS Statistics integration. O n the Statistics Output node, additional pro cedures
are availab le on the Syntax tab through the
Select a dialog button. The Regression subm enu
now suppo r ts Partial Least Squares regression, a nd there is a new Forecasting submenu with the
followi ng options: Spectral Analys is , Sequence Cha rts, Autocorrelations, and Cross-correlations.
For more information, see the SPSS Statistics documentation.
The Syntax ta b of the Statistics Output node also has a new option to generate a S tatistics File
source node for importing the data that results from running a stream containing the node. This is
useful where a proced ure writes fields suc h as scores to the active data set in addition to displaying
output, as these fields would otherwi se not be visible.
Non-root user on UNIX servers. If you have SPS S Modeler Server installed on a UNIX server, you
can now install, configure , and start a nd stop SPSS Modeler Server as a non-root user withou t the
need for a private p assword database.
Deployed streams can now access IBM SPSS Collaboration and Deployment Services model
management features. When a stream is deployed to IBM SPSS Collabora tion and Deployment
Services as a stream, it can now use the same model management features as it could if deploye d
as a sc enario. Th ese feature s include eva luation, refresh, score, and champion/challenger.
Improved method of changing ODBC connection for SPSS Modeler stream and scenario job steps. For
stream and scenario job steps in IBM SPSS Collaboratio n and Deployment Services, changes to
an ODBC connection and re lated logon credentia ls apply to all related job steps. This means that
you no longer have to change the jo b steps one by one.
Choice of execution branch in deployed streams. For stream job steps in IBM SPSS Collaboration
and Deployment Services, if th e stream con tains branches y ou can now choose one or more
stream branches to execute.