We have restored access to the website from outside the CERN network, however access from certain worldwide locations is still being blocked (read more here).

CERN Accelerating science

Talk
Title Dealing with JSON data in Oracle: DOs and DON'Ts
Video
If you experience any problem watching the video, click the download button below
Download Embed
Mp4:Medium
(1000 kbps)
High
(4000 kbps)
More..
Copy-paste this code into your page:
Copy-paste this code into your page to include both slides and lecture:
Author(s) Hammerschmidt, Beda (speaker) (Oracle)
Corporate author(s) CERN. Geneva
Imprint 2019-05-15. - 1:02:07.
Series (CERN Computing Seminar)
Lecture note on 2019-05-15T11:00:00
Subject category CERN Computing Seminar
Abstract

JSON is not a new data format but it is still gaining popularity in various aspects of data management - including databases. In this talk, Beda Hammerschmidt will give an overview about JSON, it's benefits, common use cases, dos and dont's and how JSON data can be queried, indexed, generated, and processed with the Oracle Database. The talk will also present the SODA-API which provides easy CRUD access to JSON data - similar to No-SQL document databases. The target audience are DBAs who want to learn about new features of the Oracle Database as well as developers and architects interested in modern and agile application develpment.

About the speaker

Beda Hammerschmidt is an engineer (coder) in the Oracle Database Team since 2006. For many years he worked on various components of XML DB. In 2013 he represented Oracle in a joined effort with IBM to develop a standard to process JSON data in a relational database (the proposal became part of SQL 2016). Since then, Beda has been the technical lead for JSON support in the Oracle Database and implemented many components.

Copyright/License © 2019-2024 CERN
Submitted by miguel.marquina@cern.ch

 


 Record created 2019-05-16, last modified 2022-11-02


External link:
Download fulltext
Event details