Google Analytics

Thursday, 22 September 2016

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.

Data
Warehousing
Analytics
Unstructured
Data
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
Sanket Jain, 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




Wednesday, 21 September 2016

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

Attend my top must-attend sessions and hands-on labs for Wednesday. You can add them to your personal agenda with there "My Schedule” schedule feature on the OpenWorld content catalog. Enjoy #oow16 and don't forget: if you have questions or just want learn more about Database 12c Release 2 then visit the data warehouse and big data demo booths in the database are of the demogrounds. Our development teams are located on the following booths:

  • SDB-013: Oracle Advanced Analytics - Oracle Data Mining and Oracle R
  • SDB-014: SQL Analytics and Analytic Views
  • SDB-015: Enabling Integrated Big Data and Data Warehouse Insight Across the Enterprise
  • SDB-016: Oracle Partitioning
  • SDB-017: Oracle Optimizer
  • SDB-018: Oracle Parallel Execution

 



Data
Warehousing
Analytics
Unstructured
Data
Big Data

8:00AM - 9:00AM
LAB: Use Oracle Big Data SQL to Analyze Data Across Oracle Database, Hadoop, and NoSQL
Martin Gubar, Director of Product Management, Oracle
Keith Laker, Senior Principal Product Manager, Oracle

Hotel Nikko—Bay View (25th Floor)
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: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




11:00AM - 11:45AM
Oracle Big Data SQL Deep Dive
Martin Gubar, Oracle

Moscone South—103
Oracle Big Data SQL unifies query and analysis across the big data platform using the rich SQL execution engine in Oracle Database 12c to securely correlate information from Hadoop, NoSQL, and Oracle Database tables. What's the magic behind the technology? In this session, learn how Oracle Big Data SQL works and the performance optimizations that allow it to analyze data at scale.
View in online content catalog click here




12 Things DBAs Will Love About Oracle Database 12c Release 2
Connor Mcdonald, Developer Advocate for SQL, Oracle
Chris Saxon, Developer Advocate for SQL, Oracle

Park Central—Metropolitan II
In 2005, the AskTom team gave you the top 10 features of Oracle Database 10g. In 2007, it was 11 features on Oracle Database 11g, and then another 11 features on Oracle Database 11g Release 2 in 2009. And in 2013, another 12 new features with Oracle Database 12c. Now we continue the theme, but there are so many new features we've had to partition our talk into two presentations: one for DBAs and one for developers. This session covers 12 cool features for next-generation Oracle Database 12c that will make DBAs more productive.
View in online content catalog click here




Be a Hero with Your DBA: Database Performance Tuning for Admins and Architects
Randal Sagrillo, Solution Architect, Oracle

Moscone South—307
Back again by popular demand, and updated with your latest real-world issues. Be a hero with your DBA. Learn how to identify database key performance indicators, classify relevant workloads, and analyze Automatic Workload Repository/Statspack reports to make meaningful recommendations for what is needed in your database system infrastructure to meet your performance service-level objectives. The methods discussed in this session apply equally to on-premises and cloud-based infrastructure. The session mainly focuses on transactional and analytics workloads, with some discussion of data warehouse workloads. Attendees have been turned away from this session in previous years, so register early.
View in online content catalog click here




Oracle Big Data Management in the Cloud
Neil Mendelson, VP, Big Data & Advanced Analytics, Oracle

Moscone South—302
The future of data management is exciting. Customers and analysts all agree that successful analytical environments will require seamless integration of Hadoop, Spark, NoSQL, and relational databases. Data virtualization can eliminate silos of data and technology to make this wealth of new information available to your entire business. In this session hear about Oracle’s data virtualization strategy to tame the complexity of data management in the era of big data.
View in online content catalog click here


11:30AM - 12:30PM
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:15PM - 1:00PM
A Practical Introduction to Oracle NoSQL Database
Tim Goh, Product Manager, Oracle
A Chandak, Principal Product Manager, Oracle
Michael Schulman, Senior Principal Product Manager, Oracle

Moscone South—303
Not familiar with Oracle NoSQL Database yet? Interested in some real-world use cases? This great product introduction session discusses the primary functionality included with the product as well as integration with other Oracle products. It includes a live demo that illustrates installation, configuration, and data modeling as well as querying Oracle NoSQL Database from both Apache Hive and Oracle Database.
View in online content catalog click here




Analytic Views: A New Type of Database View for Simple, Powerful Analytics
William Endress, Director, Product Management, Oracle

Moscone South—102
Analytic views are a new type of view in Oracle Database 12c Release 2 that organize data for simplified access via SQL, extend data sets with aggregate data and measure calculations, and provide a rich metadata layer to support BI applications. In this session learn how analytic views embed joins and aggregation rules, and measure calculations and navigation paths into a single view that is queried with very simple SQL. Use cases include simplifying access to data star schema, Oracle Big Data SQL, and JavaScript Object Notation and as an alternative to exporting data for the analysis in spreadsheets.
View in online content catalog click here




Leveraging Data Science to Extract Actionable Insights from Manufacturing Data
Venkat Visweswaran, Director, Product Management, Oracle
Elaine Lin, Director , Oracle

Moscone West—3002
Traditional business intelligence dashboards and operational reports are falling short of answering tough questions that factory and supply chain managers are asking today. There is a need to look at the same data with a different lens because the answers to these questions rely on discovering relationships and correlations that exist within extremely large data sets. This is where new techniques related to data science and data mining can come to the rescue. They help identify anomalies and outliers in the data as well as try to classify data into different categories based on common characteristics. Applying such techniques can help manufacturers quickly get to the root cause and patterns of interest that relate to poor yield and quality. Attend this session to learn more.
View in online content catalog click here


1:15PM - 2:15PM
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: Oracle Multitenant: Hands-on Lab
Can Tuzla, Product Manager, Oracle
Giridhar Ravipati, Principal Member of Technical Staff, Oracle
Sanket Jain, 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


3:00PM - 3:45PM
Customer Panel: Big Data and Data Warehousing
Gaurav Singh, Solution Architect, Energy Australia
Jim Hewitt, VP Data Strategy & Architecture, Vantiv
Carolina Bouvard Nuo, Directora Transformación y BI, TELEFONICA OF SPAIN
Ken Hall, Architect, SunTrust

Park Central—Metropolitan II
In this session, hear how customers around the world are solving cutting-edge analytical business problems using Oracle Data Warehouse and Oracle Big Data technology. Understand the benefits of using these technologies together, and how software and hardware combined can save money and increase productivity. Learn how these customers are using Oracle Big Data Appliance, Oracle Exadata, Oracle Exalytics, Oracle Database In-Memory 12c, or Oracle Analytics to drive their businesses, make the right decisions, and find hidden information. The conversation will be wide-ranging, with customer panelists from a variety of industries discussing business benefits, technical architectures, implementation of best practices, and future directions.
View in online content catalog click here




Best Practices for Moving Your Oracle Database to the Cloud
Brian Spendolini, Oracle
Angela Schuler, Senior Manager, S & C Electric Company

Moscone South—303
This session covers how best to move your on-premises Oracle Database and other development instances to a public cloud—such as data and development platform migration—and outlines and details best practices for DBAs, IT staff, and developers. The session also details available options for DBAs and developers for cloud application development and what mix of technologies can be used. Learn about Oracle Database backup, failover, and recovery options, Oracle GoldenGate Cloud Service, and how to use the public cloud to REST-enable your data for mobile applications. Lastly, the session covers all management options for the public cloud and discusses privacy and security concerns when moving to the public cloud.
View in online content catalog click here




Oracle Streaming Big Data and Internet of Things Driving Innovation
Atul Mahamuni, Vice President, Product Development, Oracle
Neil Mendelson, VP, Big Data & Advanced Analytics, Oracle

Moscone South—302
In the Internet of Things (IoT), whether it is a smart meter, a connected vehicle, or a digital factory, a wealth of data is generated, which can be monitored and acted on in near real time. Applying big data techniques to store and analyze this data can drive predictive, intelligent learning applications in industries such as manufacturing, transportation, and utilities. In this session, learn about the convergence of IoT and big data, and how to apply them in your business to reduce costs, generate competitive advantage, and open up new business opportunities.
View in online content catalog click here


4:15PM - 5:00PM
Extraordinary Data Warehousing on Oracle SuperCluster
Sheldon Carter, Database Administrator Manager, Digicel
Darko Krstic, Group IT Platforms Manager, Digicel
Odwar Ortiz, Infrastructure Solutions Specialist, Oracle

Moscone South—308
In this session learn how a large telco slashed operating expenses while building a data warehouse that scales to more than 2 petabytes of storage using Oracle SuperCluster and Oracle All Flash FS1 Flash Storage System. Hear how bringing together the latest Oracle Database 12c in-memory, compression, and information lifecycle management features with Oracle SuperCluster and Oracle All Flash FS1 Flash Storage System delivers an extraordinary solution that offers real-time analytics and massive scale, all in a single solution that was architected in-house.
View in online content catalog click here


7:00PM - 11:00PM
Customer Appreciation Event
Sting and Gwen Stefani Rock the Oracle Appreciation Event

AT&T Park, San Francisco

Tuesday, 20 September 2016

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

Here is my list of top must-attend sessions and hands-on labs for Tuesday at #oow16. You can add them to your personal agenda with the "My Schedule” feature in the OpenWorld content catalog. Enjoy #oow16


Data
Warehousing
Analytics
Unstructured
Data
Big Data

8:00AM - 9:00AM
LAB: Big Data Cloud Workshop
Diby Malakar, Vice President, Product Management, Oracle
Prahlad Thirumalai, Director, Product Management, Oracle

Hotel Nikko—Mendocino I/II (2nd Floor)
This hands-on lab walks you through building batch and streaming analytical applications using Oracle Big Data Cloud Service. Attendees will have a brief introduction to Oracle Messaging Cloud Service and Oracle Big Data Cloud Service and will be able to choose from among a set of self-paced tutorials to do batch processing, streaming analytics, or interactive exploration using notebooks.
View in online content catalog click here




LAB: Use Oracle Big Data SQL to Analyze Data Across Oracle Database, Hadoop, and NoSQL
Marty Gubar, Director of Product Management, Oracle
Keith Laker, Senior Principal Product Manager, Oracle

Hotel Nikko—Bay View (25th Floor)
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 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: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: 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


11:00AM - 11:45AM
Data Warehousing, Big Data, and the Cloud in the Next Generation of Oracle Database
George Lumpkin, Vice President, Product Management, Oracle

Moscone South — 305
The data warehousing market is in transition. The monolithic data warehouses of years past are giving way to more heterogeneous analytics-driven architectures that allow queries to span relational data, big data, and even the Internet of Things. This session examines how Oracle Database is evolving to support these transitions, how Oracle is expanding the domain of SQL to make it the lingua franca of data analytics, and how it is expanding the boundaries of the database itself by moving into the cloud. For those who just want to hear about the new relational features for data warehousing, we'll cover those too: they are really cool. This session has something for everyone: architect, database DBA, big data developer, and big data scientist.
View in online content catalog click here




Deploying Oracle Database in the Cloud with Exadata: Technical Deep Dive
Ashish Ray, Vice President of Product Management, Oracle
Binoy Sukumaran, Vice President, Database Cloud Service, Oracle

Moscone South — 302
Oracle Database Exadata Cloud Service combines the renowned power of the Exadata database platform with the operational simplicity and pay-as-you-grow economics of the cloud. With Oracle Database Exadata Cloud Service, you can run your Oracle Databases in the Oracle Public Cloud with the same functionality, performance, and availability experienced by thousands of organizations deploying Exadata on-premises. This session provides a technical overview of Oracle Database Exadata Cloud Service along with best practices for efficiently deploying, managing, securing, and scaling Oracle Databases in the cloud. This session also covers innovative deployment models such as bringing the power of an agile, cloud-based consumption model to your data center behind your firewall.
View in online content catalog click here




Getting the Most Out of Database Compression and Information Lifecycle Management
Gregg Christman, Oracle

Moscone South — 301
In this session Oracle product management shares best practices, tips, and insights gathered from compression users across the globe, regarding data, index, LOBs, and Oracle Recovery Manager backup compression. Even if you already use Oracle Advanced Compression or Oracle Hybrid Columnar Compression, this session provides new insights about how to get best from Oracle compression. It also explores how real-world organizations are using database compression tiering and storage tiering to automate information lifecycle management (ILM), enabling them to meet their regulatory/business rules for data retention using lower cost, high-capacity Tier 2 storage. This session is the perfect opportunity to get your compression/ILM questions answered by product management.
View in online content catalog click here


11:30AM - 12:30PM
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:15PM - 1:00PM
Oracle Big Data Cloud Service and Oracle Cloud Machine Roadmap
Jean-Pierre Dijcks, Master Product Manager, Oracle

Moscone South—301
Big data and the cloud are the two mega trends that are changing the way companies manage and analyze data. This session explains how Oracle is revolutionizing the platforms for data management and analytics, both on-premises and in the cloud. See a detailed cloud roadmap covering the offerings and plans for Hadoop, Spark, NoSQL, and Oracle Big Data SQL, as well as learn how Oracle Big Data Cloud Service is going to change the way you consume these data management services going forward.
View in online content catalog click here


4:00PM - 5:00PM
LAB: Oracle Multitenant: Hands-on Lab
Can Tuzla, Product Manager, Oracle
Giridhar Ravipati, Principal Member of Technical Staff, Oracle
Sanket Jain, 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


4:00PM - 4:45PM
The Best Way to Tune Your Parallel Statements: Real-Time SQL Monitoring
Yasin Baskan, Senior Principal Product Manager, Oracle

Park Central—Metropolitan II
Real-time SQL monitoring is a great tool for looking into the details of the execution of a SQL statement, and it is especially helpful in tuning the lengthier execution plans found in parallel statements. Real-time SQL monitoring unlocks the details of parallel execution, displaying information on data distribution, partition-wise operations, push down operations, and more. In this session, learn how to tune parallel statements using real-time SQL monitoring via in-depth examples for a better understanding not only of SQL monitoring, but also Oracle's most recent enhancements to parallel processing in Oracle Database 12c.
View in online content catalog click here


5:15PM - 6:00PM
Best Practices for Getting Started with Oracle Database In-Memory
Andy Rivenes, Senior Principal Product Manager, Oracle

Moscone South — 103
Oracle Database In-Memory is one of the most fascinating new database features to come along in a long time, promising an incredible performance boast for analytics. This presentation provides a step-by-step guide on when and where you should take advantage of Oracle Database In-Memory, as well as outlining strategies to help you ensure you get the promised performance boast regardless of your database environments. These strategies include how to identify which objects to populate into memory, how to identify which indexes to drop, and details on how to integrate with other performance enhancing features. With real-world examples, the presentation explains exactly what steps you need to take to get up and running on Oracle Database In-Memory.
View in online content catalog click here




Oracle Partitioning: Hidden Old Gems and Great New Tricks
Hermann Baer, Senior Director Product Management, Oracle

Park Central—Metropolitan II
Oracle Partitioning has proven itself over the course of decades, helping customers successfully run large, mission-critical systems. Even after such a long time the latest release of Oracle Database introduces significant enhancements; lots of them thanks to the input of our customers. And despite being around for a while, there is always *something* that is not known to the broad audience but has significant business benefits. Attend this session to learn about the latest and greatest of Oracle Partitioning and things that you wish you had known for years.
View in online content catalog click here




5:45PM 6:45PM
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: Oracle NoSQL Database for Application Developers
A Chandak, Principal Product Manager, Oracle
Michael Schulman, Senior Principal Product Manager, Oracle

Hotel Nikko—Bay View (25th Floor)
Oracle NoSQL Database is the hot new data management technology being used by enterprise customers to address their low-latency, scalable, distributed NoSQL application needs. This hands-on lab focuses on the data design and data access aspects of Oracle NoSQL Database. Learn how to create and manage table and JavaScript Object Notation (JSON) documents in Oracle NoSQL Database, express queries in NoSQL with the API and the command-line interface, and enable direct access to data stored in NoSQL from Oracle Database. Whether you are an SQL or NoSQL application developer, this session gives you the practical skills you need in order to get started with Oracle NoSQL Database application development.
View in online content catalog click here


6:15PM - 7:00PM
Ask Tom Live with Chris Saxon and Connor McDonald
Connor Mcdonald, Developer Advocate for SQL, Oracle
Chris Saxon, Developer Advocate for SQL, Oracle

Moscone South—307
When it comes to Oracle Database, the most popular and highly regarded source of advice is Ask Tom (asktom.oracle.com). For years, the legendary Tom Kyte answered any and all questions, and hosted vigorous discussions on all aspects of development on Oracle Database. Today, Chris Saxon and Connor McDonald of the Oracle Database Developer Advocates team carry on the tradition. So if you've got questions or want to hear what's it like to be on the AskTom team, or just hear about some of the strange and funny things we've been asked, don't miss this session.
View in online content catalog click here




Meet the Experts: Oracle’s Big Data Management System
Martin Gubar, Oracle
Dave Rubin, Director of NoSQL Database Development, Oracle
Xavier Lopez, Oracle
Jean-Pierre Dijcks, Master Product Manager, Oracle
Ashok Joshi, Senior Director, Oracle NoSQL Database, Berkeley DB, Database Mobile Server, Oracle
James Steiner, Oracle
Melliyal Annamalai, Oracle

Moscone South—306
New transformative capabilities delivered with Oracle Database 12c Release 2 and Oracle Big Data Appliance will have a dramatic impact on how you design and implement your data warehouse and information systems. You now have the opportunity to analyze all your data across the big data platform—including Oracle Database 12.2, Hadoop, and NoSQL sources—using Oracle’s rich SQL dialect and data governance policies. Attend this session to ask the experts about Oracle’s big data management system, including Oracle Big Data SQL, Oracle TimesTen In-Memory Database, Oracle NoSQL Database, and Oracle Advanced Analytics.
View in online content catalog click here


7:15PM - 8:00PM
Meet the Experts: Oracle XML Database
Mark Drake, Product Manager, Oracle
Vikas Arora, Senior Director, Oracle
Geeta Arora, Director of Development, Oracle
Sundeep Abraham, Consulting Member of Technical Staff, Oracle

Moscone South — 307
This session is for those interested in learning about customer innovations and best practices with Oracle XML Database and the new schema-free nature of JavaScript Object Notation features of Oracle Database. Meet the experts and discuss benefits derived from the extreme performance and advanced analytics capabilities of the platform. Topics include use cases for application developers who need to use Oracle XML Database-centric techniques to store, manage, organize, and manipulate Oracle XML Database content stored in the database.
View in online content catalog click here





Don't forget if you have questions or just want learn more about Database 12c Release 2 then visit the data warehouse and big data demo booths in the database are of the demogrounds. Our development teams are located on the following booths:
  • SDB-013: Oracle Advanced Analytics - Oracle Data Mining and Oracle R
  • SDB-014: SQL Analytics and Analytic Views
  • SDB-015: Enabling Integrated Big Data and Data Warehouse Insight Across the Enterprise
  • SDB-016: Oracle Partitioning
  • SDB-017: Oracle Optimizer
  • SDB-018: Oracle Parallel Execution