Javier Estrada Benavides

Speaker Details

Company: 
Broadcom
Bio

Javier has been working with Db2 for 14 years where he's taken several additional roles (RACF admin, Linux Admin, z/OS Admin). He's also the only Mexican IBM Champion since 2018, a member of the IDUG Content Committee, and a member of several Regional User Groups. He also has a curiosity for Data Science and how to combine the Db2 world with new Data Science trends to empower the DBAs.    

Past presentation
27 May 2021
11:45 - 12:45
European SQLAdria Seminar – Virtual Event 2021 Fantastic online nightmares and where to find them
Distributed applications migrating to the Mainframe is a common trend in many places, and their administration requires a different mindset compared to traditional environments as we’re also facing unique scenarios and problems. 
In this presentation, we’ll have a look at some common pitfalls in managing your distributed applications: From planning to important administration actions to take. Luckily, Db2 12 for z/OS also brings additional advantages to our arsenal and we need to revisit how we evolve our DBA practices.
 
Objectives:
The audience will learn about common best practices on how to plan for distributed applications coming to Mainframe (or existing ones).
The audience will learn about new and important features in Db2 12 for z/OS that will help us in managing distributed applications.
The audience will learn about some of the common nightmares (from meetings to technical measures), and how to prevent or deal with them.

10 April 2020
14:00 - 15:15
Db2 and the masters of time
Most of the data we work with is time dependent and we need to go beyond past and present data for better reporting. In this presentation, we'll learn about Time Series Analysis using Python open libraries using Db2 monitor data to explore on common questions we're often required to report.
 
From Db2 daily reports to app performance meetings, most of the data we work with is time sensitive. We're often being asked what's going to happen next and when, and that's when we need to extrapolate from our Db2 data to get insights and go beyond our monitor data. In this presentation, we’ll look into a few Statistical and Machine Learning concepts applied to Time Series Analysis with Python open libraries that can be quickly used to provide meaningful insight in Db2 monitoring. This presentation will also be focused on how the use of techniques like this can bring additional value to the DBA departments.

10 April 2020
11:45 - 13:00
Anomalize this
Anomaly detection is a trendy topic, and it is something that can be quickly explored by ourselves whether it's for your weekly Db2 trends report, monitoring or capacity planning. Db2 12 for z/OS provides a couple built-in functions that can be used for this purpose and for quick Exploratory Data Analysis, enabling people to do more analytical work within their daily roles.
 
On this presentation, we will take a look at several ways to do Anomaly Detection by ourselves and have an overall view of what these alternatives offer, tips and gotchas. We'll begin using pure Db2 SQL and then move to Data Science tools using Python Jupyter Notebooks.

10 April 2020
10:30 - 11:30
From Db2 to Data Science
Managers of DBA departments face a common problem: Trying to find ways to give more value from their departments so that they're not seen as just DBAs.
 
The scope of daily DBA tasks needs to evolve to meet current’s trending topics, attract attention, promote the capabilities of their corresponding back end environments, and maybe integrate key factors that belong to other roles, therefore opening new opportunities. The field of Data Science is such field that invites to further exploration from all fields and roles, and with new possibilities it is compelling to understand it to integrate it into new projects.
 
In this presentation we’ll take some of the most common questions DBAs get around application monitoring and diagnostics, and answer them taking an approach of Data Science and Machine Learning: Ways to begin, viewpoints to consider, and approaches that can prove useful and open new opportunities.

09 April 2020
14:00 - 15:15
Db2 and the masters of time
Most of the data we work with is time dependent and we need to go beyond past and present data for better reporting. In this presentation, we'll learn about Time Series Analysis using Python open libraries using Db2 monitor data to explore on common questions we're often required to report.
 
From Db2 daily reports to app performance meetings, most of the data we work with is time sensitive. We're often being asked what's going to happen next and when, and that's when we need to extrapolate from our Db2 data to get insights and go beyond our monitor data. In this presentation, we’ll look into a few Statistical and Machine Learning concepts applied to Time Series Analysis with Python open libraries that can be quickly used to provide meaningful insight in Db2 monitoring. This presentation will also be focused on how the use of techniques like this can bring additional value to the DBA departments.

09 April 2020
11:45 - 13:00
Anomalize this
Anomaly detection is a trendy topic, and it is something that can be quickly explored by ourselves whether it's for your weekly Db2 trends report, monitoring or capacity planning. Db2 12 for z/OS provides a couple built-in functions that can be used for this purpose and for quick Exploratory Data Analysis, enabling people to do more analytical work within their daily roles.
 
On this presentation, we will take a look at several ways to do Anomaly Detection by ourselves and have an overall view of what these alternatives offer, tips and gotchas. We'll begin using pure Db2 SQL and then move to Data Science tools using Python Jupyter Notebooks.

09 April 2020
10:30 - 11:30
From Db2 to Data Science
Managers of DBA departments face a common problem: Trying to find ways to give more value from their departments so that they're not seen as just DBAs.
 
The scope of daily DBA tasks needs to evolve to meet current’s trending topics, attract attention, promote the capabilities of their corresponding back end environments, and maybe integrate key factors that belong to other roles, therefore opening new opportunities. The field of Data Science is such field that invites to further exploration from all fields and roles, and with new possibilities it is compelling to understand it to integrate it into new projects.
 
In this presentation we’ll take some of the most common questions DBAs get around application monitoring and diagnostics, and answer them taking an approach of Data Science and Machine Learning: Ways to begin, viewpoints to consider, and approaches that can prove useful and open new opportunities.

 

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 2024

VODICE -  10th - 13th June 2024