JSON Data Type

TimesTen supports JSON data through the Oracle JSON library and the JSON data type, allowing you to store, query, and manipulate JSON data in a TimesTen database. TimesTen uses Oracle Binary JSON (OSON) to store and send JSON data. Since OSON is an optimized native binary storage used for JSON data, there is faster parsing, smaller storage requirements, and improved query performance of JSON data in a TimesTen database.

TimesTen provides the JSON data type and the JSON_SCALAR and JSON_SERIALIZE functions to work with JSON data. This enables conversion between JSON and SQL data types, and serialization of JSON data to textual representation.

The valid range for the JSON data type is from 1 to 4,194,304 bytes.

To create, query, and operate on JSON data stored in a TimesTen database, TimesTen provides the following conditions and functions:

• JSON_EQUAL Condition

• JSON_EXISTS Condition

• JSON Type Constructor

• JSON_QUERY

• JSON_TABLE

• JSON_VALUE

See JSON Data and TimesTen in the Oracle TimesTen In-Memory Database JSON Developer's Guide.