Developing Applications for JSON Tables
As part of its support for JSON tables, MapR-DB implements the OJAI API. The OJAI API provides methods for creating, reading, updating, and deleting JSON documents in MapR-DB JSON tables. It is available in Java. MapR-DB also provides a MapR-DB JSON Client API for managing JSON tables and a MapR-DB JSON REST API for performing basic operations using HTTP calls.
The following shows the general flow for developing an OJAI client application that accesses MapR-DB JSON tables:
- Make a connection to MapR-DB using the OJAI Connection and Driver interfaces
- Request a MapR-DB JSON table using the JSON DocumentStore
- Specify the table, document, or column family operation
- Perform the operation on the table
- Return the results
For additional information about OJAI, refer to the following:
- OJAI wiki page
- OJAI github repository - The README file provides an introduction to OJAI
The MapR-DB JSON Client API, implemented in Java, enables you to create, drop, and alter MapR-DB JSON tables and column families.
You can also use HTTP calls to create, delete, and query MapR-DB JSON tables Using the MapR-DB JSON REST API.
API Documentation
The following are links to the detailed API pages:
- Java OJAI Client API
- MapR-DB JSON Client
API
NOTE: Beginning with MapR version 6.0, the MapR-DB
Table
interface in the MapR-DB JSON Client API is deprecated and replaced by theDocumentStore
interface in the OJAI API.