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. |
|
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. |
|
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. |
|
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. |
|
Speakers Glenn
Steffler, 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. |
|
Speakers Adam
Storm, 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. |
|
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. |
|
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. |
|
Speakers Simon
Lightstone, 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. |
|
Speakers Ikumi
Iemura, Mizuho Bank |
|
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. |
|
Speakers Mark
Deighton, Capgemini |
|
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. |
|
Speakers Joshua
Kim, 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. |
|
Speakers Timothy
G. Davis, IBM |
|
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. |
|
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. |
|
Speakers Thomas
Chu, 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. |
|
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. |
|
Speakers Pandit
J. Prasad, IBM |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Speakers Pandit
J. Prasad, IBM |
|
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. |
|
Speakers Johannes
Schuetzner, IBM |
|
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. |
|
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. |
|
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. |
|
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. |
|
Speakers Michael
Kwok, IBM |
|
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. |
|
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. |
|
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. |
|
Speakers Adam
Storm, 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. |
|
Speakers VIKRAM
S. KHATRI, IBM |
|
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. |
|
Speakers Benjamin
Lenard, Argonne National Laboratory |
|
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. |
|
Speakers Enzo
Cialini, IBM |
|
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. |
|
Speakers Anand
Thummalapalli, gen-E |
|
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. |
|
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. |
|
Speakers VIKRAM
S. KHATRI, IBM |
|