Posts

Showing posts from April, 2021

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