oracle open world

Oracle ACE Director

Posted on

Towards the end of last week I received and email from Oracle saying that I had been nominated and accepted, by Oracle, to become an Oracle ACE Director.

This is something that makes me very proud and honours the work I have been doing over the past few years on Data Mining in Oracle (Advanced Analytics Option, Data Science/Predictive Analaytics, or whatever you want to call it). Thank you to everyone who nominated me.

If you are not familiar with the Oracle ACE Program, it is a way for Oracle to acknowledge not only technical skills but also personal engagement with the Oracle Community and Technology overall. There is even a FAQ that explains how this program works.

There are a few perks that come with the title, and Oracle have a few  expectations too. Most of these expectations I’m already doing!!  What I’m looking forward to later this years is my first Oracle ACE Director briefing at Oracle Open World (22-26 September)

OUG Norway April 2013 – New Year’s News

Posted on

I received an email at 23:24 on the 1st January from the OUG in Norway telling me that I’ve had two presentations accepted for the Annual OUG Norway seminar event. This will be on during the 17th-19th April.

The first day of this event (17th April) will be held in a hotel in Oslo. Then on the morning of 18th April we board the Color Magic cruise for the next two days of the conference. The ferry/cruise will go from Oslo to Kiel in Germany and then back again to Oslo, returning around 10am on Saturday 20th April.

I will be giving two presentations on the Oracle Advanced Analytics Option. The first presentation, ‘Using Predictive Analytics in Oracle’, will give an overview of the Oracle Advanced Analytics Option and will then focus on the Oracle Data Miner work-flow tool. This will presentation will include a live demo of using Oracle Data Miner to create some data mining models.

The second presentation, ‘How to Deploy and Use your Oracle Data Miner Models in Production’, builds on the examples given in the first presentation and will show how you can migrate, user and update your Oracle Data Miner models using the features available in SQL and PL/SQL. Again a demo will be given.

OOW content/slides are still available

Posted on

For those people who where lucky to get the Oracle Open World (OOW) and for all the many thousands of people who were not able to make it to OOW, the slides from almost all the presentations are still available.

To get your hands on these presentation slides, all you need to do is to go to the Oracle Open World website

http://www.oracle.com/openworld/index.html

Click on the Tools option on the menu and then click on Schedule Builder. You will need your Oracle Single-Sign-On username and password. Once entered you should get conference content and Schedule page.

image

You can search the content catalog for the presentations you are interested in and download the presentations.

There was been some mutterings that the presentation slides and access to the schedule build will be restricted at some time in the near future.

So get the conference material now.

While you are on the Oracle Open World site, why not sign up for notifications for the 2013 conference. They will probably start around early March.

OOW : Day by Day blog or Not

Posted on

Today Sunday is the first full day for Oracle Open World. Although parts of it started on Saturday with the MySQL conference as was as a number of other briefing type session throughout the day and evening.

One thing that I will not be doing over the course of the next 5 days is to give a day by day account of the different sessions that I attended nor will I be giving updates on what was announced at OOW.

There will be plenty of announcements and there will be many thousands of people who will be tweeting, blogging and writing all kinds of articles about the these.

When the conference finishes up next Thursday I will take some time to write a blog post on what were the main announcements for me and in particular for the Oracle Analytics Option and suppose the whole area people call BIG Data.

The first IOUG BIG Data SIG meeting will be on Tuesday morning from 8:45-9:45, Moscone West, Level 3, Overlook 3.

The main presentation on the Oracle Advanced Analytics Option will be on Wednesday by Charlie Berger (Sr Director for Advanced Analytics). In addition to this presentation there will be a number around the whole ORE and BIG Data. This will rounded off by the Keynote on Thursday morning. Yes that is the morning after the big social event on Wednesday night with Kings of Leon and Peal Jam.

One thing that I will be doing each day will be posting a new review of old Oracle Magazine. So check in daily for those.

The next 5 days will be a bit manic as I try to gain learn lots. The problem here is that my interest span a number of areas. OK the main one is the Oracle Advanced Analytics and BIG Data, but I also have DBA and Developer skills/interests too.

What to do with your Freebies from Oracle Open World

Posted on

With 50,000+ people attending Oracle Open World (and associated other conferences) between 30th September and 4th October, and with over 400 exhibitors, there should lots of freebies available.

What do you do with all of these things like pens, pencils, notebooks, memory sticks, t-shirts, pen pots, stress balls, etc. ?

Do many of these items get given away as presents, gives to your colleagues, or at some point end up in the refuge collect, land fill or recycle centre ?

Why not give these items to primary and secondary schools in Africa?

image

Over the past couple of years I have been collecting some of these kind of things to send out to schools in Africa. What I try to do is to wait until I have enough items that can kit out students in a class with pens, pencils and notepads for a year.

There is no corporate sponsorship of this project that is called Tech Gear for the 3rd World.  I just ask for people to send me their spare items or old corporate items (due to rebranding etc.).  I look after identifying what schools to send the items too, packaging of the items and I pay for the shipping of the parcels to the schools.

So after visiting Oracle Open World you have suitcase full of stuff, or if you are an exhibitor and you have items left over, why not send them to Tech Gear for the 3rd World.

Click here for more details and postal details.

Oracle Magazine Collection

Posted on

Are you going to Oracle Open World & have old Oracle Magazines.
I’ve been working in the Oracle World for 20 years now. During that time I’ve been collecting the print editions of Oracle Magazine since 1992.
I have all the Oracle Magazines from 1998, but I’m missing some of the editions prior to 1998.

Can you help me complete my collection ?   (I promise that you wont find them on ebay!!)

What I would really like to do is to have a print copy of every Oracle Magazine going back to the very first one in June 1987. To see the electronic version of the first edition, which was very kindly made available by Cary Milsap, click here.
image

So in the run up to Oracle Open World could you have a look to see if you have any of my missing editions or any of the early editions. I can collect them off you are Oracle Open World.

If you have a look through my blog you will see that I’ve been posting a review of some of the early editions of Oracle Magazine. Ideally at some time in the future I will have a review of all the Oracle Magazines available.

Oracle Open World Schedule

Posted on

Oracle Open World is fast approaching. Over the past couple of weeks I have been using the schedule builder tool to work out what sessions I would like to attend.  Unfortunately there are LOTS of sessions I would love to attend but I haven’t worked out a way to be in 10 places at the same time.

When attending a conference I try to achieve a number of things. These are find out about new topics/features, benchmark my knowledge of existing topics, try some of the hands-on labs, try something new and do something completely different. This will be my challenge at Oracle Open World.

image

There are a number of other people from Ireland who will be attending OOW, and there are some plans to have an Ireland social event. Plus there is lots of meetings/catch-ups planned too with people I know from the virtual Oracle world.

There will be some people from AIB who will be presenting at OOW. Their presentation will be on the Tuesday morning 10:15-11:00.  I’ll be there.

Other social things that are on include the Oracle ACE dinner, the Oracle Music festival, with Kings of Leon playing support to Pearl Jam on the Wednesdays night.

It is going to be a busy week, an enjoyable week, a week of learning new things and finding out lots of what the 12c database will be like. 

Will I get time to go to everything ?  The simple answer is NO.  So I will just have to try to get to another Oracle Open World soon.

Analytics Sessions at Oracle Open World 2012

Posted on

The content catalog for Oracle Open World 2012 was made public during the week. OOW is on between 30th September and 4th October.

The following table gives a list of most of the Data Analytics type sessions that are currently scheduled.

Why did I pick these sessions? If I was able to go to OOW then these are the sessions I would like to attend. Yes there would be many more sessions I would like to attend on the core DB technology and Development streams.

Session Title Presenters
CON6640 – Database Data Mining: Practical Enterprise R and Oracle Advanced Analytics Husnu Sensoy
CON8688 – Customer Perspectives: Oracle Data Integrator Gurcan Orhan – Software Architect & Senior Developer, Turkcell Technology R&D
Julien Testut – Product Manager, Oracle
HOL10089 – Oracle Big Data Analytics and R George Lumpkin – Vice President, Product Management, Oracle
CON8655 – Tackling Big Data Analytics with Oracle Data Integrator Mala Narasimharajan – Senior Product Marketing Manager, Oracle
Michael Eisterer – Principal Product Manager, Oracle
CON8436 – Data Warehousing and Big Data with the Latest Generation of Database Technology George Lumpkin – Vice President, Product Management, Oracle
CON8424 – Oracle’s Big Data Platform: Settling the Debate Martin Gubar – Director, Oracle
Kuassi Mensah – Director Product Management, Oracle
CON8423 – Finding Gold in Your Data Warehouse: Oracle Advanced Analytics Charles Berger – Senior Director, Product Management, Data Mining and Advanced Analytics, Oracle
CON8764 – Analytics for Oracle Fusion Applications: Overview and Strategy Florian Schouten – Senior Director, Product Management/Strategy, Oracle
CON8330 – Implementing Big Data Solutions: From Theory to Practice Josef Pugh – , Oracle
CON8524 – Oracle TimesTen In-Memory Database for Oracle Exalytics: Overview Tirthankar Lahiri – Senior Director, Oracle
CON9510 – Oracle BI Analytics and Reporting: Where to Start? Mauricio Alvarado – Principal Product Manager, Oracle
CON8438 – Scalable Statistics and Advanced Analytics: Using R in the Enterprise Marcos Arancibia Coddou – Product Manager, Oracle Advanced Analytics, Oracle
CON4951 – Southwestern Energy’s Creation of the Analytical Enterprise Jim Vick – , Southwestern Energy
Richard Solari – Specialist Leader, Deloitte Consulting LLP
CON8311 – Mining Big Data with Semantic Web Technology: Discovering What You Didn’t Know Zhe Wu – Consultant Member of Tech Staff, Oracle
Xavier Lopez – Director, Product Management, Oracle
CON8428 – Analyze This! Analytical Power in SQL, More Than You Ever Dreamt Of Hermann Baer – Director Product Management, Oracle
Andrew Witkowski – Architect, Oracle
CON6143 – Big Data in Financial Services: Technologies, Use Cases, and Implications Omer Trajman – , Cloudera
Ambreesh Khanna – Industry Vice President, Oracle
Sunil Mathew – Senior Director, Financial Services Industry Technology, Oracle
CON8425 – Big Data: The Big Story Jean-Pierre Dijcks – Sr. Principal Product Manager, Oracle
CON10327 – Recommendations in R: Scaling from Small to Big Data Mark Hornick – Senior Manager, Oracle

ODM–Attribute Importance using PL/SQL API

Posted on

In a previous blog post I explained what attribute importance is and how it can be used in the Oracle Data Miner tool (click here to see blog post).

In this post I want to show you how to perform the same task using the ODM PL/SQL API.

The ODM tool makes extensive use of the Automatic Data Preparation (ADP) function. ADP performs some data transformations such as binning, normalization and outlier treatment of the data based on the requirements of each of the data mining algorithms. In addition to these transformations we can specify our own transformations.  We do this by creating a setting tables which will contain the settings and transformations we can the data mining algorithm to perform on the data.

ADP is automatically turned on when using the ODM tool in SQL Developer. This is not the case when using the ODM PL/SQL API. So before we can run the Attribute Importance function we need to turn on ADP.

Step 1 – Create the setting table

CREATE TABLE Att_Import_Mode_Settings (
  setting_name  VARCHAR2(30),
  setting_value VARCHAR2(30));

Step 2 – Turn on Automatic Data Preparation

BEGIN
   INSERT INTO Att_Import_Mode_Settings (setting_name, setting_value)
   VALUES (dbms_data_mining.prep_auto,dbms_data_mining.prep_auto_on);
  COMMIT;
END;

Step 3 – Run Attribute Importance

BEGIN
  DBMS_DATA_MINING.CREATE_MODEL(
    model_name => ‘Attribute_Importance_Test’,
    mining_function  => DBMS_DATA_MINING.ATTRIBUTE_IMPORTANCE,
    data_table_name  > ‘mining_data_build_v’,
    case_id_column_name => ‘cust_id’,
    target_column_name  => ‘affinity_card’,
    settings_table_name => ‘Att_Import_Mode_Settings’);
END;

Step 4 – Select Attribute Importance results

SELECT *
FROM TABLE(DBMS_DATA_MINING.GET_MODEL_DETAILS_AI(‘Attribute_Importance_Test’))
ORDER BY RANK;

ATTRIBUTE_NAME       IMPORTANCE_VALUE       RANK
——————– —————- ———-
HOUSEHOLD_SIZE             .158945397          1
CUST_MARITAL_STATUS        .158165841          2
YRS_RESIDENCE              .094052102          3
EDUCATION                  .086260794          4
AGE                        .084903512          5
OCCUPATION                 .075209339          6
Y_BOX_GAMES                .063039952          7
HOME_THEATER_PACKAGE       .056458722          8
CUST_GENDER                .035264741          9
BOOKKEEPING_APPLICAT       .019204751         10
ION

CUST_INCOME_LEVEL                   0         11
BULK_PACK_DISKETTES                 0         11
OS_DOC_SET_KANJI                    0         11
PRINTER_SUPPLIES                    0         11
COUNTRY_NAME                        0         11
FLAT_PANEL_MONITOR                  0         11

Tom Kyte Seminar Day–Dublin

Posted on

On Wednesday 2nd December, I attended a full day of presentations given by Tom Kyte of Oracle (asktom.oracle.com). Tom covered a number of topics and these included some of his Oracle Open World presentations.

The topics that were covered included

  • 5 things about SQL (OOW11)
  • Database Option Packs
  • 5 things about PL/SQL (OOW11)
  • Q&A Ask Tom Session

All of these presentations can be downloaded from Tom’s website www.asktom.com.

Tom wont be presenting at the annual UKOUG conference in December, but he is hoping to be there next year (2012).

IMG_0749

Oracle Exalytics

Posted on

At Oracle Open World it was announced the new Exalytics Business Intelligence machine.

The Oracle white paper on Exalytics can be found here.

From page 10 onwards we get some images of what we can get out of this machine.

image

OOW Focus on Sessions

Posted on

Oracle Open World has a huge number of sessions commencing on Sunday and run until Thursday.  To help attendees and non-attendees work out what sessions are available you can work your way through the schedule builder.

This can be a bit difficult to find the sessions that you might be interested in. So this year they have produced a set of Focus On documents that contain all the session related to particular areas.

The following are the available Focus On areas and documents:

Big Data

Data Warehousing

EPM and BI

MySQL

Database Security

Application Development

Database Utilities

Linux

User Productivity Kit (UPK)

Exalogic Elastic Cloud

Public Sector

Primavera

Spatial & MapViewer

Semantic Technology

Let me know if I have missed any Focus On documents and I will update the list.

Oh and don’t forget the Oracle Data Miner sessions

If you are not able to attend OOW, you can check out the OOW Live channel on YouTube to watch the keynote and main session

http://www.youtube.com/Oracle?src=7308729&Act=99&pcode=WWMK11042185MPP039