Keynote Speaker

Presentation Summaries
            

Click on a presenter name to view summaries and click on the speaker presentation link to download the available presentations.

Addeo | Ault | Baxter |Braunschweig | Brown | Bruno | Burleson | Cannell| Coulam | Cunningham | Deeley |de Visser | DiGiacinto | Dijcks | Dorsey | Engel | Fernandez| Fink | Fons | Furnish | Garmany | Garrison | Gennick l George l Gorbachev | Gorman | Grossnickle | Haisley | Harper | Hay | Hess | Horton l Hotka | Hutchinson | Iveslatt | Jackson,B | Jackson,S | Jaffar | Jedlinski | Jenne | Carol Jeunnette | John Jeunnette| Jun | Karlstrand | Katsaris | King | Koletzke | Koopmann | Kyte | Laird | Lemme | Lewis | Lipowitz | Liu |Marx |McGurk l Mills l Millsap | Mishek | Moore | Morgan| Munsinger | Niemiec | Nikitin l Nims | Nørgaard | Ostrowski | Phillips | Presser | Reading | Reynolds | Rosenblum |Shamsudeen | Steber | Straub | Than | Trujillo | Turner-Underwood | Warhoe| Wille | Wimsatt | Wood | Worfolk | Wu

Back to the Top

This presentation will cover the new tools in Oracle11g that allow the database administrator to tune virtually every aspect of their database environment. SQL, access, backup, and replay utilities make the DBA more able to tune and control his or her database than ever before. This presentation will feature demonstrations of several of the tools from a manual viewpoint.

Back to the Top

Public speaking is not something to be feared. Speaking and presentation skills are important assets that professionals need to get and hold their jobs. The ability to develop and deliver a polished presentation is an important skill to have when it becomes necessary to sell ideas or to get a point across. Technical professionals with superior presentation skills can advance their careers by earning recognition among superiors, subordinates, and peers. Developing a polished presentation is difficult, but with time, effort, a few basic techniques, and the proper tools, it can be done. This presentation will provide tips on overcoming the fear of public speaking, preparing a speech, then delivering it to a technical or non-technical audience.

Back to the Top

The presentation will cover the use of alternative open source reporting solutions for Business Intelligence. This presentation will show the current state of several open source solutions as well as an in-depth overview/setup of the Pentaho tool suite using Oracle.  Attendees will see how a full Business Intelligence solution can be developed and deployed integrated with the Oracle platform; including ad hoc and standard (or fixed) reporting, multi-dimensional analysis, and ETL.

Back to the Top

Internal and External Application Integration — Oracle Fusion Web Services
Speaker Presentation

Having ventured down the path of a full born implementation of internal and external application integration in what I perceived as the most efficient and cost-effective manner, you'll get the benefit of my hindsight introspections today. Specifically, I implemented a lightweight Service Oriented Architecture (i.e. Web service) wherever it made sense. This presentation will discuss the good, bad, and ugly about the approach that was taken. Knowing what I know today, I would take this approach again. In fact, I highly recommend my self-named lightweight SOA. Using Web services, your customers (whether internal or external) are able to seamlessly access your core technology as if that technology is running in its own environment. This presentation will include a demonstration of the above mentioned application. If you have customers or vendors who have provided you with Web Services that you need to integrate into your existing applications, you'll want to attend this presentation.

Advanced ApEx
Speaker Presentation

Now that you have figured out just how easily Oracle Application Express (ApEx) can be used to quickly develop and deploy critical applications, this session will help you to take your ApEx development work to the next level. In this session, we will explore advanced topics that utilize ApEx APIs, AJAX, JavaScript, XML and more.

Back to the Top

This presentation is intended to educate users, developers, and managers using Oracle E-Business Suite to learn how to utilize native Oracle functionality (workflow, forms, and database technology) to automate e-mail and fax delivery of any document and volume of documents with XML Publisher integration. This session provides valuable insight into document delivery, acknowledgment, and management using robust software backed by twenty-one years of established experience. Learn how Canada’s largest communications company, an electric utility cooperative, and a major tire distributor realized immediate savings, streamlined back-office processes, increased employee productivity, and shortened procure-to-pay and order-to-cash cycles for their products and services

Back to the Top

In today's Oracle database management systems, physical disk I/O remains one of the foremost bottlenecks. Even at relatively fast speeds of 10 milliseconds, many data intensive Oracle applications can still choke on I/O by having disk enqueues or Oracle block read tasks waiting to pull information from the spinning platters. Data compression is certainly useful for reducing the amount of physical disk I/O but there are some caveats that need to be followed by the Oracle database administrator.

Oracle SQL tuning is now more complex than ever before. This presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle10g SQL tuning features. The topics will include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, re-writing SQL queries in more efficient forms, and the use of advanced techniques such as materialized views, replacing SQL with PL/SQL, the new automated CBO statistics collection, and using the new Oracle10g CPU costing approach. Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.

Back to the Top

The best way to learn APEX is to see a useful feature demonstrated, then take a look "under the covers" to learn exactly how that feature was implemented. This session demonstrates a series of not-so-intuitive features in APEX, then takes a detailed look under the covers at the implementation details, using a mix of APEX constructs, AJAX and JavaScript. The focus is on how-to, where else to use similar constructs, and adopting existing code for reuse. The goal is for attendees to gain a few more tactics and tricks for their APEX toolbox.

Back to the Top

If your company is beginning to create (or already has) custom systems that use PL/SQL somewhere in the application stack, you probably need a PL/SQL application framework. This presentation will briefly cover what an application framework/library is, how one determines what to put in it, and how to build and deploy it to avoid common pitfalls. We will also examine some of the present libraries and frameworks available commercially and through open source. References will be made to the presenter's freeware framework which has been used successfully by a number of past clients and employers. Attendees are encouraged to download, peruse, use, and improve the framework.

Back to the Top

This presentation, useful for Oracle developers and database administrators, explores the various V$SQL views that comprise the visible aspects of the Oracle library cache. Special emphasis is given to identifying, testing, and profiling troublesome SQL statements. Methods for tracking and comparing baselines and variations are explained, along with take-away SQL scripts for this purpose. In addition, new Oracle Database 11g features pursuant to the library cache are revealed.

Back to the Top

IT Governance, risk, and compliance management is a topic of much current debate.  The global economy's dependence on high-quality data, continuous service availability, and system performance means that the oversight of core IT infrastructure is a key component of enterprise risk management and compliance. The successful application of IT Governance principles can provide a mechanism to increase the effectiveness of IT, and in turn, meet the increasingly stringent demands placed on IT by regulators and by the business. In the past Twelve months, Oracle has made significant investments to help customers simplify and integrate IT Governance for improved business performance. Join this session to find out the latest in Oracle GRC, including the recent acquisition of LogicalApps.

Since its inception, ERP systems have struggled to provide accounting and finance departments with easy to use reporting tools. Most report writers are difficult to use, require development skills, are slow to run, and can't drill down for further analysis. What's more, by the time you have designed, created, and run the data it is out of date.  Business Intelligence (BI) was invented to fill this void. However, the nature of most BI systems, latent data, staged data, and transformed data, seems to fly in the face of the fundamental accounting principles. The major flaw is data must be duplicated to a data warehouse. The data transfer is normally run overnight, and it can take as long as 24 hours for the data to show up on a report, often rendering the financial information obsolete before it is even reviewed. To overcome the off-line limitations of BI, companies have started using home-grown Excel spreadsheets or Excel plug-in applications to pull data directly from the ERP system, a practice known as Shadowing Data (SD). This presentation will show you how Accounting Intelligence tools combine the best aspects of BI and SD tools, offering the speed and simplicity of implementation and use, with the security and power of a full scale Business Intelligence solution.

Back to the Top

As demand for availability increases, all self-respecting vendors tumble over one another to provide "solutions" for better availability. From an Oracle database perspective, we see the use of RAC, DataGuard, ASM, Direct NFS, and various Oracle and non-Oracle tools that spring up around those. Can many databases share a single system (m:1)? Should a single database be shared over many systems (1:m, grid)? Is 1:1 an option? Various options for virtualization offer even more flexibility. How do you stay ahead of this inevitable evolution? And what sensible and practical choices can you make? How do you make sure your systems stay robust, manageable, and of an assured high availability? What is the role of the business, of the ASP and of the IT department ? How can they impact the decisions?

Back to the Top

The nightmare of each ETL developer is to reliably and accurately match data elements from disparate systems. Whether you are looking at a master data management solution or a data warehouse, you will need to automate your match/merge process. We will show you how you can deal with this nightmare using Oracle Warehouse Builder. This session will go in-depth into how to set up a system that does the heavy lifting using match and merge rules fully based on algorithms and science rather than on gut-feel and lots of hard-to-maintain custom code.

2008 will see the next big update of Oracle Warehouse Builder. We will bring the latest software to Denver and show you (among other things): loading heterogeneous targets based on Oracle Data Integrator technology; Web services and BPEL support from within Warehouse Builder for any heterogeneous process; integration with Oracle BI Enterprise Edition and end-to-end lineage and impact analysis; and the new IDE for Warehouse Builder and many new goodies such as spotlighting, auto-mapping, and advanced search.

Back to the Top

For organizations adopting Oracle's Fusion Middleware as their development technology stack, there are many decisions to be made regarding which portions of this stack to use and how to integrate these technologies into an effective development environment. Should you use JSP/Struts or Faces? How does BPEL fit into the process? Should applications be built to be database-independent or heavily rely on the database? This presentation will describe the experiences of two development teams trying to answer these questions and what development environments were ultimately selected.

Most large software project failures could have been prevented if someone had bothered to take an objective look at the progress of the system at key points along the way. Even if an audit doesn't prevent the project from failing, discovering serious problems earlier in the project life cycle can save both time and money. Software system audits are, in and of themselves, significant projects. They cannot be accomplished by a single individual interviewing a few members of the development team over a few days. An effective audit requires a skilled team of individuals examining the functional adequacy of the system, the quality of the database design, system security, flexibility, and scalability over time. This presentation will outline the key points in a project when these audits should be performed, how to select the audit team, and the information that can be gained from the results of the audit. A case study chronicling the audit of a large financial system built in a developing nation will be included.

Back to the Top

Oracle Data Guard comes with two very nice new feautures (among others): compressed redo transport and the real time query capability of physical standby. The latter is a priced option, making a Data Guard configuration even more expensive. However, now the resources of the standby server can be used to provide reports, support Data Warehouse feeds etc., instead of having a server 'sitting idle', just in case. Can compressed redo transport help this scenario become true, by allowing synchronous redo transport at lower bandwidth usage? This presentation will give you the information you need to answer this question.

Data Guard is a high availability solution that protects you from more than just hardware errors. It can also save you from logical errors, statistically known as the major cause of unavailability of an RDBMS. If you have ever been (part of) the root cause of a disaster striking a production system — who hasn't? — this might be a nice session to help you recover from future disasters. This presentation will explain how the architecture of Data Guard can provide you with a safety net. Recovery actions after a disaster will be demonstrated.

Back to the Top

Deadlocks are not well understood and the trace file generated by Oracle when a deadlock occurs suggests that a deadlock is a problem "due to user error in the design of an application or from issuing incorrect ad-hoc SQL." In fact, sessions can deadlock even if they are not contending for the same data and a session can even deadlock with itself! We discuss this and other misconceptions about deadlock and demonstrate multiple ways in which deadlock can occur. The trace file created by Oracle when a deadlock occurs does not contain enough information to diagnose the problem and we suggest a better way. We end with an amusing demonstration of the phenomenon of "livelock."

The query optimizer assumes that the columns of a table are independent. For example, the optimizer cannot predict that the query SELECT * FROM CARS WHERE MAKE = 'TOYOTA' AND MODEL = 'ACCORD' will not produce any rows of data. Also, the optimizer does not know how many rows will be created when two tables are joined. The search for the best execution strategy is heavily influenced by the estimates of the cardinalities of SQL operations, such as Selection and Join and is therefore prone to error. The query optimizer also has to contend with SQL redundancy, computational complexity, and bind variables. We analyze these four problems and discuss the available workarounds. We conclude with a discussion of improvements in Oracle 11g including the “learning optimizer,” multi-column statistics, and statistics on expressions.

Back to the Top

Introduced in Oracle8, Statspack has become a valuable resource for diagnosing systemic performance problems. However, statspack data structures and snapshot logic are designed to support the supplied reports. Going beyond the basic report requires additional understanding and techniques. This presentation begins with an overview of statspack processing and data, focusing on the traps that can cause even the standard report to miss key information. Next, analytical functions are introduced and key concepts relating to reporting performance information are examined. The final topic is the integration of statspack data and analytical functions using examples from actual system monitoring activities.

Regular expressions have long been used in the Unix world. With Oracle 10g, they have now entered the SQL toolbox. For those unfamiliar with them, regular expressions can be both complex and confusing, but do bring substantial flexibility to the developer. This paper attempts to introduce them to the competent SQL user who has no experience with regular expressions, either in 10g, or in the Unix world. Rather than simply list their parameters, this paper will demonstrate, using simple worked examples, how the four types of regular expressions can be used in everyday coding situations. It will show how these expressions are built on the existing and familiar SQL character functions, and will explain in detail each of the various parameters associated with the four regular expressions.

Back to the Top

At Graebel Companies, Inc. and as a volunteer at RMOUG, there are opportunities for me to implement applications and modules using the ADF tool. Both opportunities provide ample examples of practices which do well and practices which do not. In this case study presentation we will look at these pluses and minuses in a more detailed way, and the presenter will generalize about an organization's first applications using the ADF tool. Issues regarding menu systems, security concerns, user-interface components, business components, and custom class adaptations utilized will be covered. This presentation will target a beginning to intermediate ADF/JDeveloper audience.

Back to the Top

Douglas County School District knows we are not unique in our struggle to get useful information from the Oracle E-Business Suite and other systems. (We keep acquiring other Oracle and SQLServer based systems.) Over the years we have spent large amounts of time writing custom reports, Discoverer workbooks, and ad hoc queries, with little to show for it. Until recently, a user request for information was likely to result in yet another ‘from scratch’ effort. We weren’t building on what we had already done, mostly because we were overwhelmed with new requests. This talk will focus on some successes in the past year to reduce the time effort, yet improve quality and availability of information. There have been some custom efforts in pulling data together into a useful format – data about reports and about employees. The presenter will share code and will talk about efforts to introduce new reporting tools: Discoverer 10g, MicroSoft Reporting Services and XML Publisher (aka BI Publisher) and how DCSD has worked to overcome a passive user mindset – why learn a new tool when you can just create a ticket and have IT do all the work?

Back to the Top

Being Regular with Regular Expressions

This updated presentation will focus on the why and how of using regular expression within the Oracle database. Unix SAs know the power of matching with regular expression and now the Oracle DBA and developer can put that power to use. But regular expressions are not the only answer in all situations. We will cover your regular expression options in SQL, PL/SQL and Java. This presentation will include the new 11g capabilities. This presentation will also discuss improper use of regular expression that can have a large negative impact on database performance. This presentation will explain the pros and cons of each method and when they can best be utilized to provide you with high performance matching capability.

The DataGuard Logical Standby and Oracle Streams both use SQL Apply to move data from one database to another.  Although one is built for protection and the other for replication, many times an organization will implement the wrong technology because they do not understand the capabilities and limitations of each product.  This presentation will discuss the capabilities of these similar technologies focusing on the advantages and disadvantages of each implementation.  This includes setup requirements; switchover/failover, implementing RULEs and custom apply processes to control data flow and format.  A detail discussion of the impact and maintenance requirements will also be covered.

Back to the Top

Back to the Top

Writing can be a huge boost to your career. Writing is a way to join in the fray, communicate with fellow professionals, influence your industry, establish your competency, help others learn, and push yourself to learn. Computing professionals are in a very favorable position—compared to aspiring authors in general—to become published. This presentation explains how the publishing industry works, tells what publishers look for in book proposals, warns of what you are getting into when you dare to write a book, and shares some tips on working smoothly with your editor. You’ll learn the benefits from publishing and some of the pitfalls to avoid. Should you aspire to someday write a book, you’ll leave this presentation with (hopefully!) a good idea as to how to make that aspiration become a reality.

Back to the Top

Oracle Business Intelligence Suite Enterprise Edition is a robust, flexible, next-generation business intelligence platform that enables organizations to tap into any data source and deliver actionable insight to all users across an organization. This session provides a technical overview of the platform, reviews how it fits into a typical IT environment, and outlines the significant benefits of its architecture.

Back to the Top

Automatically starting and stopping applications in a clustered environment can be a complex task, quite unlike the same task in a non-clustered environment. Oracle's "Cluster Ready Services" (CRS), a component of Oracle RAC, provides the ability to do this in a supported and reliable manner. This quick tip outlines the criteria for choosing to use this feature, and steps through a sample implementation.

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Online fraud and regulatory issues are driving organizations to choose stronger authentication and fraud prevention technologies as critical elements of their security infrastructure. This session introduces Oracle's adaptive access management solutions, which provide proactive, real-time fraud prevention, mutual site authentication, stronger authentication, risk monitoring, and online/offline analysis of transactions and audit data.

Back to the Top

Back to the Top

What's the Fuss about Fusion? Oracle and SOA

Service Oriented Architecture (SOA) is a standards-based framework that represents business functions as a set of shared, reusable services. Services can in turn be combined and orchestrated to produce composite services and business processes. This presentation introduces the basic concepts and terminology of a Service Oriented Architecture (SOA) and its importance to IT. Based upon lessons from real SOA projects, this session provides the basic information necessary to help you enthusiastically participate in the implementation of SOA at your organization. Upon completion of this session you should be able to: explain the concepts and principles of SOA, describe potential pitfalls, explain the benefits of the SOA approach, and describe the basic function of an ESB. Best practices from successful SOA implementations and industry leaders will also be discussed including interoperability lessons learned. Oracle's Fusion Middleware’s SOA Suite enables SOA with various components including: an Enterprise Service Bus (ESB) with features to support many messaging and routing technologies, Business Process Execution Language (BPEL) for orchestrating service-based applications, Oracle Service Registry for managing services, and various other tools. People attending this session will be introduced to Oracle's SOA solutions.

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Back to the Top

Possibly an executive or even a co-worker in your company considers Oracle still just a database company. And if it is someone within y