Sessioni

  Database | 45min |

How I Stopped Upgrading at Nights and Weekends, and Became More Relaxed and Productive

Do you shut your Oracle-based system down for application upgrades?

Do you upgrade only at nights and weekends (when you are tired and angry) for minimizing downtime?

I don’t, for more than 10 years now, because I use Edition-Based Redefinition (EBR). Join this session and learn from my experience.

EBR is a powerful feature of Oracle (added in version 11.2), that enables application upgrades with zero downtime, while the application is actively used and operational. I have been using it on a daily basis for many years now, in a production site that requires frequent application upgrades with very limited downtime, and find it very useful and fascinating.

Join this session to learn how to use EBR, see many live examples, and get tips from real-life experience in a production site using EBR extensively.

Database | 45min |

A Deep Dive View to the Performance of Views

“Don’t use views in Oracle! They are terribly slow and cause a lot of performance issues.” – That was the recommendation of a former colleague when I started working with Oracle databases in 1994. It wasn’t just due to my colleague’s (and my!) ignorance that he gave me this advice. Back then, with Oracle version 7, there were still many limitations and problems with views.

Fortunately, those days are gone. With Oracle versions 8i to 23ai, many improvements, transformations and new features were added to the Oracle optimizer. Thanks to “Predicate Pushing”, “Complex View Merging” and “Join Elimination”, many typical performance problems with views are now solved automatically. Subsumptions of views – the newest extension in 23ai – allows even to combine multiple views into one.

However, it is still important to understand how views work and how the Optimizer deals with them. With the appropriate knowledge, it is now much easier to develop efficient views.

APEX | 45min |

Getting Started with GenDev in APEX

Oracle APEX 24.2 unlocks new capabilities for Generative Development (GenDev), including retrieval-augmented generation (RAG) data sources, creating custom data models with natural language in SQL Workshop, a new dynamic action to generate text with AI and more. All of these capabilities make it easy to build intelligent applications that respond with precision and relevance. In this session, you will learn all the basic concepts and steps you need to follow to make the most of GenDev and APEX.

Database| 45min |

How Far is the Nearest Pizzeria? Let’s See What the Database Says

In the past, working with location data in the Oracle Database required a certain amount of expertise. With the release of Spatial Studio, this has changed. Loading geospatial data, enriching it, creating cartographic maps, or developing analytic workflows has since become very easy, even for non-experts.
In this talk, we want to explore how Spatial Studio can help developers and data engineers. We will demonstrate a typical workflow, starting with how to prepare data by converting the addresses of pizzerias and restaurants to geographic coordinates. As a next step, we will combine the output with data from various other sources for location-based analysis, render the results on a map in different ways, and then publish them for consumption by other applications. While we will briefly describe the architecture of the underlying platform and explain the database features enabling this kind of analysis, this presentation focuses on the practical demonstration of the tool.

Analytics | 45min |

WebRadar: AI-powered Competitor Analysis & Automated Web Scraping

Monitor your competitors and always stay one step ahead with WebRadar, the AI-driven solution for automated competitor insights. Thanks to its multi-agent architecture, WebRadar continuously scans the web, extracting and analyzing key data on pricing strategies, new product launches, and marketing initiatives. By leveraging advanced web scraping, crawling, and Generative AI, it adapts dynamically to new competitor websites and evolving market trends. With automated reports and a conversational AI interface, your marketing team gains instant access to structured, actionable intelligence—eliminating manual research and enabling data-driven decision-making.

Database | 45min |

Prepare for the Worst with Flashback

Have you, as a DBA, ever been called up by someone who needed your help after accidentally deleting the wrong data? Or perhaps dropped a table in production instead of the test environment? If you are a developer, perhaps you have struggled to determine why your data are not as expected, despite rigorous debugging? If you are the test leader, perhaps you are looking to accelerate testing because database restoration consumes too much time after each round? Or perhaps you are the CIO, concerned about compliance regarding change tracking, auditing, and archiving of security-sensitive data?

All these scenarios can be addressed and resolved with variations of Flashback technology in the Oracle database. Join this presentation to learn how to prepare for disasters and recover from them without the stress these situations typically cause.

Database | 45min |

Zero Data Loss Architectures. Empty Promises?

Replication, geo-distribution, latency, locking, consistency, quorum, consensus, network partitioning, failover. When taken individually, these are all words we hear and understand, but how do they interact together, if they interact at all?
What are the challenges and trade-offs when trying to achieve a zero data loss strategy for our application’s persistent layers? How do different high-available database solutions compare when it comes to transaction durability?
To what should we pay attention? This very high-level session overviews these interactions and the challenges we must take when designing an architecture that requires no data loss regardless of the failure type.

Database | 45min |

Scripting in SQLcl – You Can Never Have Enough of a Good Thing

So, you’ve been introduced to SQLcl, and because it’s such an awesome tool with so many incredible features, it has now become your preferred command line utility for talking to the database. I completely understand. But, unfortunately, there is this functionality that is not included that would really make your life so much easier. Or maybe some functionality that is included is implemented in a way that is not useful enough for you. Despite enhancement requests, your idea just doesn’t get implemented in SQLcl (soon enough).

What can you do? Wait? Complain? Tell everybody the tool stinks? Yes, you can do that, but it will not solve anything. There is a better solution. SQLcl allows you to script your own functionality using JavaScript and Java, and even include it as your own custom commands.

This talk will introduce you to what it takes to include your own custom functionality in SQLcl found nowhere else (unless you share it with other SQLcl users of course). You will learn what it takes to create and execute scripts and how to register and unregister them as custom commands. We will also go through a real script beyond simple hello-world code to see what it does and how.

Analytics | 45min |

Boost Oracle Analytics with Generative AI and Human Intelligence

So, you’ve made a significant investment in Oracle Analytics and implemented the ultimate semantic model for your business. Yet, your users are still grappling with logical SQL and trying to get that crucial calculation included in their reports? This session explores the application of Generative AI, and human intelligence within Oracle Analytics, enabling users to ask questions about their business in plain language and receive precise, (meta)data-driven answers.

APEX| 45 min |

APEX, ORDS and JRDV – The Three Amigos

Oracle Database 23ai introduced JRDV: JSON -Relational Duality Views. This ground-breaking functionality give you the flexibiilty of JSON documents as well as all the advantages of the relational model.

A customer uses one centralised APEX Monitoring application to keep an eye on multiple satellite installations of APEX applications for different customers. Runtime data of these APEX applications are sent from the satellites to the Monitoring application using PL/SQL functions to code and decode the data and ORDS as the bridge in between.

Taking this real life project as a starting point we will demonstrate how the use of JSON-Relation Duality Views can have a huge impact on the complexity – and therefore maintainability – of the codebase.

Database | 45min |

Using OCI Vision to Find and Track Objects in Images and Videos

Object detection is widely used in video surveillance, security monitoring, and other similar scenarios. This presentation and demonstration will take you on a journey of how you can use OCI AI Vision services to identify and find objects in Images/Photos and Videos. These demonstrations will include identifying well-known people and how you can build a home security video surveillance application.