2014 A review of the year as an ACED

As 2014 draws to a close I working on finishing off a number of tasks and projects. One of these tasks is an annual one for me. The task is to list all the things I've done as an Oracle ACE Director. If has been a very busy year, not just with ACE activities but also work wise too. That will explain why I have been a bit quiet on the blogging side of things (more...)

ODMr 4.1 EA1 Repository Upgrade

If you are downloading the EA1 of SQL Developer that includes Oracle Data Miner (ODMr), and you intend to use Oracle Data Miner then you will need to update the ODMr Repository.

You could do it the hard way and run the upgrade repository sql scripts that are located in the ...sqldeveloper-4.1.0.17.29-no-jresqldeveloperdataminerscripts directory.

Or you could do it the easy way and let the inbuilt functionality in Oracle Data Miner do (more...)

What makes MapR superior to other Hadoop distributions?

These days Hortonworks with their IPO and Cloudera sitting on $1bn of cash grab all the headlines. However,the real visionary in the field is someone else. Someone blasting the previous world record in TeraSort . A Hadoop distribution on both Amazon Web Services and the Google Compute Engine. A company that Google is invested in. While their competitors have been in skirmishes with each other, MapR has been quietly working away and innovating.

MapR-FS: Features and (more...)

Oracle Data Miner (SQL Dev) 4.1 EA1

A few days ago the first Early Adaptor release of SQL Developer 4.1 (EA1) was made available. You can go ahead and download it from here and make sure to check out the blog post by Jeff Smith on some install and setup that is required around the latest version of Java.

I've been using SQL Developer since its very first release, so getting my hands on a new release is very exciting. There (more...)

Easy method to create BIP 11g reports on top of OBIEE dashboards

This blog talks about a quick way to create BIP reports on top of OBIEE dashboards.

I have used 2 graphs from Sample Sales catalog for the purpose of this demo.














Edit the dashboard














Select the Print Options link








Select Custom Print Layouts -> Create Layouts











Thats it, OBIEE will do all the work of creating a layout and a data model for you.
















Hit the View Report button to see your report.














You will (more...)

File Encoding in the Next Generation Outline Extractor

We had a couple of issues reported with the output of the Next Generation Outline Extractor where the exported file did not work properly as a load file. After some investigation, we found that the file encoding was incorrect. We were encoding the files using the Unicode/UTF-8 format. We chose this encoding so that we could write all characters in all languages, but we did not consider that UTF-8 is only valid for loading Unicode (more...)

Preparing for TOGAF 9 and ArchiMate 2 Exams

Last week I posted a blog that I had passed my TOGAF 9 and ArchiMate 2 Certification Exams. Find below the two presentations I made for myself to help me study. It’s certainly not enough information to pass both exams, but it might help to get the bigger picture. TOGAF 9  ArchiMate 2   I hope these…Read more Preparing for TOGAF 9 and ArchiMate 2 Exams

UKOUG 2015 Conferences

The UKOUG annual conferences commence on Sunday 7th December and run until Wednesday 10th.

Like previous years there are two conferences, one called TECH15 and the other is called APPS15. You might guess what each conference is about!!.

This year these conferences are being held at the same time and in the same venue. But they are separate conferences!.

This year I've been very lucky (or very unlucky) to have 3 presentations at these conferences. (more...)

TOGAF 9 and ArchiMate 2 Certified

The world is changing. People are asking for new kinds of rapidly changing data. This has a big impact on Business Intelligence and Information Management as we have known it for a long time. Therefore I look with great interest in Information Management Architectures in general and Oracle BI Solution Architectures in particular. Information Management Architectures…Read more TOGAF 9 and ArchiMate 2 Certified

Trends in Big Data, Hadoop, Business Intelligence, Analytics and Dashboards

How has the interest in Big Data, Hadoop, Business Intelligence, Analytics and Dashboards changed over the years?

One easy way to gauge the interest is to measure how much news is generated for the related term and Google Trends allows you do that very easily.

After plugging all of the above terms in Google trends and further analysis leads to the following visualizations.

Aggregating the results by year

Image

 

It is very amazing to see (more...)

Auto Sales Data Visualization by Manufacturer

Data: Edmunds

Image

 

Top Manufacturer

Image

 

Quarterly breakup of units sold by manufacturer

Image

 

View the interactive visualizations

Active directory configuration in OBIEE 11.1.1.7


We will learn about configuring Active Directory (AD) for OBIEE 11.1.1.7 today.

We will create a new security realm and configure the default authenticator as well as the AD authenticator. Configuring 2 authentication providers will ensure that users such as weblogic continue to function (since they will be authenticated by the default authenticator) and users from the AD are also able to login (authenticated by the AD authentication provider). We will mark (more...)

Holiday Sales by category

Image

Fresh and Frozen Fruit consumption – U.S. Bureau of Labor Statistics

The south and the West consume highest amount of Fruits.

Image

Here is more individual breakdown by Quarterly expenditure on Fruits (figures in 100 million)

Image

Image

Image

Visualization on How the undergraduate tuition has increased over the years

Average undergraduate tuition and fees and room and board rates

Source: http://nces.ed.gov/

Image

These figures are inflation adjusted and look how just the tuition fees have increased compared to the Dorm and Board rates

Now comparing the rate increase for 2-year program

Image

So for the 2 year program, the board rates have remained at the same level compared to the dorm rates.

Now check out the interesting graph for 4 year program below

Image

 

(more...)

OUG Ireland 2015 : Now open for Submissions

OUG Ireland Call for submissions is now open.

The closing date for submissions is 5th January, 2015.

and the submission webpage can be found here.

Ougire15 hp cfp v2

The OUG Ireland conference will be on Thursday 19th March. Yes it is only a one day conference :-( but we will be 5 or 6 or more streams. So there will be something for everyone and plenty of choice.

On Friday 20th March we will have Maria Colgan, formally (more...)

Approximate Count Distinct (12.1.0.2 new feature)

With the release of the Oracle Database 12.1.0.2 there was a number of new features and options. Most of the publicity has been around the in-Memory option. But there was lots of other features for the DBA and a few for the developer.

One of the new SQL functions is the APPROX_COUNT_DISTINCT(). This function is different to the tradition count distinct, COUNT(DISTINCT expression), in that is performs an approximate count distinct. (more...)

ODMr : Graph Node: Zooming in on Graphs

When Oracle Data Miner (ODMr) 4.0 (which is part of SQL Developer) came out back in late 2013 there was a number of new features added to the tool. One of these was a Graph node that allows us to create various graphs and charts that include Line, Scatter, Bar, Histogram and Box plot.

I've been using this node recently to produce graphs and particularly scatter plots. I've been using the scatter plots to (more...)

50 years of killing Deer – Data visualization and analysis

Virginia maintains the summary of Deer kills way back from 1947

The stack bar gives a total view of the killings and how it has grown over the years

Image

 

By comparing the killings on a line chart we see that the female Deer killings has an uptick from 2008 onwards

Image

USA War Casualties

iCasualties.org maintains documented list of all fatalities for Iraq and Afghanistan wars.

Analysing the USA dataset, we summarize the results by the year

 

Image

USA war fatalities by year

We are approaching the levels of 2002 and hope for the best that we don’t have to suffer another wars.

Here is another view by year and month

 

 

The dataset contains the age of each (more...)