FALL 2003 ATLANTIC OTC KEYNOTE PRESENTATION
BY RICH NIEMIEC, CEO AND COFOUNDER OF TUSC

Oracle 10g—Driving the Future of the Industry
This presentation will look at the future architecture of Oracle 10g as it relates to the future of the Oracle database. It will examine some of the compelling new features of 10g. The presentation will also look at the current state of Oracle9i RAC and the trends in our industry toward consolidation. The global labor market and expectations for the IT market, as well as outsourcing and certification trends, will be discussed. The presentation will reveal the keys to succeeding in the changing years ahead.

Rich Niemiec is CEO and cofounder of TUSC. He is one of six honored worldwide Oracle Certified Masters, a member of the Entrepreneur Hall of Fame, and he is respected around the world as an Oracle master. Rich is the past president of IOUG and the president of the Midwest Oracle Users Group. Among his books is the Oracle bestseller, Oracle Performance Tuning Tips & Techniques (Oracle Press, 1999).

FALL 2003 ATLANTIC OTC PRESENTATIONS
by Topic

Analysis and Methodology

The Object-Oriented SDLC and JDeveloper
Paul Dorsey, Ph.D.
Intermediate
This presentation will address the question: What is the appropriate object-oriented software development life cycle using JDeveloper?
Back to top

Building a Business Rule Playbook in Dilbert's World
David Wendleken
All
This presentation will cover how to use business rule-based analysis, design, and coding in a hostile environment. It will demonstrate the use of business rule patterns for analysis and communication with developers and users and show how to implement them in code, plus how to get buy-in from the developers.
Back to top

Business Intelligence

Get the Most Out of Your Data Migration Using a Business Rule Approach
Joseph Hudicka
All
Are you setting your data migration goals high enough? The traditional, "code, load & explode" approach to data migration has been exposed as a fraud, and it aspires to be nothing more. This session will explore the why's and how's of leveraging data migration projects as a stepping stone to the implementation of business rules—a cost effective way to generate support for cool, new business rules projects!
Back to top

Lifecycle Management Using Oracle9i Warehouse Builder
Anissa Stevens
This presentation is an overview of the lifecycle management features of Oracle9i Warehouse Builder. It will step through a live demo of actual changes to a BI system using Oracle9i Warehouse Builder.
Back to top

Database Administration and Tuning

Oracle DBA: Friend or Foe — Understanding Your DBA and Being an Effective DBA
Manny Fu
All
This presentation is for DBAs (new and experienced), people thinking of becoming a DBA, as well as developers and managers of all levels who work with DBAs. The topics will address what it takes to be an effective DBA (from a technical and personality standpoint); what to expect from your DBA as a developer, manager, or CIO; the developer/manager's responsibility to the DBA; and what to look for when hiring a good DBA.
Back to top

Stored Outlines and What They Can Do for You
Mary Gable
Intermediate
Wouldn't it be great if a given SQL statement executed with the same execution plan every time? This presentation will define what stored outlines are, the benefits of using stored outlines in an enterprise environment, and the steps required to implement stored outlnes.
Back to top

How Smart DBAs Use Enterprise Manager 9i to Closely Watch the OS Environment
James Hanson
Advanced
Enterprise Manager 9i is now "operating system aware," which allows DBAs to monitor and track the OS statistics that directly affect database performance. This new capability expands the DBA's span of control and helps break down barriers between database and operating system administration. This presentation will outline the new OS capabilities on EM and include a case study at St. Paul Insurance in Baltimore, Maryland.
Back to top

Secure Schemata: What No One Is Telling You
Barry Johnson
Intermediate
This presentation proposes a radically different approach to the way data is secured within Oracle. With this approach, administration privileges are delegated with NO shared passwords, public data base links with usernames are forbidden, and no one gets insert, update, or delete privileges. But the payoff is a database with accountability and a robust model for reliable data—a good deal all around!
Back to top

Understanding and Leveraging Oracle9i Advisories
Azeem Mohamed
All
In Oracle9i, new features called Advisories help a DBA to choose the optimal sizes for the required memory components. This session will investigate the new features of Oracle9i relative to memory management and give insight on how a DBA can leverage these new available performance options. Specific examples and scripts will be included to highlight use case scenarios of the advisory options.
Back to top

JDeveloper, Java, and XML Development Tools

JDeveloper — Web Services Made Easy
Chris Bowlds
Intermediate
JDeveloper makes web services development possible (or at least more pleasant) for regular developers. Come see how easy it is to both write new web services, and to call existing ones.
Back to top

J2EE, Struts, and UIX in JDeveloper
Paul Dorsey, Ph.D.
Intermediate
This presentation will provide an overview of Struts, UIX, and web services for the purposes of building J2EE-compliant web deployed applications using Oracle9i JDeveloper.
Back to top

XMLDB in Action
Bonnie Vermillion
All
Learn how to utilize the XMLDB repository within the Oracle9i database. This presentation will cover the basics about storing XML-type data by explaining how to build and register XML schemas, how to insert data, and how to create views to query the XML-type data using SQL.
Back to top

Using JDeveloper to Deploy and Debug Stored Procedures
Bryan Wise
Intermediate
This presentation will focus on the new debugging features of JDeveloper and Oracle9i Release 2. The presentation outlines how to set up connections within JDeveloper, how to set up deployment profiles, and how to start a remote debugging process. These topics are illustrated with a live demonstration that shows how to debug a deployed Java Stored Procedure using JDeveloper.
Back to top

Oracle Applications

Oracle Forms Development Standards — Extending Applications the Right Way
Susan Behn
All
Ever wonder what it takes to build a custom form seamlessly integrated with Oracle11i the Oracle way? This presentation will provide an overview of Oracle standards for custom forms development and a roadmap to additional resources.
Back to top

Maximize Oracle E-Business Suite Performance and Investment
Shaun Connolly
All
The rapid accumulation of application data degrades performance, decreases your ROI, increases your TCO, and limits availability—ultimately eroding the investment and value that the applications were designed to deliver. This presentation will introduce strategies that will address the challenges of explosive application database growth.
Back to top

To Patch or Not to Patch . . . It's Not a DBA Question
Alicia Hoekstra
All
Patch application and patch application strategy was the purview of the technical support team—namely the applications DBAs. In Oracle11i, patching strategy is a business decision. This presentation will explore patching methodologies and their relative merits and risks along with impacts on technical and business teams.
Back to top

A Close Look at the Oracle Optimizers
Dan Hotka
All
This presentation will take a close look at exactly how the Oracle optimizers work and how to influence them. Dan will illustrate the Oracle optimizer choices, and how each arrives at its decisions.
Back to top

Care and Feeding of Oracle Release 11i
John Stouffer
All
The focus of the presentation is to share "real-world" experience as well as tips and techniques to install, upgrade, and tune the complex Oracle Application environment delivered with Release 11i.
Back to top

Oracle Collaboration Suite

Installation and Configuration of Oracle Collaboration Suite
Ashok Kapur
All
This presentation will introduce Oracle Collaboration Suite and its benefits. It will cover installation and configuration options. It is an ideal presentation to get an overview of OCS features, installation options, configuration options, and lessons learned.
Back to top

Oracle Designer and Oracle Repository

Unit Testing PL/SQL, Designer, and PLP in a Standards-Based Organization
Henry Miller
All
This presentation will reveal a way to design, build, test, and document PL/SQL software components, all at the same time, and use the products for quality control throughout the software lifecycle. This approach allows easy association with recognized standards such as ISO 9000:2000, ISO/IEEE 12207, and CMM documentation requirements.
Back to top

Oracle8i and Oracle9i Features

Oracle 10 — High Availability Features
Marshall Presser
All
High availability has become more important than ever. This presentation will explore the new features in Oracle 10 for high availability, disaster recovery, and backup and recovery. It will particularly be of interest to DBAs and data center managers.
Back to top

Web Development and Deployment

Not for the Faint of Heart: Migrating to Version 2 of Oracle9iAS
Erik Cohen
Advanced
The new features in Oracle9iAS are dramatic. This presentation will explain why it is essential to move in that direction for users committed to that product and why it is more than worth the complexity and expertise required to take advantage of the enhanced stability and features.
Back to top

Files, Uploads, and Downloads with Web PL/SQL
John Flack
Intermediate
This presentation will detail how to write HTML applications with the PL/SQL Web Toolkit (including PSPs) that upload, download, and process files from the user's PC. It will include: how to configure the DAD, how to write the upload form, how to build a table to receive uploaded files, how to process the upload form, and what you can do with the file once it is in the database.
Back to top

Oracle9i Application Server, Release 2: Basic Administration
Tracie Owen
Intermediate
This presentation will introduce the Oracle9i Application Server, Release 2 architecture and tools for administration. Additionally, it will provide instruction on basic application deployment procedures for J2EE, PL/SQL, and HTML applications. Basic troubleshooting techniques will also be covered.
Back to top