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 :)
Image
Whoa, check out this stage. Image
Let's put it all the data together! Image
Programming Objects "vs" tables...how can we bridge this? Image
Many attempts...ORMs, anyone? Image
We propose a new approach Image
@bch_t reminds us why #json is so popular - it's easy! Image
Thankfully @OracleDatabase is already a GREAT solution for storing your documents (XML, too!)

And yeah, you get SQL with that. Image
Is JSON perfect? Not quite. Image
We COULD attempt to normalize our JSON..to make mass updates/duplication less of an issue... Image
But now we've lost our simplicity...and sharding becomes next to impossible. Image
We want our cake and to eat it too! Gimme the best of both, please. Image
How does our 23c solution work? Image
JSON Duality Views! ImageImage
These views can be made to be PARTIALLY updateable. Image
Getting the data back out is simple. Image
Developers benefit! Shared data is automatically updated as needed. Image
We're extending the power of declarative nature of SQL to JSON

Key: language independent! Image
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. Image
Now that our database understands the nature of your data, we can bring to bear the full power of Oracle Image
But wait, we changed how we handle locking IN the database.

Lock-Free Concurrency Control ImageImage
So much nicer for stateless architectures like REST.

eTags determine what needs updated/synchronized..vs traditional locks. ImageImage
Imagine having column level locking..that's in effect what were delivering. Image
Let's pivot to code generators...

Here's my document, now give me code. Image
Data Modelers, rejoice! Image
Simpler than UDTs... Image
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. Image
Time for the summary!

Don't make me pick tables OR documents.

Gimme stateless APIs AND consistency! Image
And what about our Mongo friends, what's the appeal? Image
Meanwhile for SQL folks (like me!) Image
Let's share nice analyst quote..

@Wikibon Image
Did we get your attention? Want to have a go at this? Sign up for our @OracleDatabase 23c Beta! Image
C'est fin.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with SQL.ProductManager.Oracle.Databases 🏋️ 🥃

SQL.ProductManager.Oracle.Databases 🏋️ 🥃 Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @thatjeffsmith

Oct 18, 2022
Watching EVP @jrloaizam kick off his talk with @SQLMaria
Microservices and decentralized data - how does that square with @OracleDatabase AND simplicity
You've got options...In-Database Containers, multitenant and pluggable databases for the win!

Easily cloned and moved between physical instances.
Read 12 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(