Profiles of the Future

I've been thinking about the laws of the universe recently and came across a book written by the science fiction master Arthur C. Clarke called Profiles of the Future. Over the course of many years and several revisions he put forward the hypothesis that there are 3 laws for predicting the future. These are:
Clarke's first law
When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he (more...)

The Quistor Business Analytics & Big Data Practice is expanding

  We are expanding our Quistor Business Analytics & Big Data Practice. Therefore we are looking for new colleagues. Please find the vacancies for a Senior Oracle Business Analytics Consultant and a Senior Oracle Data Integrator Consultant below. Senior Oracle Business Analytics Consultant Senior Oracle Data Integrator Consultant Please get into contact with me or … Continue reading "The Quistor Business Analytics & Big Data Practice is expanding"

Slides from the OUG Ireland meet-ups

I've finally gotten the time (and the permissions from the presenters) to make the slides from the first two OUG Ireland meet-ups available.

I've posted them on SlideShare and I've embedded them in this blog post too.

Formatting results from ORE script in a SELECT statement

This blog post looks at how to format the output or the returned returns from an Oracle R Enterprise (ORE), user defined R function, that is run using a SELECT statement in SQL.

Sometimes this can be a bit of a challenge to work out, but it can be relatively easy once you have figured out how to do it. The following examples works through some scenarios of different results sets from a user defined (more...)

Oracle Data Miner 4.2 New Features

Oracle Data Miner 4.2 (part of SQL Developer 4.2) got released as an Early Adopter versions (EA) a few weeks ago.

I had an earlier blog post that looked that the new Oracle Advanced Analytics in-database new features with the Oracle 12.2 Database.

With the new/updated Oracle Data Miner (ODMr) there are a number of new features. These can be categories as 1) features all ODMr users can use now, 2) New (more...)

Explicit Semantic Analysis setup using SQL and PL/SQL

In my previous blog post I introduced the new Explicit Semantic Analysis (ESA) algorithm and gave an example of how you can build an ESA model and use it. Check out this link for that blog post.

In this blog post I will show you how you can manually create an ESA model. The reason that I'm showing you this way is that the workflow (in ODMr and it's scheduler) may not be for everyone. (more...)

next OUG Ireland Meet-up on 12th Janiary


Our next OUG Ireland Meet-up with be on Thursday 12th January, 2017.

The theme for this meet up is DevOps and How to Migrate to the Cloud.

Come along on the night here about these topics and how companies in Ireland are doing these things.

Venue : Bank of Ireland, Grand Canal Dock, Dublin.

The agenda for the meet-up is:

18:00-18:20 Sign-in, meet and greet, networking, grab some refreshments, etc

18:20-18:30 : Introductions & Welcome, (more...)

Explicit Semantic Analysis in Oracle 12.2c Database

A new Oracle Data Mining algorithm in the Oracle 12.2c Database is called Explicit Semantic Analysis.

[The following examples are built using Oracle Data Miner 4.2 (SQL Developer 4.2) and the Oracle 12.2 Database cloud service (extreme edition) ]

The Explicit Semantic Analysis algorithm is an unsupervised algorithm used for feature extraction. ESA does not discover latent features but instead uses explicit features based on an existing knowledge base. There (more...)

Essbase Cloud Service Webcast Available Online

Essbase Cloud Service is coming soon and, if you haven't had a chance to learn about it, here is how you can learn about it at your leisure. Oracle had a public webcast about two weeks ago and have made both the webcast and the slides available; you must have an Oracle login to see it. Here is the link to the EssCS webcast:

EssCS Webcast

And here is a link to the slides:

EssCS (more...)

The neo-MUD tunnel for OBIEE 11g RPD deployment

Ok call me a geek for writing it on new year's eve, I dont care :-P. I can tell you that this blog is totally worth it. Let's get right into it.
We know that EM can be used for deployment but we had a requirement to maintain a log every time a deployment is done so that we can keep a track of the changes been done to the RPD.
I developed the  Multi (more...)

2016: A review of the year

As 2016 draws to a close I like to look back at what I have achieved over the year. Most of the following achievements are based on my work with the Oracle User Group community. I have some other achievements are are related to the day jobs (Yes I have multiple day jobs), but I won't go into those here.

As you can see from the following 2016 was another busy year. There was lots (more...)

New pricing for Oracle BICS & DVCS

For those who have missed the news, Oracle has lowered the prices for Oracle Business Intelligence Cloud Service (BICS) and Oracle Data Visualization Cloud Service (DVCS)! Find below the list pricing per month for both products: ** BICS ** Oracle Business Intelligence Cloud Service: 130 euro per month, per user Oracle Database Schema Service: 868 … Continue reading "New pricing for Oracle BICS & DVCS"

Auditing Oracle Data Mining model usage

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...)

Renaming & Commenting Oracle Data Mining Models

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...)

12.2 DBaaS (Extreme Edition) possible bug/issue with the DB install/setup

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...)

Call for Papers Tech Experience 2017 is open!

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!"

Evaluating Cluster Dispersion in Oracle Data Mining

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...)

UKOUG Conference 1999 : Who was there & what they were talking about

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...)

Another Thanksgiving Email

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:

Happy Thanksgiving (Featuring an Email That I Am Thankful For)

I get tons of email every day and often have hundreds of emails that have to track on a daily basis which explains, in part, my absence from doing recent blog entries.   Most of the emails I track are sales and support relating to Dodeca.  After all, with Dodeca, the buck stops here, right?  I also get some spam in the mix.  Sometimes, there is an email that really makes my day.  Here is (more...)