Skip to main content


Showing posts from August, 2020

Using Oracle ADW machine learning models in Oracle Analytics

Oracle supports machine learning within several tools and technologies. One of the oldest technologies that supported machine learning algorithms in database is Oracle Data Mining. This has become the core for Machine Learning for SQL which is part of Oracle Database (at no extra cost to Oracle Database users).  Oracle Analytics now supports integration with Oracle Machine Learning for SQL and can use ML models that are stored in Oracle ADW. In my blog posts I am exploring options which are available to users by using rich and powerful Oracle Autonomous Data Warehouse support for machine learning and flexible data management and visualisation of Oracle Analytics. Using Oracle ADW machine learning models in Oracle Analytics ( part 1 ) and Using Oracle ADW machine learning models in Oracle Analytics ( part 2 ) 

Using Oracle ADW machine learning models in Oracle Analytics (part 2)

In  the 1st part of this blog we have discussed how to create a regression model for numeric prediction of housing prices. I have posted similar post Housing Price Prediction in Oracle Data Visualization , describing how to predict house pricing with machine learning algorithms and data flows available in Oracle Analytics. Register ML model from ADW in Oracle Analytics  Let’s switch to Oracle Analytics now. We need release 5.7 and higher to register and use ML model from ADW. The first step which we need to do is to register ML model from ADW with Oracle Analytics.  If there is no database connection, setup this first from the Create Connection menu from Home Page. Navigate to Machine Learning and then from actions menu (top right corner) select Register ML Model: If no connection is available, choose Create Connection. We have created our connection in the step before, therefore the list of connections is displayed. Choose the connection ... ... and then choose ML model to register.

Using Oracle ADW machine learning models in Oracle Analytics (part 1)

A few weeks ago I was exploring how can Oracle Analytics can be used for housing prices prediction. In my post  Housing Price Prediction in Oracle Data Visualization  I am discussing the tools available in Oracle Analytics to perform the task. In this post (actually there ware 2 parts) I am looking at options that we have in Oracle Analytics if we wanted to use machine learning models that reside in Oracle Autonomous Data Warehouse.  Oracle Data Mining was an Oracle Database option for more than 2 decades now. With advancement of machine learning support in database, it became part of Oracle Advanced Analytics database option. Developers were able to use Oracle Data Mining by using Oracle Data Miner which was part of the Oracle SQL Developer.  Oracle Data Mining is PL/SQL based set of libraries which supported several supervised and unsupervised data mining functions such as classification, regression, clustering, time series analysis and other functions. These functions were support b

Embedding Oracle Analytics content in web pages (part 1)

In many occasions analytics systems users expect that analyses or parts of analyses would be available for the public, exposed through public web pages. And in many instances, this is not so easy to achieve due to security and probably some other reasons.  With Oracle Analytics, we have an option to give public users secure access to analyses we maybe want to share publicly. Exposing content such as charts, graphs and other data visualisations in a web page, portal, Oracle APEX and similar systems has been available for a while.  With the latest versions of Oracle Analytics, token-based authentication in now also supported. In this first blog in this series, we will take a look, how to prepare a HTML file which will present embedded Oracle Analytics project. To start with, we need a web server. For the development it doesn’t have to be really sophisticated one, therefore, I am using a simple apache server installed on my laptop.  We will also need an analysis that was created in Oracle