PRESENTATIONS BY ODTUG EXPERTS
Monday, September 22 - Thursday, September 25

ODTUG will be presenting six technical sessions at Oracle OpenWorld and seventeen sessions at the Develop Conference. Times and location are subject to change. Plan your itinerary with Oracle's Schedule Builder.

                                          

Oracle Develop Sessions

Oracle Develop is a separate developer program at Oracle OpenWorld 2008 offered on Sunday though Tuesday at the San Francisco Marriott.  Hear and learn from world-leading experts including ODTUG speakers (17 presentations) about next-generation development trends and technologies for service-oriented architecture (SOA), Extreme Transaction Processing (XTP), virtualization, and Web 2.0.  Advance your skills and expand your knowledge in scores of expert-led, in-depth technical sessions and advanced how-tos on Java, .Net, XML, SCA, PL/SQL, Ajax, PHP, Spring, Groovy on Rails, and more. And roll up your sleeves for in-depth, hands-on labs covering the very latest development technologies including database, SOA, Complex Event Processing (CEP), Java, and .NET.

Check out these presentations from ODTUG experts.

Sunday, September 21
10:30-11:30
Marriott Golden Gate C3
XMLDB: Building Blocks and Best Practices
Marco Gralike, AMIS

Over the last few years Oracle fully implemented almost every W3C standard (such as XSD, XSLT, and XQuery etc.). The scope of functionality is overwhelming. So where do you start? What will your design be and will this perform? Should one use CLOB, Object Relational or Binary storage; using schema less or schema based storage; would using an XMLIndex be appropriate or an Equi-Partitioned XMLType Nested Table? When should you want to use XML DB in the first place? This presentation will guide you through these first, essential, steps.


Sunday, September 21
11:45 – 12:45
Marriott Golden Gate C3
Jumping The GAPP
Gerwin Hendriksen, AMIS

The presentation will demonstrate how business processes, from frontend to backend can be profiled on high level, by a new developed method called “GAPP”. The method makes it possible to get a high level profiling of a business process without actual change in the business process code, or start any tracing. The method is based on data mining and uses this in a very spectacular way. The data mining is done on already available data like CPU and I/O metrics, but also other metrics can be used. The power of the method is astonishing.


Sunday, September 21
1:15 – 2:15
Marriott Salon 06
Oracle 11g/10g Developers: What You Need to Know
John King, King Training Resources

Features of Oracle11g/10g impacting application development will be discussed. Emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, Regular Expressions, virtual columns, Binary XMLType, XML indexing, SQL PIVOT/UNPIVOT, JDBC improvements, PL/SQL enhancements, PL/SQL compiler, trigger improvements, PL/SQL Result Cache, case/accent-insensitive query,  expanded LOBs, new data types, Model clause, and the recycle bin.


Sunday, September 21
2:30 – 3:30
Marriott Golden Gate C3
JDeveloper with ADF and the Fusion Stack—Is It Oracle Forms Developer Yet?
Peter Koletzke, Quovera

JDeveloper provides a development method, using the Application Development Framework (ADF), and a set of technologies, the Fusion Stack (ADF Business Components and ADF Faces), which greatly simplify Java development tasks. This presentation describes ADF and the Fusion Stack. It explains and demonstrates ADF and the JDeveloper tools you can use to build Java EE web applications. Finally, the presentation offers insight about whether you can achieve the productivity of an Oracle Forms environment using ADF and the Fusion Stack.


Sunday, September 21
2:30 – 3:30
Marriott Salon 06
Oracle Fusion Middleware: A Set of Tools for Your Enterprise
Eric Marcoux, Université Laval

Fusion Middleware can secure your enterprise, create a service bus to exchange data/services between Oracle apps and existing systems, create workflows, manage documents in a central repository, provide availability to Oracle apps, create/manage reports, and use a Microsoft.NET environment to create Web apps. Products/best practices will be highlighted. Discover how Fusion Middleware can help integrate Siebel and eBusiness Suite into existing systems. Learn how to implement SOA with event driven architecture. A customer case study will be used.


Sunday, September 21
3:45 – 4:45
Marriott Salon 06
APEX Hints, Tips and Best Practices
John Scott, Apex Evangelists

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.


Sunday, September 21
3:45 – 4:45
Marriott Salon 10/11
Weird PL/SQL
Steven Feuerstein, Quest Software

You probably think that PL/SQL is 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.


Monday, September 22
11:30 – 12:30
Marriott Salon 03
Creating Advanced Charts in Oracle Application Express
Dimitri Gielis, Apex Evangelists

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!


Tuesday, September 22
11:30 – 12:30 Marriott Salon 02
Thick Database Techniques for Fusion (and Other) Web Developers
Paul Dorsey, Dulcian

The benefits of the "Thick Database" approach have been discussed extensively in the last year. What is missing is information about how to implement this approach in real world projects. This presentation will provide a brief overview of the benefits of this approach and then discuss specific details about how to implement in SQL and PL/SQL with emphasis on collections and dynamic SQL/PL/SQL. The presentation will cover server-side support for stateless programming. This presentation is targeted at experienced PL/SQL developers.


Monday, September 22
2:30 – 3:30
Marriott Salon 02
Did We Spoil the End User? Building Personalization into JavaServer Faces Technology-Based Applications
Lucas Jellema, AMIS

Your ADF application will be used in dozens of organizations by hundreds of users. But there is only a single, hosted instance of the application. How can you build dynamic customization and personalization into your application – that will make it look and act special for every individual user? This includes specialized resource bundles, custom properties, personal notes attached to data records, personal styling and user preferences.


Monday, September 22
1:00 – 2:00
Marriott Salon 02
Break Your Addiction to SQL!
Steven Feuerstein, Quest Software

Oracle PL/SQL makes writing SQL so darned easy – in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? Developers become addicted to writing SQL. Learn in this presentation what's so bad about writing SQL and how you should change your very naughty ways.


Monday, September 22
4:00 – 5:00
Marriott Salon 02
Birds Do It: Using Fusion ADF to Migrate Forms to Java EE Web, A Case Study
Peter Koletzke, Quovera

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”). The presentation discusses why Fusion development technologies—ADF Faces, UIX, and ADF Business Components—were selected. It also describes why thick database techniques were used for business rules logic and user interface support. Finally, it relates successes and lessons learned in the realms of technology and staff.


Monday, September 22
5:30 – 6:30
Marriott Salon 02
Introduction to Java-PL/SQL Developers Take Heart
Peter Koletzke, Quovera

Java may be in your future. However, if you know PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. It provides an overview of the language; reviews the concepts of object orientation; and describes the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables.


Monday, September 22
5:30 – 6:30
Marriott Salon 14/15
You Can't do THAT in a Browser – Version 2!  Extending Oracle APEX with 3rd Party Components
Scott Spendolini, Sumner Technologies

While APEX offers a robust set of features, it doesn’t address all possible scenarios that you may encounter developing your applications. Fortunately, its easy to use a number of 3rd party tools to enhance and/or supplement APEX's functionality. This presentation will demonstrate and discuss how to use APEX to create contacts and appointments in Outlook; how to create a dynamic DHTML-based tree; how to create and manage a Gantt chart; how to display your data on a map using FusionMaps; and how to use PL/PDF to quickly create PDF documents.


Tuesday, September 23
11:30 – 12:30
Marriott Salon 12/13
Why You Should Care about Oracle 11g PL/SQL Now!
Steven Feuerstein, Quest Software  

So Oracle has come out with another version. You probably won't be using it for years, so why should you bother learning about what's new in Oracle11g PL/SQL now? A very reasonable question, and the answer is: because once you understand what will be possible in Oracle11g, it will change the way you write your code now! This session will offer an overview of the most exciting new features for PL/SQL in Oracle 11g and prove to you beyond the shadow of a doubt that you should be designing your code at this moment to get ready for that version.


Tuesday, September 23
1:00 – 2:00
Marriott Salon 02
Oracle Forms as JSF Components, Enabling Gradual Migration
Wilfred van der Deijl, Eurotransplant 
This session will demonstrate how easy it is to fully integrate an existing Forms application into a JSF Web application. With the right JSF component library, it's a matter of drag-and-drop. A lot of Forms users have been craving this over the last couple of years. Now it's here and you have to see it to believe it. The OTN featured technology allows for a gradual migration replacing Oracle Forms with JSF pages one-at-a-time. It can also be used to integrate Oracle Forms in Oracle Portal, Oracle WebCenter, PHP, or any other web technology.


Tuesday, September 23
2:30 – 3:30
Marriott Salon 02
The Power of the Oracle APEX Repository
Patrick Wolf, Sphinx IT Consulting
One of the advantages of Oracle Application Express (APEX) is that it stores the application's meta data in a repository in the database. There is a well documented read-only view layer to access this information. Examples will demonstrate the wide range of possibilities you get by reusing this information for QA checks, documentation, monitoring and generic code you can write for your application. The second part of the presentation covers how you can safely directly manipulate the repository to do mass updates on your application's meta data.

Back to Top


                           

Oracle OpenWorld Sessions

Times and location are subject to change. Plan your itinerary with Oracle's Schedule Builder.

Monday, September 22
2:30 – 3:30
Moscone West Room 3008
Automating Business Decisions using Oracle Real Time Decisions
Mark Rittman, Rittman Mead Consulting

In this session, we look at how Oracle Real-Time Decisions can used to create a self-learning, predictive decision engine that can be used to automate a range of business decisions. We see how a project is constructed, how RTD concepts are applied to the scenarios, how RTD leverages data mining and predictive modeling techniques, and how RTD functionality is then incorporated into your Java business applications and BPEL business processes.


Tuesday, September 23
9:00 – 10:00
Moscone West Room 3008
Data Modeling Techniques Using Oracle BI Server
Mark Rittman, Rittman Mead Consulting

In this presentation, we look at techniques to transform disparate normalized application data into the single logical star schema required by Oracle Business Intelligence Server. We examine data modeling situations such as ragged hierarchies, slowly-changing dimensions, joining facts of differing granularity, incorporating historic and real-time data, and look at how you can extend the pre-defined warehouse that comes with Oracle BI Applications as an alternative to creating your own data warehouse from scratch.


Wednesday, September 24
1:00 – 2:00
Moscone West Room 3024
Essbase Tuning: Optimizing Outline
Edward Roske, interRel Consulting

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.


Wednesday, September 24
5:00 – 6:00
Moscone West 3024
Exploring the Essbase Java API
Tim Tow, Applied OLAP, Inc

This session will cover the Essbase Java API. Topics that will be discussed include architecture, scope of functionality available in the Java API, and 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.


Thursday, September 25
10:30 – 11:30
Moscone South Room 302
Database Implications of Creating StateFULL or StateLESS Applications
Michael Rosenblum, Dulcian

It is easy to define an application as either “statefull” or “stateless.” In some environments, it is simply a matter of checking a checkbox. However, it is very difficult to make the appropriate selection without a complete understanding of what each option actually entails from a database point of view. This presentation will explain the differences between “statefull” and “stateless” applications, what choices should be considered when making the decision about which to use, and existing best practices.


Thursday, September 25
1:30 – 2:30
Moscone West 3024
Tips, Tricks and Best Practices for Hyperion Planning
Edward Roske, interRel Consulting

This session will show how to work more efficiently with your Planning implementation, impressing both users and management. You will learn how to get the most out of Planning functionality and how to best optimize and manage your application. We will also step away from the technology-side of things for a bit & discuss strategic issues and best practices to consider in developing your budgeting & forecasting process.