2013 June General Meeting Presentations

June 2013 General Meeting

This presentation discusses which Oracle 12c new features should be investigated for use. Most of the features covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  Simple examples (such as a quick example using pluggable databases) will be included to show the basic functionality of the new features, including:

• Invisible columns
• Multiple indexes on the same column
• Adaptive Execution Plans
• Runaway query management
• Change Table Compression at import time
• Creating views as tables
• Online Move Partition
• Partial Indexes for partitioned tables
• Pluggable databases
• Enhanced DDL Online
• Automatic Diagnostics Repository
• Enhanced Security Features

Rich Niemiec is a world renowned Oracle Expert. He is an Oracle Ace Director and was a co-founder and CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions founded in 1988.  Rich currently serves as an Executive Advisor to the Rolta International Board of Directors and has served as President of Rolta TUSC and Rolta EICT.  TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011 (Rolta).  Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection. Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich won IOUG’s Chris Wooldridge Award in 2012.  Rich is one of six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller, Oracle11g Release 2 Performance Tuning Tips & Techniques, and an update of his previous three Oracle best sellers on Oracle8i, Oracle9i, and Oracle10g Performance Tuning.  Rich was inducted into the Entrepreneurship Hall of Fame in 1998

This presentation will review many of the current Big Data Solutions and how Oracle’s Big Data Solution is substantially better.  Rich will review the role that both Google and Facebook have played in the Big Data Ecosystem and how other NoSQL databases like Cassandra and MongoDB stack up against the Oracle Solution.  Topics to be covered include:

• –          Big Data Overview and How much Data there is in the World

• –          GFS and MapReduce early days

• –          Hadoop, HDFS, and MapReduce in Open Source

• –          A couple of the NoSQL Databases

• –          The Oracle Solution – Why Oracle should win this market

• –          Oracle Hadoop Data Loader and BerkeleyDB

Rich Niemiec is a world renowned Oracle Expert. He is an Oracle Ace Director and was a co-founder and CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions founded in 1988.  Rich currently serves as an Executive Advisor to the Rolta International Board of Directors and has served as President of Rolta TUSC and Rolta EICT.  TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010 (Rolta TUSC), & 2011 (Rolta).  Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection. Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich won IOUG’s Chris Wooldridge Award in 2012.  Rich is one of six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller, Oracle11g Release 2 Performance Tuning Tips & Techniques, and an update of his previous three Oracle best sellers on Oracle8i, Oracle9i, and Oracle10g Performance Tuning.  Rich was inducted into the Entrepreneurship Hall of Fame in 1998

After migrating many applications to Exadata, Mike and Gary will share their top 10 lessons learned when migrating applications to Exadata. Gary and Mike have over 6 years of experience on Oracle’s Exadata Platform and more than a half a century of Oracle experience.  This presentation will review the items you need to plan for when migrating an application to Exadata. Attendees will also learn what to watch out for to help ensure a successful migration to Exadata, thereby maximizing their investment in the Exadata platform. 

Gary Bhandarkar has worked as a DBA and developer for the past 18 years and has worked with Exadata since 2010.

Mike La Magna, Vice President of NYOUG, is an Associate Director of Database Services at Merck and has been a developer and DBA working with Oracle since the early 1980’s.

Learn how to bridge the gap between security regulations, privacy and compliance, yet still be able to provide powerful analysis and data insight to achieve the power behind a big data environment.  Learn how to adapt to the ever-changing data security landscape, including compliance to PCI DSS, HIPAA/HITECH and US State laws.

Ulf Mattsson created the innovative architecture of the Protegrity Data Security Platform. He is commonly considered one of the founding fathers of tokenization and has been advising the industry’s top analysts and stakeholders including PCI Security Standards Council, ISACA and Visa as they navigate the role of tokenization in payments security. Ulf is the inventor of more than 20 patents in the areas of encryption key management, policy driven data encryption, internal threat protection, data usage control and intrusion prevention. He also is a research member of the International Federation for Information Processing (IFIP) WG 11.3 Data and Application Security, ANSI X9, Information Systems Security Association (ISSA) and Information Systems Audit and Control Association (ISACA).

Building mobile applications has become a very hot topic in the IT world. Users are increasingly demanding access to corporate applications via their mobile devices. BYOD (Bring Your Own Device) articles have been increasingly featured in technology publications. New languages, development tools and skill sets along with the decisions of what mobile platforms to support can make the entry into mobile application development very difficult for many organizations. A new technology, however, makes decisions about mobile development much easier: JQuery Mobile. Oracle Application Express integrates very easily with JQuery Mobile and this combination can be used to create mobile applications that are supported on a wide range of mobile devices relatively simple.  This presentation will walk attendees through the steps of building a mobile application using Oracle Application Express. Attendees are encouraged to bring an iPad (or other mobile device) to actively participate and see the final results of their work.

Chris Ostrowski is an Oracle Solution Architect Director for Avout in Colorado. He has worked with Oracle technologies for over 20 years as a Developer, DBA, Project Manager and Enterprise Architect. Recently, Chris has focused his efforts on Service Oriented Architecture technologies including Oracle JDeveloper, the Oracle SOA Suite and Enterprise Technologies including Oracle Fusion Applications and Oracle’s Application Integration Architecture. He is the author of three books from Oracle Press, “Oracle Application Server 10g Web Development”, “The Oracle Application Server Portal Handbook” and the upcoming “Migrating to Fusion Applications”, is a certified Oracle SOA Implementation Champion and is a proud member of the Oracle ACE Program.

Oracle Application Express (APEX) provides several reporting options, allowing developers and users to quickly generate and view reports on data stored in the Oracle database. Users export their report data in PDF format, provided they have an external print-rendering engine configured with their APEX instance. With Oracle Application Express 4.2.2, the configuration has been simplified by building the PDF rendering functionality right into the APEX Listener. In this session we will show you how to configure PDF printing and demonstrate how you can create PDF reports with fully customized report layouts using standard XSL-FO layout tools, like Altova Stylevision and Stylus Studio.

Marc Sewtz is a Senior Software Development Manager at Oracle Corporation in New York. With over 16 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 APEX development group, part of Oracle Database Tools. 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 a Master’s degree in computer science from the University of Applied Sciences in Wedel, Germany.

Tagging, encoding, and encrypting with RMAN allows Oracle DBAs not only to secure database backups, but also to customize them in order to provide an intelligent repository, with the ability to attain faster restores, comprehensive recovery, and optimizing throughput for all RMAN operations, while guaranteeing the privacy and confidentiality of the backup contents.  This session will reveal top techniques to encode, tag and encrypt RMAN backups with a comparative benchmark on Linux, Windows, and Solaris systems through custom RMAN scripts supplied.  The session will also demonstrate how tagging and encoding can optimize channel usage and minimize the Mean Time to Recover (MTTR). This session covers releases Oracle10g through Oracle12c.

Anthony D. Noriega is a Senior IT Consultant and computer scientist who has focused his efforts in Oracle database technology, network computing, software and network engineering, and object-oriented programming paradigms. Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony has earned an MBA from Montclair State University (2006), and MS in Computer Science from NJIT (1992 doctoral candidate through 1997) and a BS in Systems Engineering from University of the North (1987). He is an Oracle Certified Professional and Senior Oracle DBA/Developer and a member of IOUG, NJOUG, and NYOUG Oracle groups.