ODTUG Kaleidoscope 2008

Fusion Middleware

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 deve lopment 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

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

Patrick Cimolini, Cayman Islands Government
Fusion Middleware - Other
Case Study: Selecting, Installing, and Configuring Universal Content Manager (UCM)

Oracle’s Universal Content Manager (UCM) is a recent addition to Oracle’s Fusion Middleware Stack. In 2007, the Cayman Islands Government selected UCM as its content management tool of choice. The product was procured and installed in 2007 with the configuration pilot project scheduled for the first quarter of 2008. First, this case study presents a brief overview of the general issue of content management. Second, the reasons for selecting UCM over competing products are reviewed. Third, a summary of the installation, training, and configuration projects is outlined from a lessons learned point of view. Finally, references are listed so that the audience can quickly get more in-depth material.

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

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

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

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

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

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

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

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 hig hlights 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

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

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

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

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.

Back to the Top

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.

Back to the Top

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.

Back to the Top

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.

Back to the Top

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

Peter Lorenzen, Logica Company
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

Grant Ronald , 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

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.

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, both the back-end Business Components and the front-end ADF Faces Rich Components applications can now viably be converted from Client/Server applications to Web applications. This presentation explores some of the difficulties in recreating such applications in a Web environment and shows how ADF 11g can be used to alleviate some of those difficulties. The presentation will explore 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

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
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

Jim Powell and Maiko Rocha, Oracle Corporation
Fusion Middleware – Service Oriented Architecture (SOA) Suite
Building Next Generation of Composite Applications Using WebCenter, SOA, and Web 2.0.

The real challenge in building composite applications is determining the right approach to take and knowing when to use which component of the Oracle Fusion Middleware stack. During this session, we will build an application from scratch including, modeling, service creation, etc. We will leverage services-oriented architecture (SOA), WebCenter Services, WebCenter Framework, WebCenter Composer, and Oracle Application Development Framework (ADF) to build a composite application.

Back to the Top

Grant Ronald, Oracle Corporation
Fusion Middleware - ADF BC
Step by Step Redeveloping a Forms Application Using Oracle ADF: A Case Study

You have heard how Oracle JDeveloper and Oracle ADF can bring you "Forms like" productivity when building on the Enterprise Java stack. Truth or Hype? This case study takes a typical Forms application and step-by-step redevelops it using Oracle JDeveloper and Oracle ADF. Building the application from the database up to the UI, this presentation will guide you on how closely many of the Forms concepts you rely on can be mapped to the Java world.

Back to the Top

Matt Topper, IT Convergence
Fusion Middleware - Other
Oracle Identity Management – The Total Identity Solution

Over the past three years Oracle has acquired major players in every aspect of the Identity Management realm. This leaves a lot of questions with what is going to be continued to be supported and what is not. This is a real-world from the trenches talk that discusses actual identity implementations. This presentation will cover all of the components of the Oracle Identity Management Suite, how they function, their similarities and differences, and the best practice solutions for each component.

Back to the Top

Clemens Utschig, Oracle Corporation
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Beyond WS-X, BPEL, and XML – The Future of SOA

While no other technology helped to shape Service Oriented Architecture (SOA) more than WS-BPEL, this session will challenge attendees to look over the horizon, to new, evolving standards, such as Service Component Architecture (SCA). With all those standards in place, the time for Business Process Management as a whole has arrived—manage, monitor, and refine your explicit processes based on your business goals and KPIs. The goal of this presentation is to help engineers as well as architects understand how they can benefit from today's standards, and design for the next generation. It will also look into the organizational concepts of SOA, why SOA is an enabler for change and agility of an organization, and what managers can do to turn employee fear and resistance into excitement.

Back to the Top

Clemens Utschig, Oracle Corporation
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Introduction to Service Oriented Architecture

This session will give attendees an introduction into the world of Service Oriented Architecture (SOA) and teach them the basic foundations. Starting from a brief introduction about the concepts and ideas, towards the discovery and implementation of services, and the reuse of those within executable business processes (through the usage of Business Process Orchestration Language – BPEL). SOA is the conceptual foundation for Oracle's next generation Application Suite (Oracle Fusion Applications) —hence this session will give the attendee a great chance to learnmthem. The presentation is demonstration driven and attendees will see the benefits explained in short demos to get a good understanding leave with the basic tools in their hands.

Back to the Top

Wilfred Van Der Deijl, Eurotransplant
Fusion Middleware - Building Custom Applications using Fusion Middleware
Integrating Oracle Forms with Other Web Technologies

The session will demonstrate how easy it is to fully integrate an existing Forms application into a JSF based Web application. With the right JSF component library, it's a matter of drag-and-drop. This allows you to build hybrid applications consisting of Oracle Forms and newly built Web pages. You can pass context from the Web application to Forms and the other way around. It's also possible to invoke actions in Forms from within the Web application or initiate Web application events from Forms PL/SQL. This is something a lot of Forms users have been craving for the last couple of years. Now it's here and you have to see it to believe it. It can be the key in a gradual migration from Oracle Forms to new technology, or if you're happy to continue using Oracle Forms, it allows you to integrate these forms with any Web application, whether it is a new JSF application, Oracle Portal, Oracle WebCenter, PHP, or any other Web technology.

Back to the Top

Sten Vesterli, Scott/Tiger A/S
Fusion Middleware - Building Custom Applications using Fusion Middleware
What’s Hot and What’s Not—An Overview of Oracle Development Tools

This presentation examines all of the important development tools and technologies available from Oracle today, discussing the strong and weak points of each: Application Express (PL/SQL and wizard-based); Application Development Framework, ADF (middle tier components, built with JDeveloper); ADF Faces for Web applications (used by Oracle for Fusion applications); ADF Swing for desktop applications (allows rich Desktop applications like those built with Forms); Oracle Forms (today only Web deployment, a few new features in 11g); Oracle Reports (high-end reporting tool to meet the most sophisticated reporting needs); Oracle Portal (both application development framework and basic content management); and Oracle WebCenter (next generation portal product, current version does not contain full functionality). The presentation is concluded with a “hot or not” summary of which application development approaches you can expect to be using in the coming years.

Back to the Top

Sten Vesterli, Scott/Tiger A/S
Fusion Middleware - JDeveloper
Like Open Source Forms –ADF Swing Applications with JDeveloper 11g

To a Forms developer, JDeveloper and Java development can seem rather intimidating. Especially if you are trying to build a Forms-like application (called an ADF Swing application in JDev-speak). You receive little guidance from books or Web sites. This presentation shows you how you can use JDeveloper for declarative development just like Oracle Form —dragging items onto a canvas and adding trigger code to handle necessary processing. A few things differ, naturally, and these are explained in the presentation. Topics include how an ADF Swing application has separate business and user interface tiers, how the right choice of Layout Manager removes the complexity of Java screen layout, and how to choose whether to place your code in the business logic tier or the user interface tier. The presentation is wrapped up with a brief examination of the code that JDeveloper builds for you to inspect and change if necessary.

Back to the Top

Application Express

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

Chris Ostrowski , TUSC- A Rolta Company
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

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

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

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

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

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

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

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

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

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

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

Oracle Application Express (formerly Oracle HTML DB) enables anyone, even those with limited programming experience using just a Web browser, to quickly create secure, scalable, database-centric Web applications. In this session, you'll learn why Oracle Application Express is one of Oracle's most popular technologies, and you will learn about exciting new features in Application Express 3.1. Details relating to Version 4.0 will also be covered.

Back to the Top

Tanya Podchiyska, Stanford University School of Medicine
Oracle Tools - Application Express
Application Express in Support of Institutional Strategic Planning

Oracle Application Express is a rapid application development tool which offers developers a wide arrangement of customization options. Hence, it was chosen as the development platform for the Stanford Medical School’s strategic planning application. The application provides a central repository for the Institutional Planning Office to manage the plans of organizations throughout the school. It also allows users to develop their strategic plans, including determination of missions, goals, activities, and initiatives. This Web-based application facilitates communication throughout the school of goals, initiatives, and activities. It provides tools for organizations to define their success metrics and monitor their performance relative to their plans. The technical demonstration covers session-state handling, dynamic SQL utilization in defining the authorization scheme, building of custom theme with APEX HTML templates, JavaScript and CSS (including SVG stylesheet modifications), and AJAX for user role specification.

Back to the Top

John Scott, Apex Evangelists
Oracle Tools - Application Express
APEX Hints, Tips and Best Practices

Application Express makes it incredibly easy to develop applications, however there is always more than one way to achieve something and it can be very difficult to know whether there is a “better” way to do something (and “better” can be very subjective!). This presentation will show some hints and tips on features in Application Express which you might not be aware of, but you should definitely be using! We will also cover some “best practices” (which can also be very subjective!) which can ultimately lead to a more productive development cycle.

Back to the Top

Scott Spendolini, Sumner Technologies, LLC
Oracle Tools - Application Express
You Can't Do THAT in a Browser! Extending Oracle APEX with Third Party Components

While APEX offers a robust set of features, it does not address every possible scenario that you will run into when developing your applications. Fortunately, it is quite simple to use a number of third party tools to enhance and/or supplement APEX's functionality. This presentation will review a number of these components and demonstrate how to integrate them with APEX.

Back to the Top

Karen Van Hellemont and Jan Huyzentruyt, iAdvise
Oracle Tools - Application Express
Use the Power of APEX Dictionary Views to Increase the Quality of Your APEX Applications

Since Oracle Application Express 2.2, all metadata defining your applications are exposed by means of the (new) data dictionary views. This opens perspectives to set-up your own Quality Control System with checks against coding standards and good practices. —When starting the development of a new application, one of the first actions you always do is set up naming conventions, coding standards, and best practices. This presentation will show you how you can increase the overall quality of your application by controlling whether your development team follows those outlined guidelines. Those controls can be implemented by queries against the APEX repository views presented in a custom QA application—in APEX of course.

Back to the Top

Patrick Wolf, Sphinx IT Consulting
Oracle Tools - Application Express
Increase Your Oracle APEX Development Productivity with Open Source Tools

Oracle Application Express (APEX) development is already very productive, but with the right combination of tools it can be even more productive! This presentation will give you an overview and a demonstration of open source tools which can be used to increase the productivity of your Oracle APEX development environment. It will cover "must have" Firefox and Internet Explorer plugins, the Javascript framework jQuery, the ApexLib development framework and the Oracle APEX Builder Plugin.

Back to the Top

Marcie Young, Oracle Corporation
Oracle Tools – Application Express
Building Advanced Tabular Forms
Have you ever wanted to build a tabular form manually so that you could control the way the data appeared and was manipulated. In this session, you will learn how to build a custom tabular form using the APEX_ITEM and APEX_APPLICATION APIs. You will learn how to add extra rows for insert, add optimistic locking, and validations using collections. This advanced session will expand your understanding of the inner workings of tabular forms and how they can be used.

Back to the Top

Business Intelligence

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

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

Cathye Pendley and Dan Vlamis, Vlamis Software Solutions
Business Intelligence/Hyperion/Seibel - 10g/11g OLAP
Building Cubes and Analyzing Data Using Oracle OLAP 11g

Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you? This presentation will demonstrate the process of migrating 10g cubes and dimensions to 11g and using Oracle OLAP 11g to create cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what it means to the Warehouse Architect and Users. OLAP 11g adds a lot of new features designed to help the DBA and architect build multidimensional warehouses rapidly and integrate them seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications. It will help an application developer understand what options are possible and how to gain maximum value from a data warehouse.

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
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

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.

Back to the Top

Shyam 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, Oracle Business Intelligence Enterprise Edition , 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

Doris Phillips, City of Charlotte, North Carolina
Business Intelligence/Hyperion/Siebel - Other
Stepping up to Visual Analysis!

Visual analysis is a revolutionary new way to get information out of your Oracle data warehouse or data marts! Quickly visualize what you know and discover things that you did not know existed in your Oracle data. Learn about visual analysis along with some basic tips and techniques for getting data out of the database using Tableau/Oracle [Hyperion] Visual Explorer through a case study that analyzes the City of Charlotte's helpdesk data.

Back to the Top

Mark Rittman, Rittman Mead Consulting
Business Intelligence/Hyperion/Siebel - Oracle Business Intelligence Enterprise Edition (formerly Siebel Analytics)
A Next-Generation Oracle BI Architecture

With the recent acquisitions of Hyperion and Siebel, Oracle now has a world-class set of BI tools to add to their own Oracle Database, Oracle Discoverer and Oracle Warehouse Builder. For customers though, the question now is how to build an effective BI architecture out of these tools, built around the core of an Oracle database and using the features of Oracle OLAP, Oracle BI Server, OWB and ODI, Oracle Dashboards, Oracle Answers, and the performance management tools provided by Hyperion. This presentation answers the questions around Oracle's BI strategy, provides a BI development roadmap and sets out an architecture that leverages the best elements of these tools, explaining how best to use Oracle's BI and data warehousing for a variety of customer scenarios.

Back to the Top

David Roberts and Kendall Garey, Oracle Corporation
Business Intelligence/Hyperion/Seibel
What's New and What's Coming in Hyperion BI Tools

Attend this session to learn about the latest developments and planned enhancements to Hyperion's BI tools, including Web analysis, financial reporting, interactive reporting, and SQR production reporting.

Back to the Top

Paul Rodwick, Oracle Corporation
Business Intelligence/Hyperion/Siebel
Oracle Business Intelligence Road Map and Strategy

What lies ahead in Business Intelligence? In this session, learn about Oracle's plans to deliver a complete set of enterprise performance management (EPM) applications with a best-of-breed next-generation BI foundation, operational BI applications, and market-leading financial performance management applications from Oracle Hyperion.

Back to the Top

Antonio Romero, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Oracle Warehouse Builder: Web Services and SOA Ready

Web services and SOA are the big buzzwords in today’s world of loosely-coupled applications. Oracle Warehouse Builder 10gR2 and 11gR1 are ready for today's application architectures. This presentation will focus on how to handle an XML document as a source or target (using experts) and how to expose an OWB mapping as a Web service, and call it from BPEL. Concrete examples will show you how incorporating OWB functionality in these cases improves developer productivity.

Back to the Top

Borkur Steingrimsson, Rittman Mead Consulting
Business Intelligence/Hyperion/Siebel - Oracle Business Intelligence Enterprise Edition (formerly Siebel Analytics)
Implementing Access Control for Oracle BI Enterprise Edition Suite

The Oracle Business Intelligence Enterprise Edition Suite offers a wide variety of authenticating users and permitting access to the services it provides. We will take a look at what different options we have with this respect and take a detailed look at how to set up a robust authentication and authorization model.

Back to the Top

Tim Vlamis and Dan Vlamis, Strategyscape, LLC and Vlamis Software Solutions
Business Intelligence/Hyperion/Seibel - Oracle Business Intelligence Enterprise Edition (formerly Seibel Analytics)
Lies, Damn Lies, and Visualizing Data with Oracle BI

Are you involved in generating reports for your business, but want to know which formats are best to use in which situations? Would you like a simple way of understanding when to use pie charts, bar charts, line charts, and bubble charts? Want to know when data is presented objectively and when it’s not? You’ll learn basic design principles for writing reports and generating graphs. You’ll see examples of how capabilities built into Excel and Oracle BI Enterprise Edition (formerly Siebel) both help and hurt in presenting and visualizing data in everyday situations. Join BI mavens Dan Vlamis and Tim Vlamis for an entertaining session on how managers typically manipulate, misuse, and abuse reports and analytics to conquer their companies on their way to world domination and what you can do to turn Oracle BI EE into a tool for the good!

Back to the Top

Dan Vlamis, Vlamis Software Solutions
Business Intelligence/Hyperion/Siebel - 10g/11g OLAP
Oracle BI, Oracle OLAP, Essbase: The Benefits and Cost of Openness

Companies with heterogeneous environments need to analyze data from multiple sources, through multiple application servers, in multiple presentation environments. The "hot pluggable" products work well for this need: Oracle Data Integrator, Essbase, Real-time Decisions, Oracle Business Intelligence Enterprise Edition, and BI Applications. But what if these needs are not paramount in your organization? You can use Oracle's traditional products: Oracle Warehouse Builder, the OLAP, Data Mining options to the Oracle Database, Oracle Business Intelligence Standard Edition, and Daily Business Intelligence. Come and learn which products are appropriate for your situation, how Oracle's acquisition strategy led to this situation, and how Oracle's product management structure propagates this situation. The session will especially focus on the differences between Essbase and the Oracle OLAP option—both very capable multi-dimensional databases, but with different goals.

Back to the Top

Hyperion

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.

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.

Subhash Gaur, Oracle Corporation
Kennedy: Essbase Studio

This presentation will demonstrate the capabilities of new cube building tool, Essbase Studio. It will include modeling of data sources, creation of hierarchies, design, and construction of the cube. It brings ease of use of EIS and performance of load rules. Dynamic association of Drill Through reports with cubes will also be demonstrated. New features such as XOLAP, slowly changing attributes, and derived text measure of Essbase are exposed through Studio.

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

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

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

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

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
Hyperion
MaxL (and Converting Over from EssCMD)
When it comes to automating Essbase cubes, there are two primary batch methods: old-school EssCMD and cutting-edge MaxL. This presentation will start with the basics: what is a MaxL script, how do you test it, and how do you launch it. We'll then cover converting an EssCMD script to MaxL. After addressing how to read the MaxL documentation (trust us: it's not easy), we'll show you how to write your own MaxL scripts to automate all those mundane aspects of corporate life. Finally, we'll conclude with several real world examples of MaxL scripts that you can begin using today with a minimum of customization.

Back to the Top

Tracy McMullen, interRel Consulting
Hyperion
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

Al Marciante, Oracle Corporation
Hyperion
Kennedy: Essbase Block Storage Changes

This session will highlight key enhancements to the Block Storage kernel for Essbase. These include features such as textual measures, backup/recovery, new calc functions, and time intelligence updates. It will also include a general overview of key initiatives and features as part of the overall Kennedy release of Essbase.

Back to the Top

Al Marciante, Oracle Corporation
Hyperion
Kennedy: Essbase Aggregate Storage Changes

This session will highlight key enhancements to the Aggregate Storage kernel for Essbase. These include features such as text/date measures, XOLAP, partial data clearing, and partitioning features. It will also include a general overview of key initiatives and features as part of the overall Kennedy release of Essbase.

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

Ron Moore, Marketing Technologies Group
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

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

Edward Roske, interRel Consulting
Hyperion
Optimizing Calc Scripts
There are classes (and books) on how to write calc scripts but with the exception of the often misunderstood mantra "Fix on sparse, IF on dense," there is little information on writing a well tuned calc script. When should I use CLEARDATA vs. CLEARBLOCK? (The answer: 99% of the time you should be using CLEARBLOCK.) When should I use CALC DIM vs. AGG? (The answer: in most every case, you should be using AGG or not be aggregating the dimension at all.) When should I use IF vs. FIX? Explanations for all of these questions as well as tips on writing easily maintainable calc scripts and efficient use of functions will be explained in this… the most important presentation you ever attend (as far as calc scripts are concerned, that is).

Back to the Top

Edward Roske, interRel Consulting
Hyperion
VBA: Essbase and Smart View Add-Ins
Of the Fortune 500 companies that use Essbase, more than 92% of them access at least some of their data through Microsoft Excel. Because of this, companies have created multitudes of spreadsheets ranging from single, unformatted tabs up to multi-megabyte spreadsheets. If your company is like most, you'll find yourself wanting to automate certain things. Maybe it's as simple as connecting every sheet in a workbook to Excel and then retrieving data from Essbase. Maybe it's as complex as an Excel-based dashboard with dropdowns linked to Essbase and command buttons all over the place to retrieve, send, zoom in, and more. The key to any of these applications is VBA and thankfully, Oracle has a rich "toolkit" of VBA functions for developers and users to draw on to access Essbase from within the Essbase Excel and Smart View Add-Ins. In this class, you'll see real world examples of VBA code that you can use to automate and enhance your Microsoft Office experience. You'll leave with at least a solid understanding of the principles behind writing your own VBA against Essbase. Note that a basic understanding of Excel macros is assumed: we're just going to cover the Essbase side of things.

Back to the Top

Edward Roske, interRel Consulting
Hyperion
Custom-Defined Functions in Calc Scripts
Sometimes, you just can't live within the constraints of the standard Essbase calc script functions and commands. For instance, a large retailer recently wanted to write a "Weeks of Supply" calculation to determine how long a product would remain stocked based on forecasted sales. Writing this using a calc script took pages of code and the script took hours to run. The solution was to move the function to Java where it could then be accessed via an Essbase CDF (Custom-Defined Function) that makes the Java-based function appear to be part of the Essbase calc script language. The resulting CDF was only 7 lines long and took only minutes to run. In this presentation, you will learn will learn the basics of custom-defined functions and how they can improve the speed and maintainability of your calc scripts.

Back to the Top

Edward Roske , interRel Consulting
Hyperion
Custom-Defined Functions in Calc Scripts
Sometimes, you just can't live within the constraints of the standard Essbase calc script functions and commands. For instance, a large retailer recently wanted to write a "Weeks of Supply" calculation to determine how long a product would remain stocked based on forecasted sales. Writing this using a calc script took pages of code and the script took hours to run. The solution was to move the function to Java where it could then be accessed via an Essbase CDF (Custom-Defined Function) that makes the Java-based function appear to be part of the Essbase calc script language. The resulting CDF was only 7 lines long and took only minutes to run. In this presentation, you will learn will learn the basics of custom-defined functions and how they can improve the speed and maintainability of your calc scripts.

Back to the Top

Rick Sawa, Oracle Corporation
Hyperion
Optimizing Caches and CFG Settings
This session covers how to tune and configure memory caches of Block Storage Option (BSO) Essbase, and the talk will concentrate on the Essbase.cfg settings that impact cache performance. Administrators and developers will learn how BSO Essbase manages data movement in memory between the Essbase kernel and auxilliary storage. The presentation will focus on how data is managed by Essbase to support aggregations, procedural calculations and query requests. The main focus will be to explain how to tune and optimize Essbase caches in each scenario. Some attention will be also given to the negative impact of sub-optimal Essbase configurations.

Back to the Top

Tim Tow, Applied OLAP
Hyperion
VB APIs

This session will cover the Essbase C and VB APIs with particular focus on the Essbase VB API. The session will cover differences between the APIs, platforms available, practical examples and pitfalls to avoid when using the APIs. Excel VBA integration and advanced debugging techniques will also be discussed.

Tim Tow, Applied OLAP
Hyperion
Java API

This session will cover the Essbase Java API. Topics that will be discussed include architecture, scope of functionality available in the Java API, how to get started programming with the Java API. It will also provide practical examples of Java API code and will cover advanced debugging techniques.

Back to the Top

Methodology

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

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

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

Leslie Tierstein, newScale, Inc.
Methodology - Other
What is ITIL and Why Should You Care?

ITIL, IT Infrastructure Library, is a methodology originally developed in the U.K. and rapidly gaining adherents in the U.S. In marketing speak, ITIL calls for "aligning business goals with IT functions". In real terms, ITIL provides a framework for how IT departments can structure, price, and market the catalog of services they offer to end users (or IT professionals). The goal is for people within the organization to understand (and appreciate) what IT can do for them and for IT to be able to control costs, track the approval and fulfillment process for a service request, and automate that process to the extent possible. This presentation offers an overview of ITIL and Service Catalog Management, with an eye toward how these disciplines will affect the working lives of database administrators.

Back to the Top

Margaret Tompkins, HQ USMC P&R-TSO
Methodology
Challenges of Spiral and/or Iterative Development

When One Methodology Doesn't Cut It, Customize Your Own
When one methodology doesn't fit your particular development situation, then it becomes advantageous to tailor your own. Mesh methodologies and tools that keep you focused on productivity and quality. Join this participatory session and have some fun! Prizes and surprises!

Back to the Top

William Wimsatt, Wells Landers Group
Methodology
Business Stakeholder Communication and Engagement

This a case study of an enterprise data warehouse project. Californina State AAA (CSAA) initiated an enteprise data warehouse project in the fall of 2006. This project needed to take into account the views and needs of twenty-seven different business areas spread across four offices in the southwestern United States. The project team developed a communication strategy to engage the business community from requirements, through design, into deployment. This strategy increased success through consistent business feedback, and socialized training. This presentation will provide a guided case study to go from a standing start to a prioritized set of business requirements into delivered enterprise data warehouse and business intelligence solution.

Back to the Top

Oracle Tools

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

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

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

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

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

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

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

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

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!

Back to the Top

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

Michael Rosenblum, Dulcian, Inc.
Oracle Tools - PL/SQL
Autonomous Transactions: Extending the Possibilities

This presentation discusses when, why, and how to use autonomous transactions in conjunction with other features, such as object collections, dynamic SQL, INSTEAD OF triggers, etc. Additional focus will be placed on critical issues such as resolving self-mutating tables, preventing deadlocks, understanding read/write-consistency, and its corresponding side-effects. Real-life examples will be included to help attendees avoid hidden traps on the way to building systems better, faster, and cheaper.

Back to the Top

Michael Rosenblum, Dulcian, Inc.
Oracle Tools - SQL Developer
Dynamic SQL in a Dynamic World – The Sequel
This presentation will cover some of the less obvious issues that arise while using Dynamic SQL, including defining required privileges, preventing code injections, targeting performance tuning efforts, understanding resource utilization, handling object dependencies, etc. Examples will demonstrate when, why, and how to use Dynamic SQL in real-world situations in conjunction with other advanced features such as objects, object collections, ref cursors, and bulk operations.

Back to the Top

Professional Development

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

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

Third Party Tools

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

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

Grant Ronald, Oracle Corporation and PITSS
Third Party Tools – Other
How to Turn an Older Oracle Forms Application into a SOA Application
This presentation will demonstrate each of the four steps necessary to move an older Oracle Forms application to a SOA world and thus make it usable by other applications developed using Oracle's ADF or equivalents. Demonstrations will allow a step-by-step inside view into the challenges of upgrading an older Oracle Forms application, analyzing the application to identify the components to be taken into consideration when moving to a SOA environment and finally extracting Oracle Forms Data Access Layers as well as Business Logic from the application.

Back to the Top

Java EE and SOA

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

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

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.

Back to the Top

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.

Back to the Top

John Rydzy, Dulcian, Inc.
Java EE and SOA - Web Security
Building Secure ADF Applications

Application development frameworks with integrated security modules often provide a false impression that simply by using them, your applications will be secure. In reality, a developer can unknowingly introduce security flaws into the system in spite of the security framework. This presentation will identify some of the pitfalls specifically associated with developing within Oracle’s Application Development Framework (ADF).

Back to the Top

John Rydzy, Dulcian, Inc.
Java EE and SOA - Web Architecture
Using SOA with XML at the Application Level

Using conventional system design, the user interface is usually locked into its underlying database requiring that changes in one must affect the other. This presentation explains why and how to incorporate SOA at the application level to isolate the front and backends of a system in order to improve system performance and consolidate the business rules and logic. These points will be illustrated using a real-world example of a complex tree object.

Back to the Top

David Schleis, Wisconsin State Laboratory of Hygiene
Java EE and SOA - Web Development
A Simpler Way to Do Java? Well, That's Just Groovy

Java is a remarkable programming language; there is really no arguing that. What can be argued, however, is its overall applicability. The same rigorous structure imposed by Java that aids a team of developers working on a mission-critical application destined to go through many revisions is a burden on the developer creating an intranet Web app to query a single table. There are, of course, simpler alternatives to Java; one language that warrants a closer look is Groovy. What makes Groovy different is that it compiles to Java bytecode, can leverage existing Java objects, was designed to be a part of the Java environment, and even has a JDeveloper plugin. Like it or not, it looks like Java is here for the long haul. And, like it or not, many seasoned developers have begun using Java. Groovy provides a path to Java proficiency that allows meaningful contribution along the way.

Back to the Top

Wilfred Van Der Deijl, Eurotransplant
Java EE and SOA - Faces
The Beauty of JSF Component Based Development

JavaServer Faces (JSF) has brought component-based development to the Java world. With JSF, you can drag-and-drop components from a palette onto your developing Web page. Components can hide the complexity of their inner workings from the page/form developer. This is something other development environments (like Oracle Forms) had for years. This presentation will dismantle a JSF component and will show you what's inside. If you're already developing Web pages using JSF, this can be the starting point in creating your own components or extending existing ones. If you're new to JSF this can be a great introduction and it will demonstrate how similar JSF based Web development is to Forms development, but with a few bonuses.

Back to the Top

René van Wijk, Transfer Solutions
Java EE and SOA - Web Development
Data Binding Concepts: from JSP to JSF

Data shared between Web components, either servlets or pages created using JSP or JSF technology, is usually maintained in a database. How the data sharing, i.e. data binding, for the different technologies can be accomplished is discussed by using examples.

Back to the Top

Development DBA

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

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

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 and implementing necessary conflict resolution logic. 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

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

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

Daniel Morgan, University of Washington and Tammy Bedner, 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

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.

Bert Scalzo, Quest Software
Development DBA - Tuning
RAC Be Nimble, RAC Be Quick

Often relying on default operating system setup and database configuration parameters can lead to very poor RAC performance right out of the box - a symptom that I jokingly refer to as "RAC in the Box" failure. But through simple application analysis and tuning corresponding network, operating system and database parameter settings to match - DBA's can often get past the initial RAC performance issues. Furthermore, the technique serves as a nice and simple "best practices" check-list for any RAC setup - and compliments other tuning methodologies, including Method-R.

Back to the Top

Megh Thakkar, CPT Global Ltd.
Development DBA - Tuning
Partitioning Oracle Data Warehouses for Optimal Performance

Partitioning an Oracle data warehouse can significantly improve performance—if done properly. This presentation discusses various partitioning strategies that can be considered to exploit the unique demands and characteristics of data warehouse systems. Topics covered will include partition pruning, partition-wise joins, summary management, and statistics management, as well as SQL and PL/SQL tips to provide intelligence to the optimizer.

Back to the Top

Vendor Presentations
Monday, June 16, 2:30-3:30 PM

Bizwhazee
Rich Internet Applications (RIA) for PL/SQL Developers using TURBO Enterprise Web 2.0

Enterprise adoption of Web 2.0 technology has been slow due to security concerns around Ajax, the lack of integration with back-end systems, and the need to retrain IT developers to leverage this new technology in a secure enterprise environment. According to Ajaxian.com, “most of the current Ajax frameworks are really focused on the client-side of things and yes, it would certainly be nice to have some tighter integration with backend systems.”
Also, Ted Farrell, the vice president who is setting technical and strategic direction of Oracle’s own development tools, told The Register that most Ajax frameworksfocus on the interface and pay lip serviceto the most challenging part – integrationwith back-end servers. TURBO Enterprise Web 2.0 has addressed all of these issues to ensure safe presentation of enterprise information, while making it easy to develop Rich Internet Applications from its extensive development library. TURBO Enterprise Web 2.0 provides the Ajax framework fused with the Oracle database allowing PL/SQL developers to create Rich Internet Applications using the skills and resources already available.

Back to the Top

Dulcian, Inc.
100% Repository-Based Application Development

By using a repository-based approach to developing user interface components, appearance, and behavior, it is possible to achieve complete client/server functionality in applications without the typical performance sacrifices.

Advantages to using this approach:

It is possible to train a PL/SQL developer in a week to build Web applications faster than any Java programmer.
Using the 100% repository-based approach with a thick database implementation, the applications can simultaneously run in thick client and thin client (Java EE or .Net) environments.
Technology uses ultra-low bandwidth, enabling sub-second performance with very complex screens, even with limited Internet capability.
The scripting language is PL/SQL so only one programming language is needed.

If your organization has been struggling with the complexities of building Web applications, attend this presentation to learn about a dramatically less difficult and more productive way to develop applications that provides significantly better performance and quality of user experience than that provided by other Web application development architectures.

Back to the Top

EMC
Enhance your Applications by Embedding Best of Breed Information Infrastructure Software

Learn how EMC's embeddable technologies can help you meet tough software project deadlines while keeping the development team focused on their core technology. EMC's has many best of breed information infrastructure components that are easily embeddable utilizing open standards including a true Services Oriented Architecture rather than just exposing existing API calls through Web services. This overview will include a look at EMC's embeddable software components including Information Rights Management, Content Management, Business Process Management, Scanning and Capture, Federated Search, Archival, XML Database, XML Developers Workbench, and Document Output Management.

Back to the Top

Piocon Technologies, Inc.
Premier Provider of Oracle Business Intelligence, Fusion Middleware and Database Solutions presents…
Fantastic 4: ADF Faces, Ajax, WebCenter and SOA

Developing Web applications with Oracle technology has quickly gone from labor intensive programming to a component selection and configuration process. Rapid Application Development (RAD) is a REALITY with the current and evolving Oracle Web development tools. Learn how advancements in ADF, such as ADF Faces, Rich Client Interfaces, Data Visualization, Business Components and Task Flow facilitate RAD projects. Also hear how WebCenter provides rich, Web 2.0 interfaces and how the SOA Suite provides seamless integration of legacy, current, and new systems. Provided in the context of a current, operational solution, this talk will show how Oracle’s latest advances streamline your development efforts.

Back to the Top

PITSS
With Oracle Forms to SOA

Oracle Forms and SOA: antagonism or synergy? However, there is a door opener to a SOA world – even for old fashioned Oracle Forms applications still running in client/server environments. This presentation pinpoints the major steps in this metamorphosis: Upgrade – Integrate – Prepare – Share. PITSS demonstrates the new PITSS.CON key functionalities illuminating the path and its milestones to the new service driven SOA architecture. See how you can extract Forms Data Access Layers and Business Logic and create Web services, how you can use BPEL to orchestrate those services and thus make your Forms application interact with other SOA applications.

Back to the Top

IMEX SYSTEMS
Forms Migration to Java ADF

Imex System’s ORMIT migration tools are helping customers achieve their Forms migration goals to Java-J2EE & ADF.
ORMIT-Java/ADF tools have evolved since its launch last year. Using real-life examples and performing a demo migration of an application, Rohit Bhalla will cover in detail how Imex’s ORMIT Forms to Java/ADF automated migration tool can rapidly ease the application transition while addressing new ORMIT capabilities using EJB 3.0, JSF, ADF and AJAX.
Rohit will also cover aspects including:

Discussing different architecture approaches for migrating Forms based applications
How to capitalize on existing application logic while taking advantage of newer technology UI capabilities.

Back to the Top

Applied OLAP and interRel Consulting
Power of 64-Bit Essbase (brought to you by interRel Consulting and Dodeca)
Have you wanted to go beyond the traditional 2-4 Gb RAM limitations of an Essbase cube? Do you want to build cubes that can transcend the theoretical 2 Tb limit of Essbase block storage? Come to this presentation to learn how 64-bit Essbase lets you address more RAM, more hard drive space, and more CPUs. You'll hear about clients deploying real-world implementations of 64-bit Essbase around the world. If you want to take advantage of 64-bit scalable solutions to meet heavy workloads in your Hyperion environment and the “I want it now” information demands of your customers, come to this presentation (brought to you by Tim Tow from Applied OLAP and Edward Roske from interRel Consulting).

Back to the Top

EMC
Enhance your Applications by Embedding Best of Breed Information Infrastructure Software

Learn how EMC's embeddable technologies can help you meet tough software project deadlines while keeping the development team focused on their core technology. EMC's has many best of breed information infrastructure components that are easily embeddable utilizing open standards including a true Services Oriented Architecture rather than just exposing existing API calls through web services. This overview will include a look at EMC's embeddable software components including Information Rights Management, Content Management, Business Process Management, Scanning and Capture, Federated Search, Archival, XML Database, XML Developers Workbench, and Document Output Management. "

Quest Software
Discover the Hidden Treasures of Toad

As you may know, Toad for Oracle is the de facto standard database development and administration tool used by more than one million database professionals world wide. As a Toad user, you may have been using the tool for many years to improve your productivity, to debug SQL or even to tune your code, but there are things that you may not know Toad can do.