JavaScript Object Notation (JSON) is a popular way for servers and clients to exchange information. It uses serialized text to represent objects (or data structures). If you are interested in using JSON when you work with DB2 pureXML, there is a new series of articles you should check out.

These articles teach you how DB2 pureXML can store, manage, and query JSON. The articles include downloadable sample code and step-by-step instructions. They also describe the benefits of using pureXML to store JSON.

Part 3 will focus on the creation of the presentation layer with Open-Social Gadgets that rely on the JSONx Universal Services as a back-end.


The adoption of XML-based standards in many industries has had a significant impact on native XML database adoption. After all, the processing efficiencies offered by a native XML database like DB2 pureXML are vital as systems scale up and out. Readers of the blog will also know that IBM has made it easy for DB2 users to work with many XML-based industry standards by freely distributing working sample implementations of these standards.

Of course, IBM supports such standards by making its industry experts available for participation in many of the standards committees. This week IBM further demonstrated its support for the Association for Cooperative Operations Research and Development (ACORD) and its insurance and financial services standards by donating technology assets including its Insurance Application Architecture (IAA) Business Object/Data Model and the IAA Product Specification Diagram (PSD) to ACORD.

This represents a significant contribution of intellectual property associated with IBM’s insurance industry models. The donated models are from IBM’s Insurance Application Architecture (IAA), the company’s insurance business and IT architecture framework. IAA is continually developed by IBM in collaboration with 100 leading insurance companies around the world, and the IAA model has been licensed by more than 200 insurers worldwide. IAA Business Object/Data Model, coupled with the existing ACORD Information Model, will form the building blocks for the next version of the ACORD Information Model.

This announcement builds on efforts to encourage collaboration and drive innovation in the insurance industry. The adoption of standardized business processes and models will make it easier for insurers to work with agents, brokers and other data partners.

You can read more about this announcement at IBM Contributes Technology Assets to Help Drive Standards in Insurance Industry. You can read more about implementing ACORD standards in DB2 pureXML at Storing and Retrieving ACORD Data for Insurance

Bryan Patterson has written an excellent step-by-step article about creating an electronic forms solution on Adobe Developer Connection. The article guides you through creating a simple yet powerful eForms solution based on Adobe LiveCycle Designer ES and IBM DB2 pureXML. The article includes links to download all software needed to automate:

  • The collection of user data using electronic forms
  • The transmission of user data using XML, and
  • The storage of user data using a database.

Because all parts of the solution use XML, there is no need for complex data mapping or conversion steps between components. The XML data format used in this example implementation is a very simple structure but you can easily expand the format to meet specific needs or even base the format on one of the many XML-based industry standards for data exchange such as NIEM for government, ACORD for insurance, or FIXML for financial markets. You can read more at Creating an XML electronic forms solution with an Adobe PDF form and IBM DB2 pureXML.