SQL、JSON 和 Java [SHO1351].pdf

1、 SQL,JSON,and JavaSHO1351Josh SpiegelSoftware Architect,Oracle DatabaseSQL,JSON,and Java2Copyright 2025,Oracle and/or its affiliates|Confidential:Internal/Restricted/Highly Restricted1234IntroductionSQL/JSONJDBC/JSONSpring Data JSONSlides and Demos on GitHubJSON Document Databases3Copyright 2025,Ora

2、cle and/or its affiliates Strings,numbers,Booleans arrays,and objects Objects/arrays can nest Schema independentCosmosDBDocumentDBGoogle Firestore movie_id:1652,title:Iron Man 2,date:2010-05-07,cast:Robert Downey Jr.,Larry Ellison Converged DatabaseCopyright 2025,Oracle and/or its affiliates4Converg

3、ed Database Architecture Single-purpose databases OLTPOLAPGraphSpatialDocumentMLSearchfor each data type and workloadMultiple security models,languages,skills,licenses,etcfor any data type or workloadDatabase PopularityCopyright 2025,Oracle and/or its affiliates6DatabaseTypePopularityOracleRelationa

4、l,Multi-model1244.08MySQLRelational,Multi-model1061.34Microsoft SQL ServerRelational,Multi-model821.56PostgreSQLRelational,Multi-model636.25MongoDBDocument421.08RedisKey-value,Multi-model155.94ElasticsearchSearch engine,Multi-model132.83SnowflakeRelational130.36IBM Db2Relational,Multi-model125.90SQL

5、iteRelational111.41Top-10 Ranked DatabasesTotal Popularity%by TypeWhy store data as JSON?Copyright 2025,Oracle and/or its affiliates7 movie_id:1652,title:Iron Man 2,date:2010-05-07,cast:Robert Downey Jr.,Larry Ellison,.class Movie int movie_id;String title;LocalTime date;List cast;Movie().Schema-fle

6、xibleNo upfront schema designApplication-controlled schemaSimple data modelLess Impedance MismatchMaps to application objectsSupports nested structuresRead/write without joinsNo SQLNo embedding of SQL codeMinimal new concepts for developersdb.movies.insertOne(movieValue);db.movies.find(movie_id:1653