SQL, JSON, and Java: Leveraging Multi-Model Databases for Document Storage

This 50-minute JavaOne 2025 conference talk explores how multi-model databases like Oracle, Postgres, and MySQL are becoming superior alternatives to dedicated NoSQL solutions for document storage. Learn about the trade-offs between JSON and relational storage models, discover ISO standard SQL techniques for JSON querying, and master the use of binary JSON encodings for efficient Java object storage with JDBC. Explore integrations with Jackson Databind and Jakarta JSON that eliminate string parsing and serialization overhead, and see how Java 21 features like record patterns complement schema-less JSON storage. Presented by Josh Spiegel, Software Architect from Oracle's Database Group, this session provides practical insights with examples available on GitHub for developers looking to optimize their database approach for JSON data.