Скачать или смотреть JSON, A Splash of SODA, and a SQL Chaser: Real-World Use Cases for Autonomous JSON Database (AJD)

About this event
JSON is the new XML! It’s everywhere, from NoSQL databases to REST APIs. Let me share with you how Oracle’s Autonomous JSON Database (AJD) makes short work of handling JSON-resident information, especially when paired with robust functions and features of Oracle 19c and 21c.

The popularity of JSON (JavaScript Object Notation) has quickly become a de facto method for retaining valuable business information for many IT organizations. For the modern Oracle DBA, finding the best methods to retain, maintain, and process JSON documents – especially when that information needs to be combined with non-JSON data - can be a confusing conundrum.

This session demonstrates how to tackle real-life business use cases with the newest member of Oracle’s Autonomous Database family – the Autonomous JSON Database (AJD) – and explains how it simplifies JSON document management, provides secure access to their data via SODA, and promotes easy combination of JSON and non-JSON data with SQL.

Session Outline:

Through presentations and online demonstrations, this session illustrates how to:

Use an Autonomous JSON Database (AJD) to store, retrieve, and process JSON information
Take advantage of Simple Document Oracle Access (SODA) NoSQL APIs to process JSON information … without writing any SQL code
Leverage SQL to access JSON information within an AJD and combine it with other non-JSON formatted information retained within the same AJD

Topics:

The World’s Gone JSON. Get Used To It
AJD vs. ATP: Advantages, Drawbacks, Limitations
Loading, Accessing, and Processing JSON within an AJD
Using SODA to Access JSON Within Applications
Combining JSON and non-JSON information via Oracle SQL
Promoting an AJD Instance to ATP
Objectives:

The attendee will:

Understand how to use an Autonomous JSON Database (AJD) to store, retrieve, and process information within JSON documents
Learn how to use Simple Document Oracle Access (SODA) NoSQL APIs to process JSON documents without writing any SQL code
Leverage Oracle Database SQL language functionalities to access JSON documents and combine it with other non-JSON information stored within the same AJD
Session Prerequisites:

To gain the most from this presentation, attendees should be familiar with basic Oracle PL/SQL and SQL concepts. An understanding of JavaScript Object Notation (JSON) concepts is not required but would be helpful.

About Presenter:

Jim Czuprynski has over forty years of professional experience in Information Technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology, presenting often at Oracle OpenWorld, Oracle CODE, COLLABORATE, KSCOPE, Oracle Development Community tours, and Oracle User Group conferences around the world.

Jim has authored 100+ articles on Oracle Database administration, ML/analytics, and APEX since 2003 at databasejournal.com, IOUG SELECT, and ODTUG TechCeleration and has co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (https://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle and the state of the IT industry. Jim also co-hosts the Beyond Tech Skills podcast (https://www.beyondtechskills.com), which discusses everything about tech … except tech.