13.3 JavaScript Object Notation (JSON)

JSON is a text-based format that leverages data structures and basic types found in most programming languages: objects, arrays, strings, and numbers. JSON is commonly used for information exchange between web clients and web servers. Many relational database systems now support JSON, and JSON is the primary data model for many NoSQL systems. MongoDB is one such document database that natively supports storing and querying JSON objects. JSON features in relational databases are described in Section 13.5, and examples of JSON usage in Oracle appear in Section 13.6. Mongo DB is discussed in Chapter 14.

JSON objects are denoted by curly braces { } and arrays are denoted by square brackets [ ]. Each key is ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.