JSON beyond the Blob - Data evolution with Hibernate ORM
summary
Shows how a JSON blob used for import evolves into indexed, queryable business data with Hibernate ORM by using SQL JSON functions and newer ORM features. Demonstrates using JSON_VALUE/JSON_QUERY for scalar and object extraction, the set returning JSON_TABLE to turn arrays into rows (processed once), mapping JSON to embeddables with generated check constraints, and achieving fast lookups with generated stored column + GIN index and ordinality for sorting, while warning about DB-specific performance traps.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:13Hibernate ORM history
- 2:56Startup JSON challenges
- 7:30JSON in modern SQL
- 11:07JSON extraction challenges
- 14:00JSON_TABLE function
- 17:49Advantages and challenges of JSON_TABLE
- 19:13Embeddable inheritance
- 23:06Efficient JSON filtering
- 27:22Performance and conclusion
- 28:25Q&A
related talks
51mDealing with JSON in the relational world
25mJSON in PostgreSQL - evil data type or just needs to be tamed?
14mJSON data structure – the hidden gem inside your database engine
47mDealing with JSON in the Relational World
42mHow to Store JSON in a Database Without Attracting the DBA's Attention
29mRetire your tables. It's all JSON now.
47mGoing beyond ORMs
50mSQL, JSON, and Java