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

Mark Hornick, Director, Oracle Database Advanced Analytics, Oracle

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.
"