|
FALL
2002 ATLANTIC OTC PRESENTATIONS
by Topic
Business
Intelligence
This
presentation will provide step-by-step instructions for developers
and users who are interested in enhancing their Discoverer applications
by leveraging the powerful features of Oracle9i. It will address
analytic functions from business intelligence and data warehousing
applications, summary management functionality using materialized
views maintained in an Oracle9i database, access to non-Oracle
data sources, and adapting existing database security models for
safeguarding Discoverer 9iAS applications. Specific business
scenarios and customer examples will be included.
Back to top
| Distributed
Indexing for Enterprise-Wide Performance |
| David
Griffee |
|
The
techniques of distributed indexing can be applied across multiple
DBMS nodes throughout the enterprise to provide extreme performance
and unlimited scalability to support any application. In this presentation,
attendees will learn advanced architectural tricks to create a powerful,
cross-correlated, multidimensional indexing metadatabase system driven
directly and automatically by dynamic business requirements. The
presentation will also cover how autonomous mobile indexing agents
use simple Java/XML API's to create the effect of a self-reinforcing
systemic behavior from which new business value insights emerge.
The qualitative experience is an amazing responsiveness that seems
to get "smarter"
the more it is used, and the distributed architecture actually performs
better the more it is scaled upwards.
Back to top
Data
Warehousing
Key
internal and external customer information is central to developing
successful marketing and general business strategies. However, lack
of an integrated, standardized, and consolidated view of these customers
presents a challenge. This presentation will be a case study on the
use of name and address cleansing techniques to merge and consolidate
internal and external business information to provide a 360 degree
view of the customer. It will cover database design, performance
techniques, and process considerations. Finally, it will show how
organizations can use the geocode option to spatially enable access
to your customer information through reports and queries.
Back to top
This
presentation will provide a demonstration of external table usage,
a review of the performance implications, and implementation recommendations
for data warehouses and data marts.
Back to top
This
presentation will be a step-by-step demonstration of Oracle Warehouse
Builder (OWB) and how to build your data warehouse architecture with
the metadata created within the OWB tool.
Back to top
Database
Administration and Tuning
This
presentation will cover the use of DBMS_OUTPUT, DBMS_PIPES, UTL_FILE,
DBMS_PROFILER, and Java to monitor PL/SQL. Techniques for optimizing
PL/SQL code are also discussed.
Back to top
| Developing
Performance Applications in Oracle |
| Thomas
Kyte |
|
This
presentation will focus on the key areas all Oracle developers need
to understand, or be aware of, to develop scalable, high performance
applications. Techniques, things to look for, and necessary tools
will be discussed and demonstrated. For fun, various myths about
Oracle performance will be discussed, and more importantly, debunked.
Back to top
This
presentation will enable participants to appreciate the usefulness
of the Oracle Trace tool, used in conjunction with Enterprise Manager.
Statistics can be collected for all major database events and can
be filtered for a specific user.
Back to top
This
presentation will examine several of the Oracle data dictionary views
with emphasis on what they mean and how to use them. The composition
of Oracle9i views will be featured.
Back to top
Disaster
Planning/Security
| Easing
Management and Increasing Performance in an Oracle9i RAC
Environment |
| Ron
Fontanilla |
|
In
this presentation, attendees will learn to manage Oracle9i RAC
with the speed of Raw Partition and the manageability of File System.
With Storage Virtualization software, you can enable every node in
the cluster to view the same logical volume layout, in order to increase
the size of a volume or file system with no downtime to the user.
It is also possible to see Oracle access data files stored on the
Cluster file system via the ODM interface, essentially bypassing
the file system buffer cache and internal file system locking and
allowing asynchronous I/O. This results in high availability, volume
management on the fly, and increased performance of your Oracle Database.
Back to top
Oracle
databases are a core component of enterprise systems, and as such
they house some of an organization's most valuable assets. This presentation
will discuss how hackers are attacking databases and how to prevent
this from happening to your database. It will demonstrate several
live attacks and show you how to thwart them.
Back to top
Data
Guard is Oracle's answer to a disaster at your data center as well
as a method to minimize planned downtime. This presentation will
discus the uses of Data Guard and give a technical description of
how the product works and the ways it can be configured for different
disaster recovery needs.
Back to top
JDeveloper, Java and
XML Development Tools
| JDeveloper,
Java, and XML Development Tools Parlez-Vous XML? |
| Chris
Bowlds |
Intermediate |
Attendees
will learn how to use the XML SQL Utility (XSU) from PL/SQL, Java,
or command line to extract data using select statements as XML and
perform insert/update/deletes in the database from XML data input.
The XSQL servlet, a Java servlet interface to the XSU for Web accessibility,
will also be presented. Finally, a simple introduction to Extensible
Style Language Transformations (XSLT) for transforming XML into other
formats, such as HTML and PDF, will be provided.
Back to top
Attendees
will learn how to use Extensible Style Language (XSL) stylesheets
to transform XML into other formats, including reformatted XML, HTML,
PDF, SVG, SQL, and more. The benefits of separating content from
presentation, which this allows, will be discussed. A basic knowledge
of XML is assumed.
Back to top
This
presentation will provide a comparison of Java language with PL/SQL.
It will focus on the differences and similarities between the two
languages.
Back to top
In
this session, attendees will learn about the latest and greatest
XML features in Oracle9i Release 2, known as Oracle XML DB.
XML DB provides native XML storage and retrieval capability as well
as an XML Repository that provides foldering, access control, and
versioning for XML resources.
Back to top
JDeveloper
9i represents a significant change from the 3.2 version with
many new features including UML, configuration management, and expanded
JSPs. Participants will learn what new features are worth investigating
and which ones are still immature.
Back to top
This
presentation will provide an architectural overview of Oracle's Business
Components for Java (BC4J) , discuss some of its flexibility, and
present two examples of very different application development styles
currently in use by different development teams.
Back to top
Participants
will learn how to develop database programs and applications using
Java stored procedures, with emphasis on performing operations involving
the operating system and file system outside of the database environment.
A comparison will be made between Java stored procedures and external
procedures, including environment set-up, security, and performance.
Back to top
Attendees
will learn the Java syntax necessary to query and update Oracle table
data as well as to execute Oracle stored procedures and functions.
In addition, many of the more important Oracle extensions to standard
JDBC are explored and explained.
Back to top
The
transition from PL/SQL to Java is much more than just learning a
new syntax; it is primarily a transition from procedural programming
to object-oriented thinking. Find out what it takes to make this
significant leap and why it is worth the effort.
Back to top
This
presentation will cover obtaining the SQLTags source code and documentation,
an overview of the SQLTags functionality, running the SQLTags generator,
essential components of an SQLTags page, querying the database, manipulating
data, helpful features, and built-in tags.
Back to top
Oracle
Applications
This
presentation will review the success story of MICROS systems utilizing
Oracle9i Enterprise Manager and the Oracle Applications add-on
to manage both their Oracle databases and applications. It includes
the technical details involved in setting up OEM plus a discussion
of many out-of-the-box management summaries and reports. Special
emphasis is given to tools and techniques for tuning the concurrent
manager.
Back to top
Oracle
Development Tools
Currently
Designer 6i allows only one spread table to be generated per
content canvas. Using Dynamic SQL and Developer Transactional Triggers,
this presentation will show one way to overcome this limitation,
enabling you to reuse a single spread table for any number of tables.
Back to top
This
presentation will offer Java and Oracle code examples to show how
to build an interface between a J2EE Web application and an Oracle
database. It will include Java data interface classes. Familiar and
new Oracle 9.2 and PL/SQL features to provide a technique for data
abstraction and DML processing will also be discussed.
Back to top
This
presentation will discuss the various technical issues relating to
the administration of Oracle9i Application Server Release
2. It will briefly cover installed products, troubleshooting, and
maintenance methods.
Back to top
Oracle8i and
Oracle9i Features
This
presentation will demonstrate the use Oracle's new XML DB facility
and the use of the new XMLType datatype and its supporting functions.
It will also discuss using Xpath to search XML documents stored in
the database, the support for XML Schema, and the piecewise updating
of XML documents stored in the database. The presentation will conclude
with a glimpse of the new XQuery prototype.
Back to top
This
presentation will cover how to write application modules that execute
unattended. It will include methods to load or transmit data overnight,
print reports, send e-mails, or reorganize the database for better
performance. Special consideration will be given to the DBMS_JOB,
and DBMS_SMTP built-in packages and external procedures. Examples
given will be in PL/SQL and in C.
Back to top
Oracle
provides exciting new features in its most fundamental statement
- SELECT. This presentation will focus on these capabilities and
the new possibilities they open for developers and DBAs.
Back to top
Attendees
will be introduced to new and improved features of Oracle9i (9.2)
that directly impact application development. Special emphasis is
placed on features that reduce development time, make development
simpler, improve performance, or improve deployment. Attendees will
be better equipped to create applications that take full advantage
of Oracle9i.
Back to top
This
presentation will be directed toward the intermediate DBA who needs
techniques on optimizing query performance on large tables. Practical
examples of a successful implementation of table partitioning will
be provided.
Back to top
The
presentation will cover a brief history of Oracle Text that demonstrates
why Oracle Text's tight integration leads to faster development time
and easier administration. The query language will be covered, at
a high-level, to illustrate simple and some of the more advanced
search concepts. And finally, the thesaurus and the gist and highlight
functions will be introduced.
Back to top
This
presentation will help attendees to understand high availability
(HA) and linear scalability (LS). It will explain how the synergy
between hardware clustering and Oracle Real Application Clusters
(RAC) helps toward HA and LS with added improvements to performance.
Attendees will gain an awareness of situations in which RAC is suitable
for implementation and hear scenarios in which RAC is not the optimal
solution. They will also reach an understanding of various scalability
features such as fast reconfiguration, cache fusion, and cache fusion
recovery in RAC.
Back to top
In
addition to the alphanumeric data stored in traditional databases,
today's users want access to multimedia data including text, images,
audio, and video. This presentation will detail some of the issues
involved in building a multimedia database with Oracle interMedia.
Issues covered will include entering media files into an Oracle database,
indexing the data, efficiently storing the media segments, and content-based
retrieval of the data.
Back to top
| Oracle9i Data
Storage Impact |
| Thomas
Yarmas |
Intermediate |
This
presentation will discuss the experiences of implementing Oracle
Disk Manager on top of a direct access file system client, as well
as the benefits and pitfalls of using features of an Oracle9i database
such as Oracle-managed files, the internet file system, and the undo
tablespace.
Back to top
Web
Development and Deployment
As
you begin to develop your first portal applications, you realize
that there are many features users are looking for that were not
covered in the tutorial. This presentation will demonstrate how to
incorporate a variety of advanced techniques into your portal development
to build rich, functional applications. Some of the techniques will
include using a report as a list of values and returning selected
values to a form, tabbing from one field and populating other field
values on a form, and dynamically displaying buttons based on form
data. It will also demonstrate how these techniques can help you
overcome obstacles imposed by HTML and the portal wizards.
Back to top
In
this presentation, attendees will be given information about Oracle
Forms Services, steps of the development process, design considerations,
lessons learned, and tips for development that are not obvious in
any documentation. Code examples of many items discussed will be
shared. This presentation will prove to be a considerable asset to
anyone intending to carry a client/server application to a three-tier
architecture.
Back to top
This
presentation will discuss the process of WebServer migration from
OAS 4.0.8 to OWAS 9iAS, with insights on managing all the
applications that make use of new technology. It will give a detailed
look at the problems and solutions to issues related to administration
of the WebServer by experienced DBA personnel.
Back to top
This
presentation will start where many presentations on Oracle's 9i Application
Server (9iAS) stop - after the initial installation and configuration.
It will discuss the steps taken to deploy 9iAS for use with
Oracle applications (primarily Web forms) on two servers - one available
to internal users, the other for external (internet) users only.
It will also present the configuration, security, and tuning issues
associated with supporting both servers, including interactions with
routers, the Oracle database, additional Oracle software, and other
software such as e-mail.
Back to top
We
all know that security is of paramount importance in the development
and deployment of any working Web application, and it is particularly
important within Oracle Portal. This presentation is intended to
provide insight into the mechanics of OID and to highlight the new
user security within Oracle9iAS Portal v. 2. A checklist of
security procedures will be provided that will help you deploy a
secure working portal for your users.
Back to top
|
