JSON JSON is ubiquitous in data exchange today Widely used for web services Most modern applications are architected around on web services ■SQL extensions for JSON types for storing JSON data Extracting data from JSON objects using path expressions 。E.g.V->lD,orv.lD Generating JSON from relational data E.g.json.build_object('ID',12345,'name','Einstein') Creation of JSON collections using aggregation E.g.json_agg aggregate function in PostgreSQL Syntax varies greatly across databases ■JSON is verbose Compressed representations such as BSON(Binary JSON)used for efficient data storage Database System Concepts-7th Edition 8.8 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 8.8 ©Silberschatz, Korth and Sudarshan th Edition JSON ▪ JSON is ubiquitous in data exchange today • Widely used for web services • Most modern applications are architected around on web services ▪ SQL extensions for • JSON types for storing JSON data • Extracting data from JSON objects using path expressions ▪ E.g. V-> ID, or v.ID • Generating JSON from relational data ▪ E.g. json.build_object(‘ID’, 12345, ‘name’, ‘Einstein’) • Creation of JSON collections using aggregation ▪ E.g. json_agg aggregate function in PostgreSQL • Syntax varies greatly across databases ▪ JSON is verbose • Compressed representations such as BSON (Binary JSON) used for efficient data storage