Accelerating Data Transformation with IBM DB2 Analytics Accelerator for z/OS Accelerating Data Transformation with IBM DB2 Analytics Accelerator for z/OS

Accelerating Data Transformation with IBM DB2 Analytics Accelerator for z/OS

Ute Baumbach and Others

Publisher Description

Transforming data from operational data models to purpose-oriented data structures has been commonplace for the last decades. Data transformations are heavily used in all types of industries to provide information to various users at different levels. Depending on individual needs, the transformed data is stored in various different systems.

Sending operational data to other systems for further processing is then required, and introduces much complexity to an existing information technology (IT) infrastructure. Although maintenance of additional hardware and software is one component, potential inconsistencies and individually managed refresh cycles are others.

For decades, there was no simple and efficient way to perform data transformations on the source system of operational data. With IBM® DB2® Analytics Accelerator, DB2 for z/OS is now in a unique position to complete these transformations in an efficient and well-performing way. DB2 for z/OS completes these while connecting to the same platform as for operational transactions, helping you to minimize your efforts to manage existing IT infrastructure.

Real-time analytics on incoming operational transactions is another demand. Creating a comprehensive scoring model to detect specific patterns inside your data can easily require multiple iterations and multiple hours to complete. By enabling a first set of analytical functionality in DB2 Analytics Accelerator, those dedicated mining algorithms can now be run on an accelerator to efficiently perform these modeling tasks.

Given the speed of query processing on an accelerator, these modeling tasks can now be performed much quicker compared to traditional relational database management systems. This speed enables you to keep your scoring algorithms more up-to-date, and ultimately adapt more quickly to constantly changing customer behaviors.

This IBM Redbooks® publication describes the new table type that is introduced with DB2 Analytics Accelerator V4.1 PTF5 that enables more efficient data transformations. These tables are called accelerator-only tables, and can exist on an accelerator only.

The tables benefit from the accelerator performance characteristics, while maintaining access through existing DB2 for z/OS application programming interfaces (APIs). Additionally, we describe the newly introduced analytical capabilities with DB2 Analytics Accelerator V5.1, putting you in the position to efficiently perform data modeling for online analytical requirements in your DB2 for z/OS environment.

This book is intended for technical decision-makers who want to get a broad understanding about the analytical capabilities and accelerator-only tables of DB2 Analytics Accelerator. In addition, you learn about how these capabilities can be used to accelerate in-database transformations and in-database analytics in various environments and scenarios, including the following scenarios:

Multi-step processing and reporting in IBM DB2 Query Management Facility™, IBM Campaign, or Microstrategy environments
In-database transformations using IBM InfoSphere® DataStage®
Ad hoc data analysis for data scientists
In-database analytics using IBM SPSS® Modeler

GENRE
Computers & Internet
RELEASED
2015
December 11
LANGUAGE
EN
English
LENGTH
216
Pages
PUBLISHER
IBM Redbooks
SELLER
International Business Machines Corp
SIZE
5.2
MB

More Books Like This

Enabling Real-time Analytics on IBM z Systems Platform Enabling Real-time Analytics on IBM z Systems Platform
2016
Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS
2012
Reliability and Performance with IBM DB2 Analytics Accelerator V4.1 Reliability and Performance with IBM DB2 Analytics Accelerator V4.1
2015
Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1 Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1
2013
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
2012
Data Warehousing with the Informix Dynamic Server Data Warehousing with the Informix Dynamic Server
2009

More Books by Ute Baumbach, Patric Becker, Uwe Denneler, Eberhard Hechler, Wolfgang Hengstler, Steffen Knoll, Frank Neumann, Guenter Georg Schoellmann, Khadija Souissi & Timm Zimmermann

IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
2011
IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery IBM Db2 Analytics Accelerator V7 High Availability and Disaster Recovery
2020

Customers Also Bought

Managing Ever-Increasing Amounts of Data with IBM DB2 for z/OS: Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator Managing Ever-Increasing Amounts of Data with IBM DB2 for z/OS: Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator
2015
Enabling Real-time Analytics on IBM z Systems Platform Enabling Real-time Analytics on IBM z Systems Platform
2016
IBM Spectrum Scale: Big Data and Analytics  Solution Brief IBM Spectrum Scale: Big Data and Analytics  Solution Brief
2019
DB2 11 for z/OS Technical Overview DB2 11 for z/OS Technical Overview
2016
IBM Data Engine for Hadoop and Spark IBM Data Engine for Hadoop and Spark
2016
IBM Software Defined Infrastructure for Big Data Analytics Workloads IBM Software Defined Infrastructure for Big Data Analytics Workloads
2015