Thursday's Top Picks at OpenWorld for Data Warehousing and Big Data

Attend my top must-attend sessions and hands-on labs for Thursday. You can add them to your personal agenda with there "My Schedule” schedule feature on the OpenWorld content catalog. Enjoy #oow16, today is the last day and it's going to be awesome.

Big Data

8:00AM - 9:00AM
LAB: Use Oracle Big Data SQL to Analyze Data Across Oracle Database, Hadoop, and NoSQL
Hotel Nikko—Bay View (25th Floor)

Martin Gubar, Director of Product Management, Oracle
Keith Laker, Senior Principal Product Managerm Oracle
Organizations are expanding their data management platform including data stores based on Hadoop technologies and NoSQL databases. These data sources may contain new types of data that were not previously captured in the data warehouse, provide historical data that must be retained for compliance, and more. Oracle Big Data SQL enables existing applications that query Oracle Database to analyze data from all these sources, utilizing Oracle's rich SQL support and security policies. This hands-on lab introduces you to how this is achieved: providing access to big data sources, implementing unified security, and delivering analyses that combine and correlate all data.
View in online content catalog click here

LAB: Using Oracle Database 12c as a NoSQL JavaScript Object Notation Document Store
Mark Drake, Product Manager, Oracle

Hotel Nikko—Golden Gate (25th Floor)
The schemaless nature of JavaScript Object Notation (JSON) has enabled it to become an extremely popular method for persisting application data. Oracle Database 12c introduces new features that enable the database to be used as a JSON document store and provide full support for schemaless development. This latest version can store, index, and query JSON content in a highly performant manner. It also enables SQL to be used to query JSON content and join JSON content with relational data, spatial data, and XML. This hands-on lab provides an introduction to the JSON-related features of Oracle Database 12c as well as new RESTFUL services that make it possible to work with JSON content without requiring detailed knowledge of SQL.
View in online content catalog click here

9:30AM - 10:15AM
A RESTful Microservice for JSON in Oracle Database 12c Release 2
Kuassi Mensah, Director, Product Management, Oracle
Paul Lo, Senior Director, Oracle

Park Central—Olympic
The monolithic web application is dead; this is the era of service-based architecture, microservices, and functional and reactive programming. A modern web application is an assembly of services or microservices, each with its own implementation. In this technical session learn the steps for implementing a JavaScript microservice for data processing directly in Oracle Database. This microservice processes JavaScript Object Notation documents in place, and returns only the result sets. The session also shows how to turn such microservice into a RESTful data service for cloud deployment.
View in online content catalog click here

Multitenancy at Wells Fargo Bank
Gerald Bowers, Database Administrator, Wells Fargo
Michael Anderson, Database Administrator, Wells Fargo

Park Central—Franciscan I
Wells Fargo Bank shares its experience with implementing Oracle Multitenant as part of a large-scale Oracle Exadata deployment. The Oracle Multitenant option is a vital component that will enable Wells Fargo to reach desired consolidation densities. The session covers data-gathering and planning for consolidation, consolidation selection criteria, impacts to existing processes, resource management, integration with other Oracle products, and database provisioning, and provides tips and future directions.
View in online content catalog click here

SAS to Oracle Advanced Analytics Migration at Zagrebacka Banka, UniCredit
Charlie Berger, Oracle
Sinisa Behin, Head of IT CRM function, Zagrebacka banka - UniCredit Group

Moscone South—104
With 25 percent market share, Zagreba─Źka banka (ZABA), part of UniCredit Group, is the leading Croatian financial institution. ZABA migrated from SAS to Oracle and increased bank performance using Oracle Advanced Analytics. SAS required data movement for predictive modeling and took days to complete. ZABA reduced this to seconds, minutes, and hours by leveraging the security, reliability, performance, and scalability of Oracle Database and Oracle Advanced Analytics and running data preparation, model building, and scoring inside Oracle. ZABA saved 1,000 person-days/year in IT and increased cash loans by 15 percent in 18 months due to improved hit ratios. Join this session to hear what is next in big data analytics at ZABA, and learn how to do more for less with Oracle Advanced Analytics.
View in online content catalog click here

9:45AM - 10:45AM
LAB: Getting Started with Oracle REST Data Services
Jeff Smith, Senior Principal Product Manager, Oracle
Kris Rice, Senior Director, Oracle
Colm Divilly, Consulting Member of Technical Staff, Oracle
Elizabeth Saunders, Principal Software Developer, Oracle
Gordon Smith, Director, ORDS Product Management, Oracle

Hotel Nikko—Bay View (25th Floor)
In this session learn how to quickly get up to speed with Oracle REST Data Services by using Oracle SQL Developer to quickly install Oracle REST Data Services and AutoREST-enable your database objects. This hands-on lab walks attendees through the full REST development to create and test a RESTful service, use parameters and feeds, insert and update data, and view results in JavaScript Object Notation in the web browser. In addition, the lab demonstrates how to configure security in Oracle REST Data Services using OAUTH2 authentication.
View in online content catalog click here

LAB: Oracle Database In-Memory Boot Camp: Everything You Need to Know
Andy Rivenes, Senior Principal Product Manager, Oracle
Vineet Marwah, Sr. Director, Oracle

Hotel Nikko—Golden Gate (25th Floor)
Oracle Database In-Memory introduces a new in-memory-only columnar format and a new set of SQL execution optimizations such as SIMD processing, column elimination, storage indexes, and in-memory aggregation, all of which are designed specifically for the new columnar format. This hands-on lab provides a step-by-step guide on how to get started with Oracle Database In-Memory and how to identify which of the optimizations are being used and how your SQL statements benefit from them. Experience firsthand just how easy it is to start taking advantage of this technology and the incredible performance improvements it has to offer.
View in online content catalog click here

10:45AM - 11:30AM
360-Degree Customer Predictive Analytics in the Cloud with Clear Visibility
Charlie Berger, Oracle
Ray Owens, President, DX Marketing
Michelle Plecha, Senior Data Scientist, DX Marketing

Park Central—Franciscan I
DX Marketing, a data-driven marketing firm, uses Oracle Database Cloud Service, Oracle Advanced Analytics, and Oracle Marketing Cloud Service to build 360-degree predictive analytics models for its clients, faster and with greater ease than ever before. Faced with the challenge of dealing with hundreds of millions of records and separate analytical servers, DX Marketing moved everything to the Oracle Cloud. In this session learn how it is realizing greater performance, security, and huge productivity improvements to reach its goal of delivering best-in-class predictive models for clients. Come hear from DX Marketing and Oracle how easy it is to fly through volumes of data in the cloud extracting actionable analytics.
View in online content catalog click here

Build Applications on Spark, Hadoop, and NoSQL with Oracle Big Data Spatial
Siva Ravada, Oracle
Alan Wu, Oracle, Oracle
James Steiner, Oracle

Park Central—Olympic
In this session learn about graph and spatial technologies for Spark, Hadoop, and NoSQL, and how to build analytic applications using languages and tools such as R, Python, Scala, and Java. Oracle Big Data Spatial and Graph offers a set of analytic algorithms, services, and data models that support big data workloads. Data scientists and developers can be more productive by using dozens of prebuilt, parallel, in-memory graph analytics functions and spatial functions and services. Analysts can discover relationships and connections among customers, organizations, and assets using graphs. Users can harmonize data and group results based on spatial relationships, in addition to applying spatial services to cleanse, filter, normalize, and process geospatial data sets.
View in online content catalog click here

IoT and Big Data Application Development for Analytics: Industry Use Cases
Balaji Ramachandran, CEO, SoftClouds LLC
Carla Romano, Director - Development, Oracle
Chris Fox, Director, Enterprise Architecture, Oracle

Moscone South—104
In this session learn how to develop analytic applications that integrate all kinds of data, including streaming data, to gain valuable real-time situational and context-sensitive intelligence. In addition, see how the new ecosystem can generate new (and potentially disruptive) products and services and generate requirements and priorities for standards organizations supporting the industrial internet.
View in online content catalog click here

Thinking Clearly About Database Application Architecture
Gerald Venzl, Principal Product Manager, Oracle
Bryn Llewellyn, Distinguished Product Manager, Database Division, Oracle
Connor Mcdonald, Developer Advocate for SQL, Oracle
Toon Koppelaars, Consulting Member of Technical Staff, Real World Performance Group, Oracle
Cary Millsap, Infrastructure Principal Director, Method R Corporation

Moscone South—103
The panelists strive to deserve their “Database Scientist” informal job titles by drawing their understanding of the correctness, security, and performance properties of applications that use Oracle Database from the data that proactive, empirical investigation yields. Like all scientists, they appreciate that future experiments might prompt the modification of current understanding. With this ordinary caveat, they confidently promote the understanding born of the current corpus of evidence: that the optimal database architecture starts with a carefully designed data model, manipulated by humanly composed SQL, encapsulated in PL/SQL. Come to hear them present their evidence. Challenge them with your own. They love a feisty debate.
View in online content catalog click here

11:30AM - 12:30PM
LAB: Oracle Database Cloud: Let’s Get Started
Manoj Moteka, Principal Member of Technical Staff, Oracle
Brian Spendolini, Oracle
Kris Bhanushali, Sr. Principal Product Manager, Oracle
Arindam Bose, Product Manager, Oracle

Hotel Nikko—Mendocino I/II (2nd Floor)
In this session get your first taste of Oracle Database Cloud. Create a cloud database from scratch with a few click of the mouse, and change access rules with the compute console enabling web, monitoring, and command line entry. Then see how Oracle Database Cloud can be scaled up in real time adding memory and CPU and storage. Experience the various application development, database monitoring, and administration console available via web access.
View in online content catalog click here

LAB: Upgrade and Migrate to Oracle Database 12c Release 2
Mike Dietrich, Oracle

Hotel Nikko—Bay View (25th Floor)
In this hands-on lab learn about new ways to upgrade, migrate, and consolidate databases in Oracle Database 12c Release 2. Learn to Upgrade a database to Oracle Database 12c Release 2 using the new command-line parallel upgrade script; Plug that database into an Oracle Database 12c Release 2 container database as a pluggable database (PDB); Migrate a second database to a PDB, using the new Oracle Database 12c full transportable export/import feature. The end result is a CDB with two PDBs, which is the first step toward database as a service (DBaaS) or toward building a private cloud.
View in online content catalog click here

12:00PM - 12:45PM
Analytics at Energy Australia - Building an IM Platform in the Age of Big Data
Gaurav Singh, Solution Architect, Energy Australia
Gurinder S Sidhu, Information and Analytics Leader, Energy Australia

Moscone South—302
Energy generation and retailing in Australia is in a state of flux, with centralized power generation in decline, new competitive pressures, and more customer choice. Energy Australia recognized that to be competitive and support its business strategy moving forward, it would need to revitalize its IM architecture. Implementing the Oracle Big Data solution (including Exadata, Oracle Big Data Appliance, Oracle Data Integrator, and Oracle Data Quality) has provided real benefits. This session examines Energy Australia’s journey from developing the business case and data strategy, to selecting key technologies, to implementation and quick wins. Also covered is future plans and lessons learned so far.
View in online content catalog click here

Best Practices for Developing Geospatial Big Data Apps for the Cloud
David Tatar, Principal Software Architect, Neustar
Nick Salem, Distinguished Engineer, NEUSTAR INC

Park Central—Franciscan I
Learn best practices and techniques from Neustar’s experience to build robust, scalable cloud-based applications using Oracle Database 12c, Oracle Big Data Spatial and Graph, partitioning, Oracle Real Application Clusters, Oracle Advanced Security, and Oracle WebLogic 12c. Neustar’s analytics platform delivers marketing insights to its customers quickly and efficiently, and it’s backed by a 3TB database with 5B geospatially enabled rows of information. Learn how to organize multiterabyte spatial data for maximum performance. Understand how to deploy key Oracle security and high availability capabilities essential for a cloud system, the Oracle Spatial functions for rich geospatial analytics, and leverage latest Oracle Database 12.2 features. A live demo is also included.
View in online content catalog click here

Prevent Bad SQL in the Cloud
Arup Nanda, Principal Database Architect, Starwood Hotels

Moscone South—103
Managing a database in Oracle Public Cloud makes most DBA-related tasks simpler. But applications are a different animal. Bad SQL could ruin a perfectly architected database in the cloud, and most DBAs fail to prevent that simply because that’s not their core skillset or they don’t have enough time for it. But 90 percent of the performance issues due to SQL can be handled automatically by tools built into Oracle Database. In this session learn how to harness those features to tune errant SQL without rewriting code, knowing anything about SQL constructs, or spending a large amount of time on them.
View in online content catalog click here

1:15PM - 2:00PM
Do You Have Text in Your Database? Use a Text Index
Roger Ford, Product Manager, Oracle

Moscone South—303
Most databases have textual data in them, from a few words to long documents. However, most applications don't take full advantage of that valuable content. In this session learn how Oracle Text allows you to create full-text indexes and run powerful and flexible queries on the content, all from within SQL. Oracle Text is included in all versions of Oracle Database 12c Release 2, no extra licenses needed. If you're not using it, you should, and this session shows you how.
View in online content catalog click here

Optimizing SQL for Performance and Maintainability
Christian Antognini, Senior Principal Consultant, Trivadis AG
John Clarke, Software Development Director, Real World Performance, Oracle
Connor Mcdonald, Developer Advocate for SQL, Oracle
Timothy Hall, DBA, Developer, Author, Trainer, Haygrays Limited
Chris Saxon, Developer Advocate for SQL, Oracle
Nigel Bayliss, Senior Principal Product Manager, Oracle
Keith Laker, Senior Principal Product Manager, Oracle

Moscone South—103
SQL is at the heart of every enterprise running on Oracle Database, so it is critical that our application’s SQL statements are optimized both in terms of performance and maintainability. Surprised to see the mention of maintainability? You shouldn’t be. Too much attention is paid on getting things working NOW. We need to think about the future, too. Join this session’s speaker and other SQL experts for a discussion (and lots of Q&A) on how to optimize your SQL statements.
View in online content catalog click here

Oracle’s Internal Use of Data Mining and Predictive Analytics: Case Study
Charlie Berger, Oracle
Frank Heiland, Senior Specialist Business Operations, Oracle

Palace—Grand Ballroom
Oracle uses predictive analytics in sales and customer support, HR, and elsewhere. Oracle targets customers most likely to buy products and anticipates customers most likely to discontinue service agreements. Customer service can monitor hosted database environments and anticipate unhealthy runtime behavior. Oracle Data Mining even contributed to the 2014 America’s Cup win. Oracle “moves the algorithms to the data” and extends the database to become an analytical platform; hence, Oracle has developed “predictive applications” for improved, analytically based decision-making and is adopting them internally. In this session, these internal “predictive analytics” use cases and an overview of Oracle Advanced Analytics are presented.
View in online content catalog click here

1:15PM - 2:15PM
LAB: Oracle Multitenant: Hands-on Lab
Can Tuzla, Product Manager, Oracle
Giridhar Ravipati, Principal Member of Technical Staff, Oracle
Prashanth Shanthaveerappa, Senior Member of Technical Staff, Oracle

Hotel Nikko—Golden Gate (25th Floor)
Oracle Multitenant is the first database designed for the cloud. With this architecture you can reduce both capital and operating expenses and increase agility, and it’s easy to adopt and use. Attend this hands-on lab to experience the exciting capabilities of Oracle Multitenant for yourself.
View in online content catalog click here

2:30PM - 3:15PM
Design Flexible Data Models Using Oracle's JavaScript Object Notation Capabilities
Aris Prassinos, Chief Engineer, Morpho

Park Central—Franciscan I
Oracle's JavaScript Object Notation (JSON) capabilities allow organizations to build schemaless database models while at the same time maintaining the full power of SQL. This session provides a quick introduction to these capabilities, and then examines the lessons learned from an actual application deployed to multiple customers with diverse schema requirements that also evolved over time. The examples presented cover design of JSON documents, storing and querying, advanced indexing techniques, and best practices. Finally, the functionality and performance of the JSON design approach will be contrasted to a traditional relational design and also to the XML capabilities available in prior versions of Oracle Database.
View in online content catalog click here


Popular posts from this blog

Review of Big Data Warehousing at OpenWorld 2017 - Now Available

My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

UPDATED: Big Data Warehousing Must See Guide for Oracle OpenWorld 2017