2010 Presentations
Please continue to check back for changes to the agenda

Conference Schedule
Wednesday Schedule | Thursday Schedule

Presentations now available for download!
Continue to check back for more presentations.

Keynote Address, Craig Shallahamer, OraPub, Inc.
A Day in the Life of an Oracle Block

Keynote Address, Charlie Garry, Director, Oracle Corporation
Lowering Your IT Costs

Application Development
Data Warehousing/BI
DBA
Oracle Apps
Management/Trends
Security
System Architecture/Administration

Application Development

"Excel"ing with PL/SQL: Generating Excel Spreadsheets with PL/SQL
Jason Bennett, Charlotte-Mecklenburg Police Department
This presentation will demonstrate how to create and distribute fully functional Excel spreadsheets with features such as multiple worksheets, custom styles, formulas, and hyperlinked cells using only PL/SQL.

A Language-Neutral Programming Interface to Oracle
Andy Bourassa, Digital Gaslight, Inc.
Complete with interesting visuals and breathtaking narrative, this is a combination case study and how-to story telling how our company eliminated embedded SQL from our customers' apps and developed a language-independent interface to Oracle.

Rich Web Applications for the Enterprise... Creating RWA From Your Oracle Database
John Krahulec, TURBOEnterprise
Deliver the latest in Rich Web Applications (Ajax, Flash, XHTML) AND eliminate the "middle-tier tax" at the same time. The traditional n-tier architecture has become an overly complex and bloated obstacle to Web development. Leverage the power of your existing Oracle database and PL/SQL development skills to create the rich Web applications your customers desire.

Gaining Insight into Business Resources Using Oracle APEX
Doris Phillips, City of Charlotte
This session is a case study that describes the development of an Oracle APEX application that captures resource skills, technology skills, and resource assignments for analysis purposes.  The application allows employees to enter their skills and allows managers to enter technology skills required for implementing the solutions and the resource assignments.

Dramatic Performance Increase Using Results Cache
Dean Richards, Confio Software
Defensive programming is a method used to ensure that a piece of software continues to function even though it may be used in unintended ways.  This is particulary important when software is used mischievously.  This presentation will provide an introduction by exploring several case studies of poorly written code that can cause incorrect results, SQL injection opportunities, and  performance issues.

Data Warehousing/BI

Done with ERP, Here's Your BI ToolKit
Rishi Bhatnagar, Syntelli Solutions, Inc.
Buying BI is not just a choice between vendors. The more important question is what kind of BI are you looking for: Operational BI or Strategic BI? Your imagination and your data are two underlying props for success in BI, so leverage them! This presentation will arm you with strong practical learning whether you have an active BI initiative or are contemplating one!

Enterprise Performance Management at Duke University Health System
Greg Vlahos , Analytic Vision
In this session you will learn how DUHS implemented three Oracle EPM applications (Hyperion Financial Management, Hyperion Planning, and Hyperion Essbase).   You will hear how DUHS converted from legacy Hyperion Enterprise and Pillar to Oracle’s latest EPM Applications along with the implementation of the Release 11 solution which leverages Oracle Hyperion Enterprise Performance Management Architect and Oracle Data Integrator.

Converting Oracle Reports to BI Publisher - Key Steps to a Successful Migration Project
Jennifer McNeill, CipherSoft, Inc.
BI Publisher provides a robust business intelligence reporting environment.  Learn how to convert Oracle Reports to BI Publisher by building a structured project plan and utilizing proven conversion technology. The end result is a completely usable, stable environment that will provide immediate access to data and benefits to the entire organization.

Sustaining Government Effectiveness through Visual Analytics
Jim Raper, City of Charlotte
In less than a year, the City of Charlotte has increased its use of visual analytics seven.  With the unanticipated tough economic conditions, this explosion of visual analytics has resulted in cost savings that have tempered the negative effects of revenue shortfalls as its departments are working smarter - not harder.  This presentation provides the groundwork for expanding the acceptance of new technology, such as Hyperion Visual Explorer, among business analysts and reducing IT’s reporting load.

With So Many Data Integration Tools in the Kit, Which Tool Is Right for the Job?
Paul Scott, SSG, Ltd.
Oracle offers a number of integration tools to assist in the movement of data.  This presentation will list the various offerings, and offer recommendations as to which product is right for your application.

Integrating Essbase & OBIEE with Your Data Warehouse Strategy
Kelli Stein , interRel Consulting
If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution.  Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases.

To Parallel or Not To Parallel
Romeo Vasileniuc, BB&T Specialized Lending
When it comes to parallel operations everybody expects to get performance results similar with the init.ora secret hidden parameter: _db_performance=fast. The presentation will review the Oracle Parallel option feature and the performance problems that can arise if not used properly.  Introduced will be basic parallel execution architecture, degree of parallelism, instance configuration, hints for parallelism, and monitoring parallel operations on Single instance Database and Real Application Cluster Database.

Take a Test Drive Down Oracle’s BI Roadmap
Greg Vlahos, Analytic Vision
This presentation describes the various offerings that Oracle has for Reporting and Analytical solutions, including detailed information on OBIEE, OBIEE pre-built applications, and OBIEE Essbase integration.  The presentation will also discuss key functionality coming in the next release, and will provide a detailed demonstration of OBIEE analysis that includes a drill to relational detail solution that takes the user from high level sales down to the invoice detail and into the actual invoice object.

DBA

Testing to Destruction: Part Two
Michael Ault, Texas Memory Systems, Inc.
This presentation covers the use of synthetic workloads in the testing and validation of Oracle systems. TPC-C and TPC-H tests will be discussed and examples will be shown utilizing the workloads.

Mission-Critical Database Change Deployment: Rapid, Manageable, Consistent
Vlado Barun, Jewelry Television
This presentation introduces a lightweight methodology for quickly, simply, and consistently deploying database changes in 24/7 environments.

Successful Oracle Database 11g Upgrades with the E-Business Suite
Michael Brown, Colibri Limited
Upgrading your database can be a complex task.  This is compounded when you are in the E-Business Suite.  The issues involved in an upgrade to 11g will be discussed with an emphasis on the extra steps you need to worry about when the E-Business Suite is part of the upgrade.

Multi-Protocol Unified Storage for Oracle Database Environments
Jeff Browning, EMC Corp.
This presentation will focus on the use of various storage protocols (NFS including Direct NFS, ASM over FCP, MPFS and pNFS) for storing the Oracle database. Particular emphasis will be placed on the advantages of using multiple storage protocols simultaneously for various storage components in the database configuration.

Database Duplication Using RMAN in 11g
John Claxton, B/E Aerospace
Cloning (or duplicating) a database is a common DBA task. This session discusses the improvements available in 11g RMAN. During the presentation a live cloning will be performed and we'll hit some bumps along the way, which will be learning opportunities. Using RMAN to create "clones" of a database keeps getting better and better.

The Database Breaks—You Fix It: An Introduction to 11g Data Recovery Advisor
Controlfile | Datafile | System | Repair Advisor
John Claxton, B/E Aerospace
When a database "breaks" (disaster), it’s the DBA's job to "fix it" (recovery). With 11g, the Data Recovery Advisor (DRA) can help. Either through command line or GUI tools, DRA can show you what’s wrong, tell you how it can be fixed, and even fix it for you.

Application Performance Tuning: A Practitioner’s Approach
Roger Cornejo, GlaxoSmithKline
Database application performance tuning is a high value-adding activity. This presentation provides an in-depth look at tuning from a practitioner’s perspective with the goal of improving query response times. Covered topics include SQL tools, tricks/traps, and a plethora of approaches for uncovering performance bottlenecks quickly, and discovering solutions that work.

Top 5 Data Management Strategies for 2010 for DBAs
Kay Groski & Steve Johnston, IBM
For most IT organizations, there are several common challenges facing them
as they begin implementing their plans for 2010 and beyond: (1) The need to "do more with less", while meeting the challenge and explosion of information and dwindling oversight; (2) The need to upgrade and provide the features and functionality which business demands; and (3) New and increased regulations and the ever important need to understand the location and structure of your most valuable and sensitive data across all systems. These factors are probably affecting you and your organization in some way, every day and you need to be able to respond. Join us as we discuss these topics and how you can address them leveraging the top data management strategies to help your organization withstand the IT challenges of 2010 and beyond.

Listening In: Passive Capture and Analysis of Oracle Network Traffic
Jonah Harris, myYearbook.com
This presentation discusses and demonstrates the methods for passively capturing, analyzing, and reporting the details of Oracle network traffic.

NetApp Oracle Solutions—Outrageous Efficiency Claims or Real Business Value?
Bill Heffelfinger, NetApp
For more than a decade, NetApp and Oracle have continued to collaborate and share the same vision. We focus on developing solutions that help you reduce the complexity of managing and storing information.  Deploying Oracle applications in your enterprise can yield major business benefits - and NetApp can help you get there faster. We run our own critical business applications on Oracle, and we've developed the expertise to assist you in deploying and managing your optimal combined storage and Oracle on NetApp solutions.  In this session you will learn more about our partnership with Oracle and how our database efficiency and manageability capabilities can help you lower your costs.

Measuring for Robust Performance
Robyn Sands, Cisco Systems
The first step in any performance improvement project is benchmarking the existing performance level. What you measure, how you measure it, how you analyze the results and how you define your goals will have a significant impact on your project's success. Do you measure an individual process or the overall throughput? Do you use the 10046 trace, Stats Pack, ASH or AWR? And how do you identify the critical information within your performance data and provide proof of the
improvements to the business? This session will present multiple measurement methods and how they can be used most effectively to achieve robust performance.

Oracle Apps

E-Business Suite 12 Upgrade—An Easier Ride on 9 Miles of Bad Road
Michael Barone, OATC, Inc.
Attendees will learn the new installation and upgrade features, E-Business Suite 12 supported upgrade paths, technology (Tech-Stack) differences in E-Business Suite Release 11i and Release 12, and step-by-step new technology features and setups.

How to Manage a Successful R12 Upgrade and Overcome the Challenges: Methodology and Tips that Work
Art Dowd, O2Works, LLC
If you are upgrading from the 11i apps to R12, it’s a different animal. The tools and technology have been improved but the impact will be more widely felt. Your criteria for success will be different. If this is not addressed in the planning and project management, you could learn some painful lessons that are avoidable.

Maximum Availability Patching Strategy (MAPS)
Edward Jayaraj, Oracle Corporation
Often clients seek a solution for minimizing the patching downtime, so organizations are very much interested in Maximum Availability Patching Strategy (MAPS). Some clients have also invested in advanced architecture and are still struggling to meet the 7x24 SLA cycle of their production instance.

Forms Personalization
Talbott Jones, Colibri Information Management
Forms Personalizations allow functionality modification of Oracle Applications forms without changing underlying code. We will use two real world examples to show how personalizations work.  We will make a field required, insert default values, display a message and display a warning.  We will hide a button and we will have the system populate a field with one of three possible values.  Documentation, risks, and migration will be the wrap-up.

Management/Trends

Roadmap to International Financial Reporting Standards (IFRS)
Gunjan Dhanuka, Cyret Technologies, Inc.
International Financial Reporting Standards (IFRS) are coming down the pipeline. Over 100 countries now require or permit IFRS reporting. Worldwide countries are moving toward either adopting or converging to IFRS as common accounting standards across the globe, which may represent a major change in the way most companies currently present their financial results.

Getting it Right the First Time: To Model or Not to Model, That Is the Question
Michael Farnsworth, Virginia Dept of Motor Vehicles
In the "Getting it Right the First Time" series, we ask and answer the question, "How much design is too much design, and how little design is too little design?"  You've heard of "Big Design Up Front" and "No Design at All", so what does this all mean? We'll get to the bottom of it all in our quest to "Get it Right the First Time."

Corral: Bringing Non-Oracle Applications Into the Fold
George Flanagin, Digital Gaslight, Inc.
Business exigencies and rogue programmers combine to leave even "all Oracle shops" with critical applications that IT did not develop and cannot support. These applications are often brittle and have been written by amateurs. This lecture discusses the business case and strategy for cost effectively "herding" orphan and runaway applications to the Oracle fold.

Security

The Achilles Heel in Your Data Security Strategy
Tony Cannizzo, DynamicDB
Dynamic Data Masking is an emerging technique that brings data masking into the production environment. Commonly, an ETL process will write obfuscated values into a target database. This is Static Data Masking, which for obvious reasons is not practical for production. Dynamic Data Masking obfuscates sensitive private Information at the presentation layer without changing the database or the source code.

Attack Your Database Before Others Do
Slavik Markovich, Sentrigo
In this presentation, we will show typical security flaws found in PL/SQL and Java code due to programmer mistakes. We will demonstrate how to use existing open-source scanning and fuzzing tools to automatically find and flag such flaws, and also demonstrate how creating your own tools in PL/SQL can help you keep your code secure.

System Architecture/Administration

Utilizing ASM Preferred Read Groups to Maximize Oracle Performance
Michael Ault, Texas Memory Systems, Inc.
This presentation will discuss a new architecture using Oracle11g ASM and preferred read groups to maximize Oracle performance and reliability.

Getting it Right the First Time: Architecting a Highly-Available, Fast, and Secure Oracle Deployment
Ron Carovano, F5 Networks
You've spent hundreds of thousands, or even millions of dollars developing and
deploying Oracle solutions.  Upon deployment, you discover that many remote users are unable to use the application due to unacceptably slow network performance. Your application slows to a crawl, new security concerns are coming up faster than you can update the applications, and complaints from your customers, partners, and co-workers are starting to mount.  Sound familiar?  Come learn how the discipline of application delivery networking can provide an agile infrastructure to ensure your Oracle applications are always available, fast, and secure.

When You Don't Know, What You Don't Know
Faun deHenry, FMT Systems, Inc.
This presentation is a full case study of a company’s trials and tribulations while integrating Oracle EBS applications to a multiple business functionality for a center of success.

Oracle High Availability Solutions
Ian Remidios, Oracle Corporation
This session will introduce you to the latest Oracle technology and services to support your high-availability needs. It will cover virtualization and fault tolerant computing with RAC, Grid and Exadata, disaster recovery with Data Guard, and database replication with Streams and GoldenGate.