Sessioni

  Analytics, Database | 45min |

Analytics in 2024 can hurt your database in new, unexpected, ways

Analytics nowadays is different from BI 10 years ago and even more than reporting 20+ years ago. The modern trends have a different impact on your server, and also on the DBA job because users do different things with databases compared to the past. An overview of the impact of the new trends.

AI, Cloud | 45min |

Automatizzare la documentazione di codice legacy con IA Generativa sfruttando i servizi OCI AI Vector Search

Gestire codice legacy spesso rende più difficili le operazioni di manutenzione e aggiunta di nuove funzionalità, portando anche difficoltà nella documentazione dello stesso e trasferimento di conoscenza. La Generative AI (GenAI), attualmente uno degli strumenti più avanzati basati su Intelligenza artificiale, può essere sfruttata in questo contesto grazie alle sue capacità di analisi e comprensione del testo (e codice). L’obiettivo di questo speech è esplorare e fornire degli esempi pratici su come utilizzare i servizi di Oracle GenAI per estrarre documentazione tecnica dal codice, adattabile su diversi livelli di dettaglio. La documentazioni generata poi può essere utilizzata come base di dati facilmente interrogabile sfruttando tecniche che combinano GenAI e Information retreival (es. Retrieval Augmented Generation – RAG), sfruttando i servizi di Oracle AI Vector Search.

AI, Cloud, Database | 45min |

Can the modern Frankenstein pass the Turing test?

RAGs, GAI, LLMs etc are all the rage, but are they any good at answering Database or SQL problems? Would you like to talk to Jonathan Lewis, Tim Hall (oracle-base.com) or other Oracle Experts without actually talking to them? We’ll build and use RAG & LLM using different sources, and explore if it is as good as the Real Thing. In recent times ChatGPT seems to have replaced StackOverflo and Google as sources for answering your Oracle Database questions. ChatGPT is what you can use when you don’t have Jonathan Lewis, Tim Hall or other “well-known experts” at your desk ready to answer your questions. But ChatGPT has proven to be untrustworthy with it giving incorrect answers based on mixed topics and different technologies. It seems to make up answers that sound plausible, and when you try to use it, you realise how good/rubbish it really is. What if you could create a solution to include real knowledge from real experts, and chat with it? A bit like talking to them in person. All it takes is an Oracle Database with the new Vector Search feature, some Cloud AI Services and you are ready to ask your questions. Join us in this journey in building your own JonathanGPT, OracleBaseGPT, or both, and many more all together into your own customer Oracle Database ChatGPT-like solution!

APEX | 45min |

Da forms ad Apex: porting e nuove applicazioni

Database | 45min |

Distributed databases, what to expect

The next trend (hype?) is : Distributed, Clustered, Serveless, Sharded, Replicated, Databases. That is a lot of buzzwords together, and I have omitted “multi-cloud”, “raft”, “ai” and “vector”. We’ll try to find out how various vendors interpret those (buzz)words and how/when these are useful. And We’ll explore what users, administrators and application-programmers can expect when data is stored in a distributed database, including some of the mistakes we made. And then, when your boss tells you to “Use This New Gizmo!”, then maybe you know what to watch out for.

Database | 45min |

Fundamental Oracle Security – What Many Of You Are Not Doing

I tend to work in a few companies each year. Something I have been getting asked more and more, other than “make it faster”, it how to secure the Oracle database – frequently because of a failed audit. In companies and governments, I see; poor auditing, no security consideration, no lockdown of accounts, inadequate processes, and lots of risk. There are some easy and straightforward changes which you can make to your Oracle database which will make it more secure, harder to exploit and, in the unfortunate even of a data breach, give you a chance of noticing what happened! I will talk through the changes you can make and explain why they should be made, and the effort involved.

Database | 45min |

Get me off that F*cking Exadata!

Exadatas are amazing machines. They have some extraordinary capabilities. And they are quite expensive. I mean, really quite expensive. And we need to re-buy them every few years as they age. A client came along one day and asked me “what can we do to cut the bills?” I said “Nothing. Pay the money.” And they said “We don’t want to! Can’t we do something cheaper?”. “erm” “Look, can you get us off those f*cking Exadata machines?” This is a short story explaining if I could.

Database | 45min |

Migrating a TB Database from 11g Windows to 19c Linux in less than an hour

Upgrading a database with plattform migration is always challenging especially if you should hav a very short downtime.There are many ways to do this. In a recent project I used Transportable Tablespace for that. I’ll show how I did this and what could go wrong.There are many ways for updating/migrating a database.This could be datapump/goldengate/autoupgrade and so on.Each of this ways does have some pros and cons.Recently I had to upgrade an >1TB 11gR2 database on Windows to a 19cRU14 database on an ODA.The problem was that the storage and everything on the windows side was very old and slow and we only had a short maintenance window for this action.Finally we decided to use Transportable Tablespace which provides us the possibility to incremental update the new database and have a short downtime during the maintenance window.In this presentation I’ll show you how you can migrate a database with a short downtime and what possibly could go wrong.

Analytics | 45min |

Oracle Analytics Worst Practices

27 years have passed since nQuire came out, became Siebel Analytics, became Oracle Business Intelligence, and is now Oracle Analytics. Let’s spend a fun hour looking at just how bad things are being messed up after almost 3 decades of “know-how”. Is this tongue-in-cheek humour? Absolutely not. Is this blatant honesty and can you learn valuable lessons from other’s failures and mistakes? Most definitely!

ODI | 45 min |

Oracle Data Integrator: soluzioni per l’integrazione e l’armonia del dato all’interno di una organizzazione

Oracle Data Integrator (ODI) è uno strumento per l’integrazione dei dati che punta a ridurre i costi e migliorare l’efficienza aziendale. Utilizzando l’approccio E-LT, offre alte prestazioni, una governance dei dati avanzata e un’interfaccia facile da usare, semplificando la gestione di dati complessi. Supporta molte tecnologie diverse e garantisce sicurezza e scalabilità tramite Oracle Cloud Infrastructure (OCI).
Ma come viene utilizzato nella vita quotidiana? Tramite un caso aziendale concreto, andremo a capire come una avanzata integrazione dei dati da varie fonti, qualità e consistenza del dato, Odi riesca a creare vantaggi competitivi in termini di strategia decisionale efficienza operativa all’interno della vostra organizzazione.

Database | 45min |

Oracle Database 23ai – What’s new

A presentation of some of the new features now available in Oracle Database 23ai. Learn about features like: – Boolean datatype – Group by Alias – Developer role – SQL Domains – JSON Relational Duality Views … and more.. All the scripts shown in these demos will be made available to the audience. The presentation consist mostly of live demos to showcase these features. Some features will just be a short demo, other features might lead to a discussion on whether it is useful or not, or how it can make your life as a developer easier.

Database | 45min |

Oracle SQL Pattern Matching Made Easy

Has Italy ever won the Eurovision Song Contest two or more years in a row? As we’ll see, this can be answered easily using SQL Pattern Matching. A new clause – MATCH_RECOGNIZE – was added to the SELECT statement in Oracle 12c, to allow recognizing patterns in sequences of rows. This new capability is very powerful, and introduces a completely new (yet somewhat intimidating) syntax. It allows solving a variety of problems in a simpler way than before, and with better performance.

Cloud, Database | 45min |

Trasformazione workload Database Oracle da AWS verso OCI in architettura multicloud

In questo intervento verrà presentato il viaggio trasformativo del nostro cliente ENEL, nella sua migrazione strategica dei database Oracle da AWS a Oracle OCI. Il passaggio dei database a OCI ha consentito di massimizzare il potenziale delle funzionalità avanzate di Oracle DBCS, ottimizzando le prestazioni e le funzionalità applicative. Il lavoro congiunto di Technology Reply ed il cliente ha permesso di mettere a punto una strategia di migrazione che riducesse i tempi di downtime per database di oltre 50 TB, alcuni dei quali con Oracle EBS. Particolare attenzione verrà riservata all’illustrazione della tecnica di migrazione utilizzata, all’implementazione di encryption e HA.

AI, Cloud | 45min |

What shapes prices in Airbnb? – OCI Data Science in Action

AI, Database| 45min |

What’s Our Vector, Victor? Navigating AI Vector Searches in Oracle 23ai

Oracle 23ai introduced an exciting new feature with its AI Vector Search capabilities. We’ll start with the essentials — demystifying the concept of AI Vector Search in the Oracle database. What are vectors, and how can they change our approach to search queries? The presentation progresses to discuss real examples of how to prepare and generate your vectors for embedding in your database. It also covers the new search operators and functions introduced with this feature. Moving beyond basics, we will delve into practical applications. Learn how to embed your vectors, transforming raw data into a searchable landscape. We’ll explore the new search operators and functions that Oracle 23ai brings to the table through real-world examples. We’ll take a look at vector distances and measurement methods. Through illustrative examples, understand how similarity searches can be performed using AI Vector Search. Bringing it all together, we will integrate it with PL/SQL and APEX applications, showcasing the incorporation of AI Vector Search into database environments.

Database | 45min |

Write Less (Code) with More (Features)

This session covers many features that were added to the Oracle database in the recent releases, and allow us developers to become more efficient and productive. Some features enhance the SQL language, so SQL statements can become much shorter and more readable than before. Other features offer built-in functionality that previously had to be implemented by the application. Attend this session to learn about the new features, and see many useful examples.