POUG 2020

11th-12th September, Warszawa

Agenda



8:00-9:00
Registrationrozwiń opis

9:00-9:15
Openingrozwiń opis

9:15-10:00
Francesco Tisiot & Brendan Tierney: Predicting Good Wines in the Database with Oracle Machine Learning!rozwiń opis
Oracle Machine Learning includes a set of tools enabling data scientist to create production ready Machine Learning models close to where the data sits: the database! The presentation and demo shows a full data science process: from the creation of an Autonomous Data Warehouse in the cloud in few clicks, the data upload, the creation of a deeply customisable Machine Learning model via notebooks available immediately with ADW which enable also the the visual data exploration. Few PL/SQL calls will create the ML model which will then be used to create predictions on the fly. The model itself and the results generated will be visualised in Oracle Analytics Cloud showing how easy is the Business Analyst - Data Scientist collaboration within the Oracle ecosystem. So, sit back, grab a glass and learn some practical and fun Oracle tech tips.

10:10-10:55
Oracle on Azure - practical experience - Zespół Oracle, Advatechrozwiń opis
Running Oracle database in Microsoft's cloud environment? This might sound weird at first - but it happens already.
During the session, we will share our experience gained from the projects we did recently. What works well, what needs to be avoided, and what Azure has to offer which Oracle database can benefit from.

11:05-11:50
Ludovico Caldara: Oracle Drivers configuration for High Availability, is it a developer's job?rozwiń opis
UCP, GridLink, TAF, AC, TAC, FAN… The configuration of Oracle Drivers for application high availability is not an easy job. The developers often care about the minimal working configuration, while the DBAs are busy with the operations. In this session I will try to demystify application server’s connectivity to the database and give a direction toward the highest availability, using Real Application Clusters and new Oracle features like TAC and CMAN TDM.

12:00-12:45
Flora Barrielle: One revoke a day keeps the Security Officer away : Make the resolution to reinforce privilege management ... and stick to it!rozwiń opis
Implementing the principle of least privilege on a brand new system is a must-do for a DBA. But what about a system that has been live for more than 10 years? Privilege management is usually a mess and nobody wants to take the risk to change something. How can you take advantage of new (and not so new) Oracle Database features to implement the Principle of Least Privilege and reinforce your database security? Moreover, how can you secure a healthy privilege management for the long term? In this presentation, I will introduce benefits, practical examples and demos of different solutions like Privilege Analysis (now available in Oracle Database Enterprise Edition), Unified Auditing or Schema-Only Accounts to show how they can help you stick to your good security resolutions.

12:45-13:45
Obiadrozwiń opis

13:45-14:30
Rodrigo Mufalani: Shell script for DBA and developersrozwiń opis
As a DBA, very often we need either maintain shell scripts written long time ago or create new ones for automate routines like backups, duplicates, batch jobs and other routines to get standards. So, I plan to introduce shell scripts on attendees lives and get them power to write their code in bash shell script language.

14:40-15:25
Patrick Barel: A Collection's a Collection, no matter how smallrozwiń opis
“Oracle Database provides us with collection since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude. This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.”

15:35-16:20
Erik van Roon: Handling errors during bulk DML operationsrozwiń opis
In every data oriented application questions about the data need to be answered and for that we have SQL.
But as the questions being asked get more sophisticated answering them gets more difficult.
Not really because the questions are absurd, but because we struggle letting the SQL engine know what exactly it is we are looking for.
We've had analytic functions for quite a while now to answer those questions about data in relation to other data in the same result set
But even then a lot of data questions lead to very complex queries or even to an escape into PLSQL.

No more, because we now have pattern matching, or "the match_recognize" clause.
But, I hear you say, match_recognize is complex too.
Well, yes and no. It's mainly complex because it's different than anything you're used to.
But if you take a little time to get a feeling for the concepts of the feature It isn't more complex than many SQL features you already master.

This session will take you by the hand and lead you through the first daunting steps of pattern matching.
After this you should have that feeling of what it is, how it works and what kind of problems you can solve with it, so you can start playing with it and soon be comfortable using it in your work.

16:30-17:15
Adam Kierzkowski: Fancy charts and dashboards - customizing Oracle Jet in APEXrozwiń opis
It’s been a while since Jet Charts were firstly introduced in APEX 5.1. Without any doubts it’s a great and highly customized tool, but how much friendly and intuitive it is for the APEX developer who’s just about to create his first chart?

From that developer’s point of view, the most attractive way of customization Jet Charts are declarative options exposed in application builder. Firstly I will go through the most interesting of them to be more aware of plenitude things we can do, but also that what we think we can, and it’s not that simple in a closer look. From time to time it turns out that APEX and Jet Charts are not such a perfect marriage as they were meant to be. Let’s focus on the examples that can get you stuck, especially when a brief documentation isn’t helping.

Advanced chart customization using JavaScript can be even more confusing. What do we really need to know about Jet? How to refer to the chart widget? Where is the best place to write our code? There’s not many resources on the Internet related, so basing on my experience gained by trial and error learning, I will try to answer those questions.

17:25-18:10
rozwiń opis

Koniec

9:00-9:45
Gianni Ceresa: Easy ML in Oracle Database: how good is it compared to hand-made code?rozwiń opis
The Oracle Database is more than “just” a database. One of the many extra things is Machine Learning capabilities, avoiding users to export data, which can be a security concern, and having to learn various other languages like Python or R. The database comes with some packages enabling ML algorithms, easily accessible by the same unique language as everything else in the database: SQL. It’s really easy to get started and setup, train and use a ML model in the database. Almost as easy a “next, next, done” approach. When something is as simple as that, you often trade complexity with accuracy: it’s simple and therefore less accurate. A not accurate ML model isn’t very useful as the target is the best accuracy ever for predictions and classifications.

This talk takes a unique dataset and performs ML tasks with Python (and a notebook) and in the database. The target is to compare the complexity of both approaches and the achieved accuracy, proving (or not) if ML in the database is really something worth looking at, without having to learn Python or something else.

A “live” demo will be used to show the simplicity of one solution compared to the other, as well as the accuracy.

9:55-10:40
Kim Berg Hansen: OK Oracle, Tell Me *Approximately* How Many Unique Visitors We Had Last Weekrozwiń opis
Imagine doing a SELECT and the answer coming back is “approximately 42, give or take a little.” Normally you wouldn’t want that to happen, you expect a SELECT to give you an accurate answer every time. But building a sales dashboard for your boss, for instance, could be a choice between showing him “we had approximately 4200 unique visitors from France last week” in a quarter of a second, versus showing him “we had exactly 4189 unique visitors from France last week” in 5 seconds. Most likely your boss would be happier with a fast but “good enough” answer.

Oracle supports several Approximate Query Processing Functions, starting with APPROX_COUNT_DISTINCT in version 12.1, adding APPROX_MEDIAN and APPROX_PERCENTILE as well as the capability of doing approximate aggregations on multiple levels in version 12.2, followed by APPROX_RANK, APPROX_COUNT and APPROX_SUM in version 18.1. These functions allow you to write SQL that gets approximate, but fast, answers.

But what if you already have a dashboard application built using good old trusted SQL giving accurate answers, but it is really slightly unsatisfactory as each click takes several seconds to complete? Then you can do a FAST=TRUE - if you are prepared to accept approximate answers. You can do an ALTER SESSION that enables the optimizer to rewrite for example your COUNT(DISTINCT column) to an APPROX_COUNT_DISTINCT(column) automatically. Then your application will give approximate, but fast, answers without needing change.

This presentation discusses the different approximate functions, the approximate aggregations and the ALTER SESSION method of speeding the queries - showing examples of syntax and use cases.

10:50-11:35
Julian Dontcheff-Oracle 20c new features for DBAs” rozwiń opis
I will cover most of new features of Oracle Database 20c

11:45-12:30
Piet de Visser:Partitioning - Pitfalls and Positives.rozwiń opis
Partitioning will notably help you to store and “manage” large tables of facts or items. I expect Partitioning to be or to become an effective tool to store very large, and often volatile sets of data in a “relational” database and I will point out some obvious use-cases.

After the presentation, the attendee will be prepared to use Partitioning, will understand some of the mistakes from the past, will be able to make better design-decisions for large tables, and is better able to achieve success.

12:30-13:30
Obiadrozwiń opis

13:30-14:15
Franck Pachot: 19 Features You Will Miss If You Leave Oracle Database rozwiń opis
Today, the choice of the database technology is in the hands of the developers, and Open Source alternatives look appealing. Many talks and papers show the growing features of MySQL or PostgreSQL, which compete with the commercial RDBMS. But do not forget the core features that are there for decades. They may not be there, or less efficient, in those alternative solutions. This presentation shows those basic features, with demos: in-place updates, cursor sharing, guaranteed disk writes, advanced materialized views, IOT, wait events, online operations, etc. Many were already in Oracle 30 years ago and users take them for granted. You may not realize what you will miss when going to another RDBMS.

14:25-15:10
Hans-Jürgen Schönig: Moving from Oracle to PostgreSQLrozwiń opis
More and more companies and organizations migrate from Oracle, Informix, IBM DB2, MS SQL, EDB, Maria DB or MySQL to PostgreSQL. The reasons for this are multiple: On the one hand, there are many companies that refuse to pay high license fees, which are common for commercial closed source providers. On the other hand, there are more and more companies that migrate to PostgreSQL for technical reasons.
PostgreSQL is the most advanced open source database system on the market and has been firmly established for many years – it has been voted Database System of the Year several times. PostgreSQL is highly reliable, stable, scalable and secure, developed by a large global community.

During this talk you will learn more about all the aspects of moving from Oracle to PostgreSQL.

15:20-16:05
Sabine Heimsath: Quick Start: utPLSQL rozwiń opis
Java people have been using unit tests for ages; PL/SQL people … not necessarily. We used dbUnit tests (maybe not in the intended way), which helped us a little, but code quality still left room for improvement. So something had to happen. Thanks to the great open source community we didn’t have to look far: The new version of utPLSQL has been around for a while, and it finally reached our project last year.

Learn about - the easy installation - the obstacles we had to overcome - the first steps and errors we made - where we found support and - how utPLSQL helped us to become proper PL/SQL unit testers!

16:15-17:00
Christian Berg & Mike Dietrich: Death Metal, Beer and Analyticsrozwiń opis
Using bulk operations to do dml from plsql is a lot faster than processing row by row.
However, during bulk dml some or all records may not be successfully created, modified or deleted.
This presentation will be about some of the pitfalls in handling these errors using "save exception" and its alternative "log errors".
Why is error_index a misleading name for that column in sql%bulk_exceptions? And how do you overcome the implications?
What if a record fails halfway through multiple consecutive bulk operations on relationally dependent tables?
Can log_errors be used as an alternative to using "save exceptions"?
You will be given the answers to these and more questions and gain a better understanding of how to deal with errors in bulk operations.

17:10-17:55
Niall Mc Phillips: Oracle Text - A Powerful Tool for Developersrozwiń opis
Oracle Text is included with every edition of the Oracle database - even the free Express Edition (XE). Many APEX applications can benefit from adding its powerful search capabilities. This presentation will explain how to quickly add powerful text searching capabilities to your APEX and PL/SQL applications.

We’ll look at: - Strategies for gathering and indexing textual data to be searched - Indexing of BLOBs containing PDFs or Word documents - Indexing of structured documents such as XML or JSON - Searching your data using the Oracle Text syntax - Different search types such as word, phrase, stem, etc. - Searching within tags - Google-like highlighting of snippets in search results

18:05-18:50
Roel Hartman - The Wizard of ORDSrozwiń opis
ORDS, the Oracle Rest Data Services, has evolved from just a supporting component of Oracle Application Express to the de facto standard tool for delivering RESTful API services for the Oracle database. In this session we will cover - what is Oracle Rest Data Services
- set up Oracle Rest Data Services to talk to your database - use Oracle Rest Data Services to get data of all sorts in and out of your database - create documentation for your API’s - secure the calls through Oracle Rest Data Services

In the end it will be clear, it is not magic. It is the best way to get even more value out of your Oracle database!

This presentation will cover all the necessary steps to open up the information in your database to the outside world - of course in a secure way. ORDS nowadays is so sophisticated that most steps are extremely easy to do. It almost looks like magic! There will be demo’s using SQL, PL/SQL and JavaScript.

Koniec

What are you paying for?

On-site ticket:

  • 20 sessions
  • Access to recordings and presentations
  • 2 days of lunches and coffe breaks
  • Unlimited beer!
  • A chance to win individual consultations with the speaker of your choice
  • 1-day long exlusive webinar with Oracle ACE Director Kamil Stawiarski
  • Evening integration

Online ticket:

  • Live streaming & Access to recordings and presentations

Lecturers


Jak dojechać


Indigo Hotel

Website

After party


POUG Partnership

POUG is not only the official Oracle community – first of all it is the base of very active members, who are engaged in the group development both during the meetings and the preparations to them. Our message gets to the 400 people connected with databases – from the developers to the administrators and from the begginers to the experts with years of experience.

We would like to invite you to be a part of our event – it is a chance to show your brand during and before the meeting. What does it mean?