oracle open world

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
Advertisements

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

Check out Oracle Data Miner at OOW 11

Posted on

If you are at Oracle Open World (OOW11) and you have an interest in Oracle Data Miner, check out the following presentation sessions:
image
In addition to these sessions there are also the following Hands-On Labs, where you can get your hand dirty with the tool.
image
Do let me know if I have missed a session so that I can update the list.
I’m not attending OOW11 Sad smile so let me know what the sessions are like.

And tell Charlie that I sent you

What to do with your OOW free stuff

Posted on

For those lucky people who are heading off to Oracle Open World, there is something I would like you to consider doing for me.

At OOW you will be collecting lots of free stuff. I’m hearing rumours that OTN will have lots of t-shirts, etc and for the Oracle ACE’s some new vests. Or perhaps you are an exhibitor who will be trying to give away some of your merchandised stuff.

Well instead of giving these items as presents, or carefully filled away somewhere in your office or at home, why not donate it to school children in Tanzania.

I’ve recently started a charity called Tech Gear for the Third World. This allows companies and individuals to donate their merchandised items to a good cause. It also helps companies to donate their surplus or old branded goods.

More details and a shipping address can be could here.