2012 September General Meeting Presentations

Databases keep getting bigger and bigger. Business applications that utilize these ever growing databases are expanding at an alarming rate. Businesses to stay competitive require additional functionality and technology. The Technology needed to make that additional functionality possible keeps getting more and more complex. To make matters even worse the DBAs needed to keep it all running are hard find hard to retain and good DBA skills take years to acquire. Now the role of the DBA is fundamentally changing in a way it has not changed before. In this keynote, we will review the trends in database administration, how they are affecting the DBA, and why the future of Database Administration (if it is to stay relevant) is the vDBA.

Michael Corey, founder and CEO of Ntirety, is widely recognized as a leading authority on relational databases, remote database administration and data warehousing. Michael is recognized as an Oracle Ace by Oracle and a vExpert by VMware. He is a past president of the Independent Oracle Users Group, a founder of PASS (Professional Association for SQL Server), and he currently serves on the executive committee of the Massachusetts Robert H. Goddard Council for Science, Technology, Engineering and Mathematics.

Don Sullivan has been a VMware SE Database Specialist covering North America since 2010. Don spent seven years with Oracle University teaching Oracle Server technologies and as an ATS consultant and five years with HP as part of the Polyserve acquisition. Don is an Oracle Certified Master.

DBA TRACK:  Reduce Your Disk Footprint by Sharing Read-Only Tablespaces

This presentation highlights the benefits of sharing read-only (RO) tablespaces among multiple non-production database copies. A thorough review of the standard, transportable tablespaces based, method for sharing RO tablespaces and a powerful, but not supported, universal method for sharing RO tablespaces is included. Implementation strategies and technological tips are discussed in detail.

Iordan Iotzov is a senior DBA at News America Marketing (NewsCorp) with more than ten years of database administration and development experience. He has an 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 presented at Hotsos 2012, NYOUG and BrainSurface VirtaThon, frequently participates in OTN forums and actively blogs at http://iiotzov.wordpress.com/.

DBA TRACK:  Virtualizing Oracle on VMware: Doing It Right

A database is very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for virtualizing Oracle/MySQL/SQL Server databases on VMware. We will also discuss the business case for virtualizing a database.

See bios for keynote presentation

DBA TRACK:  RAC One-Node – Reduce costs, Replace Third-Party Cluster Services with CRS

There are several vendors providing clustering capabilities for databases. The beauty of using Oracle’s RAC One-Node is that it is integrated with the Oracle stack and can help to reduce overall software costs. This gives you one vendor to handle both the clustering software and the database. Additionally, you gain the ability to upgrade to a fully RAC-enabled database at a later date with relative ease. This presentation discusses the basic Grid infrastructure required to implement RAC One-Node and how to avoid some of the pitfalls inherent in constructing a RAC environment. Additionally John will touch upon some of the utilities that can be used to manage this environment.
J
John Larkin has worked as an Oracle DBA for the last 18 years. He is currently working for a financial services company. His current project is to build the infrastructure to support the eventual migration of a Veritas-managed cluster with 140 databases from Solaris to Linux using RAC One-Node.

Frequently, during a project life cycle, new technology is introduced that presents first time challenges. This session describes a project using Oracle XML DB (Oracle Database 11gR2/SQL Developer 3.1) and discusses why XML DB was chosen, how XML DB was used and the technical issues encountered. The presentation covers several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT, XMLFOREST, dbms_xmldom and XQUERY. Attendees will learn about methods, design considerations and issues using Oracle XML DB. The presentation also provides working examples that you may copy and paste into your Oracle environment.

Coleman Leviter has presented at IOUG’s Collaborate, Oracle Open World and NYOUG Conferences. His articles have been published in NYOUG’s Journal, IOUG’s Select Journal, OTDUG Journal and IOUG’s Best Practices Handbook. He is the NYOUG Web SIG Chairperson and has recently been elected to the IOUG’s Board of Directors.

Oracle Data Integration models provide support for up to 10,000 different concurrent data sources independently including a variety of structured and unstructured data sources such as relational and object relational databases, XML, flat files, multi-dimensional data sources, message queuing and others, using Oracle Data Integrator, Oracle Streams AQ, and Oracle Golden Gate (OGG). These models encompass significant heterogeneous workflows from both virtual and physical databases, including RAC. The Oracle Data Integration model is flexible and ideal to work with Oracle Sun appliances such as Big Data, ZFS, Exadata, Exalogic, and Exalytics appliances, as well as Oracle Solaris SuperCluster T4-4, since it provides seamless designing capabilities through fast bulk transformations. The Oracle integration model is quite versatile in interaction with other tools such as Oracle GoldenGate, allowing for fast Advanced Replication, including both full replication and thin provisioning. This presentation will demonstrate modern ELT ODI and OGG capabilities live and discuss the enormous benefits of adopting this model. As part of the Oracle Fusion Middleware, this approach becomes extremely hot-pluggable. The Oracle Data Integration model also works well along with Oracle WebLogic, BPEL Process Manager, Hadoop, TopLink, JDeveloper, and Oracle Identity Management.

Anthony D. Noriega has been a systems engineer, computer scientist, OCP instructor, and Adjunct Professor, who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming. He blogs at http://noriegaaoracleexpert.blogspot.com. At ADN R&D, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony holds an MS Computer Science from NJIT. He has been a consultant for several financial and industry-leading American and European corporations. He is a frequent presenter at IOUG, Quest Conference, Oracle Open World, SEOUC, and NYOUG.

Behind the scenes, Oracle databases hide a myriad of different processes to ensure that your data can be safely stored and retrieved. But these processes also leave “tracks.” You can tell a lot about the database if you can read those tracks. This presentation is focused on additional sources of database information and techniques that can be very helpful to developers namely: key Oracle Data Dictionary elements, tracing, and logging techniques.
These can be very handy at different points in the development lifecycle, because instead of having to make guesses, they allow developers to know precisely what is going on in the database.

Michael Rosenblum is a Development DBA at Dulcian, Inc. He is responsible for system tuning and application architecture. He supports Dulcian developers by writing complex PL/SQL routines and researching new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press, 2006). Michael is a frequent presenter at various regional and national Oracle user group conferences. He won the ODTUG 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics.

Grigoriy Novikov is a Senior Developer at Dulcian, Inc. He specializes in the development of various industry and government systems such as Customs, Real Estate, Finance, Military (both US and abroad). He is also responsible for Database Modeling, researching new database features and tuning. Grigoriy holds a BS in economics (Institute for MIS) from State University of Management in Moscow.