IOUW95 Abstracts (Long version!)
Date: 1995/07/06
Message-ID: <3tho93$7uq_at_newsserver.trl.OZ.AU>
For your information.
Abstract: 1 Title: Managing Data Replication in Oracle7 Author: Kevin Loney, Astra/Merck
This presentation will explain the differences in the data replication options found in Oracle7. Understanding the different processes and objectives involved in Oracle's varying implementation of snapshots enables the user to choose the best option for specific needs. Referential integrity enforcement across snapshots, the performance of simple as opposed to complex snapshots, job scheduling, and the "unrecoverable" operations in 7.2 should all be considered when choosing among replication options.
Abstract: 2 Title: Evaluating Windows-Based Development Tools for an Oracle7 Environment Author: Earl Shaffer, Barron Collier Company
During the last two years, products such as Smalltalk, PowerBuilder, Gupta, and Visual Basic have emerged as viable competitors to Oracle's Forms/Menu/ReportWriter products, and Oracle development shops have begun to evaluate the new CDE tools. This presentation will suggest an evaluation methodology. Attendees will learn how to compare available products so that they can choose the best tools for their environments.
Abstract: 3
Title: New Dimensions in Relational Database Technology for Spatial Data
Management
Author: Catharine Kristian, Oracle Corporation
This presentation will address Oracle MultiDimension, a powerful extension to the Oracle7 Relational Database Management System (RDBMS), which breaks new ground in managing multidimensional, or spatial, data. By adding a new generic data type, extending SQL functionality, and providing an elegant methodology to operate on and maintain dimensional data, Oracle MultiDimension solves two critical problems: how to store, access, and manage conceptually different types of data in a single database simply and efficiently, and how to improve performance for very large spatial databases holding hundreds of gigabytes -- even terabytes -- of multidimensional data.
Abstract: 4 Title: Using ODBC? Better Know More Than What the Acronym Means! Author: John Molinaro
Open Database Connectivity (ODBC) is an emerging database access method which connects applications popular among PC users to a variety of data sources or databases. Such applications require ODBC drivers to link to a database. This presentation will examine successful and unsuccessful uses of ODBC in accessing Oracle databases, and will provide an overview of ODBC features, functional limitations, and differences among ODBC drivers. Attendees will learn how to avoid potential pitfalls and how to select ODBC drivers that will meet their requirements.
Abstract: 5 Title: INITWHAT.ORA?? Author: Michael Abbey Carl Dudley, Staffordshire University
The content of INIT.ORA has remained basically the same for years. Oracle7 introduces a new suite of tunable parameters, and Oracle has removed the DBA-tuning capabilities from the dictionary cache. This presentation will address such details of parameter entry tuning as shared pool, DB_BLOCK_BUFFERS, LOG_CHECKPOINT_INTERVAL, PROCESSES, SESSIONS, DML_LOCKS, DDL_LOCKS, and how these parameters affect performance, the size of the data cache, the number of users that may access the database concurrently, and the effect INIT.ORA entries have on recovery and checkpoints. The presentation will stress the importance of SHARED_POOL_SIZE, and will guide the attendee through some shared SQL sizing exercises. INIT.ORA does not have to be the single most confusing file DBAs ever encounter. Tuning and efficient resource allocation through INIT.ORA are attainable.
Abstract: 6 Title: How Sweet It Is: MicroSoft Access and Oracle Author: Bradley D. Brown, The Ultimate Software Consultants (TUSC)
Typing SELECT statement after SELECT statement to analyze the data in a database can be an awkward operation. Access is an excellent tool for analyzing data because an entire table can be set out as though it were a spreadsheet. This presentation will demonstrate how to set up Microsoft's ODBC and Access to retrieve information from Oracle tables. It will be an on-line presentation, which will demonstrate Access tables, queries, forms, reports, and modules. After linking ODBC to an Oracle database, the presenter will attach to multiple Oracle tables and create a query against them, and will demonstrate Access Wizard.
Abstract: 7 Title: Performance, Event Management, and Security of Oracle Applications Author: Richard Barker, Open*Vision
Applications using Oracle RDBMs are often found in the systems that run businesses. It is essential that such systems perform well, and that they are available, secure, and recoverable. As applications are disseminated among hundreds or thousands of users, possibly across a heterogeneous network, it is vital that automatic managing tools are constantly on the watch to detect and correct problems, or to alert central operators to them. This presentation will demonstrate how an integrated event manager and performance/trend tools minimize problems and optimize performance. It will explain how to make special extensions to cover both Oracle7, Oracle packages, and users' own applications, making them event and performance-aware. Focusing on the industry standard GSS API, the presenter will address security capabilities and will show how access to applications can be limited to authorized personnel. The presentation will also explore defragmentation, archiving, and network backup to modem robotics devices for Oracle databases, to help optimize performance and storage utilization.
Abstract: 8 Title: Unobtrusive Audit Trails Author: Christopher H. Hamilton
Every database includes crucial information that should be protected with an audit trail, a detailed record of database actions performed on each piece of data. This presentation introduces a flexible and unobtrusive audit trail method which is handled entirely by a few ORACLE7 database triggers and stored procedures. It can be implemented at table creation time or later, and, because of its transparent operation, forms developers and end users need not be concerned about it. The triggers provide detailed tracking of inserts, updates, and deletions on a table, row and column level, including pre-change and post-change column values, and manual reconstruction of deleted rows. The presentation will detail all of the steps required for implementing the audit trail -- example code and scripts for extracting existing trigger and procedure definitions from the database, database overhead, performance tips, and other "gotchas" will be discussed, as will options for reporting and implementing more limited auditing. The system evolved from a SQL*Forms/Oracle 6.O audit system to the present ORACLE7 RDBMS-only code. The presenter is currently using it on a mission-critical research laboratory database.
Abstract: 9 Title: EMail-Enabled Database Applications Author: Anthony Fong, Banyan Systems, Inc.
This presentation will address the emerging class of Email-enabled database applications which promises better automation and streamlining of traditional business processes, and which may accelerate Client/Server computing and corporate downsizing. It will review the theory, roots, and issues surrounding the implementation of Email-enabled database applications, particularly workflow applications and applications without database integration, and will discuss the details of architecture, development, tools, database definition, and rules definition. A case study and demonstration will be included.
Abstract: 10 Title: Techniques for Fast Database Reorganization Author: Nick Strange, Churchill Insurance
This presentation will summarize techniques applied to a 50 gigabyte database
with 600 high OLTP users. The presenter will describe established techniques,
(maximizing machines' resources with parallel processing; using large redo
logs; Single Task Export/Import; reducing the effect of BLOCK CLEAN OUT; and
setting correct values for SORT_AREA_SIZE), and recently-developed techniques,
(maximizing the advantages of CREATE TABLE SELECT * FROM...; understanding why
imports generate Rollback Segment entries; calculating exact rollback segment
size; quickly moving a large database to another machine; and generating a 60
gigabyte database in less than an hour). The presentation will also examine
Oracle 7.1, (Parallel Index Build), why disk striping should be considered, and,
with reference to Oracle 7.2, whether the UNRECOVERABLE create options should be
used.
Abstract: 11 Title: Object Orientation in Oracle Forms 4.5 Author: Ben Wright, Oracle Corporation
Oracle Forms 4.5 includes many improvements in productivity, usability, and maintainability. Many of these enhancements are a natural extension of the new object-oriented programming facilities that are integral to the development environment within Oracle Forms 4.5. Oracle Forms has always incorporated some object-oriented technology, and the new 4.5 release has exposed and improved a significant amount of new functionality which augments and extends these features. This presentation will demonstrate how the Oracle Forms Development Team has implemented and exposed these features to provide maximum productivity gains and the ability to solve business problems quickly.
Abstract: 12 Title: New Features in Oracle Forms 5.0 Author: Ben Wright, Oracle Corporation
Oracle Forms 4.5 has set the standard for rapid, feature-rich, high-quality, scalable application development. This presentation will address the new concepts and functionality which will improve and extend this best-of-breed development environment in Oracle Forms 5.0: improved performance, extended object orientation, embellished MS Windows integration, new Apple Mac functionality, enhanced usability and productivity, and increased GUI control. Oracle Forms 5.0's new features will allow developers to become even more productive, to produce even more consistent, functional applications, and to integrate even more closely with their environments.
Abstract: 13 Title: PL/SQL Packages: the Mystery and the Magic Author: Steven Feuerstein, SSC, Inc.
This presentation will review the basic components and features of packages, and
will extend those basics to show developers how to apply packages in their
day-to-day work. Attendees will learn how to implement global data in packages,
to distinguish between local, package, and global data, to overload modules
(create multiple modules with the same name), to construct abstract data types,
and to improve significantly the modularization of their applications. The
presentation will explore how to use packages to make immediate improvements in
developing CDE applications and stored programs, and will feature
fully-developed examples of packages that illustrate the power of the package
construct.
Abstract: 14 Title: Public Access to Information Using Oracle Forms, TextServer3 and World Wide Web Author: Gerald C. Horel, Ministry of Environment Lands and Parks
Many government agencies are required to provide technical, training, and extension information to the public. Oracle TextServer3, integrated with a World Wide Web server, provides an effective vehicle for providing such access. This presentation will discuss the methodology used to implement the Integrated Pest Management Information System, an electronic reference and information library about pest management product suppliers. The library is maintained with an Oracle Forms 4.0 application on an Oracle7 database. Public access to the data is provided by the Web. The actual text information is indexed with Oracle TextServer3. This successful project was one of the first implementations of TextServer3 technology.
Abstract: 15 Title: Partitioning Client/Server Applications Using Oracle Forms 4.x Author: Gerald C. Horel, Ministry of Environment Lands and Parks
Partitioning is a key issue in developing Client/Server applications. This presentation will detail Oracle Forms 4.x coding techniques that facilitate partitioning, and will examine issues surrounding Client/Server partitioning, the reasons for partitioning, and a partitioning methodology.
Abstract: 16 Title: CDE2 Workflow Integration Library: Using Workflow Routing as a Network Service Author: Maumzio Gianola, Recognition International (PLEXUS)
With the new workflow integration library for CDE2, a developer can readily call a workflow engine. The library contains functions to initiate work transactions, route work items, notify users of pending transactions, and administer the system. In turn, the workflow engine guarantees efficient and instantaneous routing of transactions. It can automate an entire business process, including all steps external to an Oracle application. Most important, the workflow engine is completely flexible. Routing can be changed dynamically through an interactive graphical mapping module, eliminating the need to change hard-coded programs. This presentation demonstrates how the use of workflow routing leads to faster implementation of projects, greater flexibility in workflow, and lower maintenance costs.
Abstract: 17 Title: Developing Oracle Forms 4.0 for Character and GUI Environments Author: Billy Rawles
This presentation will address the issues involved in developing an application to run in GUI and character modes and will explore the problems associated with using GUI features in a character environment. The use of buttons, check boxes, radio groups, and pop lists, and how they are implemented in a character mode, will be discussed. The presenter will share tips, suggest approaches to handling GUI and character differences, and discuss standards and implementation strategy.
Abstract: 18 Title: Installing Oracle7 on UNIX Platforms Author: Shahriar Kent Ghadishah, Oracle Corporation
Oracle 7.0 was the first Oracle release to feature an interactive, menu-driven installer. While the installer affords the user great flexibility, its complexity can create problems for both new and experienced administrators. This presentation will provide general guidelines for Oracle7 installations, including the installation procedure for tape and CD-ROM media. It will provide examples for various platforms and will describe Oracle installer options and their functions. Attendees will be alerted to some of the pitfalls and user errors common to Oracle7 installations.
Abstract: 19 Title: Monitoring and Managing the Shared Pool Author: Desmond Leverton
Oracle documentation describes the shared pool as "a portion of the SGA which contains shared memory construct", such as shared SQL areas, (within the library cache), and the Data Dictionary cache. Nowhere in the documentation is the actual physical structure of the shared pool discussed. This presentation will examine how Oracle allocates and utilizes shared memory constructs, and what methods are at DBAs' disposal for physically manipulating information stored in the shared pool.
Abstract: 20 Title: The Life and Times of a DBA in an ORACLE7 Client/Server Environment Author: Steve Recsky
A good set of tools and a sound systems management methodology can significantly increase the life expectancy of a DBA. This presentation will provide insight into many of the day-to-day, month-to-month, and year-to-year operations and services that a DBA has to handle and provide in a medium-size Oracle shop. Discussion points will include: services provided by the DBA, technology components the DBA must know, important information sources, and material site-specific information.
Abstract: 21 Title: Using Smart Agents to Manage Distributed Oracle Author: Dave Ensor
The relatively new smart agent technology was initially seen as competing with other approaches to managing the delivery of service in a distributed environment. But as increasing use was made of the new technology to monitor and control distributed Oracle databases, it became apparent that smart agent technology is complementary to other available monitoring mechanisms, most notably SNMP. This presentation will review the uses being made of smart agents, describe where they are most likely to be successful, and explain how they can enhance other service management solutions.
Abstract: 22 Title: Data Access in a Multi-Database Enterprise Using ODBC Author: Roger Sippl
This presentation will propose Open Database Connectivity (ODBC), as a solution to the problems that corporations and VARs typically encounter in developing applications that need to access data in multiple brands of DBMSs. It will address the variety of products that implement and use ODBC, define current and future ODBC architectures, with particular reference to the upcoming ODBC-Net second generation architecture, and review the history of standards in the area of inter-operable database connectivity, including X/Open SQL Access Group activities.
Abstract: 23 Title: CDE2 CASE: Setup, Applying and Using The Process Modeler Author: Peter Driver
This presentation will review the literature on which the modeler is
theoretically based, summarize how the CDE2 CASE process modeler is actually
used in business, explain the setup process, build a business process model
(including sound, image, and video), and provide examples of other uses of the
modeler in the IS development environment.
Abstract: 24 Title: Tips and Techniques for Developing GUI Applications from CASE Author: Julie Loesch
The tips for using Oracle CASE development techniques provided in this presentation, which have not been obviously documented in any book, will enable the developer to avoid novice pitfalls and to jump start into realizing the tangible benefits of effectively generated CASE applications. Discussion topics will include: run commands, DDL script generation recommendations, detail module definition short cuts, CASE derivation procedures, environment variables, library paths, generating Oracle Forms and Reports, documentation, and help text. The techniques provided will also increase seamless portability to other platforms, such as Macintosh and UNIX, when developing in the Windows environment.
Abstract: 25 Title: Architecting Object Applications for High Performance in Oracle Author: Christopher Keene, Persistence Software, Inc.
This presentation will address the issues involved in building high performance object applications that use Oracle. Discussion topics will include: mapping object models to relational schemas efficiently; tuning object models to enhance relational query performance; minimizing network traffic by processing large queries on the server; implementing object operations using the most efficient database capabilities, such as sorted procedures and array operations; and caching object data on the client machine to speed application performance. The presentation will include case studies from companies such as American Airlines, Shell Oil, and US West, and will describe how they are using Oracle to build large-scale, distributed-object systems in C++.
Abstract: 26 Title: Generation of Database Triggers from a Conceptual Model Author: Robert Winter
In a complex database, large numbers of propagation triggers have to be
developed and implemented to preserve consistency. Because CASE tools usually
support only the generation of delete cascadation, all other triggers must be
designed and implemented manually. Based on some extensions of the conceptual,
(e-r-), model, (e.g., participation constraints, derivation rules), it is
possible to generate all basic DML triggers automatically. This presentation
will explain how the presenter's approach has been applied to a production
planning database in which 91% of the generated triggers proved to be correct,
and will demonstrate a graphical design tool that includes conceptual
extensions, an appropriate development dictionary, and generation procedures
written in SQL.
Abstract: 27 Title: Developing Integrated CDE Applications for Macintosh Clients Author: Dawn Witten, UNM Health Sciences Center - EpiCC
It is important that developers become familiar with the increasingly popular Macintosh clone. The Macintosh is ideal for Oracle CDE applications, but there are some pitfalls to avoid. This presentation will provide Mac-specific tips for developing integrated CDE applications and achieving the elegant look and feel that Mac users expect. Uses and misuses of the RUN_PRODUCT and HOST procedures will be explained, as will methods to adapt applications for either Mac or non-Mac platforms.
Abstract: 28 Title: Using the FORMS_DDL Procedure to Dynamically Manipulate a Database Author: James Broniarczyk, The Spectrum Group
The FORMS_DDL Procedure, which was not included in the first publication of the Oracle Forms 4.0 documentation, allows a user to dynamically query, insert, and update existing database objects, and also to create, drop, and modify database objects inside a Forms application. By combining the use of FORMS_DDL with temporary tables, the ability to implement Decision Support Systems effectively is greatly increased. This presentation will rely on several case studies in order to demonstrate the usefulness of the procedure.
Abstract: 29 Title: Oracle Security in a UNIX Environment: Part 2 Author: Tony Jambu, Wizard Consulting
The presenter's article, "Oracle Security In a UNIX Environment", (IOUG Select Magazine, Volume I, Issue I, 1993), discussed security issues relating to Oracle software and the UNIX operating system. This presentation will continue that discussion. Oracle's RDBMS, in particular Oracle7, have many well-documented security features, but security at the operation system level, in particular UNIX, is neither well-documented nor understood. The presentation will identify some well-known security issues, such as hiding the username and password for the operating system while running in batch or interactive mode, as well as some not so well-known examples: the effect of setting the UNIX time variable, security holes using SQL*Plus and TKPROF, a feature that allows any database user to be a DBA and have unlimited authority, and obtaining SYSTEM's password with SQL*Net V2. Relying on examples, the presenter will, when possible, provide solutions and workarounds to resolve security anomalies.
Abstract: 30 Title: Administering Oracle Financials in a UNIX Environment Author: Gary Kirsh, Next Extent, Inc.
Those responsible for administering an Oracle Financials system face some unique challenges in addition to those faced by other DBAs. This presentation will show how the Oracle Financials DBA can use the power of UNIX to simplify or automate many repetitive tasks, and to avoid many common problems. Examples of useful UNIX shell scripts and SQL scripts will be provided. Key topics addressed will include the Concurrent Manager, backup and recovery, database monitoring, and user process management.
Abstract: 31 Title: A Practical Guide to Oracle Statistics: The Complete Reference Author: Eyal Aronoff, R*Tech Systems Inc.
Understanding Oracle statistics has been a struggle since the introduction of the V$SYSSTAT view. This presentation will dispel some of the mystery. It will focus on the new statistics in Oracle 7.0 and 7.1, and on the V$SESSTAT and V$SYSSTAT views. Key statistics will be reviewed in detail.
Abstract: 32 Title: One Machine and Multiple Instances: A Step-by-Step Approach To Implement Author: Nic Ventura
Most development sites, and a growing number of production environments, require access to disparate databases running on one machine. Although each instance may not require an additional DBA, developing standards and procedures remains a challenge. This presentation will provide a comprehensive set of perspectives which will explain how to standardize existing instances and how to prepare for and implement the addition of new instances.
Abstract: 33 Title: Avoiding Mutating Table Errors with Synthetic Constraints Author: Rory Darling, State of Alaska, Department of Transportation
Oracle's referential integrity constraints and database triggers are powerful
tools that promote modular and portable database designs. The transition from
logical to physical database design must, however, accommodate DBMS
limitations. Triggers cannot reference tables that are changed as a result of
the trigger statement, and certain key column update actions are restricted.
These limits result in the dreaded mutating table errors (ORA-4091 and
ORA-4094), causing the designer to compromise design and/or implement external
integrity logic. Fortunately, there is an alternative -- synthetic constraints
-- that preserves design logic, maintains consistency, and harnesses the power
of Oracle's internal programming constructs. Synthetic constraints combine key
constraints, triggers, packages, and views that preserve application logic by
circumventing database limitations. They permit implementation of such design
requirements as updatable primary keys, NULL delete constraint foreign keys,
computed statistics that roll up from child to parent, and transaction tables
(with triggers that reference a base table) that can be deleted individually or
as part of a base table cascade delete action. This presentation will include
practical examples of the synthetic constraint technique.
Abstract: 34 Title: Oracle Forms 4.5: Enriching Your Programming Environment with ORA_FFI Author: Sung Williams, Oracle Corporation
This presentation will explain how to declare and call foreign functions from any dynamic library easily, using ORA_FFI to enrich the programming environment. For Windows, this means tapping into the rich functionality of the Windows SDK; for Sun, it might mean leveraging low-level system services. The presentation will include customer case studies.
Abstract: 35 Title: Improving Database Performance in a Client/Server Environment Author: Jim Boak
As we move to Client/Server systems and entrust more and more mission-critical applications to this new paradigm, RDBMS performance issues are becoming a critical strategic concern for corporations. This is particularly true in OLTP and query intensive environments, where transaction processing and decision support are so intense that they severely tax information systems. When this occurs, the greatest difficulty is often diagnosing the problem. This presentation will demonstrate how to identify common performance problem areas in Oracle systems, and, relying on a case study, will discuss how the use of database accelerators can deliver performance gains of 200% to 500%.
Abstract: 36 Title: Oracle Forms 4.5: Built-in Object Coverage and Performance Profiling Author: Sung Williams, Oracle Corporation
PECS is not yet well known, but it is generating considerable interest among Oracle customers and internal developers. This presentation will address strategies for doing code coverage and object coverage in depth, what can be achieved from running PECS on applications, actual examples of PECS, and Oracle Forms development directions. Attendees will learn how to interpret diagnostic output reports in order to improve the performance of their applications.
Abstract: 37 Title: Top Twenty Tips for PL/SQL Programming Author: Steven Feuerstein, SSC, Inc.
This presentation will review the most useful tips and techniques in the PL/SQL arsenal, including cursor FOR loops, %TYPE and %ROWTYPE attributes, function design, local modules, module parameters, package globals, loop processing, and user-defined functions. Each tip will be offered with code examples so that attendees will be able to put them to work in their own applications.
Abstract: 38 Title: Tuning Oracle Databases: A Step-by-Step Approach Author: Nic Ventura
A highly flexible database environment like Oracle also supports complex tuning configurations. In the common RAD world we live in, proactive tuning of an Oracle database installation is often not given very high priority until noticeable performance problems occur. This presentation will provide detailed steps for both proactive tuning, (which should happen during the planning phase), and reactive tuning, (needed to resolve existing performance problems). A comprehensive set of perspectives will be presented which will address maintaining acceptable performance and planning for new instances, and will provide guidelines for analyzing and improving performance.
Abstract: 39 Title: Reverse Engineering SQL Embedded in 3GL Code for Impact Analysis in CASE: How to Automate this Odious Task Author: William Hamilton, Nedlloyd Lines, USA Corporation
Answering the question, "What will happen if we change...[?]" can take a great deal of time. The Oracle CASE Dictionary provides impact analysis reports to locate quickly which program modules use which data elements. Often, unfortunately, such information is only accurate for generated forms and reports modules. There is no validation of the data usages in the manually created 3GL code. As a result, time-consuming searches or educated guesses ensue, which in turn lead to embarrassing oversights. In addition, there is no facility for reverse engineering existing 3GL programs with embedded SQL. This presentation provides a simple, automated method for reverse engineering embedded SQL into the CASE Dictionary. Using this method saves time and increases the reliability of CASE impact analysis reports.
Abstract: 40 Title: Database Setup and Configuration for High Performance Author: Walter Schenk, Solutech Consulting Services, Inc.
A well-tuned and well-maintained ORACLE7 database system does not happen by itself. It must be meticulously planned long before any production user has ever logged in. Correct setup and configuration are very important. This presentation review Oracle's Flexible Architecture (OFA), and will provide a set of tips and techniques, some of which have never been documented, for the DBA. Special attention will be given to some of the "deadly", and often overlooked, setup areas, such as data file overhead, extent overhead, and the mapping of MEMORY_SORT_SPACE into temp areas. The truth about indexes will be told. The presentation may be of particular interest to non-expert DBAs.
Abstract: 41 Title: What You Always Wanted to Know about Oracle Indexes But Were Afraid to Ask! Author: Walter Schenk, Solutech Consulting Services, Inc.
This presentation will provide an overview of indexes -- their usefulness, advantages, and disadvantages. It will explain in detail the internal structure of Oracle's B-trees used to store indexes, and will examine the "rule of thumb" that the Oracle manuals provide for when to use an index. The concepts of row selectivity and blocking factor will be introduced in order to derive a new set of conclusions about the use of indexes.
Abstract: 42 Title: Hints and Techniques in Using Oracle Forms to Dynamically Access Other Development Environment Products Author: Susan Harper, Knowledge Systems International
The ease of integrating Oracle tools is often emphasized at product demos. Developers, however, are often frustrated when implementing systems, especially when users are required to supply data at runtime to run value-specific reports or graphs. This presentation will outline the steps involved and the built-ins used in that process. Special attention will be given to the similarities and differences among CDE products, and to the integration that is involved. Relying on case studies, the presentation will illustrate the requirements in Forms and Reports, as well as from Forms and Graphics. Comparisons will be made with embedding graphs within Forms or calling graphs from forms.
Abstract: 43 Title: Advanced Data Pivoting Techniques For More Powerful Queries Author: Douglas McMain, Aston Brooke Corporation
Data pivoting techniques, which combine a variety of SQL functions in different ways, can greatly increase the power of SQL queries. This presentation will address data pivoting and its benefits, and will illustrate several types of virtual pivoting columns. A variety of approaches will be given for each type analyzed. The presentation will examine the query performance considerations of data pivoting.
Abstract: 44 Title: Forms 4.5: Enhancing Your Applications with OLE 2.0 Components Author: Teck Choo Tan, Oracle Corporation
The information system industry is tending to create applications using pre-built components. This presentation will explain in detail how to pass data to an OLE 2.0 component, and how to manipulate it from an Oracle Forms 4.5 application using OLE Automation.
Abstract: 45 Title: Implementing A Very Large Information Warehouse Author: Tracy Currie, McKesson Corporation
The challenge of building an information warehouse to serve an entire enterprise is enormous. This presentation reveals how it was done at McKesson Corporation, a Fortune 500 company, using Oracle's Parallel Server and Parallel Query. This case study will show how McKesson provides both DSS and on-line complex processing (OLCP), access to the company's detailed customer, pricing, and invoicing data in a 400GB clustered Pyramid environment.
Abstract: 46 Title: Tools and Methods for Auditing an Oracle Database Environment Author: Conrad Regent, Merck & Co., Inc. Geoff Cooke, Oracle Corporation
Like most of today's large organizations, Merck is deploying mission-critical applications using open Client/Server and distributed database systems. The new technologies in such systems present data security and internal audit staff with new challenges, in learning both how the new technologies work, and what security, audit, and control issues surround the systems. This presentation results from joint work performed by Oracle Consulting and the Merck Computer Audit Technology group during 1995 to develop methods and tools for the internal auditor when checking Oracle systems. The presentation will examine each security and control feature in Oracle from an internal auditor's perspective, and will describe how to audit an installed Oracle-based system to insure that adequate security is enforced and control objectives are met.
Abstract: 47 Title: Oracle 7.1 Parallel Query: A Performance Study Author: Gordon Prioreschi, Emergent Corporation
This presentation will address Oracle's Parallel Query, including query server allocation, basic queries (scans and sorts), and joins (nested loop and sort-merge), and how these basic building blocks combine to form more complex queries. The presenter will explain how to obtain and interpret Oracle's parallel execution plan for a query, including Parallel Query-specific columns and information in Oracle's plan table, and what tuning considerations should be applied to query planning. The implications of skewed data distribution in various portions of a query and ways of dealing with them will be explored, as will the planning and management of temporary space, and the implications of OPQ in a multi-user context (such as a mixed-use OLTP and DSS environment). The presentation will also examine runtime analysis and tuning of OPQ operation -- the use of various runtime OS and database statistics to gauge the level of efficiency of Parallel Query operation, and ways to interpret and take advantage of this data. Particular attention will be paid to the reformulation of queries on the basis of such information, and a brief discussion of Oracle initialization parameters will be included.
Abstract: 48 Title: Oracle Enterprise Performance Solutions Author: H. Dieter Heinzer, Oracle Corporation
This presentation explains how to use Oracle TRACE to monitor performance data for Oracle Rdb and Oracle7 applications. TRACE, the leading edge in performance technology, pinpoints the application areas that consume the most resources, thereby saving time and improving performance.
Abstract: 49 Title: Lessons from an Enterprise-Wide Technical and Administrative Database Using CASE and GUI Front Ends Author: Andrea Chan, Stanford Linear Accelerator Center
This presentation will explore the experience that has been gained from the implementation an enterprise-wide database in the high energy physics field which combines the technical and administrative systems needed to monitor the construction of a $250 million research project. Key components of the database include the machine parameter list, magnet and vacuum fabrication data, CAD drawings, publications and documentation, survey and alignment data, property control, environment, safety and health records, personnel lists, and purchasing summaries. The database will ultimately hold the accelerator design specifications, and the fabrication and installation data in an integrated system. The central Oracle database on UNIX server was built using Oracle CASE and presents a seamless, integrated, enterprise-wide database that is derived from legacy mainframe systems, disparate systems on desktop computers and newly developed systems. The client Macintosh, IBM-PC and X Windows computer platforms at the local collaborating laboratories, (SLAC, LBL, LLNL), access the data remotely, using GUI tools. International access to the database is also required, and the project applies CASE methodology to turn out subsystems within the enterprise-wide database quickly. During implementation, we have integrated GUI tools and learned what can be made to work, versus what is merely "advertising" in the Client/Server labyrinth.
Abstract: 50 Title: ORACLE Forms Tips and Techniques Author: Jason Archambeau, US Air Force Technical Applications Center
This presentation will demonstrate useful techniques for working with Forms, such as how to copy items with extended triggers, how to use the module coordinate system to fix item placement in the Layout Editor, and how to use messages in triggers to display values. Attendees will learn tips for using the preferences control panel and the palette tools, and design techniques for producing more effective, user-friendly forms (e.g., using dummy fields for Commit Form Procedures; using named attributes to speed design; using automatic record counting and searching methods; using non-beveled fields innovatively; using alternatives to Master Detail Block creations; using non-table blocks; and using system variables with other Oracle products). The presentation will also explore practical trigger development and will provide useful hints for implementation (e.g., using :SYSTEM.LAST-QUERY; using GET_BLOCK-PROPERTY.RECORD_ID; using :GLOBAL variables; updating database values from triggers; triggers based on QUERY and NORMAL form modes; using the SYNCHRONIZE command with HOST commands; and using Block/Item properties).
Abstract: 51 Title: Quality Assurance for Oracle Projects Author: Joseph Zafian, Zeitech, Inc.
Cost overrides and production delays occur too frequently in large Oracle
systems implementations. With proper planning, using Total Quality Management
(TQM), such problems can be eliminated. This presentation will enable
participants in the application development process to use Quality Oracle
Systems to avoid ineffective, costly applications. It will guide the attendee
through all phases of the project development lifecycle, uncovering various
traps and pitfalls that may occur, and focusing on the conflicts between
performance, functionality, and timeliness inherent in any large systems
development. Resolving and minimizing those conflicts can be achieved with
proper use of the TQM Road Map to construct useful applications that will endure
as the business grows and changes.
Abstract: 52 Title: PowerBuilder and Oracle: The Inside Story Author: Bill Rabkin, Powersoft Corporation Scott Marlow, Powersoft Corporation
ABSTRACT%
The Oracle interface within PowerBuilder, a widely-used tool for Client/Server
application development, uses OCI functions to support a rich set of Oracle
RDBMS features. This presentation will describe PowerBuilder's support for
Oracle, providing details on connection and cursor management, SQL statement
processing, cache and buffer control, and use of stored procedures. The
interaction between PowerBuilder DataWindows and Oracle, and tips for optimizing
application performance in both local and wide-area networks will also be
addressed.
Abstract: 53 Title: Testing GUI Client/Server Applications: Expect The Unexpected Author: Nuruddin Sonowalla, Sunrise Systems, Inc.
The advent of GUI and Client/Server-based applications has significantly changed the system development lifecycle. Application development time has greatly decreased, but the comparative time to test applications has increased. Designing efficient GUI-based Client/Server applications has become challenging and complex, because the application code resides partially on the client and partially on the server. Similarly, programming and testing standards have also changed, and a new strategy is needed to test such applications. This presentation will address the complexities of developing and testing graphical Client/Server-based applications. The lifecycle of conventional applications versus GUI-based Client/Server applications, expectations versus reality, different stages in testing, the reasons for the increase in testing time, defining individual responsibilities for testing, formulating a testing philosophy, and automated testing tools will be explored in detail.
Abstract: 54 Title: Advanced Techniques for Oracle Forms 4.5 Applications Author: Joseph Zafian, Zeitech, Inc.
The dynamic capabilities of Oracle Forms 4.5 are a great improvement over prior versions of SQL*Forms. This presentation will demonstrate several advanced Oracle Forms 4.5 modules which utilize those capabilities, and will analyze the programs to show how such dynamic concepts as dynamic queries, dynamic sorting, and dynamic data presentation have been implemented. Other examples will demonstrate how to display running totals and maintenance of multi-table views by developing a customized data locking methodology. The presentation will demonstrate how to use many of the new features of DCE, such as timers and mouse interface triggers. VBX controls will be demonstrated to show how they can be used in a Forms application, and the capabilities of menus will be demonstrated and analyzed to allow users to customize the application to their needs.
Abstract: 55 Title: Turning Corporate Data into Business Intelligence Author: Loren Gruner, Integral Results Inc.
With more companies allowing end users direct access to corporate databases via decision support systems, how to synthesize, analyze, and consolidate corporate data, and how to train end users successfully become critical questions. This presentation will address when data warehousing makes sense, how to access data using ad hoc query tools (such as Oracle Browser), how to use views, how to avoid bottlenecks, how to use corporate data-educational methods to train end users, and how to develop data dictionaries that are clear to end users.
Abstract: 56 Title: Physical Design of Oracle Databases for Storage Arrays Author: Bruce Driver, Fusion Systems Group
Storage arrays play an increasing role in serving today's large database needs.
Proper physical design for such devices is necessary to achieve the goals of
recoverability and performance. This presentation will review storage array
hardware technology, and will explore the functionality of storage array
software, including striping (RAID 0), mirroring (RAID1), striping and mirroring
(RAID 0 + 1), and hot spares. The presenter will propose a conceptual approach
to Oracle physical design, with attention to tablespace and device layout, which
will be extended to accommodate storage arrays. Attendees will learn a
graphical technique for the construction of volumes and the physical layout of
databases on storage arrays.
Abstract: 57 Title: Take the Guesswork out of Space Allocation for Your Tables Author: Dean J. Kelley
Some consider predicting the appropriate space allocations for database objects to be an art. But scientific guidelines exist which can help to make predictions more accurate. This presentation will show how many of the storage parameters influence the behavior of the database. Different combinations of data types and sizes, and a variety of uses of these data, may produce much different results for the desired parameters. By using this knowledge, and performing some straightforward calculations, various storage parameters can be intelligently decided upon to help maximize application and database efficiency. The presentation will include case studies, and will describe tools that are available to monitor and verify database efficiencies.
Abstract: 58 Title: Lights-Out Backup of Oracle Databases: The Use of Robotic Tape Libraries Author: Nathan C. Thompson, Spectra Logic
Oracle Corporation, Ontario Hydro, Cisco, Standard and Poor's Associates Bank,
Unocal, Northern Telecom, Boeing, Southern California Edison, and US West all
have implemented the use of robotic tape libraries to provide unattended Oracle
database backup. This presentation will rely on case histories from among those
Oracle database users to illustrate an examination of database backup, parallel
server/cluster database backup, UNIX performance issues, and centralized versus
distributed backup. Half-inch, 8mm and 4mm tape drives and libraries will be
compared for their suitability in distributed, multi-vendor UNIX computing
environments. The presentation will also explain how the interface between
storage management application software and the Oracle database allows both hot
(on-line) and cold (off-line) backup, and will examine performance strategies
and pitfalls. Management strategies and tape library system deployment will be
addressed in a broad, non-vendor-specific context.
Abstract: 59 Title: Automating Quality Control Checking of Forms Using CASE Author: David Wendelken, Tactics, Inc. William Wey, Tactics, Inc.
Change control and quality control testing are laborious tasks that directly affect the success of projects. How do project leaders know whether a written source code matches the CASE Dictionary specifications, particularly after the Pandora's box of manual customization is opened? This presentation explains a simple method that allows project leaders and developers to automate many quality control checks. The quality checks are based on data held in the CASE Dictionary and on internally developed standards, and, because they find errors automatically, using them can greatly reduce the time and resources required to test, rework, and retest code. The techniques do not require a CASE Dictionary. The presentation will include a series of code samples.
Abstract: 60 Title: Pitfalls, Traps, and Gotchas in Building a Large, Multi-Level, Secure Database Author: Robert Michael Lefler
Trusted components do not a trusted system make. A DBMS providing multi-level security, such as Trusted ORACLE 7.1, executing atop a Trusted operating system, such as Sun CMW or B2 DG/UX, are not enough by themselves to guarantee the successful implementation of an MLS information system. This presentation will draw upon actual experience developing a multi-level secure information system for an agency of the Department of Defense to illustrate the types of security-related design problems that can arise above and beyond the normal database implementation issues. Security requirements had a major impact on the design of the agency's software processes, and while some of the problems were specific to the system under development and its environment, others were generic and represent problems likely to recur in other MLS system development efforts. The presentation will describe those problems, and the solutions which were developed to solve them.
Abstract: 61 Title: Designer/2000 Generator for Forms 4.5: The Next Level Author: Jeffrey Jacobs, Jeffrey Jacobs & Associates
Generating Forms 4.5 is one of the most important features of Oracle's latest CASE product, Designer/2000. The Designer/2000 Generator for Forms 4.5 enables the generation of sophisticated Master/Detail Forms with many complicated features that normally require considerable coding effort. This presentation will cover the advanced features and capabilities of Designer/2000 Generator for Forms 4.0. Discussion topics will include layout and formatting control, derived fields, VBX and OLE2 controls, block synchronization control, Forms calling Forms, validation control, and user preferences.
Abstract: 62 Title: Nomadic Computing Author: Thomas Kyte, Oracle Federal
Nomadic computing, the ability to compute anywhere at any time, is becoming more
prevalent as the infrastructure needed to support it -- reliable wireless
networks, advanced portable computers, and network-ready operating systems --
becomes widely available. This presentation will rely on applications actually
in use to demonstrate disconnectable client computing (applications that can
work connected to a network or without a network), Client/Agent/Server computing
(a classic three-tier architecture), and replication (used to support
disconnected clients).
Abstract: 63 Title: Architecting a Distributed Oracle Application Author: John Beresniewicz, Alexander & Alexander, Inc.
Applications written to be deployed in a distributed architecture, accessing, and, perhaps, updating Oracle databases separated by a network, are becoming increasingly widespread. Numerous technical issues arise when considering how to make remote data locally accessible and remotely updatable. Among those issues are maintaining network and schema transparency, security and the use of database links, time-zone differences, accessing remote sequence generators, and user account and role maintenance. This presentation will examine distributed application requirements, and will demonstrate an approach that was adopted to meet those requirements.
Abstract: 64 Title: How to Choose Correctly Among Alternative Technologies Author: Thomas Cox
This presentation will introduce managers to Extended Cost/Benefit Analysis
(ECBA), a structured methodology for evaluating which of several competing
technologies is best for a particular need. Attendees will be guided through
the complete ECBA process: defining a business need, identifying alternatives,
rating how well each alternative meets the need, and choosing an alternative.
The presentation will cover standard mathematical, dollar-oriented, cost/benefit
tools, (such as net present value and return on investment), only briefly,
showing how they fit into the framework of ECBA. Other aspects of ECBA will be
addressed, such as the proper statement of Hurdles (minimum technical
requirements), that avoid common errors, the soft-dollar issues often ignored in
standard ROI analysis, and intangible benefits and risks.
Abstract: 65 Title: Build a GUI Forms Template with Iconic Toolbar Author: John Stoddart, Compusource
This presentation will demonstrate how to build an intuitive GUI template for
Forms 4.0 to help enforce standards and provide a common look and feel across
applications. The template includes a built-in help facility, and an alert
messaging system. Attendees will learn how to build "generic" procedures,
(using the name-in function), how to store these generic procedures in the
procedure library, how to develop an iconic toolbar which is integrated with
corresponding function keys and menu line items, and how to develop advanced
GUI/Oracle Forms 4.
Abstract: 66 Title: Project Scope Management Author: Jeffrey S. Bertman
This presentation will address how to reduce scope creep by using techniques to make project boundaries more visible, (more black and white), in order to clarify whether functionality should be included immediately or added later. The emphasis will be on understanding the customer's perspective and amicably managing expectations. Attendees will learn how to plan for the full picture using techniques that prevent schedule-slide by planning for all the "little things" that take a lot of time, especially in Client/Server environments.
Abstract: 67 Title: Designing a Web-Based Information Systems Toolkit: Issues and Experiences Author: Christopher Smith, Georgia Institute of Technology
The Information Systems and Service Department of Georgia Institute of Technology is currently coordinating the design and development of a toolkit for campus departmental administrative applications and data. The toolkit consists of loosely coupled applications which access a centralized Oracle database and which utilize World Wide Web technology. Developing a usable set of tools for all Georgia Tech departments presents several challenges: merging Oracle and Web technology, creating an open environment that encourages the independent contribution of applications, and enforcing data security and integrity. This presentation will explore the methodology behind the design of the toolkit, explain the functional and user interface details of representative applications, describe the approaches used to meet the challenges presented, and furnish initial implementation results.
Abstract: 68 Title: Oracle TextServer 3.0 and the World Wide Web Author: John Thorpe, Oracle Corporation
TextServer's full text functionality, integrated with the World Wide Web's easy accessibility and widespread audience, provides powerful yet user-friendly access to large stores of unstructured data. This presentation will explain integration techniques, through TextServer's CAPI, and will provide practical examples of bringing text to the Web.
Abstract: 69 Title: Implementing Three-Tiered Client/Server in an Oracle Environment Author: Timothy Hoechst
The traditional Client/Server model is based on two primary software components: the application program (client), and the database (server). The distribution of work between the two components has always varied, but, generally, most of the programming and database manipulation logic resides in the application program. This means that the application program is serving two purposes: the interface and the logic. By putting the database manipulation logic and the presentation interface into a single application program, it can never be separated from that particular database back end. A new paradigm, called Three-Tiered Client/Server, has been emerging in the database industry. It separates the presentation and functional logic into two separate components that cooperate in front of the third tier, the database. This presentation will examine the many benefits of the new approach, and will describe the various technologies available in an Oracle environment that make building robust Three-Tiered Client/Server applications a reality.
Abstract: 70 Title: Minimizing Administration in Multi-Site Implementations Author: Roger Johnson, Ogden Government Services Sandy Thrasher, Ogden Government Services
Most organizations employ seasoned database and system administrators to manage their centralized data resources. The proliferation of powerful, but inexpensive, Client/Server systems at the departmental level, however, has created the need for simplified administration capabilities that can be handled by existing departmental personnel with minimal impact on their existing workload. This presentation will focus on one such system which has been successfully deployed to over 100 locations around the world, and will identify the key factors vital to successful implementation. Discussion topics will include automation of backup and recovery procedures, software and application installation, and comprehensive help-desk support.
Abstract: 71 Title: Oracle Forms 5.0 Features and Direction Author: Tim Eicher, Oracle Corporation
Oracle Forms 5.0 provides significant improvements in enterprise scalability and capacity, productivity, and support for advanced RDBMS features. New features make it easier for customers to produce very large applications and to support a larger number of simultaneous users. User interface improvements make Forms 5.0 easier to use and easier to learn. Advanced PL/SQL and RDBMS features allow customers to take advantage of the latest database features in their Forms applications. This presentation will examine Oracle Forms 5.0's new features.
Abstract: 72 Title: The Dynamic Duo: Combining the Power of List of Values and Record Groups Author: Ashley Porath
While users seek more functionality and better access to their data, developers want generic solutions to application development. New features in Oracle Forms 4.0 address both goals by allowing developers to build powerful reusable tools to solve user needs. This presentation will demonstrate how to design and develop dynamic list windows that allow users to view data based on selected search criteria. Topics discussed will include building list screens on the fly, using record groups and list of values, concepts of dynamically changing the "Where" and "Order by" clause, taking advantage of new Oracle built-ins, and managing application performance.
Abstract: 73 Title: Replication or Duplication: It's One or the Other or Is It Both? Author: Wesley Baird
Users want data. They want data now and they want that data current. How to provide data to them? The choices are to duplicate data to various systems or to replicate data to various systems. This presentation will focus on replicating data, which requires a new approach, since replicated data cannot be updated. If a company has successfully mapped out data responsibility to various departments, replication is a useful way to provide copies of data, at any point in time, to departments that use, but do not generate, data. Replication, when applied, makes the re-engineering challenge a task that pays back dividends many times over by improving data flow and reducing management costs.
Abstract: 74 Title: BLOB Management for Oracle Author: Bruce Powell, Recognition International (PLEXUS)
BLOB, (Binary Large Object), support provides a method for storing large pieces of unstructured data such as images, video, voice, and drawings in the Oracle database, providing applications that utilize BLOBs in Oracle with such features as data integrity, concurrent access, and security. This presentation will address the issues of high performance BLOB management, BLOB backup and recovery, magnetic caching, and optical storage.
Abstract: 75 Title: Applying Oracle MultiDimension to Business Data Analysis Author: Tim Robertson, Oracle Corporation
The Oracle MultiDimension Database extension is an innovative addition to the server tools available for complex database design and implementation. Much of the current research for this product has been proven in geographic information industries. Using the basic components contained in Oracle MultiDimension, along with the other tools provided by a relational database, this presentation will demonstrate how to use the benefits of Oracle MultiDimension to analyze large volumes of data and access data efficiently through the combination of multiple paths. The presentation will compare emerging techniques in Data Warehouse and OLAP Server requirements.
Abstract: 76 Title: Dynamic Reporting Using Oracle's CDE Tools Author: Brian Hill Ed Murray
A dynamic reporting system allows an end user to define what data to report and how to display that data. By abstracting the report definition from the report data, both components may be combined to produce a report. Because it uses a small number of modules to produce a large number of reports, low development and maintenance costs result. This presentation will address the database design requirements for storing report definition in a format independent of the reporting tool, and will provide an architectural overview of the Oracle Form and Oracle Report modules required to implement a dynamic reporting system.
Abstract: 77 Title: Journey to the Center of Oracle: The X$ Tables Author: Joseph Trezzo, The Ultimate Software Consultants (TUSC)
This presentation will review the V$ views and detail the X$ tables. The utility of the tables relies on an understanding of the table contents and the ability to join them to retrieve critical information. The presenter will provide scripts to use for information retrieval, and will explain how and when the tables are updated and their role in the Oracle database architecture. Attendees who bring diskettes to the presentation will be provided with all source code addressed.
Abstract: 78 Title: Replication, Replication, Replication Author: Bruce McCay, Miaco Corporation
Oracle7's first production release introduced the ability to replicate tables via snapshots. This simple form of asymmetric, asynchronous replication required the Distributed and Procedural options, and was fairly narrow in scope, limiting its usefulness. Two years later, we are presented with a more dynamic, robust, and flexible complement of replication features, substantially extending their usefulness and functionality. This presentation will examine Oracle7's replication features in detail and will provide guidelines for their implementation, use, and management.
Abstract: 79 Title: Eeek! No Mouse!: Developing a GUI Application That Also Runs in Character Mode Author: Ashley Porath
Developing a GUI application is challenging, but developing an application for both a GUI environment and a character-based environment is even more complex and difficult. This presentation will outline an application built using a single set of source code that was compiled and executed in both a GUI and a character-based environment. Extensive prototyping was done prior to development in order to understand the way Oracle Forms runs on different platforms. This presentation will address why a system needed to be developed for both environments, explain the development strategy chosen, explore standards, and describe how different GUI widgets work in a character-based environment. Tips and techniques will be provided.
Abstract: 80 Title: The Complete DBA for Beginners Only! Author: Richard Niemiec, The Ultimate Software Consultants (TUSC)
This presentation will examine all of the tasks that a beginner DBA must perform to insure that the system will run smoothly, and will try to make those tasks easier. Another title for the presentation might have been, "I'm the Oracle DBA; Where do I start?". The presentation will address: basic Oracle architecture, monitoring users, rollback segments, temporary space, system space, version control, backup and recovery, creating, deleting, granting, tuning, defragmenting, testing new revisions of Oracle, fixing your bugs, fixing Oracle's bugs, leading projects, training, explaining why the port to Forms 4.0 can't be done in a weekend, starting and shutting down the database, and, of course, documentation (ouch!). The presentation will also include some scripts that will make monitoring and maintaining the database easier, and will give some additional options such as integrating your system so that it pages the user when a problem arises.
Abstract: 81 Title: Making Distributed Databases a Reality: The Details of Two-Phase Commit Author: Sundar Viswanathan, Oracle Corporation
Oracle's distributed architecture, consisting of SQL*Net, Open Gateway, and Oracle Server, provides an effective solution to the challenge of sharing data in today's open systems environment. This presentation will provide a window to the underlying layer, helping to understand how consistency and transparency are achieved in a distributed database using Two-Phase Commit. It will detail techniques used to monitor distributed transactions, and how to resolve in-doubt transactions using the data dictionary views and the Two-Phase Commit mechanism. Attendees will learn the Two-Phase Commit process, its terminology, how it works, and where the DBA may need to intervene; the roles of the various nodes of a distributed database during Two-Phase Commit and how they are assigned; the data dictionary views that aid in transaction monitoring and tracking down deadlocks; and how to resolve distributed deadlocks once they are detected.
Abstract: 82 Title: Hints & Techniques: Exploiting PL/SQL Features/Enhancements, (2.1/2.2), Which An Application Developer Must Know Author: Prabhaker Gongloor, Oracle Corporation Rakesh Birla, Oracle Corporation
This presentation will examine the enhancements and features in PL/SQL(2.1/2.2), which help develop flexible, robust, and maintainable applications. It will describe efficient ways of using new features which can have a major impact on application development. The presentation will address: developing flexible applications using Dynamic SQL/DDL; how using cursor variables can improve productivity; how to overcome limits on debugging PL/SQL applications using the new tool, PL/SQL DEBUGGER; how to secure PL/SQL applications from a developer's point of view using the PL/SQL WRAPPER; maximizing performance and reducing coding efforts by using stored functions in SQL expressions; and effective ways of using overloading and typing mechanisms in PL/SQL.
Abstract: 83 Title: Designing C/S Applications: A Comparison of PowerBuilder and CDE2 Author: Yori Lavi, Lavi Tech, Ltd. Galia Kaufman-Lavi, Lavi Tech, Ltd.
Choosing the proper GUI front end tool for an application is difficult. This presentation will explore Client/Server and GUI planning aspects and will include a comparison of two leading front end products: CDE2 and PowerBuilder.
Abstract: 84 Title: Linking Object Models to Oracle Databases Author: Bonnie O'Neil, Miaco Corporation
Object Oriented (OO), design is becoming more popular, thanks to the increasing popularity of GUI tools which use the OO paradigm. Most companies believe, however, that object databases may not be the best way to store data. Therefore, a translation layer is needed between the object design and the relational back end. This presentation will explain how business rule capture can be used as a translation vehicle between the two paradigms.
Abstract: 85 Title: An Overview of the Conflict Resolution Methods in the Oracle 7.1 Symmetric Replication Option Author: Francisco Jose Mendieta-Albornoz
When physical copies of the same logical data can be modified at two or more sites and the changes are not propagated synchronously, the possibility of data inconsistency arises immediately. Although the best approach is to prevent such events in the application design stage, the problem can be dealt with using Oracle 7.1's Symmetric Replication Option, which provides some built-in conflict resolution routines and allows the writing of user-level functions to solve such problems. This presentation will explain the basics of those routines, how to customize them, and how to write user-level functions to resolve conflicts.
Abstract: 86 Title: Capturing Client/Server CPU Time (Who's Been Sleeping on My CPU?) Author: Bruce McCay, Miaco Corporation
Tracking CPU time in traditional Terminal/Host environments has been a business requirement in many arenas since computers were first built, and there are a variety of home-grown programs and third party products available to do so. Unfortunately, due to their inability to "see" beyond the network interface to client activity, products to capture user/machine specific Oracle connects/disconnects/CPU usage are not so readily available. This presentation will address several methods for identifying what kind of information needs to be captured, and where it can be found. Default Oracle auditing techniques and non-default auditing alternatives will be examined.
Abstract: 87 Title: Distributed Objects with Oracle Author: Andres Campo-Penuela, Oracle Colombia Ltda.
The Object Oriented paradigm models system requirements as communicating objects. Instead of the traditional use of data and functional models, the proposed methodology builds upon ERDs and HFDs to model system requirements as Object Classes, (Oracle7's Packaged Services), and Object Relationship Diagrams. Oracle's RPCs represent the message-passing mechanism. Oracle Distributed Objects are ideal for the development of distributed systems in a real-world environment. This presentation will include examples from a system that was built using that approach.
Abstract: 88 Title: Updatable Snapshots and Replication in a Production Environment Author: Sundar Viswanathan, Oracle Corporation
The Symmetric Replication technology provided with ORACLE7 release 7.1 offers state-of-the-art capability for building and maintaining distributed applications. Multiple, updatable copies of data can now be deployed at geographically distant sites. Updatable snapshots are a "quantum leap" extension of the first generation snapshot technology provided by the initial ORACLE7 release. After a brief description of the former "Read-Only" snapshots, this presentation will examine the terminology, characteristics, implementation, and applications of updatable snapshots in a production database that is part of a distributed environment. The presentation will focus on applying a change to an updatable snapshot, propagating changes from the snapshot to the master table, refreshing an updatable snapshot, and communication in a distributed database containing updatable snapshots.
Abstract: 89 Title: Data Warehouse and Physical Database Design Author: Bonnie O'Neil, Miaco Corporation
The notion of separating decision support from on-line transaction processing has been catching on. Data warehousing offers a viable alternative to environments where large queries and large transactions conflict, producing hideous performance for everyone. The design of a data warehouse involves special considerations, however, which affect database design. This presentation will provide a broad overview of physical design for data warehousing.
Abstract: 90 Title: Exorcise the Daemons: Real-Time Application Data Interchange Using SQL*Net V2, ORACLE7 Database Objects, and DBMS Pipes Author: Michael Handley, Metasys, Inc.
The real-time exchange of data between applications is critical in uncompromising production environments in which the immediate exchange of information is necessary for the success of the business. Typically, batch programs have been created to accomplish information interchange, but, as hardware performance and network throughput has improved, the need for timely data exchange has increased. This presentation will propose an alternative method for data exchange which relies upon SQL*Net V2, ORACLE7 database triggers/stored procedures, DMBS pipes, and custom C daemons to achieve the end result. The presentation will include a case study of two applications whose ability to communicate quickly and seamlessly is critical, even though the applications reside on separate machines. Additionally, the benefits of such communication (reliance upon discrete database objects), as opposed to traditional methods for interapplication communication, will be examined, and how operating system and communication protocol independence can be achieved will be explained. Also, how to isolate the application from the data exchange environment will be previewed as part of the complete discussion of real-time electronic data interchange.
Abstract: 91 Title: Data Distribution Strategies and Oracle Snapshots Author: Christopher Adamson, inCASE Corporation
An arsenal of data distribution strategies is available to database designers. There are alternative techniques for implementing any strategy. This presentation will outline such strategies and their associated implementation techniques, focusing on Oracle read-only snapshots, (a form of asymmetrical, asynchronous data distribution). The presentation will detail how snapshots are created and managed, tuning advice for snapshots and the databases that contain them, alternative strategies for refreshing snapshots, and useful tips for avoiding of pitfalls.
Abstract: 92 Title: Performance Tuning: Client/Server Considerations Author: Joseph Trezzo, The Ultimate Software Consultants, (TUSC)
This presentation will review the Client/Server environment and the potential performance bottlenecks that may hinder system performance, explore the benefits of different Client/Server configurations from a program execution standpoint, and, from a program development perspective, examine methods of improving performance. Sample code to exemplify performance improving techniques will be included. Attendees will be provided with a checklist of items to consider when programming in a Client/Server environment and when determining the placement of programs for execution. Discussion topics will also include: identifying and correcting performance problems, buffering restructuring of program logic, and other performance tips and techniques.
Abstract: 93 Title: Using Oracle Event Processing to Facilitate Client Calls to Server Programs Author: Sandy Thrasher, Ogden Government Services Roger Johnson, Ogden Government Services
Client/Server systems often employ a powerful server used for both database storage and communications access to external interfaces. Since each client workstation may be incapable of handling direct communications processing, communication interface programs must be developed for the server to facilitate client workstations' data requests. Drawbacks associated with the use of such programs include increasing backlogs, significant overhead, and delayed responses to client calls. This presentation will demonstrate a unique method of using Oracle Event Processing procedures to avoid such difficulties.
Abstract: 94 Title: The Data Warehouse Schema: Designing a VLDB Optimized for Multidimensional Analysis Author: Jeffrey Bedell, MicroStrategy, Inc.
The success of a data warehouse project is closely tied to the physical schema, because the schema is the one point where data extract and population routines, user requirements, and query performance are linked. This presentation will examine the basic components of a warehouse schema, including the processes of defining logical dimension, relating entities within a dimension, and mapping dimensions to the physical schema. The presentation will cover advanced design topics such as the use of aggregation tables, data partitioning, key structures, and data integrity. Attendees will learn the major issues, techniques, and trade-offs that accompany a large data warehouse effort, and they will learn the characteristics of a multidimensional or star schema.
Abstract: 95 Title: SNMP For Dummies Author: Perry O'Neil, Time Warner Communications
The simple Network Management Protocol (SNMP) is today's hot topic as the Oracle offering hits its first birthday and the Sybase and Informix offerings start to cut their teeth. Few system and network management tools come without complications, and SNMP has its share. This presentation will examine SNMP basics, the Database MIB, and the operation of the HP open View and SunNet Manager SNMP management Workstations with emphasis on Oracle and UNIX system management. Attendees will learn about agents, proxies, MIBs, dual homing, ping, and SNMP V2.
Abstract: 96 Title: Partitioned vs. Single Large Table Approach for Decision Support/Data Warehouse Applications: Recommendations for Using Oracle7 Author: Sameer Patkar, Oracle Corporation Prabhaker Gongloor, Oracle Corporation
Decision Support (DS)/Data Warehouse (DW) applications require the ability to
model and consolidate multidimensional data, and to drill down into details
while maintaining minimum response times for both online and batch queries.
Large DS/DW applications may be as large as 10-100 GBs, and current Oracle
architecture and technology does not provide a mechanism to handle large tables
transparently using in-built features like partitioning (as opposed to manual
partitioning) on tables. This presentation will explore the impact of storing
all the data in a single large table instead of using hand-made partitions
(using UNION ALL) on issues of operability and performance. In addition,
features of Oracle 7.1 and 7.2 which support improved performance will be
explored, and recommendations will be made concerning best practices and
approaches with respect to performance (on-line queries and batch queries), and
such operations as loading data, space management, backup, and recovery.
Abstract: 97 Title: The CASE API: An Open Door Author: Paul Mannino
Moving design data from non-Oracle CASE repositories to the Oracle CASE repository can now be accomplished easily and efficiently through the use of the CDE2 for CASE product line, which provides a PL/SQL-callable interface implemented via stored procedures and functions. Such packages allow direct interaction and manipulation of the underlying CASE tables, while simultaneously enforcing all security, integrity, and validity rules established via the CASE Dictionary screens. This presentation will examine a method used to move 1500 entities and tables stored in the CADRE/Teamwork repository into the Oracle CASE repository quickly. The approach can be extended to include other third party repositories, without regard as to how or where the data is stored. The API provides an excellent solution for moving design data when CASE Exchange is not available or direct manipulation of the Oracle CASE tables is appropriate. Support for moving data from flat files will also be addressed.
Abstract: 98 Title: Forms 4.5: The Beginner's Guide to Phenomenal Screens Author: Richard Niemiec, The Ultimate Software Consultants (TUSC)
This presentation will focus on the elements of Forms 4.5 that allow any beginner Forms 4.5 developer to create that "breathtaking" screen without an overabundance of coding. The beginner with little or no knowledge of Forms 4.5 will learn to develop phenomenal screens quickly, complete with large fonts, colors, and buttons that interface to the database. The presentation will explore: how triggers and procedures have become easier to use in Forms 4.5; import and export of images, drawings, ASCII text; the enhanced debugging tools that help developers to troubleshoot potential problem areas; other Oracle products that may be integrated with Forms 4.5; and how to establish library modules to store procedures and triggers. The presentation will explain such elements as the use of "buttons", "lists", "radio groups", and "checkboxes". Everything will be "point and click" for the user.
Abstract: 99 Title: Locking and Performance Considerations when Implementing Referential Integrity Constraints and Database Triggers Author: Ella Blue, CBIS
The benefits of implementing enforced referential integrity constraints can be considerable. This presentation explores referential integrity constraints and database triggers from a locking and performance view. Attendees will be provided with guidelines on when to use such features and measurement tools to determine the impact on performance.
Abstract: 100 Title: Optimizing Performance with PCTFREE and PCTUSED Author: Rick Brauen, ARIS Inc.
The Oracle RDBMS handles generic data table conditions well. For better performance, however, PCTFREE and PCTUSED should be considered. This presentation will clarify the terms surrounding PCTFREE and PCTUSED, explain how the database handles inserts, updates, and deletes, and examine how such operations vary among applications.
Abstract: 101 Title: Effective Design and Implementation with Oracle7 Author: Paul Song, ARIS Inc.
Oracle7 provides some of the most advanced features available in a relational database. As companies migrate from version 6 to Oracle7, using such new features as declarative referential constraints, database triggers, and stored procedures, many are experiencing problems because they do not fully understand how constraints, triggers, and procedures interact at the database level, or how problems can arise from an ill-designed database schema. This presentation will address design and implementation issues that arise when using Oracle7.
Abstract: 102 Title: Creating an Executive Information System with Developer/2000 Author: Tim Gotham
The Developer/2000 suite of development tools can be used to build advanced end user-oriented applications like an Executive Information System. An EIS system can provide significant benefit to a company's management by providing real-time information in a format that the executives and managers can easily understand, while at the same time providing a method for the user to "drilldown" to see the detail information. Developer/2000 provides an excellent platform for developing such advanced applications. The demonstration of a working EIS system will provide attendees with an example of how to integrate Forms, Reports and Graphics tightly, to provide an advanced application.
Abstract: 103 Title: Using Forms 4.5 to Build a Help System Author: Peter Koletzke, Port Authority of New York and New Jersey
Building help systems is an essential part of the development process, and Forms 4.5 offers many features that can enhance them. This presentation will explain how Forms can be used to create a context-sensitive, multilevel, searchable help system, one that is virtually "plug and play", requiring minimal modification to existing forms. The presentation will explore alternatives to the Forms help systems such as Oracle Book, third party tools, and Forms Native Help facilities, and will demonstrate that Forms is a serious candidate from the job of creating a help system. All aspects of the solution will be addressed: the tables needed, the help form, and the library routines required to attach to existing or new applications. Sample code includes a fully-implemented help system which can be made available to participants through the IOUW utility diskette.
Abstract: 104 Title: Incorporating Dynamic Toolbars in Forms 4.5 Applications Author: Peter Koletzke, Port Authority of NY and NJ
Toolbars are part of all GUI products these days and users have come to expect this feature from their applications. Forms developers can provide toolbars easily with Forms 4.5 using its enhanced capabilities. This presentation will show a working system which used dynamic toolbars to perform normal Forms functions and which changes based the cursor location in the form. The presentation will explain how a hint text item can be developed to show the function of a button as the mouse is passed over it. Other topics explored will be: generic toolbar procedures for library and template forms, stacked toolbars, user-moveable toolbars, toolbar windows, button trigger inheritance, and MDI and window toolbar canvases. The sample form with its toolbar canvases will be made available on the IOUW utility diskette.
Abstract: 105 Title: Data Model Patterns: Convention of Thought Author: David Hay, Group R, Inc.
There are many structures that almost all businesses share, regardless of their sector. All must deal with people, organizations, business activities, and contracts. This presentation will describe some of the more significant of these structures, demonstrate the models for them, and describe some of the more difficult-to-model areas, such as accounting, process manufacturing, and document management.
Abstract: 106 Title: Practical Resource Tuning Guidelines for Advanced Distributed Databases Using Oracle7 Symmetric Replication Facility Author: Javier Seen, Oracle Corporation
The new Oracle7 symmetric replication facility is a powerful and complex tool that facilitates business solutions. It is geared toward a special class of real-world databases where customers have struggled with application software interfacing with a logical database, which stores replicated schema objects at multiple sites. Despite the product hype, however, there is little concern about extra resource requirements, bottleneck factors, and workload scalability. This presentation will provide guidelines that define baseline quantities for resource utilization measurement tests performed at the Enterprise Systems Lab of Worldwide Support, including shared pool utilization, extra redo and undo generation, and asymptomatic behavior of TPS values in a concurrent client environment. The presentation will address potential bottlenecks in the replication environment, including the deferred transaction queue, CPU and disk utilization during data propagation via deferred RPCs, and scalabiltiy factors for concurrent OLTP sessions. Such tuning tips will help DBAs define their replicated database environment appropriately. It will also aid developers in adjusting the logic of the overlaying application based on their business rules.
Abstract: 107 Title: Oracle Media Objects for Home Entertainment Author: Michael Jaffee, Oracle Corporation
Building multimedia applications requires the most powerful and productive tools available. Oracle Media Objects provides the game developer all that is needed to create exciting educational products for the home user. This presentation will examine the authoring environment, application structure, object types, and scripting language used with Oracle Media Objects. A small application will be built during the presentation.
Abstract: 108 Title: Windows Development for Oracle7: Oracle CDE2 vs. Microsoft Visual Basic Author: Matthew Laing
This presentation will evaluate Oracle CDE2 and Microsoft Visual Basic by examining development toolset contents, product bundling, product architectures, the advantages and disadvantages of each toolset for both developers and end users, and such commercial issues as support and maintenance, licensing, and application development and maintenance costs.
Abstract: 109 Title: Oracle Forms Migration: Converting From Forms 3/2.3 to CDE2 -- Options and Issues Author: Aidan Naughton
This presentation will examine the options available to managers and developers. It will explore Forms 3/2.3 versus Forms 4 product architectures, key design considerations between GUI and character mode applications, how the Oracle converter works, third party automated conversion tools, what can and should be done by hand, metrics and costing for conversions, and ongoing development and maintenance issues for split GUI/Character based environments.
Abstract: 110 Title: CDE2 Development: Development Standards and Guidelines for Delivering Windows-Compliant Database Applications Author: Aidan Naughton
This presentation will address key components of the Windows interface, such as the structure and use of menus, toolbars, accelerators, and syntax; how CDE2 can be used to present Windows '95 interfaces; creating CDE2 templates for standards and minimizing maintenance costs; changing the Oracle Terminal file to insure keyboard compliance with Window's standards; creating standard procedures to handle key Windows events, such as Message Handling, Drag and Drop, and Enabling and Disabling items; and the implications for the standard on default Oracle menu security and how it can be extended to handle button and icon-related security issues.
Abstract: 111 Title: Parallel Export/Import Today on SMP Machines Author: Ron Estes, Qualcomm
Parallel export/import has many advantages over the conventional full database export, such as reducing the amount of time spent exporting data and re-building production of development databases, and greater manageability in restoring individual tables by dividing a full export into several user exports. This presentation will explain the concepts and procedures used to implement parallel export/import in a UNIX environment, using actual examples of scripts.
Abstract: 112 Title: CDE2 CASE: A Developer's Experience with a Mission-Critical Application Author: David Gottholm, Eclipse Technology, Inc.
CDE2 CASE is the long-awaited magic bullet that will let developers model, design, and implement applications that take advantage of the new CDE2 tools. It is vital to the effort to overcome the timeline pressures common to all development efforts. This presentation will examine a mission-critical application using CDE2 CASE, in which timelines are stringent, and the results will make or break both line staff and external consultants. The application's data and functional models were developed using CASE 5.0 on a SUN workstation. Obvious generation limitations meant that most of the module design was skipped and straight FORMS 4.5 development was begun. The presentation will explore the experiences of a seasoned design and development staff in migrating the application to CDE2 CASE and using it to create the application. Specific topics will include migrating from CASE 5.0 to CDE2 CASE, reverse-engineering established FORMS 4.5 look-and-feel items, designing and generating FORMS 4.5 features, and technical tips and techniques.
Abstract: 113 Title: Balancing the Load: Partitioning an Oracle7 Application in a Client/Server Environment Author: David S. Kociolek, AMP Incorporated
With the advent of Client/Server and Oracle7 distributed processing, comes a shift in the traditional application paradigm. Now it is possible, and in some cases more efficient, to centralize application functionality in the database itself but to distribute the application's processing among client workstations. Such is the hallmark of Client/Server computing in general, but where do you draw the line? Opinions differ as to which aspects of an application should be centralized and which should be distributed, and each has its own pros and cons. Custom applications demand custom functional environments. Based on the Oracle7 architecture, however, there are general paths that can effectively "balance the application load". By analyzing application requirements, process logic, and design schema, application developers can distribute their workloads to whichever Client/Server resources handle them best. This presentation will examine how developers can partition the load.
Abstract: 114 Title: PL/SQL Packages: A Solution to Batch Processing Author: Nitin Hase, Soltec, Inc.
This presentation will address using Oracle Packages to write batch programs, and using PL/SQL Packages and supplied packages to write batch processes. It will explore using the packaged cursor for scoping the cursor variables to all procedures, using forward declared parameterized procedures, and using functions that return records. Discussion topics will also include: the advantages and limitations of packaged cursors, making the package restartable, error log writing, PL/SQL-efficient coding using the exit loop statement, boolean assignment, return statements, and using such supplied packages as DBMS_SQL, DBMS_JOB, and DBMS_OUTPUT to fulfil batch processing requirements.
Abstract: 115 Title: CDE2 and VBX, a Nice Fit Author: Scott Knutsen, Metasys, Inc.
The personal computer and MS-Windows have increased end users' expectations -- they want intuitive, easy-to-use applications. With Oracle's CDE2 and Microsoft's Visual Basic's VBX controls, it is now possible to accommodate them. This presentation will explore different approaches to using the new technology, and will provide a practical guideline for methods of implementation.
Abstract: 116 Title: Agents, Agents Everywhere: Designing a Mobile Application with Oracle Mobile Agents Author: Marta Osborne, ARIS Inc. Paul Fairweather, ARIS Inc.
Mobile computing is becoming a new paradigm in the software industry. It has inherent problems, however, such as slow latency time, unstable communication, and the possibility of multiple communication methods, all of which influence the design of a mobile computing application. Fortunately, for those building such an application, Oracle Mobile Agents can help. This presentation will explore new design methods and techniques for using Oracle Mobile Agents. It will analyze the mobile computing architecture (Client/Agent/Server), and demonstrate how it affects the mobile application design. A method of planning client agent messages will be presented, as will agents' programming considerations for various transactions between the agent and the server.
Abstract: 117 Title: Don't Let Your Agents Turn into Another Maxwell Smart: Managing Oracle Mobile Agents Author: Paul Fairweather, ARIS Inc. Marta Osborne, ARIS Inc.
People are on the run more than ever, with an increasing need to access
information in a central relational database system via their personal
computers. That need has spawned the new software development, mobile
computing, to which Oracle responded with Oracle Mobile Agent. The move to
mobile computing, in conjunction with Oracle Mobile Agent, has created new
issues for those responsible for administering mobile application. This
presentation will examine the mobile computing architecture,
(Client/Agent/Server), used by Oracle Mobile Agents, and the installation
process for Oracle Mobile Agents components for both the client and server
platforms. The process of registering agents and how an agent works will be
explained, as will the day-to-day routine for managing Oracle Mobile Agent's
components. The presentation will provide tips and techniques in current use.
Abstract: 118 Title: Top Ten List of Oracle Financials Implementation Problems Author: Stanley Cohen
This presentation will explain: 1. Getting Checks to print from A/P in proper format. 2. What to do when your computer locks up while entering accounts. 3. Getting around required data fields. 4. Set required to get payment from the correct bank account. 5. Proper order to enter required information in GL and how to fix it when you make a mistake. 6. Phantom lines on FSG reports and how to remove them. 7. When to use multiple sets of books and when to use multiple companies. 8. Simple ways to set up descriptive flexfields and remove them. 9. How to avoid locked records in a Client/Server environment. 10. How to open an earlier period than your original starting period.
Abstract: 119 Title: Efficient Migration from Forms 3.0 to Forms 4.5 Author: Chiemi Okui
Forms 4.5 offers a bit-mapped GUI, which greatly differs from the Forms 3.0 character user interface, (CUI). Understanding their differences is critical for successful migration from Forms 3.0 to Forms 4.5. This presentation will examine an effective migration methodology, and how to improve the productivity of reprogramming and/or conversion from Forms 3.0 to Forms 4.5. It will demonstrate how to estimate the time required for migration, and explain differences in the application development model for GUI and CUI. Special emphasis will be placed on porting procedures from shared forms in 3.0 to libraries in 4.5, replacing KEY-triggers with mouse clicks, and changing Forms layout.
Abstract: 120 Title: Loading Invoices into AR the Easy Way Author: Gail Huguet
Oracle's AR manuals are unclear about loading invoices, although doing so is easy. Missing a step means invoices will not load, and an error message might not appear. Oracle Support is swamped with calls about the problem, and is sometimes unable to help. This presentation will explain how to match up data with the required fields, how to find the hidden descriptive flexfields and identify which are needed, how to set up the Invoice Source and Type to match the data and the method being used to load the invoices, and how to write the load routines, run the import, and interpret errors. Materials will be distributed.
Abstract: 121 Title: Oracle7 Connectivity Methods for Microsoft Windows Author: Vic Stambaugh, Integrated Computer Technologies
As Microsoft Windows gains wider acceptance, and end user applications such as
Microsoft Word and Excel become more powerful, integrating information from
enterprise databases with desktop tools is becoming increasingly common. Such
integration not only leverages the power of the tools to support what otherwise
would require additional tools or custom development, it also allows users to
perform many application functions from common, familiar interfaces such as Word
and Excel. This presentation will describe three methods for integrating
Oracle7 data with Windows applications: Microsoft's Open Database Connectivity
(ODBC) API, Oracle7 Objects for OLE2.0, and Oracle Glue. It will address basic
components for each architecture, ODBC SQL and API conformance levels, and OLE
versus DLL architecture. The presentation will also include examples of ODBC
driver configuration and various examples of each method in Visual Basic, Work,
Excel, and Access. Attendees will learn the basic functions and capabilities of
connectivity tools, and the issues surrounding the use of each.
Abstract: 122 Title: Power Objects: The New Frontier Author: Pedro Orrego, SRI, Ltd.
This presentation will explore the concepts and functionalities of Oracle Power Objects, and give practical hints for application development using this new Windows-based tool. Emphasis will be placed on Object Oriented design and programming, performance, and resource management.
Abstract: 123 Title: Implementing Windows 95-Style Applications in Oracle Forms 4.5 Author: Paul Hipsley, HIP Solutions, Inc.
This presentation will address how the improvements in Oracle Forms 4.5 allows Oracle developers to now create Windows 95-style applications. Such applications can include standard toolbars, and can take advantage of the new triggers for mouse support. Mouse triggers enable developers to create bubble help both on the toolbar and for each field in the form. In addition, support for OLE2 enables developers to create Oracle Forms applications with in-place activation of MS Word, MS Excel, Oracle Graphics, and other OLE2 servers. Oracle Forms 4.5 supports VBX Controls, allowing users to take advantage of the many third party products available.
Abstract: 124 Title: ODBC ABCs: Connecting Windows to Oracle Author: Thomas Harleman
Open Database Connectivity (ODBC) can provide Windows users a standard, flexible environment for accessing Oracle databases and other data sources. This presentation will provide an overview of ODBC technology, and instructions for installing and using the drivers. Attendees will observe ODBC used with Microsoft products, Excel, Word, Access, and Query.
Abstract: 125 Title: Demonstrations of ALERTS and PIPES Author: Paul Winterstein
Many systems need to pass information among two or more database sessions. For example, end users may complete their message compositions and, upon commit, may need to communicate to a specialized background process that the message is ready to be formatted and printed. A common solution to the problem was to use a table in the database as a message queue -- the end user would insert a row into the table and the background process would select the row to receive its instructions. That solution required, however, that the "message" table be defined and maintained. This presentation will examine how DBMS_ALERT and DBMS_PIPE are cleaner, more efficient approaches to "inter-session" communication.
Abstract: 126 Title: Reduce, Reuse, Recycle Objects in Oracle Forms 4.5 Author: Andrew Costakis, Oracle Corporation
Using the basic principals of municipal recycling, IS organizations can significantly reduce the cost and time necessary to implement relational database applications. This presentation will demonstrate techniques and functionality in Oracle Forms 4.5 for reusing, recycling, and reducing objects when creating applications. Discussion topics will include libraries, packages, drag and drop, copying/referencing, OLE, record groups, and visual attributes.
Abstract: 127 Title: A Parameter-Based Generic CDE2 Report: One Report Does It All? Author: Samir Jaipuriyar, Oracle Corporation
This presentation will explain how to create a generic report, based on the underlying Oracle Dictionary tables, so that users can specify reporting requirements and, using parameters, create a report on the fly.
Abstract: 128 Title: Successful Diagnosis of Oracle Applications Problems Author: Paul Carey, Oracle Corporation UK, Ltd.
The tools available for problem diagnosis have increased as the functionality of applications has expanded. This presentation will explore the advantages and practicalities of immediate and on-line diagnosis for applications issues. It will examine GUI applications, and character mode. Guidelines, including a list of tools, techniques, and examples, will be provided.
Abstract: 129 Title: Using Designer/2000 to Re-engineer Legacy Systems Author: Maria Billings, Renaissance Computer Education and Consulting (RCE)
This presentation will provide an overview of how Designer/2000 and Legacy Systems can work together. Using examples from Designer/2000, it will demonstrate how to convert and improve Legacy Systems by: establishing the business framework; reversing engineer data from Legacy Systems; reviewing and improving the data structure; generating first-cut of application, and creating a unified look-and-feel by using templates and preference settings; making use of imbedded object orientation, such as inheritance, object reuse, encapsulation, modularity, and polymorphism; and completing the rapid application development cycle (scope, prototype, review, refine, and implement).
Abstract: 130 Title: Oracle Media Objects: Multimedia in the Age of Interactive Television Author: Lukas Oberhuber Paul Hartenstine, Oracle Corporation
Oracle Media Objects 1.0 is a powerful multimedia environment, enabling applications from CD-ROM to Interactive Television. OMO contains a large number of objects which give application developers access to multimedia capabilities. With the Enterprise Extensions, OMO allows developers to wed multimedia access to traditional backend services, (such as the Oracle Server). This presentation will explore OMO, clarify the application architecture, describe Oracle Media Objects 2.0, and explain how it will enable a whole new class of multimedia applications. It will specify the OMO 2.0 application model, and will explain how OMO 2.0 will provide true object orientation and better control over application data and its use. Special attention will be given to the transition to the Information Superhighway.
Abstract: 131 Title: The Oracle Distributed Initiative Author: Gordon Smith, Oracle Central America
Building truly distributed systems is complex, but it offers great benefits to users. Oracle offers a wide range of technologies for distributed processing. Among them are both synchronous and asynchronous distributed database functionality, including the recently released symmetric replication capability. Other key technologies are gateways, networking, distributed system management tools, and other middleware products. This presentation will explain the use of distributed processing technologies, the key to building successful distributed systems.
Abstract: 132 Title: Oracle Server Directions Author: Jnan Dash, Oracle Corporation
This presentation will examine emerging trends in the database market.
Abstract: 133 Title: Oracle Products and Object Technology: Strategy and Direction Author: Jim Trezzo, Oracle Corporation
Object technology is playing a central role in Oracle's product plans. In order to provide products that will allow customers to build and evolve applications faster, as the complexity of these applications increases, Oracle is moving towards an integrated set of design and development tools, connectivity products, and servers, which incorporate object technology in a fundamental way. This presentation will provide an overview of Oracle's technical vision for its next generation of products, which are expected to provide significant productivity gains for customers.
Abstract: 134 Title: The Oracle Web Server Option: A Technical Discussion Author: Katrina Montinola, Oracle Corporation
The World Wide Web is expanding at a staggering rate. Many Oracle customers have either put up Web servers, or are planning to do so soon. Besides publishing information, some customers are even doing business over the Internet via the World Wide Web. This presentation will introduce the Oracle Web Server Option, a product that allows an Oracle7 database to function as a Web Server, thus bringing all the power, security, and scalability of an Oracle database to the World Wide Web. This presentation will explain the internals of the Web Server Option, and will provide a technical description of each feature. Attendees will learn how the product can aid them in their exploits on what many consider to be the precursor of the Information Superhighway.
Abstract: 135 Title: Archiving Video Clips: Media Archiving and Retrieval with Oracle Author: Steve Tonas
Broadcast companies have millions of old news video clips, some dating from the 1950s, that they must archive, manage, and retrieve, either for internal reuse or for external sale. Oracle's Media Archive Application is designed to meet the needs of broadcast companies into the next century. This presentation will address a Media Archive that used the Oracle7 Server, Oracle TextServer with Context, and Oracle Forms. It will explain the design decisions and considerations behind the application, and how a broadcast company can best use the application.
Abstract: 136 Title: Standby Database Feature of ORACLE7 version 7.3 Author: Lynne Thieme, Oracle Corporation
The objective of the Standby Database feature is to support the capability of maintaining a duplicate database of a production database, as a database recovery solution for recovering from disasters at the production site. The functionality of the feature is currently being implemented by Oracle customers prior to release 7.3, but is not supported or endorsed by Oracle Corporation's World Wide Support or Development organizations. The objective of the Standby Database feature is to support recovery from disasters by providing an external interface for the functionality and integrity checks within the Oracle RDBMS to detect and correct potential data corruptions. This presentation will address the external requirements of the feature, a description of its design and implementation, and the details of its external interfaces.
Abstract: 137 Title: PL/SQL Performance Analysis, Optimization and Runtime Size Reduction Author: Mohamed Mobarak, Oracle Corporation
PL/SQL performance can have an enormous impact on today's distributed applications. Unless they know the available profiling techniques and possible runtime performance enhancements, application developers trying to increase the efficiency of their PL/SQL-based applications are faced with an exceedingly difficult task. Using a sample application, this presentation will examine the range of PL/SQL profiling tools and techniques currently available. Attendees will learn how to improve the performance of the sample application based on the profiling methods. Because smaller application images generally result in greater performance due to their reduced use of system resources, the presentation will examine methods of reducing the runtime image size of PL/SQL applications.
Abstract: 138 Title: Query Optimization for Decision Support with ORACLE's Cost Based Optimizer Author: Linda Willis, Oracle Corporation
Unlike OLTP queries, which are often extensively tuned for frequent execution, decision support (DSS) queries are typically generated by tools and are executed only once. A query optimizer for DSS must, therefore, rely less on the form of the query and more on statistical descriptions of the data. While the optimizer may have to consider more execution strategies and transformation, it usually can spend more time doing so since queries can run for hours. Oracle 7.3 cost base optimization has been enhanced for DSS with better statistics, including histograms, more transformations, more execution strategies, and improved support for multidimensional (star) queries.
Abstract: 139 Title: Upcoming Oracle Server Releases Author: Michael Hartstein, Oracle Corporation
This session describes the new features included in the upcoming release of t
Abstract: 140 Title: Implementation Guidelines for OLTP Applications Author: Merrill Holt, Oracle Corporation
Oracle offers and increasing variety of products and configurations to implement
Abstract: 141 Title: How Oracle7 is Perceived by Managers and Business Users Author: Miro Costa
This presentation will examine the results of a recent survey of Bay Area business managers, supervisors, and users, in small, medium, and large companies, (such as banking, retail, hotel, food and beverage,consulting, health management), to ascertain how well they understand database technology, and the value they attach to the features and capabilities offered by their database systems. None held graduate degrees in Computer Science or Electrical Engineering, and none had more than 10 years of technical work experience with computer manufacturers or vendors. The companies included in the sample are currently using ORACLE7 or would like to use ORACLE7 soon. The survey sought to discover: which attributes of ORACLE7 are the most relevant to managers and business users; whether information systems managers' and business users' perceptions of ORACLE7 differ from those of managers and business users in other functional areas; and what is an appropriate mathematical model to represent and describe ORACLE7 performance based upon managers' and business users' perceptions.
Abstract: 142 Title: The Integration of Oracle Applications with Legacy and Third Party Systems Author: Walt Zerkow, Oracle Corporation Anne Blaylock,Oracle Corporation
This presentation will provide a tested methodology for integrating Oracle packaged or custom-developed applications with Legacy and third party systems. It will address both standard Oracle interfaces and custom interfaces. In many instances, Oracle standard interfaces (APIs) can be used to meet integration requirements. In some instances, however, custom interfaces will need to be designed, built, and maintained. The presentation will also explain the use of automated tools to shorten the lifecycle and improve the quality of integration development.
Abstract: 143 Title: Distributed Administration Debate: What Users Want... What Vendors Can Deliver Author: Mark Jarvis, Oracle Corporation
This presentation will explore various approaches to administering many Oracle databases and networks in a distributed environment. Four providers of systems management frameworks and database monitoring tools will address the requirements of four demanding users. Do users need integrated database and systems administration tools? Are vendors providing too much infrastructure and too few applications? Attendees will hear vendors describe how their directions will meet users' requirements.
Abstract: 144 Title: How to Get Your Data Warehouse Up to Date Quickly Author: Suresh Raman, Toys R Us
This presentation will provide an overview of data warehousing concepts and requirements at Toys R Us, the entity-relationships involved, and will highlight the volume of data. It will explore: using SQL*Loader options to load large volumes of data quickly; creating indexes with NO_SORT.OPTION; techniques used in aggregating data into different dimensions and tuning global parameters such as SORT_AREA_SIZE; trapping errors and exception in SQL*LOADER, stored procedures, SQL scripts, and file transfers to alert application support; and query tools and forms used by users to access data from across the country.
Abstract: 145 Title: Using Forms Templates for 100% CASE Code Generation Author: Floris Jan Versteeg
CASE generates static code and objects, when often dynamic behavior is preferred. This presentation will address user-configurable buttons (at runtime, not design-time), dynamic enabling/disabling of buttons (having a List button or an Edit button enable only when appropriate), forms titles in Windows, runtime user access on objects, and multi-block context (to see which path was followed to get somewhere). The presentation will give examples of such techniques, which are applicable in CASE 5.1 and CDE2 CASE.
Abstract: 146 Title: Designer/2000 to Developer/2000 - One Button CASE Generator Author: Samir Jaipuriyar, Oracle Corporation
If the E/R model has been fully designed, do we need to create a functional definition (module definition) for it, or can this be intelligently deduced? Does the E/R model imply hierarchical or parent/child-type functionality requirements? If the attributes have been defined, can we assume what columns must be included in the module definitions? If the relationships have been completely defined in the E/R model, do we have enough knowledge to generate foreign-key definitions and table usages? Using an ICON-based set of templates, and Object Oriented user preferences, can an application be completely generated? This presentation will explore and attempt to answer those questions.
Abstract: 147 Title: Object-Oriented Analysis and Design: A Survey of Methods Author: Eladi Valencia
This presentation will explore methods and techniques applicable to Object Oriented analysis and design environments, (such as OMT, Booch, Rabin, and Yourdan), and will explain when each is most suitable. It will also demonstrate how to apply the techniques to relational environments, in particular to Oracle databases.
Abstract: 148 Title: Directions in Data Warehousing Author: Neil Mendelson, Oracle Corporation
This presentation will explore the directions Oracle is taking to support data warehousing.
Abstract: 149 Title: PL/SQL Product Update Author: Peter Vasterd, Oracle Corporation
PL/SQL, Oracle's procedural extension to SQL, provides a common procedural language for client-side tools (all key Oracle application development tools), and for server-side programming such as database triggers, stored procedures, functions, and packages. Oracle7 provides a robust procedural logic environment centered on PL/SQL for building large-scale, complex, industrial-strength applications. This presentation will describe product directions for PL/SQL. It will provide an overview of the new features of the latest release, and new features of upcoming releases. New features in the RDBMS that benefit the server-side application development will also be addressed, and examples will show how the new features can best be used.
Abstract: 150 Title: Oracle's New Portable SQL/Services for Desktop Access to Rdb Author: Jan Schwartz, Oracle Corporation
This presentation will explore the new generation of database software server technology for Oracle Rdb. The software server makes it economical to support large numbers of clients with relatively small numbers of database servers. It features integrated system management and monitoring capabilities that support both Alpha/OSF/1 NFS environments and VMS clusters. Clients access the database servers using ODBC and/or SQL/Services.
Abstract: 151 Title: Oracle Symmetric Replication Author: Gordon Smith, Oracle Corporation
Symmetric Replication is Oracle's latest advancement in distributed database technology. This presentation will address the types of replication models that can be implemented using symmetric replication, including primary site ownership, dynamic ownership, and update-anywhere. The management facilities offered with the product will be described, including the replication catalog, distributed schema management, the SNMP replication MIB, Server Manager extensions, and management products available from SMTI member companies. Issues such as security, subset replication, push and pull propagation methods, and deferred RPCs will also be examined.
Abstract: 152 Title: Hacker Alert!: Protecting Your Data with Secure Network Services Author: Steven Viavant, Oracle Corporation
Hacker attacks on corporate information infrastructure are becoming a daily news item, even though most such incidents go unreported. The cost of such attacks is staggering. What is the best defense? This presentation will examine different categories of attack which can be perpetrated against all Client/Server applications, distributed databases, and replicated database. It will demonstrate how Oracle's Secure Network Services product protects against virtually all attacks. Secure Network Services, and add-in to SQL*Net, is available wherever SQL*Net is used, and requires no changes to existing applications. The presentation will address administration of the product for maximum security, migration and backward compatibility, and new features, such as network authentication and authorization, which will be available soon.
Abstract: 153 Title: Designer/2000 Generators: Hints and Tips Author: Mike Gwyer, Oracle Corporation
Desinger/2000 features generators for the Server, and Forms and Reports. This presentation will provide detailed hints and tips based on experience in the Designer/2000 development group. It will demonstrate how to get the maximum amount of generated code and the greatest flexibility from resulting generated applications, and how to get the best use of the most recently-announced generator products.
Abstract: 154 Title: Rapid Application Development, (RAD), Using Designer/2000 Author: Dai Clegg, Oracle Corporation, UK
The construction of applications using Rapid Application Development techniques has gained in popularity over the last few years. Using the approach allows users to build mission-critical Client/Server applications faster than ever before, but there are many factors to consider when constructing systems this way. This presentation will address the theory and the practice of RAD, using Oracle's Designer/2000 and Developer/2000 product sets.
Abstract: 155 Title: Designer/2000 Technical Update Author: Ian Fisher, Oracle Corporation
Designer/2000 introduces an extensive new set of modeling, repository, and generation facilities to the Oracle product line. This presentation will examine the development objectives of the product, explain its major features and functions, and will provide examples of how the product set is used to support BPR, Information Engineering, Rapid Application Development, and Design Recovery.
Abstract: 156 Title: Data Warehousing With Oracle's DSS Tools Author: Phillip Slater, Oracle Corporation
Data warehouses can be implemented using either open relational systems or proprietary vendors specializing in the market. This presentation will explore the benefits and drawbacks of both alternatives, and will demonstrate how using a sophisticated meta-layer and powerful front end tools enables users to perform rapid On-line Analytic Processing (OLAP), allowing drill down from summarized data to the detail atomic information.
Abstract: 157 Title: Oracle Data Query Author: Phillip Slater, Oracle Corporation
To access information held in complex database structures, a meta-layer is required to provide users with a business view of the information. Using Oracle Data Query, users are shielded from these complexities, allowing them to perform ad hoc queries and drill down analysis by asking business questions. This presentation will demonstrate how this meta-layer is set up, and will examine the powerful features of Oracle Data Query that enable users to perform Decision Support.
Abstract: 158 Title: Updatable Join Views Author: Atif Chaudhry, Oracle Corporation
Version 7.3 of ORACLE7 introduces updatable join views, which have more than one table in the from-clause and do not have set, aggregation, distinct, or connect-by operations. A certain class of such join views are not updatable -- they can be the target of UPDATE, DELETE, and INSERT operations. This presentation describes the class of updatable views, and how the application developer would typically use them.
Abstract: 159 Title: Oracle7 Parallel Server Tuning Author: Anjo Kolk, Oracle Corporation
Oracle 7.2 added new OPS performance features, (freelist groups on indexes, for example, and elimination of the need for pre-allocating extents to freelist groups). This presentation will demonstrate the impact of the new features, and will explain new ways to look at the performance with the CATPARR.SQL views and V$SESSION_WAIT tables.
Abstract: 160 Title: Oracle Parallel Query Architecture and Directions Author: Andrew Mendelsohn, Oracle Corporation
Oracle's Parallel Query Option is the only parallel query product designed to take advantage of the best features of what are commonly called shared-disk and shared-nothing software architectures for massively parallel, and clustered hardware platforms. This presentation will explain how PQO's unique approach is superior to pure shared-nothing implementation in terms of robustness, scalability, manageability, and harmony with emerging trends in storage technology. Future directions for the product will also be examined.
Abstract: 161 Title: Understanding Query Tuning through Understanding Database Internals Author: Dave Bayard, Oracle Federal
Usually, the Oracle kernel is treated as a black-box, hiding its inner workings; SQL is sent to the database, processed, and returned. Although this approach can be effective, knowledge of the internals is important when tuning is concerned. For instance, SQL queries often allow several approaches to return a query's data, and these different execution plans result in a wide range of performances. This presentation will demonstrate a simple model of the physical processing of queries by the Oracle database. Based on the model, cost estimates of the required resources for any execution plan can be developed. Better understanding of the behind-the-scenes execution makes SQL tuning easier. Attendees will learn hints and tricks adjusting the behavior of the Oracle optimizers.
Abstract: 162 Title: On Plug and Play SQL*Net Author: Dimitris Nakos, Oracle Corporation
Simplified network configuration is a central theme in the forthcoming SQL*Net Release 2.3. The new Plug and Play Server simplifies configuration of clients, servers, listeners, and multi-protocol interchanges, and allows for network changes on any service to be dynamically known by all interested clients. This presentation will outline the architecture of the Plug and Play Server with special emphasis on features that allow services to contact it for registering their addresses, clients to use it for resolving service names and aliases, network and database administrators to maintain it, and third parties to incorporate it in management applications for distributed Oracle environments. The presentation will also address migration from previous versions of SQL*Net to Plug and Play SQL*Net, propose general upgrade strategies, and examine characteristic migration case studies.
Abstract: 163 Title: Enterprise OLTP: Architecture, Directions and Issues Author: Frank Clugage, Oracle Corporation
Oracle will support customers who are expecting to implement larger (in number o
Abstract: 164 Title: Case Studies of Backup & Recovery with Oracle7 Release 7.1 & 7.2 Author: Rama Velpuri, Oracle Corporation
This presentation will examine real-life case studies of media failure and recovery procedures. The case studies will demonstrate rapid database recovery, recovery procedures using Release 7.2 and "resizable" data files, checkpointing, hot backup, and log switching.
Abstract: 165 Title: Performance Tuning and Optimization of Oracle7 for Sun Solaris Author: Michael Sakayeda, Oracle Corporation
Sun Servers running Solaris are the most popular Oracle database servers. Oracle7 and Sun's continuing association allows customers to reap the benefits of running Oracle7 optimally on Sun computer systems. This presentation will examine tuning Oracle7 in relation to Sun and tuning Solaris for Oracle7. It will explain how to identify bottlenecks in application with various utilities and system tools, how best to alleviate them, and will address Sun-specific enhancements for Oracle7.
Abstract: 166 Title: Capacity Planning and Tuning of Oracle Financials on Sun Author: Cindy Lim, Oracle Corporation
Proper capacity planning and tuning of Oracle Applications on Sun Solaris can provide a computing environment that will run smoothly for the planned number of users and workload. This presentation will use an actual, audited benchmark developed by Sun and Oracle to explore Oracle Application architectural features and workload that influence hardware sizing. Basic system and Oracle tuning tips will also be addressed.
Abstract: 167 Title: Objects Reusability: The Secret of Rapid Application Development Author: Andrew Lachanaris, Humanic Design Corporation
The demand for more efficient tools and techniques for rapid application development is increasing as organizations move their business applications into a Client/Server environment. The secret of rapid application development lies in object reusability, which eliminates the need to re-create objects in different applications. This presentation will explain how to design new applications by applying the principles of object reusability successfully, and how to use Oracle Forms 4.5's tools and facilities for rapid application development.
Abstract: 168 Title: Maximum Performance and Recoverability on a 1,2,3 Disk System: A Reality Check Author: Mark Staples
In a perfect world, all Oracle systems would have 22 disks with which to distribute database files optimally. In the real world, more and more database processing is done on stand-alone and work group-size systems. Little information is available about database file distribution over a small number of disks. Most DBAs know how important database file distribution is to overall database performance, but they do not consider it in recovery planning. Correct file distribution lowers the chance of failure and lowers average recovery time. IS budgets are shrinking, and many DBAs and developers must implement and administer applications with less-than-ideal hardware. This presentation will provide simple guidelines for achieving maximum performance on low-end systems, and for enhancing database recoverability.
Abstract: 169 Title: Tuning & Sizing UNIX Systems Running Financials: Manufacturing Applications Author: Tom DiPasquale, Xerox Corporation
This presentation will describe the current hardware/software configuration used at Xerox, review a benchmark study in which Xerox examined 45 software/hardware configurations using Oracle applications, explain how tuning both hardware and software can improve performance, and highlight the importance of disk configuration and placement of datafiles in relation to Oracle applications.
Abstract: 170 Title: Using the Data Dictionary to Automate the Construction of Backup and Recovery Scripts Author: Frank Ress, Argonne National Laboratory
Information in the data dictionary always reflects the most up-to-date database structure. Using that information to drive the creation of backup scripts helps to insure that backups are always complete and accurate. While most competent DBAs insure that adequate backups of the database are created to meet the demands of their environments, it is unlikely that many take the time to prepare recovery scripts as well. If recovery is necessary, the DBA generally resorts to manual means. Recovery will almost certainly be delayed as the DBA decides what steps must be taken, and the pressure to recover as quickly as possible means that mistakes may be made. Most failure scenarios are predictable, and the steps required for recovery can be determined in advance. This presentation will explain how recovery preparations can also be automated using the dictionary data, and how to guarantee that recovery operations are as rapid, complete, and accurate as the backups themselves.
Abstract: 171 Title: Database Packages, Procedures, and Triggers: When and How to Use Them Author: Frank Ress, Argonne National Laboratory
Since triggers, procedures, and packages are all constructed using PL/SQL, they share several underlying similarities. New or casual users may be uncertain which tool to use in a particular situation. This presentation will explain the tools and their capabilities, compare and contrast their features, and suggest which tools are appropriate in various conditions. It will also illustrate how to use the tools to coordinate SML operations between two tables and generate an audit table.
Abstract: 172 Title: Optimizing Oracle Queries Author: Dan Sweeney
Using examples from a production Client/Server application, this presentation will compare the Oracle rule and cost-based optimizers, explain how statistics are generated and used to optimize queries, explore various query structures, and demonstrate the performance of comparable SQL statements. The pros and cons of indexes, and how to insure that they are used when they should be, will be addressed. The presentation will also examine other optimization techniques, including the use of Oracle hints and the Alter Session command, evaluate strategies with the Explain statement, and, using the results of a performance test, benchmark different run times among queries.
Abstract: 173 Title: It's Not Magic, It's Done with Mirrors Author: Eric Mansfield, Eastman Kodak
This presentation will examine the use of disk-mirroring and the hot-backup to create a back-up and recovery procedure, and will introduce an automated process to complete the back-up procedure. The presentation will address both the system administration and the DBA tasks involved in the process.
Abstract: 174 Title: Oracle Server for NetWare SMP: Delivering on Promises Author: Larry Robinson
This presentation will explain the technical aspects of NetWare SMP architecture and examine its advantages as a Database Server Platform. It will also demonstrate the Oracle Server implementation for NetWare SMP, provide early scalability and performance data, and examine customer experiences during the beta program.
Abstract: 175 Title: Migration from AS/400 to Open Systems with Oracle Author: Karlheinz Peter
This presentation will demonstrate successful ways for AS/400 software warehouses and end users to switch into an Open Systems environment based on the Oracle Database with Client/Server and GUI technologies. The possibilities vary from one-time migrations to multi-platform strategies based on existing AS/400 RPG, CL, and COBOL application code. The presentation will explore the difficulties of migrating a record-oriented application to the set-based RDBMS Oracle, demonstrate tuning techniques, and explain how to improve database programming techniques.
Abstract: 176 Title: Integrating Oracle Office and Oracle SQL*TextRetrieval Author: Gustavo Suarez, Oracle Costa Rica
Oracle Office and Oracle SQL*TextRetrieval's information management capabilities can be incorporated into applications developed for a specific purpose. This presentation will describe the Application Program Interface included with the products, provide an example of a C application that integrates them, and demonstrate how an Oracle Office user could store and retrieve messages to and from a document database managed by Oracle SQL*TextRetrieval.
Abstract: 177 Title: Understanding DB_BLOCK_SIZE: A Critical Configuration Parameter Large Oracle Database Performance Author: Allan Edwards, Kendall Square Research
This presentation will address the significance of the DB_BLOCK_SIZE INIT.ORA parameter, and will explain a process for determining appropriate values for specific applications. Performance of large Oracle7 applications can be affected by orders of magnitude by varying this parameter setting.
Abstract: 178 Title: Integrating Oracle7 and Lotus Notes Author: Christian Schock, Oracle Corporation
For the past year, since their strategic partnership was announced, Oracle and Lotus Development have been jointly developing products and technology to integrate Oracle7 and Lotus Notes. This presentation will explain how Oracle products and Notes can be integrated by Developer/2000 access to the Notes Object Store, Notes application access to the Oracle7 database, and Oracle7/Notes data replication services.
Abstract: 179 Title: The Enterprise on Your Desktop: Crossing the Information Author: Mani Subramanyam
This presentation will address key products available for such common application requirements as data replication, distributed application configuration, and management. It will compare Oracle and third party products in terms of cost of implementation, performance, scalability, complexity, and other key aspects, and will describe products, technologies, and solutions of interest to end users, who need fast, effective access to distributed, corporate data, and to central IT staff, who are being challenged to manage increasingly complex environments and larger end user bases with fewer resources.
Abstract: 180 Title: Workgroup/2000 Database Product Directions Author: Nimish Mehta, Oracle Corporation
Early in 1995, Oracle announced the Workgroup/2000 family of low-end database and application development products. Continued enhancement of the Workgroup/2000 database products is the cornerstone of Oracle's commitment to workgroup, desktop, and mobile data management. This presentation will explain Oracle's low-end server strategy and how that strategy will manifest itself in Oracle's product plans over the next year. Details of Oracle's current Workgroup/2000 database product family and planned enhancements will be provided, with extensive coverage of Personal Oracle7 Workgroup Server. The presentation will examine Oracle's perception of low-end operating system platform viability, and Oracle's plans to support specific low-end operating environments with Workgroup/2000.
Abstract: 181 Title: Sizing Oracle on NT, Netware, and SCO Author: Steve De Luca
Sizing an application system that is designed but not yet developed can be time-consuming, and often inaccurate. In the past, users often had to master complicated equation sets, or rely on costly "experts". This presentation will explore the development and benchmark testing of the Oracle Sizing Tools for Compaq Proliant Servers, their usage, and how to interpret the extrapolation data derived from these tools. Supporting performance documentation will be supplied, including a "how to" guide for using the tools in the Windows NT environment.
Abstract: 182 Title: An In-Depth Look at Oracle's National Language Support Architecture Author: George Chang, Oracle Corporation
This presentation will examine the technology that Oracle uses to support the internationalization of products that are used in multilingual environments -- Oracle National Language Support Runtime Library, the foundation for the internationalization of Oracle software. The presentation will explore separating language-dependent data from language-independent functions, national language convention and linguistic definitions, encoding schemes, and character and string manipulations.
Abstract: 183 Title: Oracle's Direction in Object Modeling and Development Tools Author: Steve Muench, Oracle Corporation
This presentation will explore the reasons for the success of projects based on Object Oriented methodologies, explain the importance of interactive two-way tools for putting such methodologies to the test in real-life application modeling and assembly, and describe implementations being developed by Oracle for future delivery.
Abstract: 184 Title: Forms 4.5: Oracle Strategies for Cross-GUI Development Standards Author: Tech Choo Tan, Oracle Corporation
This presentation will explain why developing GUI standards is important to end user acceptance of an application, examine how Forms 4.5's new features -- including Object groups and property classes -- allow developers to implement consistent standards across modules in a project, and illustrate how Forms 4.5 developers can leverage the research and standards development work done by Oracle's Application Development group in their own applications at home.
Abstract: 185 Title: From the Desktop to the Warehouse: Strategies for Design and Implementation of Databases of Different Sizes Author: Dennis Murray, Oracle Corporation, UK
Because databases can now vary in size from kilobytes to terabytes, the strategies for designing and implementing them will vary. By comparing the problems faced by those that have to design and implement databases of differing sizes, insight can be gained into some of the fundamental issues that apply to databases of each size range. This presentation will examine such issues, in order to produce a set of questions that must be answered by anyone about to design and implement a database.
Abstract: 186 Title: Directions in Oracle Networking Author: Mark Jarvis, Oracle Corporation
This presentation will provide information about the future direction of Oracle Corporation's networking products.
Abstract: 187 Title: Migrating to SQL*Net V2 Author: Mark Jarvis, Oracle Corporation
This presentation will provide information about the future direction of Oracle Corporation's SQL*Net products
Abstract: 188 Title: Tuning Oracle's Parallel Query Option for Maximum Performance Author: Gary Hallmark, Oracle Corporation
This presentation will provide information about tuning databases using the Parallel Query Option for maximum performance.
Abstract: 189 Title: How to Troubleshoot Your Oracle Network Author: Paul Jackson, Oracle Corporation
This presentation will explore methods for problem determination and resolution in networks supporting Oracle clients and servers.
Abstract: 190 Title: Getting Started With Personal Oracle7 Author: Dave Kreines, Relational Technolgies
Personal Oracle7 is a powerful and useful product that no Oracle developer or DBA should be without, and it has a great number of advantages for the experienced Oracle user and beginner alike. This presentation will provide a "jump start" into Personal Oracle7 and its accompanying suite of GUI administrative tools. Tips and Techniques to show how PO7 can be much more than just another PC database will be provided as well.
Abstract: 191 Title: Objects for End Users: An Intuitive, Interactive Environment for Accessing Business Information Author: Robert Vollum III
The key to business users successfully accessing data is to organize and deliver it in familiar business terms. This presentation will address the differences between business users' and ISs' approaches, examine simplified and intuitive descriptions of business data, and explore business and technology requirements for information access versus data access.
Abstract: 192 Title: As Time Goes By...Building A Temporal Database Author: Michael David Burnside, Oracle Systems (Australia) Pty Limited
Most databases represent the state of data in current time. By contrast, a temporal database preserves the history of each object and provides the opportunity for time-based data analysis. While sophisticated temporal database models are becoming an important research area, the features of Oracle 7.1 can be used to simulate some of their functionality. This presentation will address the design and implementation of a database that can answer such questions as: "find the salary of King when he was managing Smith", and "who was the immediate successor of Clark". Queries of this type can significantly enhance the power of DSS Applications.
Abstract: 193 Title: Oracle Rdb: Database Server for Your Enterprise Author: Steve Hagan, Oracle Corporation
Development of the Rdb product line continues. This presentation will provide an overview of version Rdb V6.1 and will address current work on Rdb V7.0. Attendees will learn about product achievements and work in progress to enhance the product.
Abstract: 194 Title: Launching Object Oriented Programming within Oracle Forms 4.5: What Every Forms Developer Needs to Know Author: Sohan de Mel, Oracle Corporation
The Object Paradigm, or the Object Model, is a fundamentally different way of approaching the processing of business information. Object Oriented programming is a simple way of looking at problems and creating highly maintainable, easily modifiable, and relatively bug-free applications. Oracle Forms 4.5 includes many improvements in productivity, usability, and maintainability, which are a natural extension of the new Object Oriented facilities that are integral to the development environment in Oracle Forms 4.5. This presentation will explain practical ways to implement the Object Oriented concepts of inheritance, object re-use, encapsulation, modularity, and polymorphism in Forms 4.5, and will explain how to modify large applications easily. The presentation will address utilizing property classes, drag and drop object inheritance, trigger inheritance, object groups, and PL/SQL application libraries to allow for a more pragmatic approach to implementing and maintaining mission-critical applications.
Abstract: 195 Title: Mobile Applications: Automating the Rest of the Corporation Author: Jay Verkler, Oracle Corporation
Considerable productivity gains can be realized now that information systems can
be used in the field by mobile workers. This presentation will examine aspects
of mobile technology, including: enabling technologies, (dialup, LAN, wireless,
and disconnected methods of communication, software tools, runtime
technologies); architectural extension, (extending Client/Server,
Client/Agent/Server analogs in three-tier systems); and applications,
(disconnected, store and forward, asynchronous interactions, picklist and data
sychronization, management and administration in a distributed environment).
Real-world examples and case-studies will be used.
Abstract: 196 Title: Systems Management: Myth and Reality Author: Jay Rossiter, Oracle Corporation
This presentation will explore enterprise systems management requirements and technologies. It will examine present and future technology trends in network management standards, platforms, frameworks, extensible agents, and monitoring and analysis tools. Attendees will learn to see through the hype associated with many platforms and discern their real capabilities.
Abstract: 197 Title: Writing Mobile Applications Author: Larry Neumann, Oracle Corporation
Writing mobile applications is different from writing other applications. The
nature of the underlying networks -- slow wireless networks, or disconnected
dialup connections -- must be considered, and the applications themselves are
asynchronous in nature. This presentation will demonstrate how to design and
implement a mobile Client/Agent/Server application. It will: describe the
application paradigm, (explaining how and why mobile applications are different
from LAN applications), and the Client/Agent/Server architecture,
(explaining the major components in a mobile application solution); define the
application characteristics, (transactional applications, asynchrony,
event-notification); implement transactions to the client and server side
programmatic interface; and build and execute a simple wireless. The
application will be built in real time, so that attendees will observe theory
and techniques as they are applied.
Abstract: 198 Title: Designer/2000 and BPR Author: Jocelyn Hartland-Swann, Oracle Corporation, UK
Designer/2000 introduced the Process Modeler, which provides a rich set of capability to model business processes. This presentation will explain how to approach a BPR activity and how to the use the tools effectively. It will describe both the theory of BPR and its support by the Process Modeler, using real case studies. Planned extensions to the product beyond Designer/2000 will also be addressed.
Abstract: 199 Title: New for Oracle7: Oracle Expert Author: Kenneth Morse, Oracle Corporation
This presentation will provide a product overview of Oracle Expert, which will arrive with Oracle Server release 7.3. The overview will demonstrate how to use the tool to collect tuning data from the database environment, to evaluate the information collected, and to implement successfully the changes recommended by Oracle Expert.
Abstract: 200 Title: Using Oracle CDE for Rdb Author: Will Anderson, Oracle Corporation
This presentation will demonstrate how Rdb users can use Oracle's complete set of integrated lifecycle application development tools, the Oracle Cooperative Development Environment (CDE) to empower end users, programmers, and developers to work together to build mission-critical Oracle Rdb information systems.
Abstract: 201 Title: Rdb V7.0 Performance Optimization Author: Rick Anderson, Oracle Corporation
This presentation will provide up-to-date information about performance optimization. Rdb engineers will explain improved index, AIJ log shipping, and OSF/1 cluster support.
Abstract: 202 Title: Oracle Direction: Enterprise Software Distribution and Management Author: Michael Pacholec, Oracle Corporation
Building installation programs for Client/Server database applications and deploying those applications at the installation site is a complex task. Few tools are available to help. This presentation will review problems to consider when deploying Client/Server applications and introduce the suite of tools being prepared by Oracle which will provide the functions, interfaces, and implementation of enterprise-wide lifecycle management of object-based applications.
Abstract: 203 Title: Ways to Improve Rdb Database Performance Author: Zia Mohamed
This presentation will provide tips and techniques for improving performance in the Oracle Rdb environment.
Abstract: 204 Title: Are Distributed Systems a Reality? Compaq and Oracle Directions Author: Bonnie Crater, Oracle Corporation
Distributed database technologies are here. What's missing are the tools to easily deploy and manage a branch automation application. This presentation will discuss and demonstrate the Oracle/Compaq joint development projects designed to integrate low cost PC server systems with Oracle's new "Battlestar" technologies.
Abstract: 205 Title: Personal Oracle7 Enterprise Edition on Windows '95 Author: Denise Lahey, Oracle Corporation
An increasing number of users want to develop distributed applications on the desktop and deploy them on a variety on hardware/software platforms. Personal Oracle7 enterprise Edition on Windows'95 gives users the ability to have full distributed functionality on the desktop to data anywhere in the Enterprise. This presentation will focus on the new features of Personal Oracle7 on Windows '95, the benefits realized by using Windows '95, and discuss examples of using replication, distributed updates, and queries on the desktop by mobile users. The ability to easily migrate data from flat-file systems to Oracle7 will also be demonstrated and discussed.
Abstract: 206 Title: Developer/2000: Reports 3.0 Directions Author: Per Brondum, Oracle Corporation
This presentation will present a first look at the new features and direction of Oracle Reports Version 3.0, including a detailed look at the new document-centric features that allow easy implementation of the most common types of reports. Integration with Windows '95 will also be discussed.
Abstract: 207 Title: "Battlestar" -- Making Client/Server Environments Plusg-and-Play Author: John Morrell, Oracle Corporation
This presentation will introduce Battlestar, a new Oracle product for managing the distributed client/server environment. Battlestar combines all the needed administration facilities for client/server management into one product, including database/application administration and software management. This presentation will discuss what Battlestar is and how it can help make client/server environments more manageable.
Abstract: 208 Title: Developer/2000 and Sedona: Oracle's Application Development Tools Author: Sohaib Abbasi, Oracle Corporation
This presentation will describe Oracle's plans for application development tools, including Developer/2000 and Object tools code named Sedona. This presentation will describe the features planned for the upcoming releases of Developer/2000 that includes Oracle Forms, Reports and Graphics, and will describe the goals of our Object project, Sedona. Topics discussed will include the integration between Sedona and the Oracle8 Object Model, as well as between Sedona and Developer/2000.
-- _____ ________ / ___ |Tony Jambu, Database Consultant /_ _ /_ __ / |Wizard Consulting,Aust (ACN 065934778) /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559 \_______/ |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905Received on Thu Jul 06 1995 - 00:00:00 CEST