@oraclebase.bsky.social telling the audience the database 23ai features he likes and will use at #ukougdiscovery24 #ukoug2024

In a mergeable view the database combines the patent and view query

In non mergeable views the database computes the view query before combining it with the parent

Views can be mergeable or non mergeable

The database combines mergeable views with the statement that calls it

For non mergeable views it calculates the view query first, then combines it with the parent SQL

@danischnider.bsky.social running through when Oracle Database can merge views #ukoug2024

Our feed on Twitter is very quiet now, even with #UKOUG2024 underway. Here in the sky it's maybe 8-10 times busier. Further, most of what's on there is duplicated here.
Add in the friendlier feel, huge reduction in bots & accounts simply following hundred or thousands of random people, much better.

AI Vector Search improvements coming in 23ai

GPU offload coming in Autonomous Database

JSON Relational Duality view enhancements coming in 23ai

Property graph (SQL/PGQ) improvements coming in 23ai

There are many enhancements coming in upcoming 23ai patches for

Vector search
GPU offload on Autonomous
JSON relational duality views
Property graph queries

@domgiles.bsky.social showing us at #ukoug2024

SYM42 gang at
#UKOUG2024
with new member Nigel Bayliss (is he on BS yet?).
Photo taken by other new member
@go-faster.co.uk
(David Kurtz)

6 years and it feels like in a different life. Maybe it was:) Happy #UKOUG2024 to those who celebrate! I will cherish my memories of the one that took place in Liverpool in 2018. My first international talk, great audience, and @ora600pl.bsky.social in my corner.. this one didn't change:)

Screen not working? Hold my beer.
Or actually, don't hold it, I will need it.
@ora600pl.bsky.social using cans to draw an activity chart at the #UKOUG2024 conference 🍻

SQL firewall overview

Oracle Database 23ai has a built in #SQL firewall

Use this to define a list of allowed statements

Statement not the list are logged and can also be blocked

@stefanoehrli.bsky.social tracking us all about it at #ukoug2024

A description of a property graph

CREATE PROPERTY GRAPH statement

A GRAPH_TABLE query

SQL/PGQ is part of the 2023 SQL standard and available in Oracle Database 23ai

Using this you can define graph relationships over your tables

Then use GRAPH_TABLE to search it

@gianniceresa.bsky.social explains at #ukoug2024

Thanks to #Oracle for the great dinner tonight with delicious food! #oracleace #ukoug2024 #birmingham

I’m really flattered that someone like @chandlerdba.bsky.social is using my tools in his presentation :) 🥃🍻
#ukoug2024

In time for breakfast at #ukoug2024 with @julianfrey.ch

@ora600pl.bsky.social doing his usual things in his talk about low code becoming low level code, at super Sunday #ukoug2024 #ukougdiscover24

Important for those at #UKOUG2024 today - Chris Saxon and Alastair Newson are swapping session times

#ukoug2024

Massive train delays at Bristol today, so I won’t make my 2pm slot to talk about 23ai

Alastair Newson is kindly taking my place covering parallel query on Autonomous

I’m up at 4pm instead

And so #UKOUG2024 kicks off with the traditional "Tech Sunday".
Some of us remember when it was Oaktable Sunday!

On the way to #ukoug2024 See you all in beautiful Birmingham @oracleace.bsky.social #oracleace #orclapex

Already time for the last conference of the year.
On my way to #UKOUGDiscover24 #ukoug2024 by UKOUG.
I will speak about various topics including #OracleAnalytics, SQL/PGQ graphs, GenAI and RAG, and some data analysis.

See you in Birmingham!

On the way to #UKOUG2024 #UKOUGdiscover2024. See you on Sunday in Birmingham!

Final research before my 13:00 session on Tuesday: APEX and Spatial: Finding the most delicious Apple Pie virtual.oxfordabstracts.com/event/73719/... #ukoug2024 @orclapex

Finally got round to booking travel to #UKOUG2024. Hope I don't penalize anyone accidentally travelling on the same flights :)