Book description
Regarding online transaction processing (OLTP) workloads, IBM® z Systems™ platform, with IBM DB2®, data sharing, Workload Manager (WLM), geoplex, and other high-end features, is the widely acknowledged leader. Most customers now integrate business analytics with OLTP by running, for example, scoring functions from transactional context for real-time analytics or by applying machine-learning algorithms on enterprise data that is kept on the mainframe. As a result, IBM adds investment so clients can keep the complete lifecycle for data analysis, modeling, and scoring on z Systems control in a cost-efficient way, keeping the qualities of services in availability, security, reliability that z Systems solutions offer. Because of the changed architecture and tighter integration, IBM has shown, in a customer proof-of-concept, that a particular client was able to achieve an orders-of-magnitude improvement in performance, allowing that client’s data scientist to investigate the data in a more interactive process.
Open technologies, such as Predictive Model Markup Language (PMML) can help customers update single components instead of being forced to replace everything at once. As a result, you have the possibility to combine your preferred tool for model generation (such as SAS Enterprise Miner or IBM SPSS® Modeler) with a different technology for model scoring (such as Zementis, a company focused on PMML scoring). IBM SPSS Modeler is a leading data mining workbench that can apply various algorithms in data preparation, cleansing, statistics, visualization, machine learning, and predictive analytics. It has over 20 years of experience and continued development, and is integrated with z Systems. With IBM DB2 Analytics Accelerator 5.1 and SPSS Modeler 17.1, the possibility exists to do the complete predictive model creation including data transformation within DB2 Analytics Accelerator. So, instead of moving the data to a distributed environment, algorithms can be pushed to the data, using cost-efficient DB2 Accelerator for the required resource-intensive operations.
This IBM Redbooks® publication explains the overall z Systems architecture, how the components can be installed and customized, how the new IBM DB2 Analytics Accelerator loader can help efficient data loading for z Systems data and external data, how in-database transformation, in-database modeling, and in-transactional real-time scoring can be used, and what other related technologies are available.
This book is intended for technical specialists and architects, and data scientists who want to use the technology on the z Systems platform. Most of the technologies described in this book require IBM DB2 for z/OS®. For acceleration of the data investigation, data transformation, and data modeling process, DB2 Analytics Accelerator is required. Most value can be archived if most of the data already resides on z Systems platforms, although adding external data (like from social sources) poses no problem at all.
Table of contents
- Front cover
- Notices
- IBM Redbooks promotions
- Preface
- Chapter 1. Executive overview
-
Chapter 2. Analytics implementation on z Systems platform
- 2.1 Adding analytics to a mainframe data sharing environment
-
2.2 Installation and customization
- 2.2.1 DB2 and DB2 Analytics Accelerator setup and installation
- 2.2.2 Required DB2 privileges for SPSS users
- 2.2.3 SPSS Modeler client
- 2.2.4 SPSS Modeler server
- 2.2.5 Data sources in SPSS
- 2.2.6 AQT_ANALYTICS_DATABASE variable
- 2.2.7 User management in the SPSS Modeler server
- 2.2.8 Installing SPSS Modeler scoring adapter for DB2 z/OS
- 2.3 Real-time analytics lifecycle
- Chapter 3. Data integration using IBM DB2 Analytics Accelerator Loader for z/OS
- Chapter 4. Data transformation
- Chapter 5. Data modeling using SPSS and DB2 Analytics Accelerator
- Chapter 6. Model scoring
- Chapter 7. Acceleration for descriptive analytics: IBM DB2 Analytics Accelerator value with IBM Cognos BI
- Chapter 8. Using R with the IBM DB2 Analytics Accelerator
- Appendix A. ODBC connectivity between SPSS Modeler and DB2 for z/OS
- Appendix B. Job to install wrapper stored procedures
- Related publications
- Back cover
Product information
- Title: Enabling Real-time Analytics on IBM z Systems Platform
- Author(s):
- Release date: August 2016
- Publisher(s): IBM Redbooks
- ISBN: 9780738441863
You might also like
book
Real-time Fraud Detection Analytics on IBM System z
Payment fraud can be defined as an intentional deception or misrepresentation that is designed to result …
book
Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1
The IBM® DB2® Analytics Accelerator Version 3.1 for IBM z/OS® (simply called Accelerator in this book) …
book
Introducing IBM Z System Recovery Boost
This IBM® Redpaper publication introduces System Recovery Boost (SRB), which is a firmware feature that was …
book
IBM System Storage Solutions Handbook
This IBM® Redbooks® publication provides overviews and pointers for information about the most current IBM System …