2013 September General Meeting Presentations

In 2013 NYOUG redesigned its web site. To keep the older presentations they were grouped together and posted as one post. The following are all the General Meeting presentations that occurred prior to October 2013.

September 2013 General Meeting

KEYNOTE: Oracle 12c: The Gee Whiz Features You Need to Know

Oracle 12c is out, and so are about 450 new features. Instead of jumping head-first into the pool, learn about the key new features which provide the best bang for the buck. In this presentation, Arup (the author of the popular New Features series on OTN) will condense them into a manageable chunk describing the 12c features that are worth knowing about. Whenever possible, the concepts will be presented with live demos.

Arup Nanda has been working as an Oracle DBA for the past 17 years. Arup trains and mentors DBAs, has coauthored 4 books, written some 300 published articles (including the most popular 11g and 10g New Features Series on the Oracle Technology Network) and given numerous presentations. He is an OCP DBA, an Oracle ACE Director and a member of the Oak Table Network. In 2003, he won the coveted Oracle DBA of the Year award. Arup blogs at arup.blogspot.com.

 

DBA TRACK: Big Data Demystified for Oracle ProfessionalsBig Data is the future of database computing and knowing about it is not just a luxury you can avoid anymore; it’s necessary for survival and growth. If you have encountered the Hadoop, Hive, Map/Reduce, and Flume acronyms more often than you have the time to pause and think about them, this presentation will help. Learn about these and more in this informative session about Big Data components explained from the perspective of an Oracle professional, how they are the same or different and how they compare with RAC or parallel query.

Arup Nanda has been working as an Oracle DBA for the past 17 years. Arup trains and mentors DBAs, has coauthored 4 books, written some 300 published articles (including the most popular 11g and 10g New Features Series on the Oracle Technology Network) and given numerous presentations. He is an OCP DBA, an Oracle ACE Director and a member of the Oak Table Network. In 2003, he won the coveted Oracle DBA of the Year award. Arup blogs at arup.blogspot.com.

DBA TRACK: Managing Statistics of Volatile Tables in OracleAdequate, up-to-date table and index statistics are of utmost importance for achieving optimal database performance. Even though Oracle, particularly version 12c, has ways to mitigate suboptimal execution plans, it is best to have the optimizer deliver an excellent plan for every query every time. Oracle’s default statistics gathering process collects statistics every night and over the weekend. It works fine for tables that change little over the day, but it is inadequate for tables which size or data distribution fluctuate every couple of minutes. The challenge is even greater when we are not allowed to change the application design and queries, an increasingly common situation thanks to the growing use of off-the-shelf solutions. Following a review of the benefits and the pitfalls of using dynamic sampling and locking statistics to manage statistics of volatile tables, a robust algorithm that delivers both plan stability and system flexibility is proposed. The algorithm works by allowing the statistics to change only under specific circumstances. A method for gathering statistics without issuing a commit is described in detail, along with tips for improving performance of queries involving volatile tables without changing the SQL code.

Iordan Iotzov is a senior DBA at News America Marketing (NewsCorp) with more than ten years of database administration and development experience. He has a MS degree in Computer Science, holds numerous Oracle certifications, and has worked on complex database problems across various industries, providing original and effective solutions. Iordan has presented at Hotsos, NYOUG, and BrainSurface VirtaThon, frequently participates in OTN forums and actively blogs at http://iiotzov.wordpress.com/.

DEVELOPER TRACK: Developing Mobile Applications for iOS and Android the Oracle WayUntil now, taking advantage of mobile technology required adopting non-Oracle technologies with significant learning curves. In addition, the fragmented nature of the marketplace meant that developers had to master two incompatible technology stacks just to cover iOS and Android, the two dominant mobile operating systems currently available. This session will describe how a combination of Java, component-based HTML5 UI, and an MVC architecture allows developers to leverage their existing Java skills while transitioning to the new wave of enterprise mobile application development. This presentation will demonstrate how Oracle approached this challenge and show how it is possible to reuse your existing Java skills to build rich native applications that will run on both iOS and Android from a single code base.

Frédéric Desbiens is a product manager in the Oracle Application Development Tools group. He has fifteen years of experience in the IT industry, and worked for several years as a consultant, with ample opportunity to get real-world expertise on several projects involving various Oracle technologies, such as Oracle SOA Suite and Oracle WebCenter. He co-authored the WebCenter 11g Handbook: Build Rich, Customizable Enterprise 2.0 Applications, published by McGraw-Hill.

DEVELOPER TRACK: ADF On-Ramp: What You Need to Know to Use the Core ADF Technology StackDeveloping a Java-oriented web application these days requires selecting a small set of frameworks from a dauntingly long list. Fortunately, Oracle has provided some inspiration; they are building Fusion Applications using Application Development Framework (ADF) and a core technology stack consisting of ADF Faces, ADF Business Components, and JavaServer Faces. You too can develop applications using this set of technologies and the ADF environment in JDeveloper. This presentation explains these technologies and shows what kinds of development methods you will use when working in this environment. It provides guidelines for how much you need to know about the various languages used for these technologies. It also describes and shows the files you will use to build an application and how that application will be tested and deployed to a production environment. In addition, the presentation offers advice on how to learn what you need to know before starting Java web development in JDeveloper.

Peter Koletzke is a technical director and principal instructor for Quovera in Mountain View, California, and has 29 years of industry experience. He is also an Oracle Certified Master, an Oracle ACE Director, presenter of more than 310 sessions at various Oracle users group conferences, and winner of over a dozen user group awards. Additionally, he has co-authored eight Oracle Press books about Oracle development tools.

NETWORKING PRESENTATION: Managing Your Career EffectivelyAre you looking for a job as an Oracle DBA? Do you want to upgrade your current resume? Do you want to learn how to make use of the newest networking tools to enhance your career? The afternoon session will combine an inside look from Dice.com at what hiring managers want in DBAs and other IT professionals including how to optimize your resume, online footprint, and the time you spend networking. After the brief presentation, there will be time to network with Dice personnel and others with advice about how to effectively market yourself in the current IT career environment.

Christina Bedrosian is a VP of Marketing at Dice.com specializing in marketing, strategy, branding, online marketing, and search engine marketing.