2014 Summer General Meeting – Presentations

The New York Oracle Users Group Summer General Meeting

Tuesday June 3, 2014
sponsored by Dell Software

KEYNOTE: Oracle Key Vault Sneak Peek

With many global regulations calling for data encryption, centralized and secure key management has become a need for most organizations. This session introduces Oracle Key Vault for centrally managing encryption keys, wallets, and passwords for databases and other enterprise servers. Oracle Key Vault enables large-scale deployments of Oracle Advanced Security’s Transparent Data Encryption feature and secure sharing of keys between Oracle Real Application Clusters (Oracle RAC), Oracle Active Data Guard, and Oracle GoldenGate deployments. With support for industry standards such as OASIS KMIP and PKCS #11, Oracle Key Vault can centrally manage keys and passwords for other endpoints in your organization and provide greater reliability, availability, and security.

Todd Bottger is a Senior Principal Product Manager in the Oracle Database Security development team. He supports popular database features that enable customers to improve their security and comply with regulations. His main areas of emphasis are data-at-rest encryption, on-the-fly data redaction and persistent data masking of sensitive information stored in the database. Todd is a frequent speaker at Oracle OpenWorld on the topics of Oracle Advanced Security Transparent Data Encryption (TDE) and encryption key management. He has been closely involved in defining Oracle’s key management strategy. Prior to Oracle, Todd held product management positions at Siebel, Sun and Protegrity. He has a B.S. in Computer Science from Brigham Young University, an MBA from the University of Michigan, and current CISSP certification from ISC2.

DBA TRACK: Understanding Oracle Locking Internals

Have you ever wondered how the Oracle Database keeps track of who has what type of lock and who is next in the line? In this session you will learn how locking works, the mysterious Interested Transaction Lists, how it is managed, how to get the information on ITL wait, and how to tune for resolution of locking related issues, with live examples. This presentation will help you understand in clear detail how Oracle transactions and locking work, how you can avoid locking issues and transaction contentions and design efficient applications with the knowledge gathered.

Arup Nanda (arup@proligence.com) has been working as an Oracle DBA for last 20 years touching all aspects of the database from modeling to performance tuning to security and disaster recovery. He has presented 300 sessions, written 500 articles, co-authored 5 books and delivered training in 22 countries. He is an Oracle ACE Director, a member of Oak Table Network, a member of the Board of Directors of the Exadata SIG and an editor for the SELECT journal. He was the recipient of two prestigious awards from Oracle: DBA of the Year in 2003 and Architect of the Year in 2012.

DEVELOPER TRACK: APEX 5.0 Universal Theme and Template Options

This presentation introduces the new Universal Theme, which is based on modern HTML5 and CSS3 standards and very flexible, thanks to its use of responsive web design principles. Marc will show how theme styles and template options can be used to choose from a variety of available styles, and to easily and declaratively customize the UI to match specific requirements. This will empower developers even without prior HTML knowledge to build applications with modern user interfaces.

Marc Sewtz is a Senior Software Development Manager at Oracle Corporation in New York. With over sixteen years of industry experience, Marc held roles in Consulting, Sales and Product Development and now manages a global team of Software Developers and Product Managers in the Oracle Application Express (APEX) development team, part of the Oracle Database Tools group. Marc and his team are responsible for features such as the development of Mobile Web Applications with APEX, Reporting and Charting, Tabular Forms, Oracle Forms to APEX conversion and integration with Oracle Business Intelligence Publisher. Marc has an MS degree in computer science from the University of Applied Sciences in Wedel, Germany.

OPEN SOURCE TRACK: The Right tool for the Task: Using MongoDB in Combination with a Traditional RBMS

Evan Bauer has over 30 years of experience as an executive, consultant, analyst, and software engineer in the architecture, design, implementation, and maintenance of complex information systems and software products for mission-critical applications, primarily in the financial services industry. After 8 years as an independent consultant often incubating new firms and software communities, Evan is currently Vice President and Enterprise Architect for DealerTrack, Inc., a leading provider of on-demand software and services to the automotive industry.

DBA TRACK: Configure Oracle Database 12c to Tune Itself: New Features for Stability and Optimization

Release 11g introduced several powerful capabilities: SQL Plan Management, Adaptive Cursor Sharing, Cardinality Feedback, and Extended Statistics. Release 12c takes these mechanisms to the next level. The result is that DBAs can use declarative techniques to ensure that your users’ SQL will run even better, and better without the users changing anything!

Dave Anderson is SkillBuilders President and Founder. Dave is an Oracle DBA with 20 years of experience.

John Watson is an Oracle Certified Master consultant, lecturer, and author with twenty years’ experience with the Oracle technology stack, including 11g Grid Infrastructure and RAC. John has authored 5 Oracle Press Exam Guides. He is SkillBuilders’ Director of Oracle Database Services.

DEVELOPER TRACK: Designing and Building Applications for the IPAD

Building applications for the IPAD is a completely different challenge from building for a desktop computer. Applications that work fine in a browser on a PC are frequently nearly unusable when ported to the IPAD. The user experience on a touch screen requires many modifications. It is not just about making everything bigger for fingers to be able to press buttons on screen, but also involves a total rethinking of the user experience. Technically, you have to decide whether you are going to build for the browser, make a native application or some kind of hybrid. Depending upon the technology you choose, communication with the database can become another challenge. This presentation will discuss how to take a very complicated end-user centric application that was built for a browser-based PC platform and adapt it for an IPAD platform. Our decisions, UX changes and technologies chosen will be discussed.

Dr. Paul Dorsey is the founder and president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian’s BRIM® tool. Paul co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle Ace, past IOUG and ODTUG volunteer of the year, the first inductee into the IOUG SELECT Journal Hall of Fame, and an Oracle 9i Certified Master. Dr. Dorsey’s submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year. Paul can be contacted at paul_dorsey@dulcian.com

OPEN SOURCE TRACK: Introduction to Hadoop

You have probably been hearing the buzz about Big Data and how you can now reduce complex analysis tasks from days to hours or minutes. If you want to learn what the buzz is all about, this presentation will take you on an initial dive into Hadoop. It will cover the origins of Hadoop, its architecture, and include a step-by-step walkthrough of a real-time setup of a Hadoop cluster. The presentation will also cover execution of a sample analysis job including an introduction to Map Reduce, PIG, and Hive.

Vikas Sawhney is certified Oracle DBA with 15 years of experience specializing in design of data warehousing and OLTP systems. Vikas is a managing partner at Amvean Consulting Group (www.amvean.com) headquartered in New York. Amvean specializes in design, integration, and deployment of large-scale database systems.

DBA TRACK: Oracle Licensing – Mitigate Risk, Understand Compliance

This session is designed to help DBAs, Developers, System Administrators, CIOs, CFOs, IT Directors, Procurement, and others responsible for Oracle licensing within their organization to understand what is at risk when it comes to Oracle Licensing compliance. The presentation provides an overview of current hardware, software, database, and support licensing. The session focuses on what you need to know about software compliance, how to gain visibility into your licensing environment, and how to gain an understanding of licensing costs and the impact on your company. The session will examine licensing in the context of technical, support, user, and business issues. It includes a look at new information about licensing for the virtual environment, new Oracle Licensing agreements (OMA/TOMA) and discusses ways to mitigate risk to your organization.

Stu Kaplan is Solutions Business Development Director for DBAK and has been configuring technology solutions for more than 30 years including software and database implementation, database upgrades, migrations, conversions, infrastructure transformation, business requirements analysis, hosting, and ongoing support requirements. His experience extends across multiple vendor (DEC, Compaq, HP and Oracle) disciplines and technologies, and he has counseled large and small companies on mapping servers to licensing, virtualization, methods of licensing, alignment of licensing, and rules and regulations for specific infrastructure for Hyperion, Oracle EBS and the Oracle technology stack. Stu focuses on straightforward communication and synergistic outcomes that bring value to the compliance environment. He has deep knowledge of broader technology stacks
and technology trends that help companies keep their licensing concerns in context.

DEVELOPER TRACK: Calling SQL from PL/SQL the Right Way: Thinking in Sets

Everybody knows that SQL is a set language. The most effective manner in which to communicate with a set language is by using set-based operations. Otherwise, the system incurs the extra cost of transforming sets into rows and reversing rows back into sets. Oracle databases currently support multiple ways of working in sets. This presentation reviews the results of two studies focused on comparing data access approaches. The first one looks for the most efficient ways of moving significant volumes of the data between remote locations, while the second tests the impact of MULTISET operations on the resource utilization.

Grigoriy Novikov is a Senior Developer at Dulcian, Inc., where he is responsible new feature research, SQL and PL/SQL tuning, complex functionality, developing code generators and repository-based systems development and maintenance. He specializes in the development of various industry and government systems in the medical, finance, customs, real estate and military (both US and international) arenas. He is also responsible for database modeling, researching new database features and tuning. Grigoriy holds a BS in Economics (Institute for MIS) from the State University of Management in Moscow.

OPEN SOURCE TRACK: Optimizing Oracle and MySQL Network Transfer

Bugs. Errors. Slowdowns. Complete meltdowns. We have all run into performance issues. Most of the time, we focus on improving the obvious: indexes, query plans, and database hardware. But what about those things which hide beneath the surface? What about the network? Sure, you have had your share of disconnections caused by idle timeouts. Do you know how to optimize the network for your database and application usage? This presentation will discuss optimizing your database networking stack by going through the MySQL and Oracle database protocols and explaining how they work, how to tune them, and how to configure their underlying network protocols, such as TCP/IP.

Jonah Harris is currently the Vice President of Software and Systems Architecture at MeetMe.com, one of the top ten social networks in the United States and one of the twenty most trafficked sites in the US. He has spoken at various conferences, consulted in different areas of technology and business, and is a known industry expert in database network protocols. In addition to his software architecture and engineering background, he has also spent many years studying statistics, psychology, and data science.