Oracle Cloud World 2024: Trolls Are No Match for GenAI

Oracle Cloud World 2024 #OCW24 is right around the corner, and I’m humbled and excited to be presenting at my twelfth consecutive annual Oracle Open/Cloud World event. There will be over a thousand sessions on every bit of Oracle technology imaginable. If you’re planning to be in Las Vegas, please be sure to have a look at my sessions and consider attending at least one of them – I promise you will not be bored!

Dawn take you all, and be stone to you! Battling Trolls With Generative AI

The new VECTOR datatype in Oracle 23ai makes implementing Generative AI solutions much simpler than ever before – and all within the confines of the converged database itself, unless you really want or need to leverage a different LLM for Retrieval Augmented Generation (RAG).

My first session – Gimme a Vector, Victor: The Oracle 23ai VECTOR Data Type for APEX and Analytics – will show how to build a document corpus, get it “chunked” properly and create embeddings using an ONNX LLM, and then leverage the new APEX_AI package within APEX to construct responses to troublesome trolls plaguing a social media manager’s marketing campaign.

I’ll also talk about the pitfalls I encountered when deploying OpenAI, including just how easy it is to generate hallucinations if you don’t engineer prompts carefully.

LRN1105: Tuesday, Sep 10 10:30 AM – 11:15 AM PDT Galileo 1006, The Venetian, Level 1

Set It and Forget It: Automatic In-Memory (AIM)

Before I shifted my focus to APEX, Spatial, Graph, and AI, I was an Oracle DBA for most of the last 20 years. It’s been great to dive back into the technology underlying 23ai Database and revisit one of my favorite feature sets – the In-Memory Column Store (IMCS) – in Oracle Database In-Memory: Getting Started and Best Practices.

I’ll be co-presenting with my friend and colleague from Oracle, Andy Rivenes, the PM for the entire suite of Database In-Memory tools. Andy will explain how In-Memory is now totally automatic within 23ai. Then I’ll quickly demo how easy it is to implement these latest improvements just by setting two initialization parameters.

LRN3329: Wednesday, Sep 11 3:30 PM – 4:15 PM PDT Marco Polo 806, The Venetian, Level 1

Real Application Security (RAS): Yes, It Does Work!

To wrap up OCW24, I’m doing a 20-minute theatre session with my my friend, colleague and fellow Oracle ACE Director Karen Cannell called A Fishy Business, Secured: A Real-World Implementation of RAS in Oracle APEX.

We’ll show you how we implemented RAS within a complex government agency’s Oracle 19c database schema and several APEX applications to limit access to sensitive data at both the row and column level with surprisingly few code changes.

THR1685: Thursday, Sep 12 12:20 PM – 12:40 PM PDT CW Hub, Technology Theater 1

Oh, One More Thing …

You may see me wandering around the OCW24 exhibition floor like some crazed influencer – Steadicam mount, mag microphone, talking to myself – because I’m working on upping my social media game a bit. Don’t be afraid to smile and wave! See you there, my friends and colleagues. 😎