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

Comments

Popular posts from this blog

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

SQL Pattern Matching Deep Dive - Part 1

SQL Pattern Matching Deep Dive - Part 6, state machines