2016 Winter General Meeting – Presentations


2016 Winter General Meeting – Presentations

December 7, 2016

KEYNOTE: Transforming Data Management with Oracle Database 12c Release 2

Oracle Database is renowned for delivering the performance, reliability, and security that customers demand for their business applications. In this session, we’ll discuss how the latest release, Oracle Database 12c Release 2, can transform the way we manage enterprise data, and benefit from real time analytics, big data insights and the Cloud.

Willie Hardie
Originally from Edinburgh in Scotland and now based at Oracle’s Redwood Shores HQ in California, Willie Hardie is Vice President of Oracle Database Product Management. His areas of expertise include Oracle Database, Oracle Exadata, Oracle Real Application Clusters and other key Oracle Database features. Willie has been in IT for more than 30 years, specialized in relational database technologies for more than 25 years, and has worked with Oracle Database since version 5.

DBA TRACK: What’s New in Data Pump for Oracle Database 12c Release 2?

Oracle Data Pump is one of the most widely used features by Oracle DBAs. In this session learn how Oracle Database 12c Release 2 brings significant enhancements that will drastically improve performance and usability for Oracle Data Pump exports and imports. Greatly enhanced parallelism, additional functionality for network mode operations, and more file handling options are among the enhancements that are discussed in this session. The experts from the Oracle Data Pump development team provide all the details and performance numbers in this very technical session.

Roy Swonger
Roy Swonger has worked for Oracle for 22 years including work on software process and quality
improvement as well as a progression of management roles in technical documentation, software
development tools, and core database technologies. Roy has managed the Database Upgrade &
Utilities in the Server Technologies division for more than 10 years. In this capacity, he is responsible for the development of database features such as the Data Pump, SQL*Loader, External Tables, and Transportable Tablespaces.

DEVELOPER TRACK: Version Control for PL/SQL using Git

Version management of the PL/SQL source code in the Oracle Database has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid writing code in PL/SQL. In this presentation, you will learn how you can use Git, the prominent open source version control software, to manage your PL/SQL source code. Using these techniques, you can manage your source code in the Oracle Database just like any other development team manages their file based source code written in languages like Java, JavaScript or C#.

Yalim Gerger
Yalim Gerger is the Founder of Formspider, the application development framework for PL/SQL Developers. Formspider is being used by hundreds of developers in more than 30 countries.

DBA TRACK: Oracle GoldenGate – Technical Deep Dive

Oracle Golden Gate provides low-impact capture, routing, transformation, and delivery of database transactions across heterogeneous environments in near-real time. Oracle Golden Gate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise.

Venkata Ravi Kumar Yenugula
YV Ravi Kumar is an Oracle ACE and Oracle Certified Master (OCM) with 17 years of experience in Banking, Financial Services and Insurance (BFSI) Vertical. He has written 40+ OTN articles on Oracle Exadata, Oracle RAC and Oracle GoldenGate for OTN for Spanish, Portuguese and English and 17 articles for TOAD World, 2 Articles for UKOUG, 3 Articles for OTech Magazine and 2 Articles for Redgate. He is a frequent Oracle speaker in @OTN, AIOUG, Sangam and IOUG. Learn more from his profile at LaserSoft.

DEVELOPER TRACK: Analyze This! Practical Examples of Oracle Analytical Functions

If you’ve ever struggled with a particularly complex reporting request from an applications developer – for instance, returning just a specific set of rows from a subset of rows already extracted, or creating the equivalent of a Microsoft Excel pivot table, or producing a report with subtotals and subsections just like a spreadsheet – then this session is just right for you. We’ll demonstrate the basics of how to produce these complex output matrices with just a few calls to Oracle 12cR1 analytic functions and discuss how you applications developers (as well as Oracle DBAs) can leverage them for deeper insights into your database, and the performance of its application workloads. The presentation will offer real-world examples of how best to deploy these features, including detailed sample code that you can put to immediate use.

Jim Czuprynski
Jim Czuprynski has +35 years of professional experience in his career in information technology and has been an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public speaker on Oracle Database technology features, presenting topics at Oracle OpenWorld, IOUG’s COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world.

DBA TRACK: What’s New in Oracle Database 12c Release 2

Designed for the cloud, Oracle Database 12c has been the most rapidly adopted release in over a decade. In this session, we’ll provide a technical introduction to what’s new in Oracle Database 12c Release 2.

Willie Hardie
Originally from Edinburgh in Scotland and now based at Oracle’s Redwood Shores HQ in California, Willie Hardie is Vice President of Oracle Database Product Management. His areas of expertise include Oracle Database, Oracle Exadata, Oracle Real Application Clusters and other key Oracle Database features. Willie has been in IT for more than 30 years, specialized in relational database technologies for more than 25 years, and has worked with Oracle Database since version 5.

DEVELOPER TRACK: Who’s Down wit’ MPP? Hadoop and the PostRelational Revolution

We are now in the Big Data era thanks to an explosion in the Volume, Velocity and Variety of data. We are also now in the Post-Relational era thanks to a proliferation of options for handling Big Data more naturally and efficiently than Relational Database Management Systems (RDBMS). That’s not to say that we’re done with RDBMS; rather that RDBMS will be used primarily for Transactional systems, which is what they were designed for and are optimally suited for. Big Data systems are better handled by technologies like Hadoop, HBase, Cassandra, MongoDB, etc. These technologies provide scale out, Massively Parallel Processing (MPP) architectures, which are essential for Big Data systems (though sacrificing some of what is essential for Transactional systems – such as availability or ACID compliance). This presentation will discuss the rise of Hadoop and other MPP technologies and where they fit into an enterprise architecture in the Big Data era.

David Teplow
David Teplow began using Oracle with version 2 in 1981, and has worked as a consultant for Database Technologies (1986-1999) and Integra Technology Consulting (2000-present). David was president of the NOUG from 1992-1999 and on the board of the IOUG from 2003-2008. He can be reached at: DTeplow@IntegraTC.com

DBA TRACK: Hybrid Oracle Cloud Architecture : Your Foundation for Enterprise Cloud

In this technical, interactive session, Cintra will cover the key tenets to transforming your on-premise architecture into an “as a service” platform, building a roadmap to adopting Public Cloud assets where appropriate, and ultimately a Hybrid Cloud architecture which provides greater degrees of security, performance, scalability and availability.

Simon Rice
Simon Rice spent over 20 years in the Oracle DBA field in both the UK and USA, and has helped transform database architectures for many blue-chip companies to help the achieve greater business value and return on investment from their IT spend.

DEVELOPER TRACK: Developer’s Approach to Code Management

The importance of adequate code management is well-understood by anybody in the IT. Unfortunately, the practical implementation of this concept is usually left to be defined by managers and administrators, while people who actually write code (i.e. developers) are kept outside of the discussion and just being told what to do. As a result, too often whatever is approved has lots of flaws: limited scope/low flexibility/high rigidity etc. This presentation is the attempt to switch sides and show code management from the developer’s point of view. It stays outside of various VCS solutions and focuses on hands-on approaches: activity control via system triggers, conditional compilation, synonym manipulation, utilization of Edition-Based Redefinition (EBR). Overall, the goal of this presentation is to show how code management can assist developers instead of being an
obstacle that everybody is trying to avoid or sneak under. More than a decade of continuous support of a large government system provides lots of real-life stories to share and to learn.

Michael Rosenblum
Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014), contributing author of Expert PL/SQL. Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc.), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award.