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

- Institution: CERN
- Department: CERN Computing Seminar
- Speaker: Beda Hammerschmidt
- Year: 2019
- Language: English
- Subjects: Computer science
- Source: [CERN](https://videos.cern.ch/record/3016325)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:09:18 Slide 10

0:10:26 Slide 11

0:11:36 Slide 12

0:11:53 Slide 13

0:12:42 Slide 14

0:13:08 Slide 15

0:14:01 Slide 16

0:14:09 Slide 17

0:14:30 Slide 18

0:15:16 Slide 19

0:17:03 Slide 20

0:17:24 Slide 21

0:18:11 Slide 22

0:19:26 Slide 23

0:20:32 Slide 24

0:22:02 Slide 25

0:22:06 Slide 26

0:22:49 Slide 27

0:24:08 Slide 28

0:25:39 Slide 29

0:25:58 Slide 30

0:26:11 Slide 31

0:26:30 Slide 32

0:26:36 Slide 33

0:26:40 Slide 34

0:26:55 Slide 35

0:27:13 Slide 36

0:27:33 Slide 37

0:27:48 Slide 38

0:28:32 Slide 39

0:28:36 Slide 40

0:31:08 Slide 41

0:32:40 Slide 42

0:32:58 Slide 43

0:33:11 Slide 44

0:33:51 Slide 45

0:35:28 Slide 46

0:37:05 Slide 47

0:38:36 Slide 48

0:38:59 Slide 49

0:40:04 Slide 50

0:40:35 Slide 51…

## Lectures

1. [Dealing with JSON data in Oracle: DOs and DON'Ts](https://invisiblenetwork.ai/learn/cern/3016325/65c7b0dbb613), 1 h 3 min (CERN's player)