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