Aino Andriessen, AMIS Services
Fusion Middleware - ADF BC
ADF Development: Live from the Trenches

Let's take a ride and learn from our experiences with ADF development and how you can benefit from them. This session will provide you with tips 'n tricks, best practices, things to avoid, and much more from recent ADF projects. ADF and JDeveloper provide a great productivity boost to J2EE application development but as with all technologies, the development path is laden with pitfalls, steep slopes, and many more obstacles. Experience may help to avoid them. So learn from us, from our positive and negative experiences, and from the lessons we've learned. See how you can apply them to your own environment to enhance your ADF development experience and to increase the quality of your applications.

Back to the Top

---

Michael Armstrong-Smith, Armstrong-Smith Consulting
Business Intelligence/Hyperion/Siebel - Discoverer
Manipulating Dates for Use in Discoverer

Have you ever tried using Oracle's date hierarchies in Discoverer only to find out that they don't work very well or that your date indexes no longer work? Have you ever wanted to know how to manage your fiscal calendar, or even how to work out the number of business days between any two dates? If the answer to any of these questions is YES, then this is the presentation for you. Michael will show you how to manage a fiscal calendar for use with Discoverer. He will also give you many tips and tricks for managing and working with dates. Don't be drawn into thinking that this presentation is only for Discoverer because what you learn here can be applied to most SQL based applications.

Back to the Top

---

Michael Ault, Quest Software
Oracle Tools - SQL
Tuning for Developers

Tuning (good and bad) begins with the first line of code and never ends. The developer needs to understand several tuning basics before he/she can develop well performing applications. This presentation will cover the tuning basics, SQL, Indexes, and database structures to ensure the developer has a grounding in these concepts.

Back to the Top

---

Carl Backstrom, Oracle Corporation
Oracle Tools - Application Express
Building the New Stuff: AJAX , JSON, and APEX 3.1

Oracle Application Express (APEX) provides a simple and integrated set of javascript, PL/SQL, and APEX Table Views that can be used to quickly and securely add dynamic AJAX-based functionality to any APEX application. In this session, you'll learn how to leverage some of the new built; in features of APEX 3.1 to build custom user interfaces and data exchange functionality. Future direction of APEX's javascript libraries and integration points with APEX will also be discussed. This session is geared toward the advanced APEX developer, so previous APEX and javascript experience is highly recommended.

Back to the Top

---

Andrejus Baranovskis, VGO Software
Fusion Middleware - JDeveloper
Development with Oracle JDeveloper/ADF 11g Reusing 10g Best Practices

Andrejus Baranovskis, Oracle ACE director, will describe with practical demonstrations how Oracle JDeveloper/ADF 11g simplifies J2EE development. Oracle JDeveloper/ADF 11g brings new technology, which empowers developers to build new generation enterprise systems. However, when working with Oracle JDeveloper/ADF 11g the same best practices acquired when working with 10g can be reused. This presentation will focus on real development. Andrejus will share best practices in ADF business components development, validation logic development and testing, and user interface development using ADF Faces 11g. Real application will be developed and steps will be explained.

Back to the Top

---

Roland Berg, Diligent Consulting
Professional Development - Project Management
Architect v. Project Manager – Resolving the Conflict

Both the architect and the project manager are chartered with the success of the project, but the measures of success are different for the two roles. In fact, it is these different measures of success that drives the viewpoint of each. And it is these differences in perspective that set up the conflict. Using real-world examples of both positive and negative interaction between architect and project manager, this presentation will examine the relationship between the roles and expose the seeds of the inherent conflict while proposing the establishment of appropriate boundaries and methods to turn the natural conflict into a positive force driving toward a successful end to the project.

Back to the Top

---

Edwin Biemond, Ordina
Fusion Middleware - JDeveloper
ADF Taskflow in Full Action

How easy it is to make an application with ADF taskflow. In this presentation I will make a simple order application with Jdeveloper 11g. The purpose of this session is to explain what ADF taskflow really does and to demostrate how easy and effective ADF taskflow is. It will show how you can reuse certain parts of the application and how you can integrate WS (BPEL ,ESB) with taskflow in your application. .

Back to the Top

---

Matthew Braunschweig, Wells Landers Group
Third Party Tools - Pentaho
BI in a Bottle: Jumpstarting Your Oracle/Pentaho BI Solution

This presentation will cover the steps necessary for implementing an Oracle-based solution in Pentaho. Besides the installation and configuration of the solution, this presentation will also cover some of the best practices and solutions for implementation. At the end of the session, attendees will be able to implement a BI solution that will include a portal, portlets, and drill-through reporting.

Back to the Top

---

Karen Cannell, Integra Technology Consulting
Oracle Tools - Application Express
APEX Cheat Sheet 3

For beginner APEX users, and for those who have not yet memorized all the ins, outs, &’s and .’s, this “Cheat Sheet” session presents a collection of frequently used APEX features, expressions, how-to’s, and assorted “oh-yeah’s” to keep handy when building your first two or twenty-two APEX applications. We’ll cover the f?p syntax, report links, when to use &, : v(), select lists, sending e-mail, popups, adding your own logo, custom authentication, some essential JavaScript, and simple AJAX. You’ll leave this session with a “Cheat Sheet” of APEX how-to’s that will get you well into APEX development.

Back to the Top

---

Tony Catalano, TUSC
Oracle Tools - PL/SQL
Tony’s Top 10 Oracle Tips and Tricks for Developers

Throughout my fourteen years working with Oracle, I have accumulated a list of tips and techniques that assist with the development of Oracle-based custom applications. These tips and tricks can be used to improve application performance, to streamline code, and to create higher quality applications. Tony will describe each topic in detail as well as provide real world examples of how to use them.

Back to the Top

---

Vincent Chazhoor, Lafarge North America
Business Intelligence/Hyperion/Siebel
Oracle 11g Data Warehousing

This presentation will review the new and enhanced features in 11g for data warehousing. Topics include partitioning, partition advisor, referential, internal, and virtual column partitioning, composite partitioning enhancements, new sub-partition options, automatic partition creation, and incremental maintenance of NDV for partitioned tables.

Back to the Top

---

Gary Crisci, Morgan Stanley
Hyperion
ASO: Understanding MDX
While we are all familiar with traditional "Essbase calc formula syntax", Essbase Aggregate Storage databases use MDX (Multi-Dimensional Expression) in its formulas.  In this presentation, we'll start off with the basics of MDX and then move into tuples and a whole host of MDX functions/commands.  We'll cover how some of the traditional BSO functions translate into MDX functions.  We'll conclude with some real-world examples and workarounds that you can use when creating your own ASO applications.

---

Lewis Cunningham, PricewaterhouseCoopers, LLP
Development DBA - Data Model Optimization
Oracle Partitioning for Developers

Join Oracle ACE Lewis Cunningham in a discussion about Oracle partitioning in 11g. Geared toward developers and designers, this presentation will explain how to create partitions, when to use partitions, and why partitioning is a good thing. Partitioning is no longer reserved for the VLDB. Today’s medium size databases are yesterday’s VLDBs. Did you know that Oracle recommends any table over 2GB be considered for partitioning? In this session, you will learn the differences between hash, range, and list partitions and how to mix and match those partition types for optimal results. Learn how to automate some partition operations by using an interval and see how Oracle 11g can optimize joins and foreign key relationships with reference partitions. This presentation will show some maintenance operations but will concentrate more on the how, when, and why of partitioning.

Back to the Top

---

Steven Davelaar, Oracle Corporation
Fusion Middleware - Building Custom Applications using Fusion Middleware
Oracle JHeadstart: Unprecedented Productivity in Developing Oracle ADF Applications

In maybe the coolest demo of this conference, the speaker uses Oracle JHeadstart to build a complete enterprise-class application from scratch in one hour. Features include trees, shuttles, multi-select lists of values, advanced search, tabbed regions, wizards, conditionally dependent items, deep linking, flex fields, role-based security, dynamic menus, drag and drop, and more. This presentation is a MUST-SEE for developers with a Forms/4GL background who are considering moving to J2EE.

Back to the Top

Steven Davelaar, Oracle Corporation
Fusion Middleware - Building Custom Applications Using Fusion Middleware
Beyond Drag and Drop: ADF Faces Advanced Techniques

In this presentation, Steven explains how JSF and ADF Faces actually work "under the covers", and how ADF integrates with the JSF Page Lifecycle. This knowledge is indispensable for developers who want to build more sophisticated user interfaces using ADF Faces. The concepts are illustrated with step-by-step demos to build common UI requirements like conditionally dependent items and deeplinking.

Back to the Top

---

Marc De Oliveira, PYTHIA Information
Oracle Tools - Designer
Designer Is Dead – Long Live Oracle Designer Extension Builder

Jonathan Wallace announced the Oracle Designer Extension Builder at the ODTUG conference a few years back. It was a called a Designer Generator because its purpose was to simplify the production of text documents based on the content of the Designer Repository. Basically, it could be used to build a Designer Generator for PHP, JAVA, Perl, or .NET but could also produce nice Designer reports, requirement documents, test plans, or other project management documents in PDF, RTF, or XML. This year the product was finally released as an official extension to Designer 10g. Even though Jonathan Wallace is an Oracle employee, ODTUG and Maggie Thompkins played an important role in bringing him together with Suresh Ramaswamy, the Oracle Designer product manager at the time, making it possible for the product to become an integrated and supported part of Designer. Come see what Marc has done with the Oracle Designer Extension Builder.

Back to the Top

---

Peter De Vaal, Transfer Solutions
Fusion Middleware - OAS
Robust App Server Topologies for Deploying Highly Critical Applications

The application server has become the most important part of an IT infrastructure for the deployment of any kind of application. It is often very important to choose application server topologies that offer scalability, reliability, and security. The design of such topologies should be made in an early phase of a project in order to make the right choices and to let application developers and architects get acquainted with aspects such as load-balancing, session fail-over, authentication using single sign-on, and deployment independent packaging. These aspects will be demonstrated in an implementation case of a highly critical system for one of the largest airports in the world.

Back to the Top

---

Jean-Pierre Dijcks, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Development's Bag of Tricks for Oracle Warehouse Builder

You are using Oracle Warehouse Builder and you see many things you could do or could do better. See how you can solve some common problems by using the functionality that OWB provides in 11g. We will be discussing a set of topics with hands-on examples which will include, for example, using analytical SQL in OWB (hierarchical queries, advanced aggregations), dealing with XML data sources and targets, matching and merging information from different systems, and extending the product using Experts. This session is intended to deepen your knowledge about Warehouse Builder and make you, as a developer, more productive.

Back to the Top

Jean-Pierre Dijcks, Oracle Corporation
Methodology - Other
Best Practices in Implementing Data Quality Process with Warehouse Builder

We all know it is there, we all know we need to do it, but how do we apply this data quality stuff in real projects? In this session we go through a set of examples showing how to implement data quality policies in an organization using OWB. Topics to expect include determining survivorship of your master records, householding, and linking of records. In addition, we will discuss and show how to create smart auditing and testing of data in a so-called data quality firewall. This firewall prevents bad data from even entering the systems being targeted. Last but not least, we will discuss how to implement a quality assessment and reporting structure on your existing systems.

Back to the Top

Jean-Pierre Dijcks, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Warehouse Builder Goes Heterogeneous: What That Means for You

With Warehouse Builder 11g Release 2 you will get the best of both the OWB and the ODI world in one tool. Yes, OWB is integrating the ODI heterogeneous concepts and templates within the familiar OWB functionality. So you now have full heterogeneous support for both sources and targets included with the data profiling, data quality, and regular Oracle PL/SQL mappings. On top of that you will see a unification of the metadata layer in the database and a unification of the client tool user interfaces (OWB goes JDev IDE!). In short, if you are interested in ETL and OWB, this session shows the newest of the newest in OWB land, straight out of development. See it all in action and ask questions about our direction in ETL land.

Back to the Top

---

Mike Donohue, Oracle Corporation
Business Intelligene/Hyperion/Seibel – BI Publisher (formerly XML Publisher)
Oracle BI Publisher Overview: New and Planned Features
Oracle Business Intelligence Publisher (BI Publisher, formerly XML Publisher) is Oracle's strategic  enterprise reporting solution to author, manage, and deliver all types of highly formatted documents eliminating the need for costly point solutions. Built on open standards, IT staff and developers can create data models against practically any data source and use BI Publisher Web Services or Java APIs to build custom applications leveraging existing data sources and infrastructure. End users can easily design report layouts using familiar desktop tools, dramatically reducing the time and cost needed to develop and maintain reports. In this session we will cover an overview of BI Publisher as well as what is new and coming in the next release.

Back to the Top

---

Robert Donahue, Whittman Hart
Scalable Infrastructure: Clustering, Load Balancing, and Fail Over
Increasingly Essbase and Hyperion are being implemented to support functions which are critical to the daily operations of the business & enterprise as a whole.  This introduces the need to ensure that infrastructure architecture is stable and reduces the risk of performance issues or unplanned outages.  This session will focus on different options to implement a scalable & fault tolerant infrastructure.  In addition the session will discuss the considerations that drive the overall infrastructure design.

Back to the Top

---

Paul Dorsey, Dulcian, Inc.
Professional Development - Project Management
Using Periodic Audits to Prevent Catastrophic Project Failure

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

Paul Dorsey, Dulcian, Inc.
Methodology - Thick Databases
Thick Database Techniques for Fusion (and Other) Web Developers

This presentation discusses how the decision to use a  thick database approach  impacts database developers. Successful application logic in the database requires SQL and PL/SQL features such as object types, collections, INSTEAD OF triggers, function-based views, bulk operations, autonomous transactions, etc. This presentation will include real-world examples to help attendees build systems that perform better and are easier to maintain over time.

Back to the Top

---

Susan Duncan, Oracle Corporation
Fusion Middleware – Jdeveloper
Seven Secrets (and More) of Successful JDeveloper Database Designers

In JDev 11 R1 the database features take a big step forward, and customers are now increasingly using JDeveloper to design bigger and more complex databases. This frequently means teams of designers working together. This paper will introduce and demonstrate features for live, connected modeling (compared to file based modeling), enhanced file-based modeling, ERD syntax modeling,  Oracle & third party database DDL generation and round-trip engineering. We show how these can be used effectively in a multi-user team to manage versioning, sharing and access controlling your models in an open-source SCM repository such as Subversion.

Back to the Top

---

Prabir Dutt, InfoPower International, Inc.
Java EE and SOA - SOA
Globally Transforming Forms and PL/SQL to Web-based SOA and SaaS

This presentation explains a step-by-step approach to effectively and accurately transform the forms/reports based full functional ERP application package (ERPDBO) to be fully deployable and operable in a Service Oriented Architecture (SOA) environment. The existing forms and reports software with many PL/SQL functions, procedures, packages, and triggers require multiple steps. The core activities included in this presentation are (1) Process mapping and modeling, (2) Transform rules engine to SOA, (3) BAM within SOA, (4) "Flexponsive" and preemptive risk management, and (5) SaaS deployment.

Back to the Top

---

Eric Evans, HOTSOS Enterprises, Ltd
Development DBA - Tuning
Without a Trace

Many tuning efforts require the use of Oracle SQL trace files. These files are generated on the system where the database resides. Most developers are hamstrung strung by having to get the trace files from DBAs or sysadmins. Fortunately there are a few recipes that should satisfy all concerned for getting trace files to developers without having to give direct access to the filesystem or require interaction with the DBA or sysadmin. We'll cover database scripts that find the appropriate trace files and move them to a location or machine. In addition, with the use of CLOBs we can have IDEs to copy the files over automatically. These are proven techniques to speed up the development environment profiling capabilities.

Back to the Top

---

Steven Feuerstein, Quest Software
Oracle Tools - PL/SQL
Weird PL/SQL

You probably think that PL/SQL is a dull and ordinary programming language. Not so! Parts of it can be downright WEIRD. In this presentation, Steven offers what he considers to be some of the stranger nooks and crannies of the PL/SQL language, perhaps in the process making them a little bit less weird.

Back to the Top

Steven Feuerstein, Quest Software
Oracle Tools - PL/SQL
Why You Should Care about Oracle11g PL/SQL Now!

Oracle 11g  is the latest version of Oracle—and you probably don’t really care all that much, since you won’t be using it for years. Well, believe it or not, knowwing what Oracle 11g will do for you and your applications in the future will change the way you write your code today. In this session we will cover the following features: the function result cache, compound triggers, automatic in-lining of local subprograms, the latest in native compilation, PL/Scope, and more.

Back to the Top

---

John Flack, Synectics for Management Decisions, Inc.
Fusion Middleware - Building Custom Applications using Fusion Middleware
Google Maps, ADF Faces, and Oracle Locator: A Backstage Tour of the New Treatment Locator

This is a guided tour of a prototype locator application that uses Oracle Locator, PL/SQL, ADF Business Components, ADF Faces, and the Google Maps API. It shows how to use a REST Web service from PL/SQL, call PL/SQL from an ADF BC Application Module, use a PL/SQL table function as the basis for an ADF BC View Object, and include maps from the Google Maps API on an ADF Faces Page.

Back to the Top

---

Julie Fowler, Maverick Solutions
Oracle Tools - SQL
11g New Features for SQL and PL/SQL

Oracle 11g has more than 500 new features for DBAs and developers. The most significant SQL and PL/SQL new features and improvements will be covered. The focus is to help developers sort through all these new 11g SQL and PL/SQL features to find which ones are going to be the most helpful, and when and how to use them.

Back to the Top

---

Harish Gaur and Brian Gilbertson, Oracle Corporation and Hitachi Consulting
Fusion Middleware – Service Oriented Architecture (SOA) Suite
SOA Suite Customer Story
Oracle SOA Suite, a member of Oracle Fusion Middleware, is a comprehensive solution offering to build and deploy SOA and composite applications. Why do customers adopt SOA? What are the key sweet spots to get the biggest bang for the buck? What are the best practices around building service oriented architecture? In this session, you will learn about Oracle SOA Suite, customer adoption patterns, and best practices. You will also hear from a customer about their SOA journey detailing their implementation and key learnings/challenges. If you are thinking about SOA or already doing SOA, you don't want to miss this session.

Back to the Top

---

Dimitri Gielis, Apex Evangelists
Oracle Tools - Application Express
Creating Advanced Charts in Oracle Application Express

More and more people want to see data in a graphical view. This presentation shows you how to create an advanced "graphical view" of your data in Oracle Application Express (APEX). This presentation will be seasoned with one big live demo! A risk, but I want to "show" it to you!

Back to the Top

---

Dan Glasscock, Oracle Corporation
Development DBA - Replication
Transparent Replication

While Replication should be integral to the design of an application, it is common for replication to be added to an existing application after development is complete. This results in an application that does not necessarily include the proper data elements and logic needed to support a replicated environment. This presentation presents a technique for replicating application data without making any application changes while at the same time and implementing necessary conflict resolution logic necessary for distributed computing. A basic discussion of the need for Conflict Detection and Resolution are presented. Examples on how to add replication support for an application with no changes to the application itself are also presented for Advanced Replication and Oracle Streams.

Back to the Top

Dan Glasscock, Oracle Corporation
Java EE and SOA - SOA
Rules Rule

Using a rules engine can allow a developer to create more flexible programs faster. A rules engine can also lower an application's maintenance and extensibility costs by reducing the complexity of components that implement complex business logic. For example, in many situations building a pricing calculator can be complex. Needing to incorporate logic for different countries, states, pricing structures, etc., may result in a large amount of difficult to maintain code. Using a rules engine one company replaced thirty pages of code with approximately one page of rules resulting in a faster, simplier, more flexible implementation. Several rules engines are available, including commercial and open source choices. This session introduces you to the Oracle engine and uses a sample program to help you understand how to use the Oracle rules engine as part of your business logic layer in a Java application and Web service.

Back to the Top

---

Sue Harper, Oracle Corporation
Oracle Tools - SQL Developer
Oracle SQL Developer: Focus on a Few Features

Oracle SQL Developer provides database developers with a convenient way to perform various database tasks and to manage database objects. This session focuses on a few aspects of the tool that users often overlook; building extensions, Oracle APEX support, the new SQL Tuning support, and third-party database support and migrations. The session concludes with a review of new functionality in the latest release, with specific reference to Oracle 11g database support.

Back to the Top

Sue Harper, Oracle Corporation
Oracle Tools - SQL Developer
Oracle SQL Developer: An Overview and New Feaures

Oracle SQL Developer database developers have a convenient way of performing basic database tasks and managing database objects. The latest release of Oracle SQL Developer includes significant updates to the SQL and PL SQL code editors, by including enhanced formatting and code templates. The Schema Compare has been rewritten for the new release and the Schema Export has been updated to a wizard, facilitating ease of use. Both utilities conclude with reports the user can review. In an addition to these, there is a new schema copy feature. This session will walk through the product and its advantages as a GUI to the Oracle database. For those already familiar with the tool, the new features added to the latest release will be on display, including 11g feature support.

Back to the Top

---

Eric Helmer, The Hackett Group
Architecting a System 9 Implementation

Successful implementations of Hyperion System 9 BI+ Foundation Suite require a level of architectural planning and understanding from the very beginning.
This session is specifically tailored for technical system architects and system administrators considering System 9. It will cover a general high-level introduction to the many components of System 9, process
interdependencies, and interactions. We will also touch on more advanced topics on installation strategy, sizing considerations, clustering, and high availability based on best practices and lessons learned in the field.

Back to the Top

---

Kenton Ho, Perfit Computer Systems Group, Inc.
Fusion Middleware - ADF BC
Our First Oracle ADF/JSF Based Product: What They Didn't Teach You in the Demos and Courses...

This presentation will be beneficial to those developers that have been inspired to get into the world of Oracle ADF/JSF development. We’ve all seen the demos and we’ve all done the hands-on labs, but what are we missing to develop and deploy business applications? Our emphasis is to help the new ADF/JSF Developer focus on what they need to learn after they’ve left the conference. We’ll answer common questions, such as, how do my users login? We’ll highlight the most important chapters that we’ve had to understand in the 1,160 page Developer’s Guide For Forms/4GL Developers in addition to other resources we’ve used. We’ll also talk about the things you need to consider when you deploy your application. This presentation contains the highlights of a six-part course that we teach in our organization to get our Oracle Forms developers transitioned into Oracle ADF/JSF developers.

Back to the Top

---

Bill Holtzman, National Air Traffic Controllers Association
Oracle Tools - Application Express
APEX Development: Watch It Live

Application Express, like most development technologies, has its own sense and feel that developers must become familiar with to be productive. By watching someone experienced do it, others can pick up on methods, practices, and nuances that they might not otherwise absorb. An arsenal of approaches are needed by every developer to solve the innumerable and inevitable problems. The point of this demonstration will be to provide some of those approaches in a very illustrative way.

Back to the Top

---

Ann Horton, Oracle Corporation
Fusion Middleware - Other
Using the Oracle Business Process Analysis (BPA) Suite

The Oracle Business Process Analysis Suite is a mature, repository-based tool for analyzing and modeling business processes. It is a key component of Oracle's complete Business Process Management (BPM) solution. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This suite is being leveraged to deliver Fusion Application Reference Models. This presentation will present the capabilities of the BPA Suite, teach you to use this tool, and explain why you will want to use it.

Back to the Top

---

James Hudson, Wisconsin Department of Natural Resources
Oracle Tools - PL/SQL
Introduction to PL/SQL Web Services

Web services are a key part of any Service-Oriented Architecture. All development environments, including PL/SQL, should be able to expose programs as services, and identify and use other services available within your organization and over the Internet. In this presentation, we will walk through the steps involved in both creating and consuming Web services using PL/SQL. We'll focus on Soap 1.1 services using the 10g and 11g databases for the examples, but also note the steps involved for other types of services and the 9i database.

Back to the Top

---

Rob Hull, Oracle Corporation
Smart Space Gadgets with Visual Studio
Oracle EPM Smart Space provides a new and innovative way of delivering content to users, enabling user collaboration and exposing a combination of Oracle BI, BI Publisher and Oracle's Hyperion BI reporting content in an extensible gadget-based environment. This session will explore the integrated services exposed through Smart Space, and discuss the extensibility of the Smart Space product through custom gadgets and services. There will be a demonstration of gadget development in Visual Studio .NET using the Smart Space SDK's. A review of other technologies available to integrate external systems and products with the Oracle landscape using Smart Space will also be covered. The discussion will include information around the Smart Space OTN developer community and additional resources available to developers, partners and customers.

Back to the Top

---

Kathy Hunsicker, WaMu
Oracle Tools - Application Express
Creating Dynamite Applications with Application Express that Deliver

Oracle’s Application Express has enabled WaMu's Card Services group to rapidly deliver robust, low cost, secure, scalable, and successful Web-based applications. As a key component of their BI and MIS platform, APEX has empowered both technical and business teams to replace legacy processes based on paper, Excel, and MS Access with simple, yet powerful applications with improved controls and capabilities.

Back to the Top

---

Jerry Ireland, Rightsizing, Inc.
Fusion Middleware - BPEL/BAM
BPEL for Workflow Developers

Attendees of this presentation will learn the basic differences between Oracle Workflow and BPEL. They will also see, through a specific example, how some of the important components are actually built. This knowledge will be essential to anyone who is contemplating future versions of any of the Oracle applications.

Back to the Top

---

Shankaran Iyer, Carlson Marketing Worldwide
Development DBA - Caching
Creating a Winning Combination – Oracle 11g Features with SOA Data Layer

The presentation is divided into four parts. The first part will include a brief discussion of the SOA architecture environment and the data layer. The specific needs of the data layer for scalability, performance, and security will be highlighted with examples. The second part will include a discussion on REF and virtual column-based partitioning for handling very large application tables included in the data layer. Specific examples from two different service layers will be provided. The third part will include a discussion on Oracle 11g Database Vault as a solution to secure sensitive customer information in the SOA data layer. A method of vaulting the critical data and then sharing  it with different components of the SOA data layer will be discussed. The final part will include specific features of the Oracle 11g TimesTen In-Memory Database. This product provides the required performance and throughput to the service layers by caching critical data components.

Back to the Top

---

Robert Jackson, General Dynamics
Development DBA - Tuning
How We Used Materialized Views to Speed up Our Slow Applications

This session will explore the speaker’s experiences and discuss lessons learned on how to speed up long running queries and reduce report generation from hours or minutes to seconds. Learn how highly normalized databases work fine for transactional systems, but can be problematic when performing multi join queries or complex calculations. Hear about our team’s solution to improve performance of an application with complex reporting needs through the use of materialized views. We will discuss situations where data is co-located in distributed systems, where lots of data aggregation is needed, and where complex queries with lots of joins exist. We will explore how materialized views can solve your response time problems by making the data real and masking the complexity of your queries for reporting needs. We will also cover how materialized views can be maintained and refreshed, the pros and cons of the various types of materialized views and things to keep in mind such as disk space, rebuild times, and cost considerations. Learn from our team’s experiences and how to find that a happy medium keeps your DBAs and customers satisfied.

Back to the Top

---

Vinay Jain, Oracle Corporation
Fusion Middleware
Learn About Oracle’s Implementation of SOA: Application Integration Architecture
Oracle Application Integration Architecture (AIA) provides an open standards based framework for creating cross-application business processes that support the way you run your business today, while paving the way for your long term, strategic, business transformation plans. In this session, you'll learn what AIA is, how it works, and how it enables service-oriented architecture (SOA) to empower you to utilize the applications of your choice to create composite processes unique to your business.

Back to the Top

---

Lucas Jellema, AMIS Services
Fusion Middleware
BPEL and ESB: What's in It for Oracle Database Developers
SOA is a hot topic and Oracle is pushing the BPEL Process Manager and in its wake the Enterprise Service Bus so forcefully that probably something is going on. However, many Oracle Database developers are not really clear about what it is or what it means to them. Is BPEL a world apart from plain old PL/SQL programming? Is SOA irrelevant to database designers and SQL programmers? Or should they care?
This presentation explains in a high level overview what the key SOA concepts are. It also describes the respective roles of BPEL PM and the Enterprise Service Bus. It will then demonstrate how from PL/SQL programs (and even from SQL queries) SOA Services offered in BPEL or ESB can (and sometime meaningfully should) be leveraged, for example to perform operations across databases or even heterogeneous data stores.
The presentation will spend quiet some time on the ways the Oracle SOA Suite (both ESB and BPEL PM) can work with the Oracle Database through the Database Adapter.

Back to the Top

---

Michiel Jonkers, AMIS Services
Oracle Tools - Application Express
Explore and Benefit the APEX Repository

The APEX engine generates forms, reports, and charts based on meta data that is stored in the APEX repository. As a developer it is very easy, but still not common practice, to use this repository with meta data for quality assurance and impact analysis. APEX also comes with an API on the APEX repository which can be used to perform automated bulk operations to enforce a consistent behavior or look and feel for APEX applications. In my presentation I will explain how the APEX repository is organized and how developers can benefit from the repository and its API. I also will demonstrate how to develop quality reports and how to use the API to perform time consuming changes in one or multiple applications in only a few seconds.

Back to the Top

---

Mike Killeen, Ranzal and Associates
Hyperion
Optimizing Essbase Retrievals
In the Essbase world, considerable time is spent on tuning and optimizing calculations – after all the predominant value proposition of the product is that by pre-aggregating and calculating as many values as possible, sub-second retrieval times should be a given. For top down retrievals and P&L reporting, this is nearly always the case;  however there has always been a class of retrievals that have proven problematic in Essbase with respect to response times – these include bottoms up queries with multiple row dimensions, bulk data extraction methods, queries with attribute dimensions, and dynamic range based functions (Ranks, Counts, etc).  
This session will focus on a variety of techniques for optimizing the above scenarios, including the following:

• Bulk Data Extraction Methodologies – a comparison of Report Scripts, calculation, and Export methodologies, with optimization techniques for each
• Techniques for optimizing Bottoms up Queries in a Block Storage Database
• Aggregate Storage Databases as a Retrieval Optimizer for Range Based Functions and Attributes
• Tools Tips and Tricks – techniques for optimizing Hyperion Planning, Hyperion Reports, Hyperion Web Analysis, and Excel Add-In Retrievals

Time will be allocated at the end of the session for a general Q&A.

Back to the Top

---

Joel Kallman, Oracle USA, Inc.
Oracle Tools - Application Express
Go Global with Oracle Application Express!

The world is shrinking. And eventually, you will be given the task to develop an application which is used by people from a variety of languages and cultures. Oracle Application Express is a complete development environment used to quickly build sophisticated Web applications in an Oracle database. Unbeknownst to many developers are the sophisticated features inherent in Oracle Application Express which enable easy development of a perfectly translated and localized Web application. This session will demonstrate, from beginning to end, the development of a Web application using Oracle Application Express, and also the translation and localization of this application. Best practices will be reviewed in addition to practical examples of how to exploit the globalization features native to the Oracle database.

Back to the Top

---

John King, King Training Resources
Fusion Middleware - BPEL/BAM
Beeple, B-Pel, Beepul? Understanding BPEL and Its Role in SOA

Business Process Execution Language (BPEL) is an important part of the Oracle Fusion SOA Suite and helps fulfill the orchestration component of Service Oriented Architecture (SOA). Two key promises of SOA are reusability and integration. Once services have been defined and tested, it is important that organizations be able to leverage them elsewhere. Oracle Fusion Middleware's BPEL Process Manager provides a process-centered mechanism for orchestrating services from different systems. Further, Oracle's BPEL supports the industry standard and eases integration with systems developed in non-Oracle environments (e.g. IBM, Microsoft, BEA, etc.). This presentation will help developers understand the role of BPEL, using BPEL to develop services, and using BPEL to integrate services.

Back to the Top

---

Peter Koletzke, Quovera
Fusion Middleware - Building Custom Applications using Fusion Middleware
Birds Do It: Migrating Forms to Java EE Web, A Case Study

This case study examines the migration of an enterprise-level, character-mode, Oracle Forms 6.0 application to Web technologies based on Java Platform Enterprise Edition (“Java EE,” formerly known as “J2EE”). It explains the decision points for choosing Fusion ADF and focuses on how ADF provided the pivot point around which technology decisions were made. The presentation discusses why Fusion development technologies–ADF Faces, UIX, and ADF Business Components–were selected. It also describes why the decision was made to leverage thick database techniques for business rules logic and user interface support. The presentation then explains and offers insight on the techniques used to migrate the skills of staff Forms developers to the new technologies. Finally, it lists successes and lessons learned during the application migration.

Peter Koletzke, Quovera and Duncan Mills, Oracle Corporation
Java EE and SOA - Web Security
Web Application Security with JAZN - Implementing the Superstition in JDeveloper

Designing user access to specific parts of your application is important for all types of applications, but security plays an even larger role in Web applications that are usually open to access from a wider user base. The Oracle Application Server's Java EE runtime component, Oracle Containers for Java EE (OC4J), provides a security feature, JAZN (Java Authorization and Authentication), which allows developers to use standard Java security libraries to implement access control in their applications. This presentation explains JAZN and discusses how it provides security services for J2EE Web applications; how to store user credentials in JAZN; and how to tap into existing Lightweight Directory Access Protocol (LDAP) providers such as Windows' Active Directory, or into XML user credentials stores. This presentation also describes and demonstrates how to set up and code security hooks into your application using JDeveloper 10g.

Peter Koletzke, Quovera
Fusion Middleware - JDeveloper
Made from the Same Mold: Template Techniques for Fusion Applications

Users will more easily understand your application and will therefore be more productive if all pages of your Web application are designed to look and act the same. The requirement for a common look and feel has traditionally been met by the use of templates. However, the methods for implementing template systems change with each new technology. This presentation discusses how to work with templates and other common look-and-feel options in JDeveloper 10g and 11g. It explains and provides code examples for template systems using ADF Faces mentions JSP tags as well as additional Java templating frameworks. It also describes the Oracle Browser Look and Feel (BLAF), which is used for the E-Business Suite. The presentation also describes the ADF Faces skinning feature, as well as how the JHeadstart plug-in to JDeveloper plug-in, JHeadstart, uses templates.

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 1: Fusion Development and JDeveloper Overview

These days, development shops have been mandated to develop new applications using Java Platform, Enterprise Edition (Java EE) Web technologies. This can prove to be challenging for traditional Oracle developers because the main Java EE languages and the style of development are very different. Oracle is developing the next wave of Oracle Applications/E-Business Suite (Oracle Fusion) using JDeveloper and Application Development Framework (ADF) technologies such as ADF Business Components and ADF Faces. With JDeveloper 11g, Oracle offers a tool that helps Web developers from every discipline transition more easily than ever to Java EE Web development. Its declarative and visual development environment rivals that of traditional tools, yet it creates standard Java EE code that can be deployed on any Java EE server such as Oracle Application Server. This presentation series, presented by the co-authors of the Oracle Press book Oracle JDeveloper 10g for Forms and PL/SQL Developers, explains how to use JDeveloper and ADF with the Fusion technology stack that Oracle is using for Fusion Applications. It also builds a comprehensive sample application to demonstrate the techniques and best practices you can use to create custom applications. The first presentation in this series provides an introduction to JDeveloper’s visual and declarative tools and shows how to start creating the application.

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 2: Developing the Model Layer

This presentation uses the tools discussed in the first part of the series to create the Model layer the application uses to interact with database objects such as tables, views, and PL/SQL packages. The presentation explains how ADF Business Components (ADF BC) allows you to declare components that query, insert, update, and delete data. It demonstrates these techniques and shows how you can also write code snippets to perform actions not provided by the ADF BC components.

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 3: Developing the View Layer

This final presentation in the series completes the picture of Fusion Web development using JDeveloper 11g by explaining the components you use to create the View layer code for the user interface. It discusses how you tie the ADF BC database components you created for the Model layer to the components on the page. It then demonstrates how you can work in the visual layout and declarative editing tools within JDeveloper and ADF to build the UI.

Back to the Top

---

Thomas Kyte, Oracle Corporation
Development DBA
The Top 10 – No 11 – New Features of Oracle Database 11g

This session will focus on eleven new, high impact features of Oracle Database 11g and what they mean to you, the developer or DBA. Continuing the format of the last four Oracle OpenWorlds—Oracle's AskTom will present these as a "top eleven" list—the eleven new features he believes will be the reason to look at Oracle Database 11g in the near future.

Thomas Kyte, Oracle Corporation
Development DBA
Instrumentation 101: One Hour
This session will discuss the importance of heavily instrumenting your code and explore the possible methods of instrumenting your code in an Oracle environment — concentrating on developed code both in the database (stored procedures) as well as outside the database (Java, C, VB and the like).

Back to the Top

---

Steve Liebermensch, Oracle Corporation
Hyperion
ASO:Conversion Issues from BSO
In this session you will learn about converting an existing block storage(BSO) outline to aggregate storage(ASO). This will include discussion on the hierarchical differences and implications thereof, as well as, basic member formula syntax conversion and mapping of BSO functions to MDX.

Back to the Top

Steve Liebermensch, Oracle Corporation
Hyperion
Optimizing ASO
In this session we will discuss the various opportunities to tune an aggregate storage(ASO) database. Specific topics will include dimensional types and usage; materialization concepts and techniques; enhancements to data loading; as well as MDX formula optimization.

Back to the Top

---

Peter Lorenzen, Logica
Fusion Middleware - Other
A Practical Introduction to Oracle Web Service Manager

Web Services are more and more widely used thanks to the adoption of SOA strategies. This leads to an increased need for ways to secure Web services. Oracle Web Service Manager (OWSM) provides a unique way of doing just that. OWSM is a standard based platform that makes it possible to secure Web services declaratively without any modifications to the existing Web services implementation. We will start with an overview of the different components and move on to a simple demonstration, which will make it easier to understand concepts like gateways, agents, and policies. After the demonstration we will look at some of the components in a bit more detail. The presentation will also introduce some of the standards that OWSM is based on like WS-Security.

Back to the Top

---

Eric Marcoux, Université Laval
Business Intelligence/Hyperion/Siebel - BI Publisher (formerly XML Publisher)
How BI Publisher Can Help Manage Reports of the Whole Enterprise

During this session, you will discover how we have deployed BI Publisher to manage the reports of Oracle applications (Siebel, eBusiness Suite, PeopleSoft), Oracle ADF Web-based applications, and third party applications like Sungard’s Banner. You will also learn the benefits of BI Publisher compared to Oracle Reports for your IT team and your end users. Plus, you will see how you can mix BI Publisher with Oracle Content DB and Stellent UCM to store your dynamically generated reports. Installation, configuration, and deployment tips will be shared throughout this presentation. This presentation is based on two distinct customer case studies.

Eric Marcoux, Université Laval
Third Party Tools - Open Source
Managing Oracle Forms, PL/SQL, and ADF Source Files in a Single Environment

During this session, you will discover how Collabnet Subversion can help your IT team manage your Oracle Forms, PL/SQL, and ADF (Java) source files in a single configuration management environment. You will also learn how you can automate the deployment of your Oracle Forms and ADF applications in different development environments using Apache Maven and Apache Continuum together. Installation, configuration, and deployment tips will be shared throughout this presentation. This presentation is based on a customer case study.

Back to the Top

---

Raj Mattamal, Niantic Systems, LLC
Oracle Tools - Application Express
Writing a Custom Authentication Scheme for Application Express: A Case Study

Although Application Express has excellent out-of-the-box options for authenticating users into applications, it is sometimes necessary to write custom authentication schemes to meet the specific needs of customer environments. Using an existing implementation as a case study, this session will explore many of the considerations required when assembling a custom authentication scheme including using some of the APEX custom authentication APIs provided by Oracle. In addition to discussion, this session will demonstrate the functionality discussed.

Back to the Top

---

Jeff McAhren, Health Markets
Optimizing Dataloads and Dimension Builds
We will discuss best practices for dimension building and data loading regarding performance and maintainability, including optimizing data sources, build types, types of database restructures, and things to avoid when building dimensions and loading data.

Back to the Top

---

Tracy McMullen, interRel Consulting
Optimizing Outlines
Some people want to optimize their Essbase cubes for calculation performance.  Others want to reduce the speed of data loading or improve the performance of retrievals.  The best place to start no matter what you're optimizing is the common factor across all of these: the Essbase outline.  This presentation will cover essential outline optimization topics like dimension order, density and sparsity, tuning compression to the outline order, dynamic calculations, proper attribute dimension usage, and more.  Using primarily these tips, your presenter has personally seen optimization improvements of more than 99.9%.  If you want to learn to optimize the foundation on which all other aspects of Essbase sit (we're talking about the outline here), then make sure you attend this presentation.

 

Back to the Top

---

David Mellor, Oracle Corporation
Hyperion
First Look Beyond Kennedy: An Alpha Preview

The First Look Preview session will introduce new capabilities for Essbase to utilize the Application Development Framework via an extension for Oracle JDeveloper.  JDeveloper is a complete IDE for Service-Oriented Architecture (SOA) and Java.   An Essbase Developer is no longer constrained to use a specific browser front end to build Essbase Applications. The developer can now use the full power of JDeveloper to develop components such as member selectors, pivot tables as well as building predefined dashboards with a variety of visualizations. The session will provide an interactive demonstration by building a sample application in JDeveloper which highlights the Essbase integration. 

Back to the Top

---

Josh Millinger, Niantic Systems, LLC
Oracle Tools - Application Express
Migrating from Access to Oracle Application Express

As we all know, Microsoft Access is ubiquitous in our IT environments, even if it wasn't intended to be. Application Express is the obvious choice to look to when deciding how to move the now mission-critical applications into our Oracle environment. This session will take an example of starting with MS Access with an application and go through all the necessary steps to make it "live" in APEX. Steps include using the Oracle Migration Workbench to move the data and then Oracle APEX to help create/modify the application.

Back to the Top

---

Duncan Mills , Oracle Corporation
Fusion Middleware - Building Custom Applications using Fusion Middleware
Oracle ADF 11g: New Declarative Development Features for Fusion Applications Development

ADF is the framework of choice for Oracle's own Fusion Applications developers. Whether you are building applications to extend or integrate with Fusion Applications, or you are simply looking for a framework to enable declarative development of 'home-grown' applications, JDeveloper and ADF provide the tooling you need to accomplish these tasks. This session explains all of the new declarative development features in ADF 11g. Through demonstrations, this session shows how to build business services with ADF business components, expose those services to the user interface using ADF Faces Rich Client components, and orchestrate application logic using the new ADF controller.

Back to the Top

---

Cary Millsap, Method-R Corporation
Methodology - Other
Measure Once, Cut Twice (No, Really)

“Measure Twice, Cut Once” is a reminder that careful planning yields better gratification than going too quickly into operations that can’t be undone. Sometimes, however, it’s better to measure once, cut twice. It’s one of the secrets behind how carpenters hang square cabinets in not-so-square kitchens. And it’s one of the secrets behind how developers write applications that are easy to fix when they cause performance problems in production use. The key is to know which details you can plan for directly, and which details you simply can’t know and therefore have to defend yourself against. In this session Cary will discuss some aspects of software development where flexible design is more important than detailed planning, using woodworking analogies for inspiration. Cary will  describe some particular flexibilities that your software needs, and he’ll describe how to create them.

Back to the Top

---

Ron Moore, MTG
Calc Scripts: Beyond the Basics

So you’ve mastered the basics.  Now what?  Calc Scripts: Beyond the Basics will take it to the next level and explore solutions to some of the most common calculation problems such as rolling calculations, block creation issues and calculating across databases with different dimensions.  If the next level isn’t enough for you, we will also introduce a few functions from Essbase’s new generation such as DataExport that lets you push data to a relational database.  We wrap up with some discussion of calculations for the ever popular allocations.  Calc scripts at 8:00 AM?  Bring coffee!

Back to the Top

---

Rune Mørk, TIA
Oracle Tools - PL/SQL
Serialize Your PL/SQL

Often when building PL/SQL programs for batch environments, these programs are constructed in such a way that it will only utilize one of the CPU’s of the machine. That is not feasible when you have a string of programs that needs to be executed one after each other. SQL  offers the possibility to serialize SQL statements, PL/SQL does not. In this presentation Rune will show how you can build an execution environment that adapts to the available CPU resources. He will present first a crude first shot showing you an easy way to divide your workload on multiple CPU’s with no guarantee of an equal split of the work on hand. Secondly, he will take this a higher level where he will present a method by which you can guarantee that the workload is equally split, by utilizing dbms_pipe and AQ for communicating between processes. AQ and dbms_pipe serves as the foundation for this solution, therefore this presentation includes an introduction to these utilities.

Back to the Top

---

Daniel Morgan, University of Washington and Tammy Bednor, Oracle Corporation
Development DBA - Other
Audit Vault and Your Regulatory Requirement Needs

Audit Vault is Oracle's tool for collecting and reporting on operating system and database changes required for complying with regulatory controls. This presentation will utilize an on-site Audit Vault Server and separate target database and will use them to cover the installation and configuration of an Audit Vault server, the live installation of the Audit Vault Agent, collector creation, and the development of audit reports. The need for Audit Vault is being driven by both government and industry regulations that, more and more, DBAs and developers are required to implement. This session will cover the technology while providing a primer on internal controls.

Back to the Top

---

Lynn Munsinger, Oracle Corporation
Fusion Middleware - JDeveloper
7 Things That You Should Know When Using JDeveloper 11

Turns out that not everything is in the guide books. This session reviews helpful tips and tricks that will get you more productive when using JDeveloper 11. Not for the newbies, but rather for the more experienced developer, this session covers tips on everything from new coding features and other hidden gems in the core IDE to finding the information you need to get your work done.

Lynn Munsinger, Oracle Corporation
Java EE and SOA – Web 2.0
JDeveloper 11 ADF Faces Rich Client: Mastering Web Layout Development

Web layout components allow developers to create attractive, logically organized user interfaces. With JavaServer Faces, these layout components also have behavior that needs to be taken into account when building Web applications with this technology. This session shows how to build Web layouts with ADF Faces Rich Client components and how the new JDeveloper 11 reusable components, like templates and declarative components, help you in your job. To ice the cake, this session explains how skinning can be applied to further control your application's layout.

Lynn Munsinger and Susan Duncan, Oracle Corporation
Fusion Middleware - JDeveloper
Who Moved My Code? – Team Development in Oracle JDeveloper

Developing applications as a team introduces several considerations, including source and version control for files and utilizing shared resources. This session details the use of integrated source control via Subversion in JDeveloper 11g and how your team can package and share resources such as deployed services. Through realistic demonstrations, this session explains best practices in team development and shows how to coordinate check-in procedures and shared files across a development team. Come see JDeveloper product managers create an application using the team development features of JDeveloper, and learn how your team can leverage these features for maximum productivity.

Back to the Top

---

Shyan Vran Nath, Deloitte Consulting LLP
Business Intelligence/Hyperion/Siebel - Other
A BI and Advanced Analytics Case Study

This presentation will look at the framework for developing a data-driven planning application using business intelligence and advanced analytics. Often the planning, budgeting, and forecasting involves quantitative details that make the job of the approving authorities harder. Here we take the domain of K-12 education and look at how advanced analytics can be used to predict the students who are "at-risk" of graduation versus those who are likely to succeed. This is a major U.S. national challenge and the government's "No-Child Left Behind" initiative addresses that. We look at how K-12 cross-subject education related data such as attendance, enrollment, achievement, discipline, etc. can be used to create an education datawarehouse and can be used for data mining. We will look at the use of Oracle Warehouse Builder, Oracle Data Mining, OBIEE, other BI tools, and the development environment in the process. The outcome of the data mining provides the "actionable" data to the education administrators and decision-makers via the education dashboards. These in turn help to initiate data-driven planning that can use the results of predictive analytics to plan for current and future school years. This presentation was developed using a real Department of Education BI project from 2007.

Back to the Top

---

Anton Nielsen, C2 Consulting, Inc.
Oracle Tools - Application Express
How to Hack an Oracle Application Express Application

Oracle's Application Express (APEX) allows developers to quickly build highly functional applications that interact with an Oracle database. APEX dynamically generates HTML applications (hence the former name, HTML DB). All HTML applications share some attributes that expose them to potential hacking. APEX has many features that will allow developers to lock down their applications – or to expose them to hacking. I will show (live!) a number of techniques that can be used to hack HTML applications—and how to close these holes within APEX and where APEX may expose these holes through its wizards. Naturally, I will show how to protect against any hack that I demonstrate. The session will be interactive with the audience participating in ways to hack and prevent hacks. This is truly a session that can benefit the novice to the highly advanced APEX developer.

Back to the Top

---

Robert Nocera, Vgo Software, Inc
Fusion Middleware - ADF BC
Using ADF 11g as a Platform for Oracle Client/Server Forms Conversions

With the introduction of ADF 11g, including both the back-end Business Components and the front-end Rich Faces Components systems can now viably be converted from client/server applications to Web applications. This presentation explores some of the difficulties in recreating Client/Server applications in a Web environment and shows how ADF 11g can be used to alleviate some of those difficulties. The presentation is based upon a real-life proof-of-concept project that uses ADF 11g as the target platform for a client/server migration project. Real-life problems, their solutions, and code examples will be reviewed.

Back to the Top

---

Mogens Norgaard, Miracle A/S
Development DBA - Tuning
You Probably Don't Tune Right (and You Probably Never Have)

This presentation will explain the four worst practices to date regarding performance optimization and tuning. Topics include best practices (vs. best evidence),  counters (don't) count, guess and  grimmacing,  and Groundhog Day tuning. Then the grand unifying solution (GUS) will be presented. Finally, the problems with GUS will be briefly discussed.

Back to the Top

---

Dan Norris, Piocon
Development DBA - Tuning
How a RAT Will Save Your Job

Like the rodents that have survived for centuries, Oracle 11g Real Application Testing will likely be here for many generations to come. Of course, it will hopefully evolve more than the rodents have, but for DBAs, the challenge is to understand and use it in its current form. Oracle Real Application Testing provides a way to simulate a real workload on the database while simultaneously limiting the factors that might invalidate a true database load test. Most load testing has been done via an application, but Real Application Testing adds the option to test just the database without a running application. Plus, with the ability to capture exactly what's happening at the database layer, load tests on other environments and database versions are more reliable. This session reviews the Real Application Testing feature and how you will employ it to look like a genius and get a raise! No rodents will be harmed in this session.

Back to the Top

Dan Norris, Piocon
Development DBA - Tuning
RAC For Beginners: The Basics

Oracle Real Application Clusters (RAC) has been steadily gaining momentum in the market with new and old customers considering RAC implementations. Both DBAs and managers need to understand some basics about RAC and how it is managed. There have been many mistakes made by those that attempted to create RAC environments without having a solid understanding of the architecture. This session will focus on the technical architecture of the RAC feature with an emphasis on those areas that are frequently misunderstood. The presenter is a veteran RAC implementer and RAC SIG board member who deals with many different RAC environments on a weekly basis.

Back to the Top

---

Jason Novikoff, interRel Consulting
Hyperion
Installing Essbase: The Basics
There are hundreds of pages of installation documentation in several different guides but yet in some cases they are missing critical pieces of information.  In this session, you will see the steps necessary to install and configure Essbase.  We will cover installation of the license server and discuss which versions no longer require it.  We will cover installation and configuration of Shared Services and Essbase Administration Services as well as Essbase itself.  There are several choices you can make for the third-party prerequisites; we will not cover all combinations but you will get exposure to some common steps and troubleshooting techniques.

Back to the Top

---

Alex Nuijten, AMIS Services
Oracle Tools - PL/SQL
Stuff You Can Do with Conditional Compilation

How can you test a procedure or function which is private to a package? How can you continue with development when the component that you depend upon is not finished yet? How can you make sure that your code gets compiled with the best optimizer settings possible or have it not compile at all? How do you leave debug code out of production code? With version 10g, Oracle provided the PL/SQL PreCompiler, one of those features that demonstrate how PL/SQL is still not just very much alive but a modern programming language as well. You, as a serious PL/SQL developer, will want to learn all about this feature and how it will help you in your job. Another neat thing you can do with Conditional Compilation, is create database version independent code. Take full advantage of new Oracle 11g development features, but still be compatible with your Oracle 10g application. Get your code ready for tomorrow by using Conditional Compilation!

Alex Nuijten, AMIS Services
Oracle Tools - SQL
Oracle 11g for Developers

Every major new release of the Oracle Database is a special event. Last year's launch of Oracle 11g initially looked like an exception to that rule, at least to developers. What is in it for them? However, on closer inspection, the 11g release has a load of new functionality that is very useful to application developers. In this presentation we will take a look at the most important new features that we encountered during our involvement in the Beta program for 11g or since its production release and try to make you as happy with them as we are and less puzzled than we sometimes were upon our first encounter with certain features. A few of the most remarkable features include XML DB and native Web services, the PL/SQL result caching functionality, the compound trigger, the PIVOT statement, virtual columns, database continuous query notification, table flashback archive, the continue statement, and direct sequence access in PL/SQL. Of course,there will be plenty of demonstrations on how you can use the most important features in your own applications.

Back to the Top

---

Shaun O'Brien, Oracle Corporation
Fusion Middleware - JDeveloper
Keeping Your Leftovers Fresh with JDeveloper – New Reusability Features in 11g

Reusability is crucial to the productivity of development efforts as well as to ensure the consistency of systems within an organization. Even the most stringent of guidelines are going to end up being violated after being repeated enough times. Obviously, the more that this can be packaged into actual code artifacts the more reliable this solution is going to be. JDeveloper 11g has been specially augmented with a focus to take these use cases into consideration. In this session, JDeveloper 11g new features will be examined with special care given to the reusability features including an end-to-end demo illustrating several of these as well as providing a sneak preview of the new metadata driven systems for runtime customization of content.

Shaun O'Brien , Oracle Corporation
Fusion Middleware - ADF BC
Service Oriented Development with Oracle ADF Business Components and BPEL

BPEL is a powerful language for orchestrating services into composed business processes. This session provides a deep-dive into the new features of ADF Business Components as they relate to BPEL processes. Through demonstrations, this session explains how an ADF BC component can be consumed by Web service-savvy applications, including BPEL processes, and how to trigger a BPEL process from an ADF application using events.

Back to the Top

---

Chris Ostrowski , TUSC
Oracle Tools - Application Express
Advanced Oracle Application Express Tips and Techniques

Oracle Application Express (APEX) is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include pop-up windows, complex searches, document management, indexing and searching, tool tips and hints, e-mail links, page 0, help text, background jobs, add to my calendar feature, saving contacts (VCF), sending mass e-mails, and more.

Back to the Top

---

Chris Ostrowski, TUSC
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Internal and External Application Integration — Oracle Fusion Web Services

Having ventured down the path of a full-bore 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 Services) wherever it made sense. This presentation will discuss the good, bad, and ugly about this approach that was taken. Knowing what I know today, I would in fact 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 in action. 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.

Back to the Top

---

David Peake, Oracle Corporation
Oracle Tools - Application Express
Oracle Application Express (APEX) Version 3.1