Using JSON in a Relational Database Best Practices


Relational databases = strict data types and stored schema.  JSON = free form but no data rigor.  But what if you could reliably use JSON in your relational database to get performance, the processing power of Structured Query Language (SQL), and reatain the flexibility JSON is know for.  This talk will cover the best practices for using JSON in your realtional database, how to temporarily transform unstructured JSON data into structured data with JSON_TABLE() or permanently with generated columns.  And how do you ensure that the JSON data has the proper format or is required before entry to the database.

Ballroom C
Friday, March 10, 2023 - 17:00 to 18:00