By Charlie Berger, Advanced Analytics-Oracle on May 04, 2015
To download, visit:
New Data Miner Features in SQL Developer 4.1
In response to the growing popularity of JSON data and its use in Big Data configurations, Data Miner now provides an easy to use JSON Query node. The JSON Query node allows you to select and aggregate JSON data without entering any SQL commands. The JSON Query node opens up using all of the existing Data Miner features with JSON data. The enhancements include:
Data Source Node
o Automatically identifies columns containing JSON data by identifying those with the IS_JSON constraint.
o Generates JSON schema for any selected column that contain JSON data.
o Imports a JSON schema for a given column.
o JSON schema viewer.
Create Table Node
o Ability to select a column to be typed as JSON.
o Generates JSON schema in the same manner as the Data Source node.
JSON Data Type
o Columns can be specifically typed as JSON data.
JSON Query Node (see related JSON node blog posting)
o Ability to utilize any of the selection and aggregation features without having to enter SQL commands.
o Ability to select data from a graphical layout of the JSON schema, making data selection as easy as it is with scalar relational data columns.
o Ability to partially select JSON data as standard relational scalar data while leaving other parts of the same JSON document as JSON data.
o Ability to aggregate JSON data in combination with relational data. Includes the Sub-Group By option, used to generate nested data that can be passed into mining model build nodes.
o Improved database session management resulting in less database sessions being generated and a more responsive user interface.
o Filter Columns Node - Combined primary Editor and associated advanced panel to improve usability.
o Explore Data Node - Allows multiple row selection to provide group chart display.
o Classification Build Node - Automatically filters out rows where the Target column contains NULLs or all Spaces. Also, issues a warning to user but continues with Model build.
o Workflow - Enhanced workflows to ensure that Loading, Reloading, Stopping, Saving operations no longer block the UI.
o Online Help - Revised the Online Help to adhere to topic-based framework.
Selected Bug Fixes (does not include 4.0 patch release fixes)
o GLM Model Algorithm Settings: Added GLM feature identification sampling option (Oracle Database 12.1 and above).
o Filter Rows Node: Custom Expression Editor not showing all possible available columns.
o WebEx Display Issues: Fixed problems affecting the display of the Data Miner UI through WebEx conferencing.
For More Information and Support, please visit the Oracle Data Mining Discussion Forum on the Oracle Technology Network (OTN)
Return to Oracle Data Miner page on OTN