The growing popularity of JSON data and its easy implementation and use in mobile apps for the GET
and POST
methods of data transfer prompted Oracle to include the capability in Data Miner, which now provides an easy-to-use JSON Query node. The JSON Query node allows select and aggregate JSON data without entering any SQL commands. The JSON Query node opens, using all of the existing Data Miner features with JSON data. The enhancements include the following:
Data Source node:
Identifies all the columns containing JSON data by referring to the
IS_JSON
constraintGenerates JSON schema for any selected column that contains JSON data in XML format
Imports JSON schema for a given column in XML format
Using the JSON schema viewer, the data is displayed
Create Table node:
Ability to select a column to be typed as JSON
Generates JSON schema in the same manner as the data source node
JSON data from a 12c
native table can be recreated over to Data Miner via the new JSON Query node. Once the...