DB2 10.5 for Linux, UNIX, and Windows

JSON application development for IBM data servers

In DB2® Version 10.5 Fix Pack 1 and later fix packs, you can use 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 format is often used for serializing semi-structured data and transmitting that structured data over a network connection. An example would be transmitting data between a server and a web application. It also serves 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.

DB2 JSON 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.

For a list of known issues for JSON, go to Known issues for DB2 JSON application development for IBM data servers