user manual

8
Chapter 2
Default settings for database connections. You c an no w specify default settings for S QL Server
and Or acle dat
abase connections, as wel l as those already supported for IBM DB2 InfoSphere
Warehouse.
Stream properties and optimization redesign. The Options tab on the Stream Proper ties dialog box
has been redesigned to group the options into catego r ies. The Optimization options have also
moved from User Options to Stream Properties. For more information, see the topic Setting
Options for Streams in Chapter 5 on p . 54.
Node execution timing. You can now set an option to display individu al exe cution times for
the no des i n a stream. For more information, see th e topic Viewin g Node Execution Times in
Chapter 5 on p. 67.
You can also set an opti on (time_ecode_execution_log) in the se r ver configuration file to recor d
these execution times in the message log .
Stream parameters in SQL queries from Database source node. You can now include SPSS Modeler
stream parameters in SQL queries t hat you enter in the Database sour ce node.
Expression Builder supports in-database functions. If a stream connects to a database through a
Databa se sour ce node and you use the Expression Builder with a downstre am node, you can
include in-datab ase f unctions from the connected database directly in the expressio n you are
building. For more information , see the topic Selecting Functions in Chapt er 7 on p. 120.
IBM Cognos BI node enhancements. The Cogn os BI source node now supports imp orting Cognos
list r eports as well as data, and additionally supports the use of parameters and filters.
For the Cognos BI source and e xport nodes , S PSS Modeler now a utomatically detects th e version
of IBM Cognos BI in use.
Enhancements to Aggregate node. The Aggregat e node now supports several new aggregatio n
modes for aggregate fie lds: median, cou nt, varia nce, and first and third quartiles.
Merge node supports conditional merge. You can now perform input record merges that dep end on
satisfyi ng a condition. You can specify the c ondition directly in the node, or build the condition
using the Expression Builder.
Enhancements to in-database mining nodes for IBM DB2 InfoSphere Warehouse. For in-database
mining with IBM DB2 InfoSphere Warehouse, the ISW Clustering node now supports the
Enhanced BIRCH algorithm in addition to demogra phic and Kohonen clustering. In addi tion, the
ISW Association node provides a choice of layout for non-transa ctional (tabular) data.
Table compression for database export. When exporting to a database, you can now specify table
compression options for SQL Serv er and Oracle da tabase connections, as well as those already
supported for IBM DB2 InfoSphere War ehouse.
Bulk loading for database export. Additional help information is avai lable for database bulk loading
using an external loader program.