Speakers & Sessions

Database | 45min |

Regular Expressions: Say What?

It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible.

With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.

This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples.

Database | 45min |

Oracle Exadata Cloud at Customer Technical Deep Dive

Oracle Exadata Cloud at Customer continues to attract new customers across the globe and offers a compelling platform for customers that want cloud benefits but can’t move to the public cloud. Oracle Exadata Cloud at Customer uniquely combines the best database technology and Exadata, the most powerful database platform, with the operational simplicity and pay-as-you-grow economics of the cloud in a customer data center. Whether you are an experienced Exadata customer or never used Exadata before, you will benefit from the breadth and depth of this session. Topics covered include deployment, operations, networking, security, backup and recovery, maintenance, and use cases.

Database | 45min |

How to Find Patterns in Your Data with SQL

SQL is a powerful language for accessing data. Using analytic functions, you can gain lots of insights from your data. But there are many problems which are hard or outright impossible to solve using these.

Introduced in 12c, the row pattern matching clause, match_recognize, fills this gap. With this it’s easy to write efficient SQL to answer many previously tricky questions.

This session introduces the match_recognize clause. It will use worked examples to show how it works and show how it’s easier to write and understand than traditional SQL solutions.

This talk is for developers and data analysts that need to do advanced data analysis.

Database | 45min |

SQL Syntax: Oracle vs. ANSI. Fight!

Debates over whether it is better to use Oracle syntax or ANSI in your SQL rage on the internet. It is time to settle these once and for all!

In the blue corner, Alex will champion ANSI style. And in the red corner, Chris will defend Oracle syntax.

In a best-of-three battle, covering joins, functions and recursive queries they will each highlight the benefits of their chosen style.
This session is for developers looking to expand their SQL skills and understand the pros and cons of the syntax methods.

Database | 45min |

Flashback – not JUST for DBAs

Most people think of the Flashback features in Oracle as the “In Case of Emergency” switch, to only be used when something catastrophic has occurred on your database. And yes, it is true that Flashback will definitely help you in those 3 seconds after you press the Commit button and you realise that you probably needed to have a WHERE clause on that “delete all rows from the SALES table” SQL statement. Or for when you run “drop table” on the Production database, when you were just so sure that you were logged onto the Test system. But Flashback is not only for those “Oh No!” moments. It offers much much more in modern application development. It enables benefits for developers ranging from data consistency to continuous integration and data auditing. Tucked away in Enterprise Edition are six independent and powerful technologies that might just save your career but they will also open up a myriad of other benefits of well.

Database | 45min |

Avoid “Horror Queries”: Keep Your SQL Simple and Fast

SQL is a powerful and efficient query language when used correctly. But inefficient and inappropriate SQL statements can cause massive performance problems. Instead of solving such issues with additional indexes, optimizer hints, SQL profiles or SQL plan baselines, a much better and more sustainable solution is often to rewrite the SQL statements and to reduce the complexity of the queries.

During performance tuning tasks for my customers, I’m often confronted with complex SQL statements. Many of these statements were developed years ago and changed several times by people that either had not enough SQL skills or had not the time to understand the original query in detail. This can lead to queries that are not only very slow, but also hard to understand – for the developers as well as for the query optimizer. By transforming these SQL statements into simpler queries, the optimizer can calculate better estimations and generate faster execution plans.

In this presentation, some real-life examples of terrible “horror queries” will be shown and rewritten into simpler, more elegant and faster SQL statements. The goal of the presentation is to show how to improve the performance of a query by factors with appropriate SQL statements and powerful Oracle SQL features.

Database | 45min |

Alternative al public cloud

Come poter sfruttare i vantaggi del cloud computing anche negli scenari in cui non è possibile accedere al cloud pubblico.
Scopriremo come i sistemi ingegnerizzati oracle possono essere utilizzati per il deploy di un cloud privato o ibrido in modalità at customer sia su Exadata per workload esclusivamente database e PCA per workload general purpose.

Database | 45min |

How to identify performance problems of a sql statement

How to identify performance problems of a sql statement:? in this session we will discuss different techniques (ash, awr etc) on how to identify performance problems related to sql statement.

Database | 45min |

MySQL Group Replication in Docker Containers

Would you like to get a clustered environment up and running in a very short time and automate your deployment? What are you waiting for? Attend my session and you will discover how to get a MySQL high available replication topology on Docker.
After a short introduction about some top current trends of our days, such as DevOps, Agility, On-Demand environments and Open Source, we will start talking about what’s Docker and MySQL Group Replication. I will also explain what a database proxy is. Then, with the help of a demo, we will see all the steps to deploy a 3-nodes cluster in containers.

Database, Analytics & Big Data | 10min |

Oracle ACE Program Presentation

Database | 45min |

Zero Downtime Migration: what is it and how to implement it?

Oracle has recently announced Zero Downtime Migration (ZDM), a tool that automates the migration of on-premises databases to the cloud. But how it works and what can it achieve beside moving databases to the cloud?

In the first part of the presentation, the ZDM product manager, Ricardo Gonzalez, will give an overview of the tool and its capabilities for migration to the cloud as well as on-premises.

In the second part, Ludovico Caldara, database engineer at CERN, will show some technical aspects about its configuration and usage.

Database | 45min |

Explain the Explain Plan – Interpreting Execution Plans for SQL Statements

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Database | 45min |

Harnessing The Power Of Optimizer Hints

The goal of the Oracle Optimizer is to examine all possible execution plans for a SQL statement and to pick the one with the lowest cost, which should be the most efficient. From time to time, it may become necessary to influence the plan the Optimizer chooses. The most powerful way to alter the plan chosen is via Optimizer hints. But knowing when and how to use Optimizer hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored.

Database | 45min |

AutoUpgrade – Unattended Hands-Free Database Upgrades to Oracle Database 19c

Database upgrades are no fun for most people. And some customers have hundreds or thousands of databases to upgrade. The new AutoUpgrade tool will automate your database upgrades. This is exactly what most people waited for. A small, lean and simple tool which upgrades your databases – not only to Oracle 19c but also to 18c or 12.2.0.1. Upgrades become an easy task. You can embed it into your scripts – and schedule it overnight. The next morning, the database is upgraded. One config file – that’s it. This talk includes an interactive live demo – and many tips and tricks.

Database | 45min |

Database Stats. Doing It Right, When It’s Harder

Following on from “Doing It Right, The Easy Way”. Oracle Statistics are critical to the optimizer and your system performance, whether on-premises, in the Cloud or Autonomous.
What do you need to consider when tables get big, you have quickly changing data, and other more complex situations.
What can you do with Oracle to make your life easier, and where can it get in the way?

Analytics & Big Data| 45min |

Putting machine learning into production : the good the bad and the ugly

Data Science and Machine Learning are key tools that organisations around the world are using to find hidden patterns in their data. These patterns can give key business insights and financial benefits. When it comes to maximizing the business value there are a number of key technical and business challenges that are limiting this potential success. One key success factor is the ability to take data science and machine learning out of the lab environment and into production use. Developers find it difficult to incorporate the outputs and models from data science and machine learning into applications and building complex IT solutions, particularly when trying to manage concept drift. At the same time the business is facing difficulties with ROI and how these projects operate differently to typical IT projects. This presenting will explore these challenges for IT and Business and will give pointers for how you can maximize the business value of data science and machine learning.

Analytics & Big Data| 45min |

REST enabled Neural Networks in Oracle 18c

Everywhere you look machine learning is being used to provide valuable insights of your customer data, as well as data from other parts of your organisation. The Oracle Data Warehouse Cloud Service and Oracle 18c Database allows you to build real-time predictive machine learning models. These can be build using the Oracle Advanced Analytics option, using the R language or using the new Oracle Machine Learning product. But the real value comes when these machine learning models can be shared throughout the organisation. This presentation will demonstrate how these machine learning models can be build and then shared using RESTful services allowing real-time scoring of data from any of languages used for your production applications.

Analytics & Big Data| 45min |

Buzzword Bingo or Reality? OAC ADW ODA Combined

AI technologies have enabled us to interact with systems and devices in revolutionary ways. Oracle has evolved chatbots into digital assistants (Oracle Digital Assistant) to leverage AI to improve the user experience. Come to this session to learn the basics of these digital assistants, such as intents, utterances, and entities. The presentation looks at the design of a conversation flow, connects Digital Assistant to Oracle Autonomous Data Warehouse and Oracle Analytics Cloud via back-end API, enabling Digital Assistant to execute and embed Analytics Cloud reports or execute and return SQL statements from Autonomous Data Warehouse and Digital Assistant to display dashboards from Analytics Cloud.

Analytics & Big Data| 10min |

I AM SPARTACUS – Making sense of IDCS

Oftentimes the journey to the cloud stems from a yearning for “Cloud removes all issues we used to have”. While cloud solutions do alleviate many tasks and eradicate many issues commonly found with on-premises products, it also adds new pieces to the puzzle which need to be understood in order to fully unlock their potentials and allow customers to realize all of the benefits.

Migrating on-premises OBIEE to Oracle Analytics Cloud is a straightforward enough task. The integration of a central cloud analytics platform with other clouds, on-premises data sources and security mechanisms at the same time, however, is a key factor that’s often neglected or misunderstood. In reality it is one of the most crucial success factors to any initiative.

Success is not about eye candy – it’s about what makes an initiative actually successful as in integral part of the enterprise.

The Oracle Identity Cloud Service IDCS is the unifying platform and methodology which allows you to integrate all the distinct security concepts and technologies playing a part in a modern, heterogeneous and hybrid infrastructure.

This presentation aims to walk through the technical steps needed to configure LDAP, IDCS and OAC.

Analytics & Big Data| 45min |

Challenges and Pitfalls of Data Visualization

“A picture says more than a thousand words”. This sounds like a true statement. While it’s true that it is easier to tell a story with visuals than with words, it makes a huge difference which visual you are using for which story. What is the real story behind a visual. Using the wrong visual to tell a certain story can reduce the benefit of a visual to zero. In this presentation we will go through the Challenges & Pitfalls of Data Visualization.

Analytics & Big Data| 45min |

Is it Corked? Wine Machine Learning Predictions with OAC

What do you know about Machine Learning and Artificial Intelligence? How deep do you need to study before you can actually start implementing it?
Oracle Analytics Cloud democratizes the concept of Data Science: data cleansing, enrichment, model training and evaluation are now tasks that can be performed visually in the tool lowering the barrier of Machine Learning.

This presentation will show a live Machine Learning example with OAC, starting from a Wine Rating Dataset, we will understand the features, enrich them, build a predictive model to score the wine rating and validate it against unseen data, all with a simple GUI and without having to write a single line of code!

Are you ready to see Machine Learning in action? And understand all the steps involved in building and validating a model? Then check out this session!

Analytics & Big Data| 45min |

When Machine Learning meets Graph Databases

Machine Learning is everywhere these days (just after AI), it started as a python and R thing, it joined the Oracle Database after and it’s now available for Oracle Graph Database as well. Let’s go through some examples of how graphs require to slightly adapt data preparation to run Machine Learning algorithms.

Analytics & Big Data| 10min |

Relational DB vs Graph DB: And The Winner Is?

No need to introduce Relational Databases anymore, and even less the power of SQL. But better to not ignore Graph Databases: they are powerful and have some obvious benefits compared to a relational database. Let’s compare the two and the power of their query languages with some practical examples and see which wins!

Analytics & Big Data| 45min |

Making Sense of Location: Tracking, Visualizing & Analyzing Objects in 2D, 3D & 4D

Location information is a common element in many Big Data scenarios, in Smart Cities or in the context of the Internet of Things. This kind of positional data can explicitly be expressed as coordinates if it comes from a GPS sensor or it can be implicitly included in a postal code, a city or a landmark name, occurring in two or three dimensions, potentially even using time as the 4th dimension. For many years, Oracle has been offering technologies to manage, to analyze and to visualize this kind of data. In this session, we will review the basics of database development for geospatial data, both on-premise as well as in the cloud. We will look at tracking and tracing of moving objects, spatial data visualization, as well as more advanced analytics based on road networks. Two customer projects in Germany and Belgium are included to round off the session.

Analytics & Big Data| 10min |

HELP! How can I resolve my Oracle Analytics issues?

There is a vast amount of Oracle Analytics information out there in the wilderness but how do you get to it? How do you access it quickly? How can you keep up to date with this information? How can this information come to you? This 10 minute talk should show you how to get to the information that can assist you in resolving any Oracle Analytics issues that you may encounter.

This is targeted at the Oracle Analytics space but the principles apply across the board.

Analytics & Big Data| 45min |

Time Series Forecasting with R and Analytics

How to deal with time series forecasting with Oracle Analytics and R: how to predict sales for different types of items (continuous, seasonal, new,…) through the implementation of both algorithms already embedded in analytics and custom R scripts in order to see which of them best fits the problem and produces the best results.

JDE| 45min |

Estensioni applicative per Oracle JD Edwards

Come supportare la Digital Transformation attraverso le estensioni interne ed esterne all’ERP Oracle JD Edwards, per sfruttare al meglio le sue potenzialità e ottimizzare, di conseguenza, i processi aziendali.

JDE| 45min |

Presentazione della struttura del gruppo

Presentazione della struttura del gruppo, desiderata e definizione dei primi gruppi di lavoro con relativi referenti.

JDE| 45min |

Soluzioni di Picking Medical Spare Parts grazie a JDE