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_JSONconstraint - Generates 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
- Identifies all the columns containing JSON data by referring to the
- 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 data is projected to a relational format, Data Miner uses the data for processes such as graphing, data analysis, text processing, transformation, and modeling, as it is for any normal table without the JSON data column.
This new node is automatically identified when connected to a 12c table with a column that contains data in the JSON format, which can be dragged and dropped into our workflow builder screen. Once the JSON Query node is added, we can link them to the Data Source node and the Explore Data node.
The data will start flowing from Data Source | JSON Query | Explore Data, as shown in the following figure. Apart from this, we can add the data classification to other nodes as we need.
