This document contains the following sections:
This Release Note contains the following information:
The new features in Oracle Data Miner 4.1 include:
JSON data support for Oracle Database 18.104.22.168 patch release.
Note:To avail support for JSON data, contact Oracle Support at
https://support.oracle.comfor the specific Oracle Database 22.214.171.124 patch release.
In response to the growing popularity of JSON data and its use in big data configurations, Oracle Data Miner now provides an easy-to-use JSON Query node. The JSON Query node enables you to select and aggregate JSON data without entering any SQL commands. The JSON Query node uses all of the existing Oracle Data Miner features with JSON data. The enhancements include:
Data Source Node
Automatically identifies columns containing JSON data by identifying those with the
Generates a JSON schema for any selected column that contain JSON data
Imports a JSON schema for a given column
Provides the JSON schema viewer
Create Table or View 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 type
Columns can be specifically typed as JSON data
JSON Query Node
Ability to use any of the selection and aggregation features without entering SQL statements
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
Ability to partially select JSON data as standard relational scalar data while leaving other parts of the same JSON document as JSON data
Ability to aggregate JSON data in combination with relational data. Includes the Sub-Group By option, that is used to generate nested data that can be passed into mining Model Build nodes
New PL/SQL APIs for managing Oracle Data Miner projects and workflows
The PL/SQL APIs handle the following for a workflow:
Runs a workflow
Cancels a running workflow
Renames a workflow
Deletes a workflow
Imports a workflow
Exports a workflow
The APIs handle the following for a project:
Creates a project
Deletes one or more projects
Renames a project
Repository views are available to:
Query project and workflow information
Monitor workflow status
Query generated results
Note:The views for the generated results are available only for Oracle Database 126.96.36.199 and later.
The Transformation Nodes have been enhanced with the following:
In the Add Transform dialog box, the Transform NULL's check box has been added. This is applicable for:
Transform Type—Binning, Custom
Bin Labels—Number, Range
The Binning Intervals are displayed in a different format. For example,
101126.0 - < 102251.0
102251.0 - < 103375.0
New UI element has been added to the Transform node Properties, to define settings for all transformation. The UI elements are:
Null Values Label
Other Value Label
For Custom binning, the option to rename Bin Label and Bin Value is provided in the Edit Transform dialog box.
The general improvements in Oracle Data Miner include:
Improved database session management resulting in fewer database sessions being generated and a more responsive user interface.
Filter Columns node
Combined primary Editor and associated advanced panel to improve usability.
Explore Data node
Allows multiple row selection to provide group chart display.
Classification Build node
Automatically filters out rows where the Target column contains Null values or all spaces. Also, issues a warning to the user but continues with Model build node.
Enhanced workflows to ensure that the loading, reloading, stopping, saving operations no longer block the UI.
Revised the Online Help to adhere to topic-based framework.
The following bugs have been fixed in Oracle Data Miner 4.1:
GLM Model Algorithm Settings: Added GLM feature identification sampling option (Oracle Database 12.1 and later).
Filter Rows Node: Custom Expression Editor not showing all possible available columns.
WebEx display issues: Fixed problems affecting the display of the Oracle Data Miner UI through WebEx conferencing.
For details on supported platforms, see Oracle SQL Developer Installation Guide.
Before you can use Oracle Data Miner, ensure the following:
Install SQL Developer 4.1 on your system.
Secure access to an Oracle Database:
Minimum version: Oracle Database 11g Release 2 (188.8.131.52) Enterprise Edition, with the Data Mining option.
Preferred version: Oracle Database 12c Release 1 (184.108.40.206) Enterprise Edition.
Create a database user account for data mining.
Create a database connection within SQL Developer for the Oracle Data Miner user.
Install the Oracle Data Miner repository.
Note:The JSON data support feature is available only for Oracle Database 220.127.116.11 release.
The known problems and limitations in this release include:
Association Model Build node cannot consume data coming directly from JSON Query node.
Users need to persist the data coming out of the JSON Query node through Create Table node, and then use the persisted data as input to the Associate Model Build node.
Classification nodes and Regression Model Build nodes are unable to consume data directly coming from JSON Query node if JSON aggregations (with Sub Group By) are defined.
Users need to persist the data coming out of the JSON Query node through Create Table node, and then use the persisted data as input to these Build nodes.
Note:Build nodes can consume data directly coming from JSON Query nodes if JSON Aggregations (without Sub Group By) are not defined.
Setting Parallel Query for a node that queries JSON data can result in a workflow runtime error. JSON queries will fail if they are run with the database Parallel Query set to ON. The following error message is displayed ORA-12805: Parallel Query server died unexpectedly.
Parallel Query can be configured through Oracle Data Miner at the node level:
The Node context menu has the option to set Parallel Query. Click Parallel Query and select the nodes to configure the parallel settings.
The View Data viewer provides the option to set Parallel Query to ON when querying the selected Data Nodes.
In both the cases, the error occurs and the same error message is displayed.
Oracle Data Miner 4.1 is certified on Oracle Database 18.104.22.168 through Oracle Database 12.1. Oracle Data Miner is not certified on Oracle Database 12.2 and higher. Therefore, it cannot be installed on Oracle Database 12.2 and higher.
Note:If you have installed Oracle Data Miner 4.1 on a certified Oracle Database and have upgraded the database to version 12.2 or higher, then you must upgrade to a newer version of Oracle Data Miner that supports the upgraded Oracle Database version.
Multi byte character data is not supported in Oracle Data Miner with Oracle Database 12.1 because of database issues. To address the multibyte issue, apply the Oracle Database 22.214.171.124 patch. It is also recommended to use the AL32UTF8 character set.
Note:Request the Oracle Database 126.96.36.199 patch through Oracle Support. See "Documentation Accessibility" for information about how to access Oracle Support.
Oracle SQL Developer LDAP connections utilizing a proxy or target user protocol, can generate an SQL run time error when running the SQL Query Node. If you encounter the
Invalid name pattern error when running a query as a proxy user, then perform the following configuration workaround. The workaround is to set the JVM property
To set the JVM property, open Oracle SQL Developer and run the following from the command prompt:
To make a permanent change, update the
sqldeveloper.conf file and include the property definition, as follows:
Shut down Oracle SQL Developer.
sqldeveloper.conf file and update it with the property definition:
sqldeveloper.conf file to
<sql_dev_install_dir>\sqldeveloper\bin\sqldeveloper.conf. This overwrites the existing file.
With the updated
sqldeveloper.conf file, you do not have to start Oracle SQL Developer from the command line.
The top of the
sqldeveloper.conf file is shown below with the new text in bold:
#Workaround for LDAP Proxy failure
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Release Notes, Release 4.1
Copyright © 2014, 2015, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.