Learn · CERN

Talk1 h 3 min

Dealing with JSON data in Oracle: DOs and DON'Ts

Beda Hammerschmidt · CERN

Watch At CERN

About

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. .

0:00:00 Slide 1

0:04:47 Slide 2

0:04:58 Slide 3

0:06:04 Slide 4

0:07:29 Slide 5

0:07:56 Slide 6

0:08:42 Slide 7

0:08:46 Slide 8

0:09:13 Slide 9

The talk

  1. Dealing with JSON data in Oracle: DOs and DON'Ts 2019-05-15 · 1 h 3 min · CERN's player

Credits and licence

Institution
CERN
Department
CERN Computing Seminar
Speaker
Beda Hammerschmidt
Year
2019
Language
English
Subjects
Computer science
Source
CERN
Licence
CERN, as CERN states it. CERN's terms
Attribution
© CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
Who can watch
CERN gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed