Db2 Lecture Sessions

 

Load and Go! Data Movement Options for IBM Db2 in the Cloud

Monday, Mar 19, 2018 | 11:30 AM - 12:10 PM | Breakers H | Session ID: 2136A

What's the most important thing in your database? Data, of course. As you plan to deploy your workloads and databases into the cloud, a major consideration is how you'll get your data there. Simplicity and speed are key. There are many different options available for loading data into the various Db2-based cloud offerings?such as Db2 utilities, External Tables, ETL tools, IBM Cloud Data Connect and the IBM Lift CLI service. This session shares more about these options, including best practices and when to use them. You may also have a need to stage your data in a cloud-based object store like IBM Cloud Object Storage or Amazon S3, so the discussion will include guidance on how to store and retrieve data from there.

View this session online

Speaker

Kelly Schlamb, IBM

The Future of Enterprise Analytics and Data Management

Monday, Mar 19, 2018 | 12:30 PM - 1:10 PM | Breakers H | Session ID: 3619A

Today, businesses need real-time predictive analytics insight derived from transactional data as it flows into the organization. Critical initiatives such as customer interaction, counter-fraud, and risk management require real-time facts. Data latency and movement work in opposition to real-time decisions. This session will discuss IBM technologies like DB2 Analytics Accelerator, Db2 Query Management Facility (QMF) and more that are helping to deliver extraordinary analytics insight in unison with the most current transactional data and new offerings like Machine Learning for z/OS. Learn how IBM is continuing its investment in the Db2 utilities and tools portfolio to answer your needs today?and in the future.

View this session online

Speaker

Udo Hertz, IBM

IBM Db2 Family Data Virtualization Deep Dive

Monday, Mar 19, 2018 | 1:30 PM - 2:10 PM | Breakers H | Session ID: 4680A

Data federation is more essential than ever when it comes to making the most of varied data types and sources. The extended IBM Db2 family of database and data warehouse products provides virtualization capabilities that increase your flexibility across the family and across third-party and open source data repositories. Capabilities such as these are essential when you're facing more and more data sources all the time. We'll begin reviewing this solution by looking at access, security, SQL, monitoring and administration. We?ll also look at the Common SQL Engine and how unified data access is fueled by built-in data federation capabilities. This will include also an overview of IBM Big SQL, which works with Hadoop implementations.

View this session online

Speaker

Michael D. Connor, IBM

IBM Data Replication?Comprehensive, Flexible and Scalable

Monday, Mar 19, 2018 | 1:30 PM - 2:10 PM | Breakers I | Session ID: 5595A

In this session, you will hear about the latest capabilities IBM has to offer around data replication. We will also discuss future plans and the roadmap planned for the months ahead.

View this session online

Speakers

Glenn Steffler, IBM
Karen Durward, IBM

Differentiating in Digital Business with Event-Driven Applications and IBM Db2 Event Store

Monday, Mar 19, 2018 | 2:30 PM - 3:10 PM | Breakers H | Session ID: 3889A

Today you have to keep pace and differentiate by being more responsive to changes and, where possible, predicting the changes before they happen by being in tune with events and interactions happening around you. Event-driven systems allow you to tap into a variety of event data across your business so you can build intelligent IoT and digital business applications that provide in-process analytics, develop intelligent business processes that leverage analytics and machine learning, and achieve real-time business insight to differentiate in the market. IBM Db2 Event Store gives you the platform on which to build these applications, offering the scale, performance and intelligence to be successful.

View this session online

Speakers

Adam Storm, IBM
PHILLIP H. DOWNEY, IBM

A Look Under the Hood (into DB2) to Find Internal Champions and Drive Adoption in IBM Connections

Monday, Mar 19, 2018 | 2:30 PM - 3:10 PM | Surf A | Session ID: 3119A

DB2 data can be leveraged in many situations to gather mission-critical data on key social business applications. With simple processing, you can transform this data, allowing you to gather valuable insights about usage and individual user activity. Learn how you can query DB2 to identify the internal champions of your IBM Connections environment. By running simple queries against Connections, you will be supplied with valuable raw data. This raw data can then be processed in common programs such as Excel, to deliver actionable insights on Connections user activity. The session will wrap up with a discussion on how you can use the stories of internal champions to drive adoption in all Connections communities.

View this session online

Speaker

Alan Forbes, RPR Wyatt

Using IBM Big SQL and Apache Spark to Create a Self-Service Data Lake

Monday, Mar 19, 2018 | 3:30 PM - 4:10 PM | Breakers H | Session ID: 3648A

Landing data in Hadoop typically requires a schema to be defined so that the data can be accessed. This means business users must rely on administrators to first create a table and then grant privileges. But even for the database administrator there are challenges. What format is the data stored in? What are the datatypes? How many columns compose the data? What should be the permissions on the datasets? The integration of Apache Spark and IBM Big SQL allows for users to directly query data without having to define or know the schema of the data and without requiring an administrator. This session shares how to implement this capability, as well how to implement security, auditing, monitoring and workload management of these queries.

View this session online

Development Simplified: Using Db2 for Modern Application Needs with Structured/Unstructured Data

Monday, Mar 19, 2018 | 4:30 PM - 5:10 PM | Breakers H | Session ID: 8290A

Modern apps must leverage data of multiple types and sources. While transactional data is at the core of these applications, integrating unstructured sources in near real-time is also critical. IBM Db2 stores both relational data and unstructured data like JSON in a single database to simplify coding, while meeting the requirements for scalability, availability and accessibility. We will demonstrate sample applications for Node.js/JavaScript, REST/JSON/OData, C#, VisualStudio and IBM Data Science Experience. The session will also show supported languages, IDEs and APIs, and explain how you can virtualize SQL to open source platforms. The session includes Db2 Developer Community?a free, full-featured edition of Db2.

View this session online

Speakers

Simon Lightstone, IBM
Michael D. Connor, IBM

How Mizuho Bank is Developing Its Next Data Lake with IBM Machine Learning

Tuesday, Mar 20, 2018 | 10:30 AM - 11:10 AM | Lagoon K | Session ID: 2448A

To accelerate its digital strategy for business development, Mizuho Bank is expanding its data lake with a digital sandbox called ?BigData lab? to evaluate and develop two new use cases : 1) Analysis of unstructured data (web logs/social data) with IBM Watson Explorer and Db2 Warehouse on Cloud to gain new insights; and 2) Machine learning to enhance the quality and speed of analytical applications. In this session, Mizuho Bank's IT manager summarizes the architecture and shares results of the PoCs, along with the bank's midterm plan for its next data lake with hybrid cloud and machine learning for advanced digital strategy.

View this session online

Speakers

Ikumi Iemura, Mizuho Bank
Shutaro Nonami, IBM
Kewei Wei, IBM
Avijit Chatterjee, IBM
Toshihiko Kubo, IBM

How UK Water Utilities are Solving a 100-Year-Old Leakage Problem with Data Science and IBM

Tuesday, Mar 20, 2018 | 10:30 AM - 11:10 AM | Breakers H | Session ID: 3376A

Learn how to radically improve water leakage detection without capital investment. 30%+ of drinkable water is lost to leaks. UK water utilities are radically transforming leak detection and location using the data they already possess. Smart data science powered by Capgemini on the IBM Watson Data Platform delivers over 80% accuracy in leak detection using existing SCADA data together with IBM Intelligent Operations Center?the foundations of a Smart Water Network. In this session, we will present how we took seven years of historical data to identify the "signature" of a leak and enable operations teams to move from reactive to proactive repair processes; and how we are adapting the model to tackle other business challenges.

View this session online

Speakers

Mark Deighton, Capgemini
Brandon Mackenzie, IBM
Kevin McIntyre, IBM

How to Turn $1 Million in Annual Spend with Oracle into $5 Million-Plus in Savings with IBM Db2

Tuesday, Mar 20, 2018 | 10:30 AM - 11:10 AM | Cloud and Data Campus Small Theater 2 | Session ID: 8856A

Almost every business today is being forced to cut costs in every area of their IT operations, and do so while getting more value from the investments they are making. But what if you learned that IBM offers a product that is easier to use and provides better performance and functionality? Further, that product costs 93% less over five years than you are currently paying Oracle today for support of your Oracle DB and options. A built-in Pl/SQL compiler provides near 100% compatibility, making it fast and virtually risk-free to move applications to Db2 while protecting your DBA's skills.

View this session online

Speakers

Joshua Kim, IBM
Tony Mancini, IBM

Harnessing the Data Tsunami at Marriott

Tuesday, Mar 20, 2018 | 11:30 AM - 12:10 PM | Breakers H | Session ID: 3287A

Marriott is undertaking a quantum leap in the use of data and analytics to transform the guest experience and drive our vision to become the world?s favorite travel company. Marriott is growing rapidly, fueled by acquisitions, organic growth and increased global travel?a perfect storm of torrents of data and real-time analytics. We will describe the challenges in connecting meaningfully with hundreds of millions of consumers across 100-plus countries with different languages, customs, and expectations. We provide insight into our Marriott data platform, including open-source and IBM products such as Db2 Warehouse and IBM Big SQL. We highlight the accomplishments and challenges as we deliver a high-performance, scalable data platform.

View this session online

Speakers

Timothy G. Davis, IBM
Eric Tagliere, Marriott International

Data Told Me the Earth is Flat

Tuesday, Mar 20, 2018 | 11:30 AM - 12:10 PM | Breakers K | Session ID: 7191A

In this provocative talk, Jason will cover common follies in adopting a data-driven culture without appropriate data governance processes.

View this session online

Speaker

Jason Federoff, USAA

Empower Your Business with a Hybrid Cloud Data Architecture

Tuesday, Mar 20, 2018 | 12:30 PM - 1:10 PM | Cloud and Data Campus Large Theater | Session ID: 8104A

Among the best ways to deliver a business advantage are to be more efficient at new application development, and to leverage all your data sources for deeper insights. Success depends on your ability to converge data on the right data architecture for increased responsiveness. We will explain the benefits of a common database and data warehouse strategy so you can land transaction data, then easily analyze or move it without application rewrites. See how AMC Networks has partnered with IBM to build an enterprise hybrid cloud platform for industry-leading insights into audience preferences. Find out how to get your development projects off to a solid start on this flexible hybrid cloud platform that puts data to work for you.

View this session online

Speakers

Thomas Chu, IBM
Matthias Funke, IBM

Empowering SQL Developers and Users with Machine Learning

Tuesday, Mar 20, 2018 | 1:30 PM - 1:50 PM | Cloud and Data Campus Think Tank A | Session ID: 1622A

Organizations may have rich SQL skills yet struggle to find talent that is experienced with emerging technologies like Apache Spark. Apache Spark has become the de facto platform for data science, but requires a specific skill set to operationalize it. Big SQL's Spark integration capability empowers SQL developers and users to use Spark ML models via ANSI-complaint SQL queries. This helps lines of business to self-serve themselves to achieve their business goals by leveraging machine learning.

View this session online

Speaker

VINAYAK AGRAWAL, IBM

Building a Hadoop Environment to Centralize Reporting and Analytics: Insight from Verizon

Tuesday, Mar 20, 2018 | 1:30 PM - 1:50 PM | Cloud and Data Campus Think Tank B | Session ID: 8019A

Let Verizon show you how to build a Hadoop environment from which you can also provide centralized reporting and analytics. This approach will remove the need for data marts, which can result in loss of data and erosion of data quality, not to mention the additional cost to deploy and manage data marts. A centralized, secured Hadoop environment also gives business users access to quality customer insights, expanding its value beyond a narrow group of IT users.

View this session online

Speakers

Pandit J. Prasad, IBM
Randy Torres, Verizon

Avoiding Turbulence on Your Journey to the Cloud

Tuesday, Mar 20, 2018 | 1:30 PM - 1:50 PM | Cloud and Data Campus Think Tank D | Session ID: 2794A

From service location to data transfer to optimizing application design to security... Based on experience designing and reviewing hundreds of digital transformation solutions, this session will show you how you can avoid the most common, and sometimes most painful, bumps on the road to the cloud.

View this session online

Speaker

DWAINE SNOW, IBM

Advanced Analytics for the World's Most Valuable Data

Tuesday, Mar 20, 2018 | 1:30 PM - 2:10 PM | Cloud and Data Campus Small Theater 2 | Session ID: 3632A

Information is at your core and you manage the most valuable asset in your company. However, aligning your analytics approach with your business strategy and expanding from analytics describing the past to analytics that improve the future isn't always straightforward. It is imperative that you incorporate the most current, actionable enterprise data within your analytics initiatives. Building on this data foundation will be essential to get to the next level of analytics advantage and augmented intelligence?which can facilitate the ability to optimize business decisions, increase wallet share and maximize customer satisfaction.

View this session online

Speaker

Steve Astorino, IBM

Avoiding Turbulence on Your Journey to the Cloud

Tuesday, Mar 20, 2018 | 2:00 PM - 2:20 PM | Cloud and Data Campus Think Tank D | Session ID: 2794B

From service location to data transfer to optimizing application design to security... Based on experience designing and reviewing hundreds of digital transformation solutions, this session will show you how you can avoid the most common, and sometimes most painful, bumps on the road to the cloud.

View this session online

Speaker

DWAINE SNOW, IBM

Empowering SQL Developers and Users with Machine Learning

Tuesday, Mar 20, 2018 | 2:00 PM - 2:20 PM | Cloud and Data Campus Think Tank A | Session ID: 1622B

Organizations may have rich SQL skills yet struggle to find talent that is experienced with emerging technologies like Apache Spark. Apache Spark has become the de facto platform for data science, but requires a specific skill set to operationalize it. Big SQL's Spark integration capability empowers SQL developers and users to use Spark ML models via ANSI-complaint SQL queries. This helps lines of business to self-serve themselves to achieve their business goals by leveraging machine learning.

View this session online

Speaker

VINAYAK AGRAWAL, IBM

Building a Hadoop Environment to Centralize Reporting and Analytics: Insight from Verizon

Tuesday, Mar 20, 2018 | 2:00 PM - 2:20 PM | Cloud and Data Campus Think Tank B | Session ID: 8019B

Let Verizon show you how to build a Hadoop environment from which you can also provide centralized reporting and analytics. This approach will remove the need for data marts, which can result in loss of data and erosion of data quality, not to mention the additional cost to deploy and manage data marts. A centralized, secured Hadoop environment also gives business users access to quality customer insights, expanding its value beyond a narrow group of IT users.

View this session online

Speakers

Pandit J. Prasad, IBM
Randy Torres, Verizon

How Standard Bank Uses IBM Db2 and SAP for Core Banking to Improve Availability and Scalability

Wednesday, Mar 21, 2018 | 8:30 AM - 9:10 AM | Breakers H | Session ID: 5583A

This presentation covers how Standard Bank of South Africa uses Db2 for z/OS for its SAP core banking environment. Db2 data sharing and IBM z Systems Parallel Sysplex provides the basis for high availability and scalability for the SAP core banking environment. We review some of the key configuration attributes to achieve these goals. We will also describe our experiences with consolidating SAP application servers on Linux on z Systems to achieve improved efficiency and performance.

View this session online

Speakers

Johannes Schuetzner, IBM
Neels Muller, Standard Bank of South Africa

Virtual Db2 Analytics Accelerator Experiences at Citigroup

Wednesday, Mar 21, 2018 | 8:30 AM - 9:10 AM | Cloud and Data Campus Think Tank B | Session ID: 1292A

Citigroup will discuss our experiences in testing virtual IBM Db2 Analytics Accelerator (IDAA) running in a z/Series Secure Service Container LPAR. Citi will also discuss other projects that are evaluating the use of IDAA to decrease batch CPU costs, modernize applications and increase customer value.

View this session online

Speaker

Bob Perih, Citigroup

Meet the Experts: IBM Db2 Migration Planning

Wednesday, Mar 21, 2018 | 8:30 AM - 9:10 AM | Cloud and Data Campus Think Tank D | Session ID: 7193A

We will share lessons learned, surprises and pitfalls, and provide hints and tips for upgrading your Db2 system. We will also address many myths, and provide additional planning information, usage guidelines and positioning on new enhancements. This will help you migrate as fast as possible and safely.

View this session online

Speaker

Tim Willging, Rocket Software, Inc

Master Data Management Success Story at FarEasTone Telecom

Wednesday, Mar 21, 2018 | 10:30 AM - 10:50 AM | Cloud and Data Campus Think Tank D | Session ID: 1944A

FarEasTone Telecom (FET) is one of the top three telecom companies in Taiwan. FET started a master data management (MDM) project in three phases under an IT transformation program from 2014 to 2016, and successfully launched to production in June 2016. FET built up party domain MDM in its mobility line of business, and extended this to customer interaction events, customer transactions in order entry, customer campaign and prospect customer operations. FET will focus on customer data integration in its Internet & Commerce, Fixed Line and ISP lines of business over the next three years.

View this session online

Speaker

Thomas Yang, FarEasTone Telecommunications Co. Ltd.

AMC Networks' Enterprise Hybrid Cloud Solution with Advanced Analytics

Wednesday, Mar 21, 2018 | 10:30 AM - 11:10 AM | Breakers H | Session ID: 3621A

AMC Networks has been at the forefront of television, producing critically acclaimed shows like ?Mad Men? and others. AMC thinks it is essential to uncover insights into audience preferences and viewing patterns to make smarter scheduling and market decisions, yet they face huge data volumes. Partnering with IBM, AMC built an enterprise hybrid cloud platform with industry leading analytics and the new IBM Integrated Analytics System and Db2 Warehouse on Cloud. In this session, AMC shares their story and lessons learned. They also explain how the combination of high-performance analytics, including Data Science Experience and Apache Spark, gives business analysts the ability to conduct intense data investigations with speed and ease.

View this session online

Speakers

Michael Kwok, IBM
Vitaly Tsivin, AMC Networks

Using Data from the Internet of Things to Gain Analytics Insights at CIT Group Inc.

Wednesday, Mar 21, 2018 | 10:30 AM - 11:10 AM | Breakers J | Session ID: 1893A

This session will show how CIT Group uses sensor data on vehicles to gain insights from the Internet of Things. CIT Group is one of North America's largest equipment lessors, with access to thousands of sensors tracking movement and linking cargo to specific vehicles (trains) during routes. Join us to learn more about unlocking the potential of sensor data with IBM SPSS Statistics Subscription, and get hands-on expertise in combining IoT data with other internal data sources to find actionable insights.

View this session online

Speaker

John Hassman, CIT Group

The Need for Speed: 7 Ways to Move Your Data(base) from Ground to Cloud

Wednesday, Mar 21, 2018 | 11:30 AM - 12:10 PM | Cloud and Data Campus Small Theater 2 | Session ID: 1245A

Database services in the cloud are a key building block for many cloud and hybrid cloud solution architectures. dashDB, Db2 on Cloud, and Db2 Hosted are some of the flagship database services on the IBM Cloud platform. However, a recurring challenge for cloud database adoption is fast and secure movement of large data volumes into the cloud. This session presents seven methods for moving data into IBM Cloud database services such as dashDB and Db2 on Cloud. For each of these methods you will learn how to use them, their performance and security characteristics, and the pros and cons?so that you can choose the right approach for your needs.

View this session online

Speaker

Matthias Nicola, IBM

Advance Your Business with New, Event-Driven Microservices and IoT Solutions

Wednesday, Mar 21, 2018 | 1:30 PM - 2:10 PM | Cloud and Data Campus Small Theater 2 | Session ID: 8105A

Next-generation applications like smart energy grids need to ingest and process millions of data elements to find key patterns for taking action. They must process data in real-time, which means you need ways to rapidly ingest and analyze large volumes of data. Yet management of all this data may not be fully considered from the start. Learn best practices for these new applications and understand how to get real-time and/or historical analytics in the right combination to deliver key insights. We will show you how to use the Lightbend development platform together with new IBM data management technology as an end-to-end solution. You'll come away with new application ideas to start advancing your business goals.

View this session online

Speakers

Adam Storm, IBM
PHILLIP H. DOWNEY, IBM

IBM DB2 pureScale on AIX and Power P822/824 Experiences

Wednesday, Mar 21, 2018 | 3:30 PM - 4:10 PM | Breakers H | Session ID: 1025A

A major health services provider has one of the largest DB2 pureScale instances in North America. This client will share the high-level business case, plan, data movement strategy and test plan to identify and overcome performance and stability issues. Data virtualization played a large part in deployment and we will talk about how to identify bottlenecks, SSL performance implications and CF metrics. We will also discuss leveraging physical schema changes and optimizations to overcome DML performance issues.

View this session online

Speakers

VIKRAM S. KHATRI, IBM
Sudip Kundu, Mayo

Empower Your Developers to Write Faster, More Efficient and Scalable Data Apps

Wednesday, Mar 21, 2018 | 4:30 PM - 5:10 PM | Breakers H | Session ID: 2320A

At the Argonne National Laboratory, the DBAs and developers work together to build world-class scientific and engineering supercomputer applications built with Db2. The developers have been using IBM Data Server Manager to optimize their data applications and become more independent and self-sufficient. In this presentation, you will see how they have taken advantage of the browser-based interface to manage database objects, monitor and control their SQL statements and tune and optimize workloads.

View this session online

Speakers

Benjamin Lenard, Argonne National Laboratory
Peter Kohlmann, IBM

Harnessing the Scalability and Availability of IBM Db2 pureScale for Banking: A Customer Use Case

Thursday, Mar 22, 2018 | 8:30 AM - 9:10 AM | Breakers H | Session ID: 5188A

Scalability or Availability? With IBM Db2 pureScale you don't have to choose, as it offers impressive scalability and continuous availability with great utilization of hardware resources. The ability to deliver RPO=0 DR and flexible deployments are only a few of its capabilities. We'll discuss these topics and others as we explore Db2 pureScale architecture and capabilities and deep-dive into how Db2 pureScale on IBM Power Systems was the only solution to meet the production demands of Camara Interbancria de Pagamentos (CIP), one of the most challenging Db2 pureScale implementations with more than 500,000 SQL/s and scaling up, intensive writing, no window for housekeeping nor maintenance stops and completely fault-tolerant in all levels.

View this session online

Speakers

Enzo Cialini, IBM
Marcos Barretto, CIP Brazil

Improving Customer Service in Telecommunications through Hybrid Data Management

Thursday, Mar 22, 2018 | 10:30 AM - 11:10 AM | Breakers H | Session ID: 5426A

We all know that customer service is critical to service provider success. But providing access to all the data that a customer service agent needs continues to be a challenge. This session shares methods and business benefits to correlating network operations center (NOC) alarms with incoming customer service calls. By using data mediation, data warehousing, and data analysis tools, we are able to show relationships between alarm volumes for different geographies or services, and customer service tickets. The NOC can thus be directed to focus on what is affecting customers, and customer service can demonstrate to customers that the source of their problems is understood and work is being done to restore service.

View this session online

Speakers

Anand Thummalapalli, gen-E
Danny Butler, Consolidated Communications

Meet the New IBM Integrated Analytics System?It Makes Data Science Simple and Faster

Thursday, Mar 22, 2018 | 11:30 AM - 12:10 PM | Cloud and Data Campus Small Theater 2 | Session ID: 4866A

The IBM Integrated Analytics System is a cloud-ready, unified data science solution. Data scientists can use the built-in IBM Data Science Experience to develop and drive insights with machine learning analytics that benefit from a performance-optimized, common SQL engine and embedded Apache Spark processing. Business analysts can benefit directly from the data scientist collaboration to deliver optimized business insight and operational analytics for improved decision-making. Join us as we deep-dive into the core capabilities this platform has to offer for your needs.

View this session online

Speaker

Hemant Suri, IBM

From Propeller to Jet Engine: Moving Gaming OLTP Workloads to IBM Db2 pureScale

Thursday, Mar 22, 2018 | 1:30 PM - 2:10 PM | Breakers H | Session ID: 1202A

An increasing proportion of today?s databases are governed by continuous availability and scalability to meet the ever-growing field of competition in the gaming industry. A casino?s survivability lies in its ability to understand the patron?s needs by analyzing a large number of attributes and processing them in a clustered database system to enhance the patron gaming experience. This session illustrates automation of the IBM Db2 pureScale rapid deployment methodology adopted by the second largest contiguous property casino in North America. This approach avoids common failures and shortens deployment time for pureScale clusters to support casino growth with no downtime while migrating legacy data to the newer systems.

View this session online

Speakers

VIKRAM S. KHATRI, IBM
Dharmatej Inaganti, Mohegan Sun