In a previous blog post I talked about how you can rename and comment your Oracle Data Mining models. This is to allow you to easily to see and understand the intended use of the data mining model.
Another feature available to you is to audit the usage of the the data mining models. As your data mining environment grows to many 10s or more typically 100s of models, you will need to have some (more...)
As your company evolves with their data mining projects, the number of models produced and in use in production will increase dramatically.
Care needs to be taken when it comes to managing these. This includes using meaningful names, adding descriptions of what the model is about or for, and being able to track their usage, etc.
I will look at tracking the usage of the models in another blog post, but the following gives examples (more...)
A few weeks ago the 12.2 Oracle Database was released on the cloud. I immediately set an account and got my 12.2 DBaaS setup. This was a relatively painless process and quick.
For me I wanted to test out all the new Oracle Advanced Analytics new features and the new features in SQL Developer 4.2 that only become visible when you are using the 12.2 Database.
When you are go to (more...)
English version below Op donderdag 15 en vrijdag 16 juni 2017 organiseert de OGh haar eerste Tech Experience 2017, dit is een samensmelting van de succesvolle OGh Fusion Middleware Experience en de DBA & SQL Celebration Day. Dit tweedaagse event zal dus de complete Oracle Stack bedienen. Het zal gehouden worden in de rijtuigenloods in Amersfoort … Continue reading "Call for Papers Tech Experience 2017 is open!"
When working with the Clustering algorithms, and particularly k-Means, in the Oracle Data Miner tool there is no way of seeing how compact or dispersed the data is within a cluster.
There are a number of measures typically used in various tools and algorithms, but with Oracle Data Miner we are not presented with any of this information.
But if we flip from using the Oracle Data Miner tool to using SQL we can get (more...)
Yes you read the title of this blog post correctly!
Recently I was doing a bit a clear out and I came across a CD of the UKOUG Conference proceedings from 1999. That was my second UKOUG conference and how times have changed.
The CD contained all the conference proceedings consisting of slides and papers.
Here are some familiar names from back in 1999 who you may find presenting at this years conference, some you (more...)
Here is another email we got Wednesday from a Dodeca Excel Add-In for Essbase customer. This customer has a lot of VBA macros running some automation with Essbase and asked for some assistance. We told it was as easy as replacing they Essbase function declarations file with our Dodeca Add-In function declarations file, and then setting the variables that contain the location for the Dodeca-Essbase server. In other words, replace this file:
With this file:
If you are a user of the Oracle Data Miner tool (the workflow data mining tool that is part of SQL Developer), then you will have noticed that for many of the algorithms you can specify a Case Id attribute along with, say, the target attribute.
The idea is that you have one attribute that is a unique identifier for each case record. This may or may not be the case in your data model (more...)
Finally, I found something that I was looking for a long time, thought is would be very useful. A simplified maze of #MachineLearning #Algorithm feeling like Nirvana Today #MachinesWouldRuleWorld #AdvanceAnalytics
Hope this helps
Sunil S Ranka
“Superior Data Analytics is the antidote to Business Failure”
The Oracle 12.2c Database has been released and is currently available as a Cloud Service. The on-site version should be with us soon.
A few weeks ago I listed some of the new features that you will find in the Oracle Data Miner GUI tool (check out that blog post). I'll have another blog post soon that looks a bit closer at how the new OAA features are exposed in this tool.
Last week I read an article from Bernard Marr about why #SelfService #BI, #Analytics and #Reporting might not be such a good idea. There is a growing need with Business Users to do things themselves. The world is changing fast and there are situations where people want to act quickly to stay ahead of the … Continue reading "Self Service Business Analytics is great but there is more."
Have you ever been faced with having to generate a data set in the format that is needed by another analytics tool? or having to generate a data set in a particular format but you don't have the software that generates that format? For example, if you are submitting data to the FDA and other bodies, you may need to submit the data in a SAS formatted file. There are a few ways you can (more...)
In this 5th blog post in my series on using the capabilities of Oracle Text, Oracle R Enterprise and Oracle Data Mining to process documents and text, I will have a look at some of the machine learning features of Oracle Text.
Oracle Text comes with a number of machine learning algorithms. These can be divided into two types. The first is called 'Supervised Learning' where we have two machine learning algorithms for classification type (more...)
Last Thursday evening (20th October) we had our first Meet-up event for OUG Ireland.
Up to recently we have had a one or two full day SIG events that covered both the Tech and BA/Big Data areas. But we have been finding it increasingly difficult to get speakers and attendees to take a full day out of work to attend the SIG events. This was particularly true for a SIG event we had scheduled to (more...)
With each new release of the Oracle Data Miner (ODMr) tool (part of SQL Developer) an upgrade of your ODMr Repository is needed. This is because of the numerous new features in the tool. This is particularly the case with ODMr (SQLDev) 4.2.
No most of the new features for ODMr 4.2 will not be visible until you are running a 12.2 Database. But a small number of new features are available (more...)
One of Oracle’s focus points within the Oracle Business Analytics Suite is Oracle Data Visualisation. The Oracle Business Analytics Strategy is based on three pillars. One of these pillars is; “See the Signals”, Visual Analytics in every solution. It doesn’t matter whether you run Oracle Business Analytics in the Cloud or On-Prem, Stand-alone or integrated in … Continue reading "Oracle Data Visualisation License Pricing"
This blog post is my contribution to the OTN Appreciation Day, the brain child of Tim Hall (read his blog post here).
For my contribution, I'm going to write about something that is a bit different to what most people will be writing about. Most people will be writing about some feature of the Oracle Database or maybe their favourite tool.
I'm not going to do that. What I'm going to write about (more...)
Come along to the first OUG Ireland meet-up on the 20th October, in Bank of Ireland, Grand Canal Dock, Dublin, between 18:15 and 20:00.
Over the years the OUG Ireland SIG committee have organised one day SIG events once or twice a year. This is in addition to the annual OUG Ireland conference (typically held in March). Sometimes it has been a challenge to get people to attend, sometimes it has been a challenge to (more...)
A couple of weeks ago during the madness of Oracle Open World there was some new product releases and lots of updates to existing products.
One such product was SQL Developer. They released an Early Adopter version (EA1). This is where you can try out the new version of the product, but you need to be careful as it is not the GA/Production version. So it may have some "features".
One component of SQL Developer (more...)