JSON application development for IBM® data servers

In Db2, you can store and manage data that is formatted using JavaScript Object Notation (JSON). JSON provides a flexible mechanism to store and transmit data between application tiers. JSON is becoming one of the predominant technologies for rapidly changing mobile and interactive applications.

The JSON capability in Db2 provides a Java™ API, a command-line interface, and a wire listener feature to manage and query JSON documents that are stored in a Db2 database by using a JSON-oriented query language. These new interfaces are considered NoSQL interfaces. They use query, administration, and data manipulation syntax that is not based on SQL.

The JSON format is often used for serializing structured data and transmitting that structured data over a network connection. It is used primarily to transmit data between a server and a web application, serving as an alternative to XML. It eliminates the need for predetermined schema designs and reduces the need for data transformations.

JSON is a lightweight data exchange format that is specified in IETF RFC 4627. It is language independent and portable. As a subset of the JavaScript programming language, it is easy to implement and is easily read by humans and machines alike.

BSON is a standardized binary representation format for serializing JSON documents. It allows for fast traversal of JSON documents.