Thread by @thatjeffsmith

Don't miss [SOL2606] with @jrloaizam @dbinmemory @bch_t in 1 hour over in Caesars Forum @CloudWorld !

JSON Documents...Relational structures...coming together for maximum flexibility and power of SQL!

Exciting new tech/features for @OracleDatabase 23c :)

Whoa, check out this stage.

Let's put it all the data together!

Programming Objects "vs" tables...how can we bridge this?

Many attempts...ORMs, anyone?

We propose a new approach

@bch_t reminds us why #json is so popular - it's easy!

Thankfully @OracleDatabase is already a GREAT solution for storing your documents (XML, too!)

And yeah, you get SQL with that.

Is JSON perfect? Not quite.

We COULD attempt to normalize our JSON..to make mass updates/duplication less of an issue...

But now we've lost our simplicity...and sharding becomes next to impossible.

We want our cake and to eat it too! Gimme the best of both, please.

How does our 23c solution work?

JSON Duality Views!

These views can be made to be PARTIALLY updateable.

Getting the data back out is simple.

Developers benefit! Shared data is automatically updated as needed.

We're extending the power of declarative nature of SQL to JSON

Key: language independent!

Docs can now be specialized per use case.

The duality views are per use case, but the underlying data is shared across all use cases.

Now that our database understands the nature of your data, we can bring to bear the full power of Oracle

But wait, we changed how we handle locking IN the database.

Lock-Free Concurrency Control

So much nicer for stateless architectures like REST.

eTags determine what needs updated/synchronized..vs traditional locks.

Imagine having column level locking..that's in effect what were delivering.

Let's pivot to code generators...

Here's my document, now give me code.

Data Modelers, rejoice!

Simpler than UDTs...

These documents, duality views + domains brings a lot of benefits. But let's tie this back to our friend, the relational database.

SQL is always in the room if you need it.

Time for the summary!

Don't make me pick tables OR documents.

Gimme stateless APIs AND consistency!

And what about our Mongo friends, what's the appeal?

Meanwhile for SQL folks (like me!)

Let's share nice analyst quote..

@Wikibon

Did we get your attention? Want to have a go at this? Sign up for our @OracleDatabase 23c Beta!

C'est fin.