SQL, JSON, and Java
summary
Relational databases store JSON in a new OSEN binary format that is smaller than text/BSON, supports random access into large documents, and ships to the JVM unchanged; JDBC exposes it via getObject/setObject so the demo inserts four movies “four different ways” (string, DOM, file, POJO) and reads them back efficiently. Jackson integration (Jackson databind extension) maps POJOs directly to OSEN, Spring Data JDBC treats JSON aggregates as single-row reads/writes, and multivalue indexes and JSON transform handle indexing and migrations.
AI-written summary · about
chapters (7)
- 0:00JSON in databases
- 7:29JSON in relational DBs
- 14:35Java JSON APIs
- 23:07JDBC JSON columns
- 26:21Spring Data JSON
- 32:25Live JSON demo
- 46:17Oracle features Q&A
related talks
47mDealing with JSON in the Relational World
51mDealing with JSON in the relational world
44mWho is Jason, and what’s he doing in my database?
47mGoing beyond ORMs
01h 06mSQL ❤️ JSON: The Best of Both Worlds
15mPlug-and-Play for JSON and MongoDB Developers
29mRetire your tables. It's all JSON now.
35mJSON beyond the Blob - Data evolution with Hibernate ORM