62

Hybrid Transactional/Analytical Processing (HTAP) Workloads on z Systems

Date: 
Friday, 10 April, 2015 - 15:15 - 16:15
Speaker: 
Eberhard Hechler
Content: Delivering HTAP - a single workload-optimized system that integrates operations and business critical analytics into one streamlined system
 
Abstract: This presentation will describe the Hybrid Transactional/Analytical Processing (HTAP) concept that enables the execution of true mixed workloads, meaning high volume business transactions and batch workloads running concurrently with complex queries. HTAP solves the issue of analytical latency in multiple ways, specifically by eliminating the need for multiple copies of the same or modified / aggregated data and the requirement for data to be off-loaded from transactional systems of record to systems of insight. In this presentation, we will describe today's capabilities with the IBM DB2 Analytics Accelerator and future trends.

Real-Time z Analytics

Date: 
Friday, 10 April, 2015 - 14:00 - 15:15
Speaker: 
Eberhard Hechler
Content: IBM DB2 Analytics Accelerator as an enabler for an Operational Data Store (ODS) on z Systems, low-latency replication scenarios, operational analytics for fraud prevention
 
Abstract: Transactional processing has been the primary processing paradigm on z Systems for years. With the IBM DB2 Analytics Accelerator, z Systems and specifically DB2 for z/OS clients can broaden the processing scope to include Analytics - even with low latency. This presentation will introduce the key technical aspects of the Accelerator, and how it can be used for real-time / low latency analytics on z Systems. This includes implementations of Operational Data Stores (ODS) for operational analytics for instance for fraud discovery and prevention. In addition, we will describe the IBM SPSS Modeler Server Scoring Adapter for DB2 on z/OS that embeds scoring algorithms directly into IBM DB2 for z/OS transactional data, which enables the real-time scoring of new transactional data as it is created.

Break

Date: 
Friday, 10 April, 2015 - 13:00 - 14:00

Augmenting z Analytics by leveraging the Hadoop Ecosystem

Date: 
Friday, 10 April, 2015 - 11:45 - 13:00
Speaker: 
Eberhard Hechler
Content: Complementing z Analytics by using Big Data analytics and Natural Language Processing (NLP), integration of BigInsights with z Systems, customer use case scenarios, keeping DB2 for z/OS as control point for enriched z Analytics
 
Abstract: This presentation will illustrate how to complement existing 'traditional' DB2 for z/OS based analytical capabilities with Big Data analytics, e.g. by using text analytics and Natural Language Processing (NLP) as part of IBM InfoSphere BigInsights. This leverages key Hadoop components (MapReduce programming model, HDFS, HBase, Zookeeper, etc.) to analyze data from Enterprise-owned systems of engagement (e.g. call center transcripts, e-mail traffic, Facebook), and data from external social media sites (e.g. Twitter tweeds, Facebook sites, Blogs) and putting this in context with transaction insight from data on IBM z Systems. We will provide examples on how Hadoop systems - by using HBase and Hive with corresponding connectors to existing z Systems – and Big SQL on HDFS and Hive will enrich analytical insight.

Break

Date: 
Friday, 10 April, 2015 - 11:30 - 11:45

Big data / Hadoop for dummies

Date: 
Friday, 10 April, 2015 - 10:15 - 11:30
Speaker: 
Eberhard Hechler
Content: Definition and explanation of Big Data and Hadoop, meaning of Big Data and Hadoop, relevance and value to z Systems customers, specifically DB2 for z/OS, key concepts of Big Data and Hadoop, Apache Hadoop ecosystem with key components and initiatives
 
Abstract: During the past decade, the Apache Hadoop open source community has developed an impressive set of products and tools that represent an important aspect of Big Data. During this introductory presentation, we will explain the term Big Data, its relationship to the Hadoop ecosystem, and corresponding use case scenarios. We will highlight the key Hadoop components, including the latest development of Hadoop 2 with Spark, YARN, and the broad processing paradigms (e.g. batch, interactive, analytics, low latency workloads) that are now possible with Hadoop 2. Most importantly, we will present the business drivers and use cases that have inspired open source innovations, including its value for z Systems clients - specifically DB2 for z/OS clients.

Introdution: SQLAdria team

Date: 
Friday, 10 April, 2015 - 10:00 - 10:15

Planning and Executing a DB2 11 for z/OS Migration & Extending the Log RBA / LRSN

Date: 
Thursday, 9 April, 2015 - 14:30 - 16:30
Speaker: 
Ian Cook
Speaker: 
Paul Fletcher
This session will take the additional 2 hours in total as it covers the complete Migration process, plus the extension of the Log RBA / LRSN. The session objectives are to provide planning information, outline the migration process, share some lessons learned, hints, tips and best practices to help customers plan for, and  execute DB2 11 for z/OS migrations as fast as possible, but safely. The main topics covered are:   
  • Planning, Education and General Preparation 
  • Prerequisite Summary
  • Pre migration planning
  • Incompatibilities, removed & deprecated items
  • Test configurations
  • Regression testing
  • Migration Process Details
  • Migration to Conversion Mode (Running DSNTIJTC)
  • Enable New-Function-Mode (Running DSNTIJEN)
  • Catalog Evolution / Restructure
  • Extending the Log RBA / LRSN

Break

Date: 
Thursday, 9 April, 2015 - 13:30 - 14:30

A Technical Overview of the New Features and Functionality of DB2 11 - Part II

Date: 
Thursday, 9 April, 2015 - 12:00 - 13:30
Speaker: 
Ian Cook
Speaker: 
Paul Fletcher
This session will take around 3 hours in total as it covers a number of topics for Systems Administrators, DBA's and Application Developers. We will also include early customer experiences and best practices for these topics. The topics will include: 
  • Connectivity Enhancements 
  • Data Sharing 
  • Storage Enhancements 
  • Serviceability 
  • SQL Enhancements 
  • Optimization Evolution 
  • Temporal Update and Archive Transparency 
  • Index Enhancements 
  • Security 
  • Advanced Design Options 
  • Utilities
Syndicate content  

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023