JSON Data Type

You can create a database table that has one or more JSON columns, alone or with relational columns. TimesTen recommends that you use the JSON data type for JSON columns.

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, the JSON_SCALAR and the 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.

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.