JSON, Part 1: Store semi-structured documents in Oracle Database with SQL
Leverage the JSON data interchange standard and the SQL language to simplify information storage and retrieval. [Due to recent interest in JSON—including the release of Oracle Autonomous JSON Database —we have updated this two-part series, first published in Oracle Magazine in 2015. — Ed .] Recently Acme Bank has been accepting transactions from business partners such as convenience stores and third-party billing companies—and even partners outside the country. Those transactions contain different fields but conform to the JavaScript Object Notation (JSON) interface standard for semi-structured documents. Mark, the chief technology officer, has been cornered by two colleagues who are concerned about the use of JSON. JSON enables any set of data to be transmitted immediately, without a predetermined format expected by a relational database, and this makes it attractive for integrating outside transactions quickly. Acme’s partners can send any pertinent data they ...