IBM Systems Magazine, Mainframe - November/December 2015 - 26

Mainframe Skills

IBM SPSS* Modeler server for
further processing.
The predictive analytics process
in the customer infrastructure
consists of three steps:
1. In the data preparation phase
a data analyst copies historical
purchase and customer data
from a data warehouse on the
mainframe to the SPSS Modeler
on a distributed platform. The
data is then prepared via a
series of steps (e.g., cleansing,
aggregations, joins, transforms,
etc.) all within the SPSS
Modeler server.
2. In the modeling phase the
models are calculated in SPSS
Modeler based on the data
prepared in the first step and
the predictive model nugget
is created.
3. The scores of the model are
generated and analyzed by
the data analyst.

LEARN HOW
Mainframe clients
can mitigate
the effect of the
upcoming skills
shortage in our
new special report.
Read the full report here:
ibmsystemsmagmain
framedigital.com/
MFSkills
Platinum Sponsor

Gold Sponsor

The steps are repeated by the
data analyst using a subset of
the whole data as training data
for step two and a distinct subset
as test data to verify the model
in step three until it delivers
expected results. At this point the
models can be deployed for usage
in the operational environment.
Instead of selecting and moving
complex data from DB2 for
z/OS to SPSS Modeler for further
processing, the time-consuming
data preparation can be executed
in the accelerator. This feature was
enabled by a new infrastructure,
the accelerator-only tables (AOT) in
the IBM DB2 Analytics Accelerator
V4 program temporary fix (PTF) 5.
AOTs don't originate from base
tables in DB2 for z/OS; their data
exists only on an accelerator.
The data in the AOTs can only be
modified by data-manipulation
statements (i.e., INSERT, UPDATE
and DELETE). This type of
modification, called in-database

26 // NOVEMBER/DECEMBER 2015 ibmsystemsmag.com

transformation, is supported in
SPSS Modeler 17.
In step two, the SPSS Modeler
can execute the embedded
analytics algorithms in the analytics
layer in the accelerator, the IBM
Netezza* Analytics, on the data
generated in step one to create the
predictive models. This means the
data preparation and the modeling
in the SPSS stream processing can
be mapped to the database and
embedded analytics algorithms in
the IBM DB2 Analytics Accelerator
without moving the data to the
SPSS Modeler. The technology
to process the modeling in the
accelerator is not supported in SPSS
Modeler and Accelerator yet, but is
planned for future releases.

Optimized Infrastructure
for Predictive Analytics
Two types of modeling algorithms
in the customer environment were
investigated in the study. The
first type was a cluster algorithm
used for the segmentation of
customers based on demographic
data, buying behavior, time of
purchase, etc. The second type
was an association algorithm
used to identify patterns, and
create buying recommendation
and product assignment for
marketing campaigns as well
as selling recommendations at
the point of sale. The study used
the new accelerator technology

More Resources
Accelerator-only tables
and in-database transformation: ibm.co/1JjRdgk
IBM Netezza Analytics:
ibm.co/1VbqD0H
IBM SPSS Modeler: ibm.
com/software/analytics/
spss/products/modeler


http://www.ibmsystemsmagmainframedigital.com/MFSkills http://ibm.co/1JjRdgk http://ibm.co/1VbqD0H http://www.ibm.com/software/analytics/spss/products/modeler/ http://www.ibm.com/software/analytics/spss/products/modeler/ http://www.ibm.com/software/analytics/spss/products/modeler/ http://www.ibmsystemsmag.com

IBM Systems Magazine, Mainframe - November/December 2015

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - November/December 2015

IBM Systems Magazine, Mainframe - November/December 2015
Table of Contents
IBM Perspective: Opening new options for real-time analytics
Editor's Desk: Predictive analytics enhances purchases
Infographic: Breaking down the mainframe skills gap
Partner PoV: IBM z Systems clients must manage existing and emerging assets together to get the most value
Focus on Storage: The IBM Spectrum Storage family of software-defined solutions simplifies storage management
Currents: Architect real-time analytics into operational systems for competitive advantage
Cover Story: Dynamic Spark: IBM brings the Apache project's analytics power to Linux and z Systems servers
Feature: Personal Shopper: Retailer optimizes analytics to drive a more customized client experience
Tech Showcase: In a roundtable, distributors discuss how IBM LinuxONE enables flexibility for users
Tech Corner: Runtime Diagnostics and Predictive Failure Analysis V2.2 improve z/OS availability
Solutions: Strobe 5.2
Stop Run: IBMer volunteers time to educate people about malaria and technology
Reference Point - Global Events, Education, Resources for Mainframe
2016 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - November/December 2015 - Intro
IBM Systems Magazine, Mainframe - November/December 2015 - IBM Systems Magazine, Mainframe - November/December 2015
IBM Systems Magazine, Mainframe - November/December 2015 - Cover2
IBM Systems Magazine, Mainframe - November/December 2015 - 1
IBM Systems Magazine, Mainframe - November/December 2015 - Table of Contents
IBM Systems Magazine, Mainframe - November/December 2015 - 3
IBM Systems Magazine, Mainframe - November/December 2015 - 4
IBM Systems Magazine, Mainframe - November/December 2015 - IBM Perspective: Opening new options for real-time analytics
IBM Systems Magazine, Mainframe - November/December 2015 - Editor's Desk: Predictive analytics enhances purchases
IBM Systems Magazine, Mainframe - November/December 2015 - 7
IBM Systems Magazine, Mainframe - November/December 2015 - Infographic: Breaking down the mainframe skills gap
IBM Systems Magazine, Mainframe - November/December 2015 - Partner PoV: IBM z Systems clients must manage existing and emerging assets together to get the most value
IBM Systems Magazine, Mainframe - November/December 2015 - 10
IBM Systems Magazine, Mainframe - November/December 2015 - Focus on Storage: The IBM Spectrum Storage family of software-defined solutions simplifies storage management
IBM Systems Magazine, Mainframe - November/December 2015 - 12
IBM Systems Magazine, Mainframe - November/December 2015 - 13
IBM Systems Magazine, Mainframe - November/December 2015 - 14
IBM Systems Magazine, Mainframe - November/December 2015 - Currents: Architect real-time analytics into operational systems for competitive advantage
IBM Systems Magazine, Mainframe - November/December 2015 - 16
IBM Systems Magazine, Mainframe - November/December 2015 - 17
IBM Systems Magazine, Mainframe - November/December 2015 - Cover Story: Dynamic Spark: IBM brings the Apache project's analytics power to Linux and z Systems servers
IBM Systems Magazine, Mainframe - November/December 2015 - 19
IBM Systems Magazine, Mainframe - November/December 2015 - 20
IBM Systems Magazine, Mainframe - November/December 2015 - 21
IBM Systems Magazine, Mainframe - November/December 2015 - 22
IBM Systems Magazine, Mainframe - November/December 2015 - 23
IBM Systems Magazine, Mainframe - November/December 2015 - Feature: Personal Shopper: Retailer optimizes analytics to drive a more customized client experience
IBM Systems Magazine, Mainframe - November/December 2015 - 25
IBM Systems Magazine, Mainframe - November/December 2015 - 26
IBM Systems Magazine, Mainframe - November/December 2015 - 27
IBM Systems Magazine, Mainframe - November/December 2015 - 28
IBM Systems Magazine, Mainframe - November/December 2015 - Tech Showcase: In a roundtable, distributors discuss how IBM LinuxONE enables flexibility for users
IBM Systems Magazine, Mainframe - November/December 2015 - 30
IBM Systems Magazine, Mainframe - November/December 2015 - 31
IBM Systems Magazine, Mainframe - November/December 2015 - 32
IBM Systems Magazine, Mainframe - November/December 2015 - 33
IBM Systems Magazine, Mainframe - November/December 2015 - Tech Corner: Runtime Diagnostics and Predictive Failure Analysis V2.2 improve z/OS availability
IBM Systems Magazine, Mainframe - November/December 2015 - 35
IBM Systems Magazine, Mainframe - November/December 2015 - 36
IBM Systems Magazine, Mainframe - November/December 2015 - 37
IBM Systems Magazine, Mainframe - November/December 2015 - Solutions: Strobe 5.2
IBM Systems Magazine, Mainframe - November/December 2015 - 39
IBM Systems Magazine, Mainframe - November/December 2015 - Stop Run: IBMer volunteers time to educate people about malaria and technology
IBM Systems Magazine, Mainframe - November/December 2015 - Cover3
IBM Systems Magazine, Mainframe - November/December 2015 - Cover4
IBM Systems Magazine, Mainframe - November/December 2015 - RF1
IBM Systems Magazine, Mainframe - November/December 2015 - SE1
IBM Systems Magazine, Mainframe - November/December 2015 - SE2
IBM Systems Magazine, Mainframe - November/December 2015 - SE3
IBM Systems Magazine, Mainframe - November/December 2015 - SE4
IBM Systems Magazine, Mainframe - November/December 2015 - SE5
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20200910
http://www.ibmsystemsmagmainframedigital.com/mspcomm/ibmsystemsmag/ibmsystems_mainframe_20200708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20200102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2020mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
https://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
https://www.nxtbookmedia.com