oracle open world
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.
|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|
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 (
Step 2 – Turn on Automatic Data Preparation
INSERT INTO Att_Import_Mode_Settings (setting_name, setting_value)
Step 3 – Run Attribute Importance
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’);
Step 4 – Select Attribute Importance results
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
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
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).
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:
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
If you are at Oracle Open World (OOW11) and you have an interest in Oracle Data Miner, check out the following presentation sessions:
In addition to these sessions there are also the following Hands-On Labs, where you can get your hand dirty with the tool.
Do let me know if I have missed a session so that I can update the list.
I’m not attending OOW11 so let me know what the sessions are like.
And tell Charlie that I sent you
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.