Store and analyze JSON data using the Oracle API for MongoDB and SQL/JSON

on YouTube ↗23m

" summary

Loads 1,600 stations and 20,000 status records into Autonomous JSON Database using mongoimport and mongosh, builds a Spring Boot REST microservice that reads and writes the collections, and runs a JMeter workload that shows about avg 6 ms latency over ~2,000 requests. Creates SQL relational views via the Data Guide, joins JSON collections to compute min/max/avg bike availability, and drives a live chart that updates when new status documents are inserted.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 0:20Understanding AJD
3. 3:18Project Setup
4. 5:18Loading JSON Data
5. 7:35NoSQL Interaction
6. 8:50Building the Microservice
7. 12:20Performance Testing
8. 14:00SQL for JSON
9. 15:41Data Guide and Views
10. 17:35Data Visualization
11. 21:22Conclusion and Resources

" related talks

• 15mPlug-and-Play for JSON and MongoDB DevelopersBEDA HAMMERSCHMIDT · Oracle DatabaseWorld: Multicloud AI Edition 2025
• 44mWho is Jason, and what’s he doing in my database?Martin Bach · Voxxed Days Zürich 2024
• 51mDealing with JSON in the relational worldAndres Almiray · Devoxx Belgium 2024
• 26mMySQL Without the SQL -- Oh My!Dave Stokes · Data Con LA 2020
• 29mRetire your tables. It's all JSON now.BEDA HAMMERSCHMIDT · Oracle DatabaseWorld 2021
• 29mDatabase: What's new, what's nextJenny Tsai-Smith · Oracle DatabaseWorld 2021
• 47mGoing beyond ORMsAndres Almiray · Porto Tech Hub Conference 2024
• 50mSQL, JSON, and JavaJosh Spiegel · JavaOne 2025