Keynote Speaker
Lower IT Costs with Oracle Database 11
g Release 2 
Charlie Garry, Oracle

Oracle Database 11g is helping organizations across the world reduce their computing costs through consolidation onto enterprise grids, reduced storage requirements, and elimination of idle redundancy. Oracle Database 11g Release 2 includes new major features that make grid computing more accessible, DBAs more productive, offers up to 20x data compression ratios, and enables online application upgrades. In this keynote presentation, you’ll learn how to drive down costs and improve IT’s quality of service while simplifying your software portfolio.

An Oracle Solution to Identity Management and Authorization
Erik Cohen, SAIC
This presentation will be a detailed look at the setup of a three-machine network lab designed to provide a proof of concept for Identity and Authorization Management (IAM) using existing Oracle products. Oracle Internet Directory infrastructure and associated repository are outlined, as well as LDAP concepts. An additional 11g database is configured to access the LDAP to retrieve user information that will be passed to an application to enable a context to be set for Virtual Private Database (VPD) filtering. Network topology and infrastructure details will be provided as well as code examples. LDAP management tools will be discussed as well.
Attack Your Database Before Others Do
Todd DeSantis, Sentrigo, Inc.
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.

Extending SQL Developer - It's Easier than You Think
John Flack, Synectics for Management Decisions, Inc.
The built-in functionality of SQL Developer is quite good, but what you may not know is how easy it is to extend SQL Developer to do things that Oracle didn’t think of. In this paper, I’ll show you how to do it. First of all, you can write your own reports in SQL Developer. We’ll add a few reports to the report navigator. Then we’ll export the reports so you can share them with all your friends. By default, SQL Developer can start several well-known external tools like Windows Explorer, Internet Explorer, and Microsoft Word. You can easily get it to open just about any tool on your computer, and even pass the external tool a few parameters. For instance, this can be used to invoke source control utilities that SQL Developer doesn’t currently support. It isn’t as good as the built-in version control support, but it is a good work-around. Would you like to add a new node to the connection navigator? This can be done with a little bit of XML and no programming. I’ll show you how I added a view into the Order Entry schema as a new navigator node. You can also add functionality to the existing nodes – I’ll show you how.

Oracle 11g: PL/SQL New Features
Mary Gable, Oracle

This presentation will discuss several basic, but noteworthy, new features available for PL/SQL in version 11g in addition to the PL/SQL result cache setup and use. Features such as new datatypes, use of the CONTINUE statement, the ability to directly reference sequence values, and new features for the PL/SQL compiler will be discussed. In addition, Oracle 11g provides many new ways to cache information. Cache more is the motto for 11g! One of the things we can now cache is the results of a PL/SQL function call. Often, we have multiple sessions making expensive function calls to the same function even with the same input parameter values. Now, we can cache these results so they may be used by subsequent sessions without those sessions having to incur the expense of the function call and execution. This presentation discusses the new features of the PL/SQL language available with version 11g.

OBIEE Jumpstart
John Kelly, AIDHM, Inc.

Oracle's Business Intelligence Enterprise Edition software is now the company's flagship BI solution. This presentation provides a quick jumpstart for anyone interested in OBIEE, managers starting a project, or developers transitioning from other BI applications like Discoverer. The presentation reviews the OBIEE architecture and details its functional components. The presentation then considers an OBIEE case study that demonstrates the power and elegance of OBIEE. Finally, the presentation covers the challenges and pitfalls of the OBIEE platform. If time permits, some of latest OBIEE developments and announcements from OpenWorld will be discussed.

De-Mystifying OBIEE/Oracle Business Intelligence Applications
Shyam Varan Nath, IBM/Oracle BIWA SIG

Confused about the right BI solution for your organization? This session will help attendees make an informed decision about their Business Intelligence and Data Warehousing projects. Speaker will discuss the evolution of the BI and reporting solutions for Oracle applications (such as EBS, Siebel, Peoplesoft, JDE) leading to the current state of Oracle BI Applications (OBIA). The specific cases for discussions will be: "How to plan and implement for OBIA;" "Custom OBIEE Development where applicable;" and "Discoverer to OBIEE migration - do's and don'ts overall." The audience will be able to find a suitable BI strategy for their organization and take a behind-the-scene tour of how to implement that. Speaker will discuss the tips and tricks to enable success of such a project.

Integrating Oracle APEX and dhtmlx Components
Bharadwaz Pappu, VISTAtsi
Make your Oracle APEX Web application look rich and provide the sizzle by integrating your Oracle APEX application with one of the best DHTML and JavaScript UI component libraries. This session will showcase real world examples on how to integrate Oracle APEX with dhtmlxTree, dhtmlxGrid, dhtmlxTreeGrid, and other dhtmlx products. I will provide live demonstrations with both small and large datasets and share some tips and tricks to overcome potential performance issues.

Oracle Warehouse Builder 11gR2 New Features
Mark Rittman, Rittman Mead
OWB11gR2 is the latest release of Oracle's in-database ETL tool, and comes with a number of new features such as code templates (ODI integration), web service integration, the ability to create Oracle BI EE metadata, support for Oracle Change Data Capture, and support for non-Oracle databases and data sources. This presentation will outline these new features and demonstrate how they can be used on development projects, taking data from a variety of sources and integrating it using the new features.

Troubleshooting Oracle APEX
Scott Spendolini, Sumner Technologies
Oracle Application Express is made up of several technologies: PL/SQL, HTML, CSS, JavaScript, and Ajax. When something goes wrong, it's often more difficult to figure out what went wrong than it is to fix it. This presentation takes a brief look at each technology that makes up Oracle Application Express and discusses and demonstrates how to effectively track down and solve the problem. As an added bonus, every tool outlined in this presentation is available for free.

Extreme Makeover: APEX Edition
Scott Spendolini, Sumner Technologies
Users will make up their mind as to whether your site looks professional in a matter of seconds. Thus, you get only one chance to convey an image of professionalism to both existing and potential clients. Even sites that don't compete for clients, such as internal applications, will benefit from a crisp UI, as it will exude a level of confidence to your users. This session will outline the steps and skills required to create a custom look and feel for your APEX applications, and include a live demonstration of how to incorporate an existing look and feel into APEX templates.

A Technical Roadmap for Oracle Fusion Middleware, E-Business Suite Release 12 and Oracle Fusion Applications
John Stouffer, CMS Subcontractor
Many companies who have purchased best of breed application solutions over the years find themselves facing a difficult problem - should they keep each product as a separate entity, or is there a way to integrate the products, choosing the best qualities of each while taking advantage of new features and technology enhancements? The answer, of course, is what we will be discussing in this presentation. This presentation describes a technical roadmap that shows how Oracle Fusion Middleware, the E-Business Suite Release 12, and Oracle's Fusion Applications will fit together. By understanding how these three pieces work together, you can plan your organization’s strategy for dealing with Fusion.

2EE or not 2EE: Database Design for J2EE ORM Applications
Heather Toombs, Guident Technologies
This presentation is designed to convince DBAs and DBEs to take more responsibility in understanding object-relational mapping (ORM) tools, as well as to help them understand how they work. For demonstration purposes, we will use Hibernate, a very popular Java based ORM tool. As Hibernate is capable of working with a standard normalized database, we will first demonstrate how modifying the model can enhance the power of Hibernate. First we will focus on a simple problem set and the standard database model that would be utilized. A snippet of Java code will be used to show how the Java developer would work with the standard design. Then, we will present an ORM-friendly database model and a corresponding Java snippet demonstrating the power of the ORM tool. This will be followed by an introduction to Hibernate and its mapping capabilities, specifically as it relates to SQL generation. We will show how data is retrieved into Java domain objects, as well as how it is created, modified, and persisted via Hibernate. We will also discuss performance strengths and weaknesses of ORM tools, as well as common problems to watch out for when using Hibernate or other ORM tools as part of a multi-tiered application.

Mid Atlantic Association of Oracle Professionals | 910.452.0006