Tuesday, September 30, 2014

What's in the air @Oracle Openworld 2014

Just came out of the keynote of day 2, the first speaker Dr. Didier Bonnet, SVP and Global Practice Leader at Capgemini  focused on Digital transformation of business. He used examples of Starbucks, Asian Paints, Vail and so on... ""Digital technology will remain the endless agitator of the business world."   It was good to hear GE's Industrial Internet as a transformative concept.

Thomas Kurien spoke at the later half and had several invited folks to show the live demo of many new offerings on the Cloud, Big Data and Analytics front. It was interesting to see the demo using SQL Developer to show the speed-up due to use of in-memory computing. I posted a lot of images from the keynote from my Twitter account    It was interesting to see that Thomas covered mainly Technology topics topics today as against "Applications" topics.

More to come...

Friday, September 26, 2014

Oracle User Group Summit Sep 2014

This year the Oracle User Group Leaders are meeting just before Oracle Openworld world for two days - Sep 25-26, 2014. Selected Oracle User Group Leaders immerse themselves into activities and sessions that help to manage the User Groups, Special Interest Groups (SIG's) and Regional Groups throughout the year. This is a good meeting point of the Leaders from different parts of the world.

Check out the pictures of the activities these such as the Customer Journey map:
https://twitter.com/MeKolbe/status/515272230997983232/photo/1  OR here

I am doing a pitch on Internet on Things (Embrace IoT) later today. More to come...

Tuesday, September 23, 2014

BIWA Summit Jan 27-29 2015 Agenda, Speakers and Workshops

BIWA Summit 2015 Agenda, Speakers and Workshops
Early Accepted Submissions

Track:  Big Data

Big Data SQL: Oracle SQL Access to Hadoop        
Brian Macdonald, Oracle Enterprise Architect
As adoption of Hadoop continues to increase more users are requesting access to the data that on Hadoop.  These users want to continue to use the tools they have and leverage the skills they already know.  The most common way people and tools access data is via SQL.  And for the majority of companies, it is SQL against an Oracle database.  Oracle Big Data SQL provides a mechanism to issue SQL on relational and Hadoop data from one environment.  One fast SQL engine to all your data.  Oracle BIg Data SQL leverage a smart scan service just like Exadata to provide fast performance with all the security and robust capabilities of the Oracle database.  This session will explain what Oracle Big Data SQL is, how it is architectected and what its benefits are to Oracle customers.
Naval Postgraduate School Report on the Oracle Cloudera Solution for Big Data
Tom Plunkett, Principal Consultant and Author, Oracle
This presentation discusses the results from a Naval Postgraduate School report that evaluated the Oracle Cloudera solution for big data in the context of a U.S. Marine Corps logistics project. The team began with a Cloudera Distribution for Hadoop cluster and an Oracle Database. After evaluating the initial architecture, they then evaluated how the Oracle Big Data Connectors and the Oracle Big Data Appliance would increase performance for the U.S. Marine Corps logistics application.
Personalized Healthcare using large genomic datasets and Oracle Exadata
Rene Kuipers     Principal Consultant TRC and Huvariome, VP Technology OBUG VX Company
Personalized diagnostics and hence personalized treatment sounds like Utopia. The road to personalized healthcare is paved with huge amounts of data. Clinical and genomic. It requires specific tools and techniques to handle these amounts of data. With Oracle TRC and Oracle Exadata, this becomes reality.
Query Oracle Database from Hadoop Compute Engines using HiveQL, Impala, SparkQL, Shark
Kuassi Mensah, Director of Product Management, Oracle
For many companies, big data involves relational data such as: point of sales records, financial, medical, intelligence data, call records, stored in Oracle databases. How to query and analyze or correlate relational data in Oracle database using the latest and modern Hadoop compute engines including HiveQL, SparkQL, Impala, Red Shift, etc) without copying data over?  This session describes an HCatalog-based Storage Handler which allows Hadoop compute engines to safely, directly and transparently process relational data w/o copying.  This session will also discuss use cases.

Track:  Advanced Analytics

Massive Predictive Modeling
As enterprises continue to amass data at ever increasing rates and with greater variety -- what is being called “big data” -- the ability to extract value from that data demands high performance and scalable tools -- both in hardware and software. In various industries, enterprise take on massive predictive modeling projects, where the goal is to build models, one per customer, to understand behavior and tailor predictions at the customer level. These predictions can then be aggregated to assess future demand. When there are millions of customers, each with their own accumulated data, such as frequent utility meter readings or retail sales, the scale of such projects takes on a new dimension. Massive predictive modeling comes with challenges: effectively partitioning data, storing and managing resulting models, associating models with customers during prediction, as well as backup, recovery, and security.

While R has parallel capabilities to facilitate taking advantage of clusters of computers, significant coding is usually required to meet the challenges noted above. In this talk, we present the business problem and illustrate how Oracle R Enterprise, one of Oracle's R technologies, facilitates massive predictive modeling in a pair of succinct R scripts. With Oracle R Enterprise, the data, R scripts, and models all reside in Oracle Database, which simplifies and speeds production deployment.

Moving beyond Oracle Data Miner. What the Oracle DBA and Developer needs to know
Brendan Tierney, Oralytics, Oracle ACE Director
What about the Oracle DBA and Oracle Developer about Data Mining? How can the Oracle DBA and Oracle Developer use Data Mining.  This presentation will look at what the Oracle DBA and Oracle Developer needs to know to deploying, implementing and integrating the predictive models produced by the Data Miner. These predictive models can be used in multiple databases and across their many applications. Examples will be given of the typical tasks data mining task for the DBA and for the Oracle Developer. These examples will include SQL, PL/SQL and embedded Oracle R Enterprise functions.

Oracle Data Miner 4.0 Hands on Lab
Charlie Berger, Sr. Dir. Product Management, Oracle Data Mining and Advanced Analytics, Oracle
Bigger Insights!  Oracle Data Mining Release 12c, a component of the Oracle Advanced Analytics database Option, embeds powerful data mining algorithms in the SQL kernel of the Oracle Database for problems such as predicting customer behavior, anticipating churn, identifying up-sell and cross-sell, detecting anomalies and potential fraud, market basket analysis, customer profiling, text mining and retail market basket analysis. Oracle Data Miner 4.0, an Extension to SQL Developer 4.0, enables business analysts to quickly analyze data and visualize data, build, evaluate and apply predictive models and develop sophisticated predictive analytics methodologies---all while keeping the data inside the Oracle Database. Oracle Data Miner's easy to use "drag and drop" paradigm enables data analysts to quickly view and explore their data, build and evaluate predictive models, apply them and immediately generate SQL scripts to accelerate deployment.  Come see how easily you can discover big insights from your Oracle data and generate SQL scripts for deployment and automation and deploying results into Oracle Business Intelligence (OBIEE) dashboards.

Track:  BI and Visualization

Data Visualization for Oracle Business Intelligence 11g
Dan Vlamis, President, Vlamis Software Solutions
The vast majority of organizations who implement one or more of Oracle's Business Intelligence applications end up designing their own dashboards, analyses, and visualizations. During this informative session, we will evaluate several prepackaged dashboards and offer suggestions for extensions and improvements, review dashboard design best practices, and demonstrate cutting edge visualizations. Oracle BI 11g is perhaps the most complete and comprehensive Business Intelligence platform technology, but because it is so powerful and flexible, careful consideration must be given to the visual interface design in order to maximize investment returns. You'll learn best practices in dashboard design along with specific dos and don'ts. You'll see how to customize dashboards using skins, style sheets, and HTML. You'll understand how to extend OBI's native visualizations with Java script and advanced visualizations. You'll see how to adapt and modify your current dashboards, visualizations, and analyses for use with mobile devices such smart phones and tablets.

OBIEE Data Visualization: The "How" and the "Why"
Daniel Adams, Principal Consultant, Rittman Mead
Training seminars are usually delivered as a set of tasks combined by instructions for execution. While this "click here, then here" approach may demonstrate "how" to visualize data using OBIEE, attendees are less likely to understand "why" particular choices were made. What's missing from this paradigm is "content." Without it, users get confused about why they are performing certain tasks. In this results-driven hands-on lab, attendees will build dashboards that use data to tell a story, conform to best practices in dashboard design, and never lose focus on the finished product.

Oracle BI and Geo-Spatial Big Data
Antony Heljula
The role of "Geo-Spatial" data is often overlooked when it comes to "Big Data" analytics.   This presentation aims to demonstrate how Oracle Spatial can significantly extending the capabilities of Oracle BI by providing advanced Geo-Spatial analytics. As well as understanding how maps and spatial can integrate into Oracle BI, delegates will see and learn how to perform advanced Geo-Spatial analysis and appreciate the real Business Value it can deliver to just about any Organization.

Track:  Cloud Computing

Architecting Multi-Tenancy Analytics in the Cloud Using OBIEE, Hadoop and Oracle DB
Mayank Srivastava, Chief Architect, Xtime
Architecting multi-tenancy in OBIEE along with Hadoop and Oracle DB poses multiple challenges which are not encountered in Enterprise IT implementations. Multi-tenancy is key in providing Analytics for Software-as-a-Service in the Cloud. The session will focus on:

- Seamless switching of OBIEE between Oracle DB for Dashboards to Hadoop Big Data for detail reports. This ensures complete synchronization between the strengths of Relational Database and Big Data maximizing the efficiency and productivity of Business Analytics.
- Architecting security based on Tenant serving multi-tenant data from single schema and single database thus minimizing storage and database administration.- Use of Flex Fields for addressing new business requirements for Tenants from the same schema without any change in ETL.

This can reduce turnaround time by 80%.
- Use of Logic Gates for addressing Tenant based aggregation requirements on the same presentation attribute without any change in ETL.
- Use of Dynamic Runtime Binding for Multi Hierarchy (Graph instead of a Tree Hierarchy) to address problem of a child node having multiple parents.
- Use of Tenant based Dynamic report switching on the same Dashboard minimizing new development. This enables to quickly address new reporting business requirements and reducing development time significantly.
- Use of Application Controls to provide customized experience to Tenants from the same stack based on their Service Level Agreements.
- Use of Exchange Partition for data loads to provide extremely high ETL performance without any downtime on single instance of data warehouse thereby reducing storage and processing time.

Track:  Internet of Things

Big Data Analytics for Industrial Internet
Shyam Nath, Principal Architect, GE
This session with showcase the industry landscape of the Internet of Things with focus on Big Things. Learn about the industry use cases for Industrial Internet and how this poses storage challenges for Big Data. Look at the scenarios for applying analytics to harness the full potential of the sensor and machine data along with the rest of the enterprise data.

Rethinking Analytics & Big Data Information Architecture for the Internet of Things
Robert Stackowiak, VP Information Architecture & Big Data, Oracle
This presentation defines what the Internet of Things is, how companies are rethinking their business models as a result, and the critical role of analytics and Big Data in building a solution.  We'll review some of the "out-of-the-box" thinking we've encountered in clients, the emerging reference architecture, and how to apply information architecture best practices to justify these projects.

Track:  Oracle Spatial Summit

Building HTML5 Maps for Web Applications: A Developers Introduction to Oracle MapViewer
LJ Qian, Oracle
MapViewer is a feature of Oracle WebLogic that allows developers to incorporate maps and spatial analysis into business applications. Learn how MapViewer's HTML5-based Javascript API provides users with a much enhanced user experience.

Geomarketing Analysis: a developed solution for Italy's Leading Supermarket Chain, Unicoop Firenze
Michele Sacchi  Business Intelligence Reporting Responsible       Bridge Consulting S.r.l.
Unicoop Firenze is Italy's largest consumer cooperative, with more than one million consumer-members and sales of over 2 billion euros. It deployed a rich location intelligence system, with interactive geomarketing features, including detailed analysis of business facts and dynamic user-defined areas. The Unicoop system includes a geo-datawarehouse with dashboards to better evaluate business opportunities on a specific territory, on the base of statistical and socio-economical data coming from Institutional sources.
Unicoop and system integrator Bridge Consulting deployed this system on an Oracle Database Exadata Machine, using Oracle Business Intelligence Enterprise Edition, Oracle MapViewer, and Oracle Spatial Network Data Model and Geocoding features. The developed solution incorporates all of Business Intelligence systems and all of departmental systems, and supports Marketing, Development and Management divisions analyses.  Dashboard solution includes:
* Territorial analysis of supermarket-receipts
* Analysis of consumer-member behaviors
* Product traceability to contact the customer in case of any fault or problem
* Geomarketing analysis to:
-  Locate relationships of consumers and supermarkets
-  Study the territory capability to locate new stores
-  Study the market share by territories
-  Place Consumer-members, owned and competitor stores 

Bridge Consulting used the Oracle Spatial Network Data Model to generate trade areas (radial, polygonal, isochrones, isodistances), Oracle Spatial functions (sdo_geom) to refine areas dynamically for deep territorial analysis, as well as the integration of the geomarketing features with OBI Publisher. The Oracle Spatial geocoding capability and NOKIA's NAVTEQ ODF dataset were used in constructing the geo-datawarehouse.An excellent Return of Investment was realized from adopting an entire Oracle architecture for a scalable, performant system delivering valuable location intelligence insights.

Oracle BI and Geo-Spatial Big Data
Antony Heljula
The role of ""Geo-Spatial"" data is often overlooked when it comes to ""Big Data"" analytics.   This presentation aims to demonstrate how Oracle Spatial can significantly extending the capabilities of Oracle BI by providing advanced Geo-Spatial analytics.
As well as understanding how maps and spatial can integrate into Oracle BI, delegates will see and learn how to perform advanced Geo-Spatial analysis and appreciate the real Business Value it can deliver to just about any Organization.

Performance Gains with Spatial and Graph Using Oracle Database 12c
Steven Pierce & Nick Salem
One of the most notable improvements with the Oracle Spatial and Graph option for 12c can be seen in performance increases in vector data operations. Enabling the Spatial Vector Acceleration feature dramatically improves the performance of commonly used vector data operations. With 12c, these operations run more efficiently in parallel than in prior versions through the use of metadata caching.
In this presentation, Steve Pierce will present use cases from Think Huddle clients who have migrated to 12c. These will illustrate how performance increases in serialized processing compare to the performance increases seen in parallel processes. These client's stories will demonstrate how parallelism is being used to greatly enhance the performance of batch geocoding. Performance improvements of 40% to 99% will be highlighted.
Nick Salem will share Neustar's experiences with its ElementOne platform, which is built on Oracle Database 12c, Oracle Real Application Clusters, Advanced Security, Partitioning, Spatial and Graph, Oracle WebLogic Server 12c, and Oracle Fusion Middleware MapViewer 12c. ElementOne leverages the latest 12c features in Oracle Spatial and Graph---including vector performance acceleration---for dramatic performance improvements with minimal code changes. In conjunction with other 12c capabilities like in-memory global temporary table, parallel executions, LOB operations, SQL and PL/SQL function and execution enhancements, and cross session result set cache, ElementOne has achieved substantial performance and efficiency gains.

For organizations that are facing processing limitations, learning about these enhancements will enable developers to make a small set of configuration changes and quickly realize significant performance improvements.

Sunday, September 21, 2014

Oracle and Larry Ellison

Lawrence Joseph (Larry) Ellison - The Man the Myth the Legend!
Those were the thoughts when I first heard the news that Larry is stepping down as the CEO of Oracle on Sep 18, 2014, in the middle of my work day. As I scanned the web to read more about the announcement, I was soemwhat relived to read that he will remain the Chairman of the Board as well act as the CTO to focus on Product Engineering. I thought that was interesting, shift of focus from management to product innovation. His successors are no surprises, at least not as much a surprise when Mark Hurd replaced Charles Phillips. Safra Catz has been around for ever in Oracle and Mark brings the experience of running a $100B+ company, HP, prior to his role at Oracle.

Interestingly, this news came just a few days before Oracle Openworld this year. Historically, a lot of announcements are made at Oracle Openworld, well I guess product announcements not people announcements! What I found interesting was that this announcement was part of the quarterly earnings announcements. Over his tenure, the ORCL stock has seen a significant dip after the dot.com crash and it took too long to recover, I think partly due to all the acquisitions like PeopleSoft, Siebel, Hyperion, BEA, Sun and so on. However, on the big picture, the stock is almost back to near top levels, before Larry's resignation or rather I should say shift of focus from management to Product Engineering.

Larry is still on the schedule for Oracle Openworld Keynotes (Sun and Tue). Will he make it, the big question!  I have asked some of the folks who are part of the Oracle eco-system (either as ex-Oracle employees, current professionals via the partner network and so on) whether they like Oracle more or Larry more. I got interesting answers. I hope to carry that conversation at OOW  with IOUG members and other stakeholders, while this topic is still fresh.

Sunday, September 14, 2014

Oracle BIWA and Spatial Summit Jan 27-29 2015 at Oracle HQ in Redwood City, CA

The Annual BIWA Summit will take place Jan 27-29, 2015 at Oracle HQ in Redwood City, CA.

The best way to attend an event for free, is to become a speaker, The call for speakers for the event is open here:   This year IOUG's Spatial SIG and BIWA SIG are joining hands along with NoCOUG, to bring this event together.This implies coverage from Advance Analytics, Big Data, BI, Spatial and Graph, Internet of Things (IoT), Data Warehousing and much more!  See the content from the previous years here.

We will soon post the early acceptance list of the Featured talks and the other sessions from the Industry experts.

Getting Ready for Oracle Openworld 2014 (Sep 28 - Oct 2)

We are two weeks away from Oracle Openworld 2014! One of my favorites are the high profile Keynotes, you can see the lineup here. I noticed that while Larry Ellison used to speak only on Wed afternoon, a few years ago, now he is a regular on Sunday evening and then on Tue this year. The Sunday evening allows a preview of the new announcement at the OOW and those do not have to wait till Wed. There is no title or theme for the Sunday evening keynote by Larry, I guess that leaves room for any new announcements! However, the Intel speaker Renee James will speak on the hot theme today "soft-define anything!"

Unlike last year, when the Thursday keynote by Edward Screven, was about Internet of Things (IoT), there is no talk with specific IoT focus this year. However, both OOW and JavaOne had IoT as a major Track and is full of rich content. I will speaking on a related topic of Industrial Internet / IoT on Sunday under IOUG's user group sessions. On Monday, I will be at an Aerospace and Defense Industry session talk and talk about GE's Industrial Internet efforts for Aviation sector. On Tue, I will help to host a BoF session on use of Java in the Industrial Internet / IoT space. This one is under JavaOne IoT track.

In last few years, most the Wed afternoon talks by Larry was accompanied by the Infosys CEO and seems like this tradition will continue on Tue afternoon.

More to come.... I will be active on Twitter @ShyamVaran