Fall 2005 presentation handouts by the following topics:
ODTUG, JAVA/HTML DB, BI/MGMT, DBA

ODTUG

A Hidden Gem: The PL/SQL Web Toolkit
John Jeunnette, Prairie Systems Group, Ltd.
This presentation describes the PL/SQL Web Toolkit components and includes practical tips and techniques for experienced PL/SQL programmers to take advantage of the PL/SQL Web Toolkit to develop robust, scalable web-based applications.

Data Modeling Using the UML
Paul Dorsey, Dulcian, Inc.
This presentation will familiarize attendees with the fundamentals of UML class diagrams and show how UML class diagrams can be translated into a relational database. The pros and cons of three different products providing translation mechanisms from the UML to a relational database will be discussed.

Ultra High-Performance SQL and PL/SQL in Batch Processing
Paul Dorsey, Dulcian, Inc.
You have ten million logical objects spread across 100 million rows in the database that have to be processed in under 2 hours. The processing will require an additional 20-30 million records to be created and inserted into the database. Your Java team tried to build the application in the middle tier and crashed and burned. You tried writing standard PL/SQL and the routine takes two days to execute. What do you do now? This presentation will explain how fast you can perform various operations in SQL and PL/SQL when throughput is the top priority. There are several surprises in this talk: 1) Cursor FOR LOOPS should be avoided, 2) Memory structures (such as object collections and VARRAYS) are slower than physical tables, and 3) “create table as select” works much better than imagined.

Improving Analysis Techniques From Active Listening To Body Language
Maggie Tompkins, Defense Finance and Accounting Service
An entertaining and fun look at seriously improving analysis techniques. Improve the business interviewing process by incorporating non-traditional techniques into the interview. Attendees will learn to use active listening skills to better understand what is said and non-verbal body language to understand what is not being said. Lots of fun! Prizes and surprises!!

Oracle JDeveloper 10g for Database Developers and DBAs
Sue Harper, Oracle Corporation
Oracle JDeveloper 10g offers support to database developers, DBAs, and application developers alike. This presentation will explore online and off line database development using JDeveloper 10g. Online support includes creating database objects, editing and compiling PL/SQL code, running and debugging PL/SQL code, running and debugging PL/SQL-and Java-stored procedures and more, while off-line features also include database modeling.

XML: What's in It for Me? Handouts not available
Greg Matus, Maverick Solutions, Inc.
XML has been touted as "the language of the internet" and has become an important ingredient in enterprise-level web applications. With the latest releases of Oracle and JDeveloper, Oracle has significantly increased its support of XML. This presentation will explain what XML is, and what all the fuss is about.

XML Support in 10g: JDeveloper and Oracle Handouts not available
Greg Matus, Maverick Solutions, Inc.
One of the most interesting new features of Oracle9i is its support for XML. From Oracle's new XML column datatype and built-in XML parser to newfound XML support in JDeveloper 9i, find out the ways Oracle has significantly increased its integration with XML.

Introduction to Oracle Forms
John Jeunnette, Prairie Systems Group, Ltd.
Forms 101: a brief introduction to application development using Oracle Forms.

Back to top

JAVA/HTML DB

How To Get Donald And Martha To Communicate: Employ A Service-Oriented Apprentice (I mean, Architecture)
Eric Cohen, CASEtech, Inc.
Learn what a Service-Oriented Architecture (SOA) is, and how it relates to those of us who are used to writing programs in an Oracle Database. You will learn the principles of web services, protocols, and other terminology. More importantly, we will walk through an example of how to take an existing Oracle application and make parts of it available to other applications through an SOA. By being accessible to other parts of the business, your applications will never hear the words "You just don't fit in."

A Hierarchical File System for PL/SQL
David Bibeau, Dartmouth College
One of the weaknesses of PL/SQL has always been access to some kind of file storage. The built-in UTL_FILE package tries to address this need, but has many restrictions and disadvantages. Our approach was to build a hierarchical file system directly inside the database using tables and PL/SQL. The system uses unstructured LOB storage to contain text and binary data. A hierarchical directory structure is maintained in table meta-data; querying is done using the CONNECT_BY syntax. Security access is enforced per user, or by role. A web-based File Explorer is built on the Oracle web toolkit. And it's all built in PL/SQL and available as open source (there is a Java command line client available for bulk loading and unloading). Even if you don't need such a system, you may learn some new things about LOBs, PL/SQL, Java and SQL, and just how far you can take PL/SQL.

Oracle JDeveloper 10g Overview
Sue Harper, Oracle Corporation
This presentation provides an overview of Oracle JDeveloper 10g and discusses how to build J2EE applications and services, as well as how to debug and deploy applications on any J2EE application server such as Oracle Application Server, JBoss, or BEA WebLogic. This presentation highlights the new Oracle Application Development Framework. The future of Java is all about making J2EE development more productive and accessible to a broader population of developers and this presentation shows how the new oracle JDeveloper 10g, with its built-in Oracle Application Development Framework, takes J2EE productivity to the next level.

What is SOA, and Why Should I Care?
Ken Stewart, Software AG
In recent years, Service-Oriented Architecture or SOA has become a hot topic. In this session, you'll learn why it's such a big deal, what it means to you and our organization, and how to get there.

HTML DB 2.0 Jumpstart
Bonnie Vermillion, LMI Government Consulting
HTML DB is an Oracle database add-on component and is a powerful tool to build, access and run database objects and scripts in addition to being a great web tool for building web applications that access data in the Oracle database. HTML DB has many uses and, as a free add on component to the Oracle database that runs in a browser, its value is growing tremendously.

Integrating Oracle HTML DB & Oracle E-Business Suite
Scott Spendolini, Sumner Technologies
The Oracle E-Business Suite is a large, powerful set of applications. Despite its wide range of functionality, sometimes your requirements just can’t be met by it. Thus, you’re forced to either customize the eBusiness Suite or write another non-integrated one-off application from scratch, costing you both time and money. There has to be a better way! With Oracle HTML DB, you can solve both of these problems at once. Oracle HTML DB allows you to quickly create one-off applications that integrate into the eBusiness Suite’s Portal and security model. This session will outline the steps required in order to do just that. It will also discuss some examples of the types of Oracle HTML DB applications customers are using with the E-Business Suite.

Developing Web Applications with Oracle ADF and ADF Faces
Rick Wang, LMI Government Consulting
Oracle ADF, Application Development Framework, is a very powerful and flexible framework. It can be used to develop Web, Wireless, or Rich Client applications. Oracle ADF Faces is providing a very rich set of components for Web application development. This presentation will give a brief introduction about Oracle ADF and ADF Faces. Then, the tips and tricks of using ADF and ADF Faces will be shared.

Google Maps and Oracle HTML DB
I. Michael Snyder, CASEtech, Inc.
The Google Maps API lets developers embed Google Maps in their own web pages with JavaScript. You can add overlays to the map (including markers and polylines) and display shadowed "info windows" just like Google Maps. This presentation will show you how you can take advantage of Google Maps in an Oracle HTML DB environment. This session will show you some basics on how to use the Google Maps API; resources for getting further assistance; and techniques for using the API in Oracle HTML DB. There will be a live demonstration and an under-the-covers look at a sample Google Maps API implementation.

Back to top


BI/MGMT

Oracle Business Intelligence Discoverer 10g: How to Add the OLAP Option Handouts not available
Alfred Adams, Avanco International
OracleBI Discoverer for OLAP, together with the OLAP Option for Oracle Database 10g Enterprise Edition, provides the ability to create and query multidimensional data models within Oracle Database. This presentation will provide explanation of the benefits/advantages of adding the Oracle Database Enterprise Edition OLAP Option to your OracleBI Discoverer reporting and analysis. A description of the steps required to make OLAP reporting available to end users will also be provided for OracleBI Discoverer administrators and developers.

Software As A Service
Dale Lowery, CASEtech, Inc.
Buy versus rent? A simplistic catch phrase such as this is not really adequate for the next wave of decision-making issues in the computing world, but it catches the essence. Years ago we “bought iron” to build glass house installations based on big, shiny machines. Then the paradigm shifted to the desktop with the PC revolution, GUI, and Windows interfaces. After the PC, the internet was the next altering of our basic assumptions about what IT consists of. Our next change is barely evolutionary by contrast. We are about to leave the world of buying software and supplementing it with online services. From here forward we subscribe to services. Are you ready? Are you ready for this?

Oracle Fusion Middleware: Oracle Application Server 10g Release 2 - New Features Overview
Ruth Delaney, Oracle Corporation
This session will provide an overview of the new features in Oracle Application Server and Developer Suite Release 10.1.2 and 10.1.3, part of the Oracle Fusion Middleware family. The presentation will highlight capabilities as an SOA platform; new features for Java, Web Services, and Forms developers; Enterprise Portals; Business Integration; Business Intelligence; and Identity Management. Attendees will also learn how Oracle Application Server 10.1.2 can be deployed and managed in a grid computing environment. Using customer examples and demonstrations, this session will explain how to best use Application Server 10g Release 2 with the Oracle Database.

Data Warehouse for OLTP Developers
Leslie Tierstein, newScale, Inc.
Logical and physical data modeling for a data mart or data warehouse require a set of skills that intersect with those generally used by OLTP data modelers. What skills carry over from one realm to the other? What do OLTP modelers need to "unlearn" to be proficient data mart designers? And what new skill sets are required? Logical data mart design builds on some principles of normalized database design but requires practitioners to contradict others. On the physical design level, the developer needs extensive database tuning and configuration expertise to build a data mart that performs adequately.

Dispelling Myths and Creating Legends for Your Data Warehouse and E-Biz Intelligence Environment
Jeffrey Bertman, DataBase Intelligence Group (DBIG)
Dr. Ronald Pan, Senior Oracle DBA
The data warehousing industry in particular is cluttered with a barrage of valuable options clouded by myths, once-truths, and semi-untruths which can easily lead us astray in very costly ways, often to the tune of millions of dollars. To set and maintain a successful course for our decision support project, we need to make appropriate choices for each particular environment and plan around potential traps and pitfalls. This presentation arms you with a multitude of facts, figures, and templates to identify and prevent common pitfalls and traps from impeding your data warehouse projects. Critical terminology and in-depth architectural options are covered, along with specific procedures to springboard your team through a successful data warehouse implementation. Special attention is raised for E-Business Intelligence environments. Attendees will also receive a comprehensive project plan template which incorporates industry standards and best practices along with hard-learned lessons.

Standards and Measures of Quality!
Maggie Tompkins, Defense Finance and Accounting Service
The judicious use of standards on applications in the Oracle Repository can easily make the difference between an application that succeeds and one that fails. You can develop it faster, better, and cheaper! You must know where and how to apply standards judiciously to get much faster development and much improved quality.

Using, ColdFusion, Flash, SAS, Excel and Access with Oracle
Michael Fox and Alla Guseynova, Johns Hopkins University
We are the Research Information Technology Systems (RITS) at the Johns Hopkins University Oncology Center, using Oracle versions 8i and 9i. All of our applications are designed and programmed in house, and run on an IIS web server. This allows us, with a small staff, to support any client workstation which has a browser. Our tools of choice for building applications are ColdFusion MX and Flash. ColdFusion and Flash support both native and ODBC connections to Oracle. We run SAS directly against the Oracle database for statistical analysis and produce HTML output for several applications. We also use other ODBC compliant software, such as MS-Excel and MS-Access, to download and upload data into Oracle. MS-Access is used to link live Oracle data to local and network applications built by non-RITS colleagues. These will be explained and demonstrated in our presentation.

SQL What? What Do You Mean I Have to Work with an SQL Server?
Chris Grabowy, Lockheed Martin
The participant will learn some basic SQL Server database administration skills from the Oracle DBA’s perspective. The DBA tasks are actually demonstrated live during the presentation. Participants will walk away with a hardcopy of the presentation that has the steps for each of the SQL Server DBA tasks.

Back to top

DBA

High Availability and Disaster Recovery—Oracle 10g and 9i Advanced Features versus the Competition
Jeffrey Bertman, DataBase Intelligence Group (DBIG)
Establishing a business continuity (BC) framework is crucial for most organizations, and a necessity for 24x7 mission critical OLTP and business critical decision support databases. This presentation elaborates on the two major aspects of business continuity: High Availability (HA) and Disaster Recovery (DR). The primary focus is at the database applications level, including coverage of fringe technologies such as server, network, and disk storage. A multitude of comparison information and detailed best practices are conveyed for leveraging Oracle-specific and third party offerings. Innovations are presented, including when it is valuable to combine or complement technologies for maximum benefit. Business continuance requirements along with measurable goals and metrics are explained and quantified in meaningful terms, to help evaluate appropriate solutions for various environments. Real world planned and unplanned outage scenarios are cross-referenced to specific architectures to better understand and validate suitability of different HA/DR solutions.

A Discussion and Demonstration of 10g Flashback Technology
Erik Cohen, Science Applications International Corporation
Using the Flashback Database feature, you can turn back your entire Oracle database to the state it was in at a past point in time, expedited faster than traditional recovery techniques. We will discuss the benefits and limitations of this feature of the 10g database. Using the Flashback Drop feature, you can now reverse a DROP TABLE command. We will discuss this and the 10g recycle bin. The Flashback Versions Query will also be reviewed. This is technology that was introduced in 9i, but is relevant to this presentation. Flashback Transaction Query is a tool that you can use to view changes made to the database at the transaction level. This allows the user to determine errors and recover to previous points in time by using this and the Flashback Versions Query. Flashback Table can be used to recover a table or tables to a specific point in time without using traditional physical or logical methods of recovery.

OEM/ Grid Control
Ralph Massanova, Oracle Corporation
The latest release of Oracle Enterprise Manager Grid Control presents a dramatic architectural departure from the previous releases, incorporating a portable browser- based interface to the management console and Oracle’s application server technology to serve as the middle-tier Management Service (OMS). The foundation of the tool remains rooted in database server technology to manage the repository and historical data.

Oracle 10g New Features Handouts not available
Steven Wadsworth, Oracle Corporation
Oracle Database 10g is the technology leader in today's RDBMS market. Learn how Oracle Database 10g Release 2 is the first database designed for grid computing. Find out how to lower costs with the first self-managing database. Come see why 10g is the industry leader in security. Finally, find out how to easily build an application using HTML DB.

Lets Take a Look at the Intricacies of the Outer Join SQL Operation
Kalman Zilberman
Most definitions of the Outer Join operation are misleadingly simple, lacking a key element essential to understanding its functionality that often leads to coding errors. This presentation will clarify the aforementioned issue by taking the ambiguity out of the Outer Join definition and will compare the original as well the new Oracle9i SQL Outer Join syntax and implementation. It will also show how a proper understanding of the Outer Join operation helps in developing correct code and eliminates unexpected results.

Kick Up Your Data Load and Data Extract Jobs a Notch!
Mary Wagner, Delaware Department of Transportation
Are you still using utl_file_dir and OS utilities for data load and extract jobs? If your database is Oracle9i or 10g, there's a better way-do it all in the database with directory objects, external tables, and PL/SQL! This session will cover using the new 9i/10g features of directory objects and external tables, with PL/SQL to complete all of the steps of a data load and a data extract job from within an Oracle database. There will be a data load and a data extract example covered. The data load example will cover a PL/SQL solution to get a file from a remote server, ftp it to a local database server, then read the file and load it into a database table. The data extract example will cover a PL/SQL solution to extract data to a file on a local database server and ftp the extracted file to a remote server.

Enterprise Code Tables
John Flack, Synectics for Management Decisions, Inc
This presentation will explore various code table structures, from the simple code/description table, to complex hierarchical tables optimized for enterprise wide use. The author makes suggestions about how code tables should be structured, how they should be administered, and how they should be maintained and by whom. Special emphasis is given to shared code tables meant to be used by more than one application system.

Building Oracle 10g RAC Cluster in a Single PC
Shaojing Guo, The Washington Post
For the DBAs who are interested in Oracle's 10g RAC but could not find a test environment, this presentation will cover how to create a Oracle 10g RAC cluster in a single PC using downloadable software. Started with SUSE SELS8 virtual server installation, this session will also includes disk partition layout, database creation on each nodes, setting up Transparent Application Failover (TAF) and testing RAC. This presentation is not for the experienced RAC DBA.

Back to top