OceanBase Database supports the JavaScript Object Notation (JSON) data type that complies with RFC 7159. You can store semi-structured JSON data and access and modify the data in a JSON document.
The JSON data type offers the following advantages:
Automatically validates JSON documents stored in JSON columns, and invalid documents will result in an error.
JSON documents stored in JSON columns can be converted into a format optimized for fast reading and access. When the server needs to read JSON values stored in binary format, it does not need to parse the values from text.
Supports semi-structured encoding in MySQL-compatible tenants, further reducing storage costs. A JSON data object can be split into multiple sub-columns for storage, with each sub-column encoded individually to improve compression rates and reduce the storage space required for the JSON data. For more information, see Creating a JSON Value.