ODTUG 2006 Washington DC 17062006 21062006

1
ODTUG 2006 Washington DC17-06-2006 21-06-2006

• Alex Nuijten

2
Saturday 17-06-2006

• Departure
• Movies
• Firewall
• Flight Plan
• Hoodwinked

3
Wardman Park Marriot Hotel
4
Sunday 18-06-2006

• National Zoo
• Applied Mathematics for Database Professionals
  Toon Koppelaars
• Working on book with Lex de Haan
• Specifying Business Rules using unambiguous
  mathematical notation
• RuleGen
• Speaker and Ambassador Meeting

5
Monday 19-06-2006

• Keynote Marco Tilli
• Core ETL is FREE with Oracle 10gR2
• Keynote Sohaib Abbasi Informatica
• High TellSell Level
• Oracle XML Publisher Whats it all about Mark
  Rittman
• Introduction to XML Publisher
• Rebranded to BI-Publisher

6
Monday 19-06-2006

• SQL Games we can play in PL/SQL Steven
  Feuerstein
• Bulk Operations
• Forall Statements
• Table Functions
• Quest bought QNXO and QUTE
• Tuning Oracle 9i/10g using Statspack Rich
  Niemiec
• Overview of the Statspack Report
• gt140 slides
• Application Development Tuning Best Practices
  Peter Koletzke
• PL/SQL
• Forms
• Java

7
Tips
Break up large UNION or other complex
statements - Put results together yourself with
PL/SQL or Global Temporary Table
Best Tip If you dont like this presentation,
dont come to the other ones I give

• INSERT INTO or UPDATE on large record sets may
  need to process sets
• Again, with PL/SQL
• Commit Frequently (500-1000 rows)
• Or use BULK COLLECT

8
Editors Choice Award

• Andre Beland The Oracle 10g Rules Manager and
  Expression Filter Events for Business Rules
• Lucas Jellema Pretty JavaServer Faces
• Alex Nuijten One Analytic Function can do more
  than a 1000 lines of code
• David Schleis Polishing up your Web
  Applications with AJAX
• Maggie Tompkins Lean Six Sigma Tools and
  Techniques for Software Process Improvement

9
Tuesday 20-06-2006

• The Water is still burning A New quiz on Oracle
  SQL and PL/SQL
• No Cary, were STILL not tuning the right stuff
  Mogens Nørgaard
• I KTTM
• Hash Value in VSQL
• One Analytic Function can do more than a 1000
  lines of Code

• SQL/PLSA Panel Feuerstein Jellema Beumer -
  ?

• SQL/PLSQL Panel Feuerstein Jellema Beumer -
  ?
• Oracle 11g Specification Freeze
• Versioning Objects (24/7)

10
(No Transcript)
11
Wednesday 21-06-2006

• Object Type Evolution. Solved!!! Scott Knutsen
• Google Maps and Oracle HTML DB I. Michael
  Snyder
• www.casetech.net whitepapers and code samples
• Inside the Oracle 10g Cost Based SQL Optimizer
  Donald Burleson
• JDeveloper and ADF for Forms Developers Taking
  it to the next level Grant Ronald
• XQuery in Oracle the new XML Data Language Kim
  Alex Olson
• FLOWR
• Oracle Webforms Productivity with new choices
  Matthieu de Graaf
• Sightseeing

12
White House
13
Washington Memorial
14
Vietnam Memorial
15
Jefferson Memorial
16
Thursday 22-06-2006

• Shopping
• Flying back
• Chicken Little
• King Kong

17
Friday 23-06-2006

• Arrival at Schiphol
• last weekend

18
Proof we were there