| |
 |
| NYOUG is an Affiliate of IOUG |
NYOUG does not share its email list with any vendors or other organizations. You
may opt out of receiving our email blasts at any time by sending an email to
info@nyoug.org with "Remove" in the subject line.
| |
- 2008
- 2007
- 2006
- 2005
- 2004
- 2003
- 2002
- 2001
- 2000
- 1999
|
|
|
|
KEYNOTE:
Oracle e SOA Suite 11g - A Foundation Building Block for Oracle's Next
Generation Fusion Applications
This session provides an overview of the upcoming SOA Suite, and
introduces the concepts behind it, such as Service Component Architecture
and how it simplifies the end-to-end lifecycle management of SOA composite
applications. Application designers can now design, package, version, and
manage their SOA composite applications (Web services, BPEL, Enterprise
Service Bus flows, and the like) as one single entity, making it easily
available for reuse. This session will also discuss the challenges
associated with data and component integration while building Fusion
applications and explain concepts needed to get ready for Fusion.
Clemens Utschig works for the SOA Product Management team at
Oracle Headquarters, CA. As a native Austrian, he started his career years
back at the local consulting branch, helping customers define their next
generation J2EE and SOA architectures. Later, he founded the local Java
Community to spread knowledge and help consulting teams with the uptake of
Java for new projects. During his consulting years, he spent a year in
Switzerland doing crisis management for a large scale program, in Dubai
helping on ADF BC issues for the government and giving workshops all around
Europe. Since his transfer some 2 years ago into the Product Management
group, Clemens is responsible for cross product integration and is now the
advisor for SOA to Oracle Fusion Applications development, helping to build
the next generation standard software suite. Clemens is also an advisory
member of the Applications Architecture Board. He is a frequent speaker at
worldwide conferences (Oracle Open World, JAX, OOP, ODTUG) and has published
countless articles in known industry journals on SOA and related challenges.
Back to Top
|
|
DBA TRACK: Application diagnostics for DBAs – JVM Visibility
DBAs are not responsible for just databases any more. Most DBAs are
also responsible for the entire production application performance
including the middle-tier. Often they are challenged with the
performance problems caused by the Java middle-tier. DBAs do not have
enough tools to gain visibility into the production applications to
identify the root cause of performance problems. To resolve performance
problems, they depend on developers and architects who reproduce and
diagnose the problems in the development environment. Reproducing
problems in non-production environments is difficult, time consuming and
increases the problem resolution time drastically.
This session focuses on diagnosing application problems in production.
It shows how to diagnose database problems caused by the middle-tier and
how to perform expert level Java diagnostics without much Java or
application knowledge.
Rajagopal Marripalli is a principal product manager in the
Oracle Applications and Systems Management division. His primary focus
has been in the area of application performance management. He has more
than 12 years experience in the software industry in product development
and product management. He has published papers and articles as well as
presented technical seminars at conferences and user groups
Back to Top |
|
DBA TRACK:
Dynamic
SQL in a Dynamic World - The Sequel This presentation will cover
some of the less obvious issues that arise while using Dynamic SQL,
including: defining required privileges, preventing code injections,
targeting performance tuning efforts, understanding resource
utilization, handling object dependencies, etc. Examples will
demonstrate when, why, and how to use Dynamic SQL in real-world
situations in conjunction with other advanced features such as objects,
object collections, ref cursors, and bulk operations.
Michael Rosenblum is a Development DBA at Dulcian, Inc. He is
responsible for system tuning and application architecture. He supports
Dulcian developers by writing complex PL/SQL routines and researching
new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies
(Wiley Press, 2006). Michael is a frequent presenter at various regional
and national Oracle user group conferences. In his native Ukraine, he
received the scholarship of the President of Ukraine, a Masters Degree
in Information Systems, and a Diploma with Honors from the Kiev National
University of Economics.
Back to Top |
|
DBA TRACK:
Use of
DataGuard and Cold Failover Clusters
At my organization, we make extensive use of DataGuard, including an
international implementation (between two of our European locations).
This presentation will describe the practical use of DataGuard focused
on the differences between DataGuard and Standby databases. Time
permitting, the presentation will also include a discussion of Cold
Failover Clusters (aka, "a poor-man's RAC").
Jonathan Intner has been working with Oracle for over 17 years
and started in the dark days before the CREATE CONTROLFILE command --
even before there were tablespaces! He is not only an Oracle Certified
Professional but also a Certified Information System Security
Professional and (now) ITIL V3 Foundation Certified. He currently heads
the US DBA Group for one of the top generic pharmaceutical companies.
Back to Top |
|
DBA TRACK:
Manage
End User Experience with Enterprise Manager
Oracle Real User Experience Insight (UXInsight) enables enterprises
to maximize the value of their business critical applications by
delivering insight into real end user experiences. It can help identify
lost revenue from frustrated users, reduce support costs by lowering
call center volumes, accelerate problem resolution of poorly performing
applications, and help businesses adapt to changing needs by providing
insight into business trends and user preferences. This presentation
will explain how to manage end users’ experiences with your
applications, using Enterprise Manager products, identify performance
issues with your applications, as well as identify missed revenue
opportunities because of end user problems.
Nadu Bharadwaj is a Principal Product Manager in the
Applications and Systems Management group at Oracle HQ, with over seven
years at Oracle in various roles- from Consultant, DBA, Developer and
presently as Product Manager. He specializes in the areas of SOA
Management and User Experience Management. He has presented at several
Oracle events representing the Enterprise Manager suite of products.
Back to Top |
|
DEVELOPER TRACK:
Working with iBATIS in the Oracle Environment
The iBATIS Data Mapper framework makes it easier to use a database
with Java and .NET applications. iBATIS couples objects with stored
procedures or SQL statements using an XML descriptor. Simplicity is the
biggest advantage of the iBATIS Data Mapper over object relational
mapping tools. This presentation discusses how to use iBATIS with Java
in an Oracle environment. It discusses topics of interests to both Java
and Oracle developers.
Richard Ji is a Senior Manager, database engineering from
RealNetworks. He architected databases that handle over a billion
transactions per day and 27TB in size. He is also a past presenter at
NYOUG on "How to Build Your own Instantclient".
Back to Top |
|
DEVELOPER TRACK: Advanced SOA Suite Concepts & Tricks This
presentation will introduce advanced concepts of the SOA platform, from
transaction handling and fault policies to usage patterns of BPEL, ESB
and the service registry. The goal is to provide attendees with a solid
understanding of how the transaction model in BPEL works, and how it can
best be leveraged. Clemens will show how the Service Registry can be
used to dynamically discover and bind to services at runtime, rather
than hard-wiring the service consumer with the provider. The
presentation will also discuss common usage patterns for BPEL and ESB,
which is a topic often requested by those new to the platform. Finally,
Clemens will include an overview of what developers can expect from the
upcoming 10.1.3.4 release, what features are recommended to use it
efficiently, and its new diagnostic features.
Clemens Utschig works for the SOA Product Management team at
Oracle Headquarters, CA. (see full bio above)
Back to Top |
DEVELOPER TRACK:
JRE Cutover
for Oracle Forms
This presentation discusses the desupport of Oracle JInitiator in the
context of the widespread deployment of JDeveloper. The presentation
references several position papers from Oracle from the summer and fall
of 2007 which describe the way in which Forms will participate in the
BPEL-SOA landscape. Attendees will learn how to reconfigure forms to use
the generic Sun JRE instead of JInitiator, and also will be presented
with a comprehensive upgrade strategy designed to leverage their
existing Forms environment through use of PL/SQL wrappers for Java and
through forms which can register an interest in a BPEL event.
Gil Standen is the Founder and Managing Partner of Stillman
Real Consulting. Gil more recently has joined Rich Niemiec's company,
TUSC, in Chicago, IL as a Sr. Consultant. Gil has 12 years experience
supporting large Oracle enterprise deployments on all flavors of UNIX,
Windows, OS/390 and VAX/VMS and Novell OS platforms, including all
versions of Oracle beginning with Oracle 7.1.3.2.3 through 10gR2.
Back to Top |
|
DEVELOPER TRACK:
The Rise of
eDiscovery
Recent updates to the Federal Rules of Civil Procedure (FRCP) have
placed an increased burden on IT organizations to produce data as part
of a civil or criminal “e-discovery” request. If your company received
an e-discovery request today, would your IT organization have the
capability to retrieve the appropriate information and supporting
evidence to comply? Would you be able to meet the timeframes dictated by
law and civil procedure? With the rise of the “new data center” and
“paperless” application environments, most corporate data is managed
electronically. Improving the way in which you manage information and
being prepared for e-discovery simply makes good business sense. This
presentation provides an overview of the potential challenges that new
eDiscovery rules and regulations could pose for them their IT
organizations. It explores best practices to support data retention and
ensure compliance requirements for accessibility and production of data
within deadlines, and some case studies of how others have succeeded and
failed in implementing them.
Eric Offenberg, CIPP and Product Marketing Manager at IBM, has
established himself as a thought leader on data governance, database
archiving, enterprise data management and data privacy. With nearly 10
years of technology marketing experience across industries, Eric is a
regular speaker in live Webinars, industry events and with media and
analysts on behalf of IBM. He holds an MBA with a concentration in
marketing from Rider University and a BA degree in communications with a
concentration in public relations from Rutgers University.
Back to Top |
|
|
|
KEYNOTE:
PL/SQL Enhancements in Oracle Database 11g
• Transparent and
“knob-controlled” performance improvements;
• New language features that you use in your programs to get better
performance;
• New language features that bring functionality which you earlier couldn’t
achieve, or could achieve only with
cumbersome workarounds;
• New language features that improve the usability of programming in PL/SQL.
Bryn has made an unashamedly
personal selection of some of these features to describe in fair detail in
this
presentation. He used two criteria: his instinct-based ranking according to
their relative importance for customers;
and his judgment of whether attendees might appreciate some background that
they’re unlikely to find in other
accounts. For completeness, Bryn will finish by just listing the other
features and giving a skeletal account of each.
Bryn Llewellyn is the
PL/SQL Product Manager, Server Technologies Division, at Oracle HQ. He has
worked in
the software field for 30 years. He joined Oracle UK in 1990 at the European
Development Center in the Oracle
Designer Team. He transferred to the Oracle Text Team and then into
Consulting as the Text specialist for Europe.
He relocated to Redwood Shores in 1996 to join the Oracle Text Technical
Marketing Group. He has been the
Product Manager for PL/SQL since 2001. It’s hard for Bryn to remember his
life before Oracle. He started off doing
image analysis and pattern recognition at Oxford University and then worked
in Oslo, Norway, in the public sector
and in a startup. Bryn programmed in Simula (its inventors were his close
colleagues). This language was the
inspiration for Smalltalk and C++.
Back to Top
|
|
DBA TRACK:
The Secret to a
Successful Upgrade: Using Database Replay to Guarantee Success
Extensive testing is usually
performed to validate system changes such as database upgrades. However,
unforeseen
problems such as performance regressions often occur when the production
database is finally upgraded. This
presentation describes how you can significantly improve your chances of a
successful upgrade by using Database
Replay, a new feature introduced in Oracle Database 11g. Mughees will
describe, in detail, the internal architecture
of this feature, give practical examples of its usage, as well as discuss
general best practices for using Database
Replay.
Mughees Minhas is
responsible for the self-managing solutions of the Oracle Database with
special interest in
areas such as performance diagnostics, SQL optimization and tuning, space
management and load testing. He has
more than 12 years of experience working with Oracle databases and is
currently director of product management
in Oracle’s Server Technologies division.
Back to Top
|
|
DBA TRACK:
Overview of
TimesTen
TimesTen is a very popular, fast-growing product in the
Oracle suite. This presentation will walk through the
TimesTen feature set and discuss the path to implementation. Shig will cover
the cover the product features,
function, and implementation required for TimesTen as well as discuss
success stores and case studies.
Shig Hiura is a Senior Sales Consultant with
Oracle in the Embedded Global Business unit, serving embedded and
ISV partners who want to leverage Oracle technologies in their solutions. He
has over 15 years of experience in the
IT industry and has worked with the Oracle database since version 7. Much of
his experience includes work in the
Financial Services sector and work with Fortune 500 companies. |
|
DBA TRACK:
DUDE, Where’s my
Data?
It's a DBA's worst nightmare--the loss of data. Sure,
your backup scripts were well-tested and had some real cool
exception handlers in them. But now the time has come to recover your data,
and guess what? Those exception
handlers weren't so cool after all. Datafiles are missing, you're missing
archives, and hey, where did that system
tablespace go anyway? This presentation describes several real life
situations where Oracle database recoveries
went terribly wrong, resulting in a situation where using a data unloader
was the only option left to extract data.
The second part of the presentation provides an overview of how data
unloaders work. By briefly looking at the
block internals, it will show you how data can still be recovered, even when
the system is gone or the database can't
be opened. The data unloader “DUDE” is used as a case study.
Having administered, developed against, and consulted
on all versions of Oracle since version 7, Jonah Harris has
spent a considerable amount of time specializing in OCI, performance tuning,
and researching Oracle Internals.
When time permits, he provides support to the Database, Call Interface,
Instant Client, ODBC, PHP, Linux, SQL,
and PL/SQL community forums on OTN. |
|
DBA TRACK:
Protect Privacy
with Data Masking
The Data Masking Pack for Databases helps organizations
share production data in compliance with privacy and
confidentiality policies by replacing sensitive data with realistic but
scrubbed data based on masking rules. This
presentation discusses the two primary use cases for the Data Masking Pack:
1. DBAs want to take a copy of production for testing purposes and use the
Data Masking Pack to replace all
sensitive data with innocuous but realistic information and then make this
database available to developers.
2. Organizations want to share production data with 3rd parties.
This presentation will include a demo to show how to Mask data and maintain
referential integrity.
Nicholas J. Donatone is a Grid Sales Consultant
for Oracle Corporation. Nick has been working with Oracle
software since version 4 (1986). Nick is one of the founders of the New
Jersey Oracle Users Group (NJOUG) and
was president/co president of the NJOUG for more than 18 years. He is Vice
President of the Philadelphia Area
Oracle User Group (PHLOUG). Nick has made presentations at NYOUG, NJOUG,
IOUG, ODTUG, SEOUG and
Oracle OpenWorld. |
|
DEVELOPER TRACK: Doing SQL from PL/SQL: Best and
Worst Practices
The PL/SQL developer has many constructs for executing
SQL statements, and the space of possibilities has
several dimensions: embedded SQL versus native dynamic SQL versus the
DBMS_Sql API; bulk versus non-bulk;
implicit cursor versus parameterized explicit cursor versus ref cursor; and
so on. Deciding which to use might seem
daunting. Moreover, as new variants have been introduced, older ones
sometimes have ceased to be the optimal
choice. Oracle Database 11g has kept up the tradition by bringing some
improvements in the area of dynamic
SQL.This presentation examines and categorizes the use cases for doing SQL
from PL/SQL, takes the Oracle
Database 11g viewpoint, and explains the optimal approach for the task at
hand.
Bryn Llewellyn is the PL/SQL Product Manager,
Server Technologies Division, at Oracle HQ. (See full bio above) |
|
DEVELOPER TRACK:
Forms to Fusion
This presentation reviews the current Forms landscape
and options Forms users have in regard to their existing
investment. Ernst will review when to upgrade or convert, what role ADF
plays in Forms applications, and what
technologies will come into play in an SOA environment. This presentation
will also discuss how to understand your
current state environment and map it to a practical, workable, future state.
This session will provide insight into
making thoughtful decisions regarding the advancement of a Forms
application.
Ernst Renner is CEO of Vgo Software, a leader in
the modernization of client/server applications. In addition to
leading Vgo, Ernst is managing partner at NEOS, a services company he
started in 2000, specializing in enterprise and
information architecture services. He brings over 15 years of
high-technology experience to the table in database and application
technologies. |
|
DEVELOPER TRACK:
Value of Embedding Oracle Technologies
95% of Oracle user do not know that they could
potentially embed Oracle technologies saving them money and
implementation effort. Participants will learn the value of embedding, how
to embed, and which Oracle products are
“embeddable.” Mel will cover the basics of embedding and the implementation
required. The presentation will
include descriptions of case studies and success stories.
Shig Hiura is a Senior Sales Consultant with
Oracle in the Embedded Global Business unit. (See full bio above) |
|
DEVELOPER TRACK: Two 30-minute presentations
A.
Oracle Instant Client
for Windows
Oracle Instant Client allows you to run your applications without installing
the standard Oracle client, while using
significantly less disk space than before. Even SQL*Plus and ODBC can be
used with Instant Client. This
presentation demonstrates the easiest way to connect to a remote Oracle
database, requiring light installation of small
libraries on Windows using Oracle Instant Client on Windows XP.
Eunhee Lee is a Senior Database Architect at ReturnPath Inc. in New York
City with over 10 years of Oracle
Database and software development experience. She earned her Master's Degree
in Computer Science and
Engineering at HongIk University, South Korea and New York University.
B.
Consensus and the Collaboration Method
Accessing data is a core aspect of any n-tier software system. From a
traditional software development lifecycle
point of view, there are three popular ways in which the application
developer works with the emerging
schema/database:
1. The Developer may have carte blanche to dictate the type of tables/views
to be built and/or accessed.
2. The database tables/views have already been fully implemented via the
Data Architect and the DBA. Therefore,
the developer must do his or her best to work with what has been put into
place.
3. Collaboration and consensus between the Application Developer(s), the DBA
and the Data Architect, working
together towards a common goal.
This presentation discusses the risks and rewards of
using the different methodologies. Ultimately, the findings
substantiate the claim that using the Collaboration/Consensus method
produces the most benefits.
Joshua Feinstein-Plummer is a Data Systems
Architect at Standard and Poor's. He has over 10 years of practical
experience in financial information systems and currently serves as a member
of the S&P Technical Architecture
Group. He lives in Brooklyn with his wife, Eva-Maria C. Plummer. |
|
|
KEYNOTE:
Trends in
Database Management…Is this 1987 or 2007?
What with new-fangled this and new-fangled that, many of the issues that
surfaced 20-25 years ago were supposed to "disappear" with the influx of new
more powerful hardware and more database self-management techniques. The
major players in the database arena are proud of the advancements they have
made in the throughput of query processing. Whether companies go the "open
source" MySQL route, or choose a more industrial strength vendor such as
Oracle, so many problems that surface are reminiscent of the 80's and, in
many cases, have little or nothing to do with the software.
IT management and the "human factor" are still the major dictators,
influencing what works and what does not. Management decisions made 20 years
ago still affect what's going on today. Once vendors get their claws into
corporate IT infrastructures, companies are stuck with what they have in
order to protect their investments and product knowledge gleaned from years
of product use.
This presentation will discuss database management in the first decade of
the 21st century, and offer some suggestions about what may be the "best"
route to take. As the baby-boomers approach retirement, this may be the only
chance we have to turn things around and not keep repeating the mistakes
that we made in the 80's.
Michael Abbey is a recognized authority on database administration,
installation, development, application migration, performance tuning, and
implementation. Working with Michael Corey, he has co-authored 14 books for
McGraw-Hill's Oracle Press Series, including most recently Oracle Database
10g: A Beginner's Guide. Active in the international Oracle user community,
Abbey is the director of events for and serves on the board of directors of
the Independent Oracle Users Group (IOUG). He is a frequent speaker and
keynoter at user group and vendor conferences and has appeared at such
events as IOUG Live!, COLLABORATE, Oracle Open World, the European Oracle
User Forum, and UK Oracle User Forum.
Back to Top
|
DBA TRACK:
Oracle Enterprise
Manager
System Administrators have to manage a larger number of critical systems
and deliver a higher quality of service. At the same time, decision-makers
require more insight into business agility in order to meet service
performance goals. This presentation will show how to automate your IT
systems to improve quality of service and lower data center management
costs. Learn how Oracle Enterprise Manager manages IT services and the
system infrastructure in Grid computing and service-oriented environments,
thereby reducing costs and risks, maximizing productivity, and aligning your
IT objectives with your business.
Sandra Cheevers has been with Oracle for over 18 years, and has
worked in Customer Support, Customer Education and Product Management. She
handles product management in the development organization for the Oracle
Enterprise Manager product, and is a frequent speaker at Oracle conferences.
Back to Top
|
DBA TRACK:
Secure Your
Database in Just One Day
With the myriad of laws and mandates such as SOX and PCI-DSS, DBAs are under
pressure to comply very quickly with these rules. But how difficult is it?
In this presentation, you will learn the easy ways to fix issues that have
the broadest impact such as: listener securing, session auditing to match
patterns of attacks, removing SUID bits and permissions on Oracle
executables and many others. This presentation will also discuss how
seemingly innocuous packages like utl_tcp can be used to mount attacks or
how lsnrctl can be used to move to a different machine. All concepts will be
demonstrated using live examples.
Arup Nanda is the lead DBA at Starwood Hotels. He has been an
Oracle DBA for more than 12 years. He writes for many Oracle related
technological magazine, speaks at many Oracle conferences and has
co-authored four books. He paints watercolors when is not doing all of these
activities. He was Oracle Magazine's DBA of the Year in 2003 and is an OTN
ACE Director.
Back to Top
|
DBA TRACK:
Upgrade and
Archive Strategies for Enterprise Database Applications
Database archiving allows sites to streamline the application upgrade
process, minimizing costly business disruption and improving performance.
This presentation explores how managing enterprise application data can
help:
1. Reduce time to upgrade and “go live” into production, while minimizing
downtime during the conversion.
2. Control costs associated with application upgrade time, resources and
maintenance
3. Increase your ability to satisfy data retention compliance requirements,
ensuring that historical reference data remains accessible, even after
applications have been upgraded.
Attendees will learn how some sites have cut downtime by over 50 percent
while boosting the performance of key functional processes.
Steve Johnston is an experienced marketing and technology
professional who has spent more than 10 years working in and around the
technology industry. Steven has spoken at numerous conferences, user groups
and associations on topics ranging from data privacy and compliance to the
management of the effects of data growth in enterprise databases, the
implementation of compliance-driven data management strategies, and the
implementation of solutions to secure data in test and development
environments. His background and experience includes successful work with
EPCglobal US, GS1 (formerly the Uniform Code Council), Apptix, RealMedia,
Penn Mutual and currently Princeton Softech.
Back to Top
|
DBA TRACK:
Triaging a Database Slowdown
There are probably close to as many ways to investigate a database
slowdown as there are DBAs in attendance at most user group events. We all
have a suite of methods and techniques in our toolkits to troubleshoot the
performance hiccoughs that systems experience from time to time. When the
call comes or the pager sounds off, this presentation will suggest one track
to follow when trying to figure out what role the database is playing in
these service interruptions (if any!). This presentation discusses my
favorite places to go in the data dictionary and offers a handful of queries
that may end up assisting the Oracle professional in getting to the bottom
of application bottlenecks.
Michael Abbey is a recognized authority on database
administration, installation, development, application migration,
performance tuning, and implementation. Working with Michael Corey, he has
co-authored 14 books for McGraw-Hill's Oracle Press Series, including most
recently Oracle Database 10g: A Beginner's Guide. Active in the
international Oracle user community, Abbey is the director of events for and
serves on the board of directors of the Independent Oracle Users Group (IOUG).
He is a frequent speaker and keynoter at user group and vendor conferences
and has appeared at such events as IOUG Live!, COLLABORATE, Oracle Open
World, the European Oracle User Forum, and UK Oracle User Forum.
Back to Top
|
UCM TRACK:
10gR3
File Store Provider
This session demonstrates the power and flexibility of the new File Store
Provider in 10gR3. This component has abstracted the content storage from
the Content Server allowing the use of multiple file systems and even
database storage for very large file stores including HSM.
Bob Wicklund is a Consulting Technical Senior Director at Oracle
Corporation
Back to Top
|
DEVELOPER TRACK:
Oracle 11g
SQL PLAN Management
This presentation will describe how Oracle 11g manages SQL execution plans
in order to preserve SQL performance in a production environment which will
be affected due to changes in the Optimizer statistics/parameters/version.
It will provide an architectural overview demonstrating how Oracle 11g
allows you to create SQL PLAN baselines manually or by using default
configured Scheduler tasks. It will also explain the process of moving the
SQL PLAN baselines from one database to another and use the same SQL
execution plan on a new machine.
Inderpal S. Johal has been working as a lead database
administrator and architect for more than 10 years. He is currently working
as principal consultant for Data Softech Inc., a New Jersey based company
that specializes in providing complete database support solutions and
training to various clients. He has written various Oracle technical
articles for journals and magazines including Oracle Magazine and has spoken
at Oracle Open World, IOUG, UKOUG, NYOUG, NJOUG and DBA Online. He has a
Master's Degree in Computer Science from Punjabi University and worked as a
Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.
Back to Top
|
|
DEVELOPER TRACK:
If you’re not using
Analytics, shame on you!
In this presentation, will explain why you should be using analytics along
with the minimum knowledge needed to get started. The presentation will also
include some easy-to-understand, yet effective examples.
Travis Rogers is a Senior VP of Database
Development for CDG Management LLC with over 15 years of software
development including 10 years of Oracle development.
Back to Top
|
DEVELOPER TRACK:
Time Zones –
From the Big Picture to the Small Picture
If your application users span time zones, dates should be relative to
the user and transformable to different time zones. Oracle offers a complete
set of options serving different requirements. Daylight savings time and the
dynamic policies that determine it, must also be accounted for. What are the
options and trade-offs? What are the relationships of the session, database,
and server? This presentation will answer those questions and further
discuss all the ancillary functions and their use. Detailed examples will
explain the differences between SYSDATE, SYSTIMESTAMP, CURRENT_DATE,
LOCALTIMESTAMP, etc. And finally the bugs.
Edward Kosciuszko started at Oracle Corporation in 1981 and since
leaving in 1986 has been consulting, teaching SQL courses and designing
Oracle tools. Ed created the first SQL optimization product, which was later
sold to Platinum Technologies.
Back to Top
|
DEVELOPER TRACK:
Testing Oracle
– Strategies for Success
This presentation discusses various scenarios to successfully approach
Oracle testing based on the workload/workflow characterization, involving
forms, reports, SQL, PL/SQL, and object-oriented programming languages among
others. Independent from the methodology used, the presentation will also
challenge opinion discrepancies among approaches such as CMM/CMMI and XP
models, and traditional, object-oriented, and iterative software engineering
methodologies. Best practices in testing Oracle front-end, back-end and
middleware development at any stages will be covered. Finally, cases
discussing strategies to both front-end, middleware, and back-end testing
with an assessment as to whether a successful or failed outcome was related
to the methodology utilized will be presented.
Anthony D. Noriega is an IT consultant and computer scientist who
has focused his efforts in database technology, network computing, software
engineering, and object-oriented programming paradigms spending most of his
time as a database architect, DBA, database analyst, and developer. Anthony
holds an MS Computer Science from NJIT, an MBA from Montclair State
University, and a BS in Systems Engineering from University of the North. He
has been a Senior Consultant or Associate for Bowne & Co., IBM, Time Warner,
AT&T, Reed-Elsevier, MCS Canon, Time, FMC, and Deutsche Bank.
Back to Top
|
|
|
|
KEYNOTE: Linux Futures - Why you Should Consider Linux and Dispel the
FUD
Linux installs are still growing rapidly and many companies are deploying
new systems with Linux as the preferred operating system. However even
today, there is a lot of concern around Linux, its future and
reliability/scalability in big datacenters. This presentation will discuss
some of the new features coming up and see what companies like Oracle are
doing to help ease the concerns. Linux is a very viable deployment platform
and we want to make sure everyone feels comfortable with it.
Wim Coekaerts is vice president of Linux Engineering for Oracle,
reporting to Chief Corporate Architect, Edward Screven. He is responsible
for managing Oracle's Unbreakable Linux strategy with a dedicated focus on
ensuring large enterprises can adopt Linux quickly. Mr. Coekaerts has spent
more than 7 years building a large-scale development and support
organization and has fostered comprehensive customer and partner
relationships, which helps drive the company's evolution of Linux.
Additionally, his group develops and makes on-going contributions to the
Linux community, including the first Cluster File System to be accepted into
the Linux mainline kernel in 2006.
Back to Top
|
DBA Track:
DBA Best Practices from the Field
You are starting out as an Oracle DBA, a road that is as exciting as it is
treacherous. How can you tread safely? This session distills the speaker’s
experience of 13 years as an Oracle DBA to 10 best practices that will save
you someday, as well as make you look like a hero. The concepts presented
are battle-tested and ready for the real world, which may be different from
other preaching, including that from Oracle. Questions that DBAs face every
day such as choosing between a large number of small datafiles and a small
number of large files will be discussed, along with tips such as setting the
audit_trail to DB. Regardless of your level of expertise, this session will
make you a better DBA.
Arup Nanda has been an Oracle DBA for more than 13 years working in all
aspects of database management from modeling to performance management and
disaster recovery. He is the author of books Oracle PL/SQL for DBAs
(O'Reilly 2005) and Oracle Privacy Security Auditing (Rampant 2003). He was
awarded the DBA of the Year by Oracle in 2003.Back to Top |
DBA Track:
Oracle 11g – Top Features for DBAs
2007 marks 30 years of Oracle helping businesses and governments manage
their most valuable asset—information. This presentation introduces the new
features in Oracle Database 11g including: Total Recall, Flashback
technologies, new compression algorithms, automatic SQL and memory tuning,
new partitioning methods and more. The topics covered in this seminar are
primary for database administrators.
Daniel Liu is a Principal Solution Architect at Oracle Corporation
and co-author of Oracle Database 10g New Features (Rampant TechPress). A
recognized Oracle expert and a frequent speaker at various Oracle
conferences, Daniel has published articles with DBAzine, Oracle Internals,
Oracle Technology Network, and the SELECT Journal. Daniel received the 2001
SELECT Editor's Choice Award and has been named Architect of the Week by the
OTN in 2004. Prior to joining Oracle Corporation, he worked as a Senior
Technical Manager at First American managing one of the largest and most
complex database environments in the world.Back to Top |
DBA Track:
Custom Performance Reporting Changes Going to Oracle10g
This presentation will discuss some of the areas where Oracle has changed
its internal reporting structures and what you should be aware of when
developing or migrating custom performance monitoring scripts from one
release to another. When migrating to Oracle 10g, most people are focused on
the new functionality that is being made available with the new release.
Along with this new functionality, there is existing functionality that
changes its behavior. This is where the biggest risks and surprises lie. The
focus areas of this presentation will be Oracle10g reporting changes of: GV$
queries and their operation across multiple instances in a RAC Cluster, CPU
time calculations for Parallel Query executions, determining the DOP
achieved for Parallel Query operations, and identifying some data element
precision changes.
Brian Doyle is responsible for product management, technical support
and customer training at BEZ Systems. As chairman of the company's Product
Strategy Committee, Doyle also plays an active role in guiding the future
direction of BEZ Software's product solutions. He is responsible for
evaluating market opportunities and establishing market requirements for
existing and future products being developed by BEZ Systems. Prior to
joining BEZ, he was responsible for managing the customer support operation
for the Precise i3 product line at VERITAS Corporation. He was previously
Director of Technical Services Operation for Precise Software, which was
acquired by VERITAS. In this role, Brian was responsible for managing a team
of technical service engineers that handled the daily call center operation,
escalation processing and follow-the-sun handoffs for North and South
America customers and partners.Back to Top |
DBA Track:
Effective Use of Table Functions
This presentation begins with a brief description of table functions and
covers the specification using both nested tables and indexed tables. The
goal is to illustrate where the table function can be a tremendous
advantage, especially in the world of web applications. Optimization plans
are illustrated with the specific operations of a table function, as well as
how to enable the table function for parallel processing. The final section
of the presentation will discuss specific areas where the table functions
can be misused.
Edward Kosciuszko started at Oracle Corporation in 1981 and since
leaving in 1986 has been consulting, teaching SQL courses and designing
Oracle tools. Ed created the first SQL optimization product, which was later
sold to PLATINUM Technologies.Back to Top |
DBA Track:
Automating Database Management – How NOT to RAC Your Brain
Today’s organizations will reap tremendous benefits from the advanced
capabilities of Oracle 11g database as the new features introduce a more
sophisticated set of technologies into the IT environment. The introduction
of Oracle 11g also requires a great deal of understanding and knowledge
prior to implementation. Attendees will learn how automation can help
companies overcome possible hurdles during the upgrade to Oracle 11g and
ease ongoing management of the database infrastructure.
Matthew Zito is an expert in large-scale infrastructures, with
extensive experience in designing and deploying some of the world's largest
system, network, and application architectures. In addition, he has worked
with Linux for almost 10 years, testing, contributing, and advocating Linux
as the future of the enterprise datacenter. His code is running in a number
of open-source software projects, and he currently serves as Chief Scientist
of GridApp Systems, Inc.Back to Top |
DBA Track:
Database Growth – Problems & Solutions
Critical Oracle Database application environments in many enterprises are
growing larger and larger. Unmanaged data growth impacts application
performance, escalates IT infrastructure costs, and reduces application
availability for backup and recovery. The pros and cons of strategies for
managing database growth will be discussed. This session is helpful for
those who are experiencing database performance degradation, increasing
database capacities (footprint), or increased time for database recoveries
and backups.
For the last 15 years of his 25 year career, Eric Popiel has worked
in Enterprise Software applications including Oracle, PeopleSoft, and SAP.
Eric managed OuterBay’s North American pre-sales engineering resources, and
now manages Hewlett Packard/OuterBay’s Americas Pre-Sales for Reference
Information Manager for Databases, HP’s enterprise archiving solution. He is
a frequent presenter at local, regional, and national conferences.
Brian Bent of Solution Beacon has over eight years of experience in
all phases of design, development, and implementation of Oracle systems. He
has worked with clients within the transportation, healthcare, and
manufacturing industries. His areas of expertise include Database
Administration, E-Business Suite Administration (installing, maintaining,
patching and cloning), RAC and UNIX administration. Brian is adept at
architecting infrastructure solutions, which includes O/S, Network, Storage,
Database and Inter/Intranet design. He has been extensively involved in
database and application performance tuning, capacity planning and
implementing backup and recovery strategy for large 24x7 Oracle databases.
Brian is currently an Oracle Certified Professional, a Red Hat Certified
Engineer, and holds an ITIL Foundation Certificate in IT Service Management.
Brian can be reached by email at bbent@solutionbeacon.com.Back to Top |
DBA Track:
Oracle 11g Database Replay
This presentation will explain the benefits of Oracle 11g Database Replay to
IT Professionals and Managers. It includes all of the details for capturing
the workload on one server and then replaying it on a second server so
attendees will understand the impact of moving from one server/database
version to another.
Inderpal Johal has been working as alead database administrator and
architect for more than 10 years. He is currently working as principal
consultant for Data Softech Inc., a New Jersey based company that
specializes in providing complete database support solutions and training to
various clients. He has written various Oracle technical articles for
journals and magazines including Oracle Magazine and also spoken at Oracle
Open World, IOUG, UKOUG, NYOUG, NJOUG and DBA Online. He has a Master's
Degree in Computer Science from Punjabi University and worked as a Lead DBA
for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.Back to Top |
DBA Track:
Database Security & the Insider Threat
Insiders attacks account for 80% of security breaches, and privileged users
often have unlimited access to data without being monitored. This
presentation will discuss how to maintain regulatory compliance related to
insider threats. It will also describe several attacks that have been in the
news recently and what countermeasures could be taken to avoid similar
situations. Attendees will learn about database attacks initiated by
employees of an organization and effective countermeasures against them.
Aaron Ingram has fifteen years of experience developing enterprise
software, focusing on database systems and security applications. After
graduating with a Bachelor's Degree in Computer Science from Columbia
University, he worked at Accenture as a consultant for Fortune 500 financial
and telecommunication companies and for various government agencies. Most
recently, he merged his extensive database background with his security
skills to manage the development of Application Security's real-time
database intrusion detection and security auditing solution, AppRadar.Back to Top |
Developer Track:
Oracle 11g/10g Developers: What You Need to Know
New features of the Oracle 11g database geared to developers will be
discussed and demonstrated. Attendees will be introduced to the new and
improved features of Oracle11g/10g that directly impact application
development. Special emphasis is placed on features that can reduce
development time, make development simpler, improve performance, or speed
deployment. Specific topics include: New SQL statements,
case/accent-insensitive query, regular expressions, expanded LOB storage,
new data types (Binary XML, BINARY_FLOAT, BINARY_DOUBLE, SDO_GEORASTER), new
Statistical functions, Model clause, recycle bin, XML support improvements,
MERGE improvements, Object improvements, expanded Java capabilities, Regular
Expression expansion, virtual columns, and PL/SQL improvements. Attendees
will be better equipped to create new applications or modify existing
applications to take full advantage of Oracle11g/10g.
John King founded King Training Resources in 1988; he has been
working with Oracle products since Oracle Version 4 and has been teaching
Oracle-related courses since 1986. He has presented papers at various user
group conferences including: IOUG-Collaborate, ODTUG, UKOUG, EOUG, AUSOUG,
NYOUG, and the RMOUG Training Days.Back to Top |
Developer Track: Records and Information Rights Management
Attendees will learn how Oracle Universal Records Management (URM) and
Information Rights Management (IRM) can greatly reduce organizational risk
and lower the costs associated with discovery and other legal proceedings.
Oracle URM allows you to enforce consistent records and retention management
across the enterprise and enables you to apply your records management
policies and practices on content in remote repositories such as file
systems, content management systems, and email archives. URM also enables
you to apply records management practices to non-records content. Oracle IRM
allows organizations to protect content, even when it leaves the enterprise.
Oracle IRM (formerly SealedMedia) is the best system to secure and track the
use of sensitive documents and emails-even when copies are sent beyond your
own network.
Brian Dirking has been in the electronic publishing industry for over
15 years, as Marketing Manager for Barrington House Publishing, Product
Manager for OWL International Inc. and Director of Marketing for InfoAccess
Inc. There he was responsible for the development of Web publishing
technology that is now an industry standard, and licensed by most major
content management vendors. He is currently Principal Product Director for
Oracle Content Management, where he is responsible for Oracle URM and Secure
Enterprise Search products.Back to Top |
Development Track:
Using OracleAS Portal to 'Bring it all Together'
Oracle markets OracleAS Portal as the "Face of SOA." This presentation will
show how easy it is to create an "SOA-like" environment using OracleAS
Portal's sophisticated integration features (with minimal coding required).
A live demonstration will be presented. This presentation shows how to
integrate external applications into Portal and how to use Portal's security
features to provide a seamless environment for your end-users.
Chris Ostrowski is a Technical Management Consultant for TUSC in
Lakewood, Colorado. He has worked with Oracle technologies for over 15 years
and has presented at all of the major Oracle conferences. He is an Oracle
Ace Director, coauthor of the Oracle Press book Oracle Application Server
10g Web Development with Brad Brown and is the author of The OracleAS Portal
Handbook.Back to Top |
Developer Track:
Integrating Oracle 10g XML: A Case Study
Many times during a project life cycle, new technology is introduced that
presents first time challenges. The author will describe a project using
Oracle 10g XML DB and discuss why XML DB was chosen, how XML DB was used,
and the technical issues encountered. The author will provide several
examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and
XMLFOREST. Attendees will learn about methods, design considerations and
issues using Oracle 10g XML DB.
Coleman Leviter is employed as an IT Software Systems Engineer at
Arrow Electronics. He has presented at IOUG's Collaborate 07. He is the WEB
SIG chair and sits on the steering committee at the NY Oracle Users’ Group.
He has worked in the financial services industry and the aerospace industry
where he developed Navigation, Flight Control and Reconnaissance software
for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester
Institute of Technology, an MBA from C.W. Post and an MSCS from New York
Institute of Technology.Back to Top |
Developer Track:
Using Application Express with Fusion Middleware
Oracle Application Express (APEX, formerly HTML DB) can be used to rapidly
develop web-based applications leveraging the features of Oracle database.
The latest release of APEX integrates directly with Oracle BI Publisher and
includes new functionality that can be used to invoke web services or
processes built using Business Process Execution Language (BPEL). Oracle BI
Publisher and Oracle BPEL Process Manager are both components of Oracle
Fusion Middleware. This presentation will introduce attendees to aspects of
APEX, BI Publisher and BPEL Process Manager that make this interaction
possible. Participants will learn how to build simple user interfaces using
APEX to interact with BPEL Process Manager and BI Publisher.
Basheer Khan, president and founder of Irvine, California-based
Innowave Technology, was named the Oracle Magazine’s Integration Architect
of the Year 2006 and Oracle Application Users Group (OAUG) Member of the
Year in 2003. A frequent speaker on the capabilities of Oracle Applications
& Technology at major conferences including OAUG Collaborate and Oracle
OpenWorld, he has been published numerous times. With 20 years of experience
in information technology & solution architecture, his specialization
includes enterprise/business process integration using SOA, Web Services and
Oracle technologies.Back to Top |
Development Track:
Real-Life Data Mart Design Challenges
This presentation describes a real-life exercise in constructing a data mart
to meet many of the challenges recognized in data mart design and
implementation methodologies. Foremost among these is the need to load
dynamically defined data (like Oracle Applications' Flex fields) into the
data mart, and build the reporting tool's metadata so it correctly reflects
the source system's metadata. It will also address the issue of handling a
very large number of dimensions (in the 100's!) in a design that performs
adequately, but also provides an intuitive end user query interface as well
as the challenge of building an incremental refresh process that will also
accommodate updates to the data mart contents. The presentation concentrates
on design and methodology and describes the tools used (the Cognos ETL and
reporting suite).
Leslie Tierstein is a Senior Technical Architect at newScale, Inc, a
Silicon Valley-based company that provides and customizes ITIL (IT
Infrastructure Library) applications. She has over 15 years of experience
with Oracle technology, including project management, design, and
implementation of OLTP systems and data marts. She is a recognized Oracle
speaker and technical editor, and has spoken at Oracle conferences including
ODTUG, IOUG, and NYOUG.Back to Top |
Development Track:
ADP Implements a Real-Time Reporting System
ADP has initiated an enterprise-wide data integration initiative. The
objective is to provide cross-product reporting/analytics capabilities
across multiple HR, payroll, and benefits products that are implemented on
disparate, heterogeneous platforms in an ASP environment. This has spawned a
critical initiative called “ADP Reporting,” driving the IT team to implement
a solution to enable real-time data integration from source systems into a
centralized enterprise Oracle Data Warehouse. The first phase is to build an
Operational Data Store by integrating data from multiple product lines and
offering cross-product operational reporting. Participants will learn how to
evaluate and deploy solutions that offload reporting demands from primary
OLTP databases and allow for the enablement of a real-time, low-impact
enterprise reporting environment, using the Oracle database and GoldenGate
Software.
Amit Mukherjee is Sr. Director, Reporting Services at ADP. He has
been leading the ADP Reporting Initiative as part of the Integration
Services organization in the IT department at ADP Employer Services. He is
responsible for the data replication and ETL of data for ADP Reporting as
well as the front-end reporting application. Amit has over 12 years
experience in the IT industry focusing on Data Warehousing, Data
Integration, Business Intelligence and Decision Support Tools.Back to Top |
Development Track:
4GL Mini-Languages for Fast, High-Volume Reporting
Oracle (and other) databases are usually optimized to handle as many
concurrent independent read and write transactions as possible, and most
discussions of optimization focus on this usage pattern. This applies both
to runtime speed and ease of development. However, the right mini-language
can make use of tools and techniques specifically geared to work with
complex reports in large batch processing situations. Even better, it can
facilitate rapid development by using entity relationship introspection to
ease query development and by including support for automatic print-vendor
integration. Attendees will learn about techniques for using Oracle to
quickly develop complex, flexible reports that perform well in very
high-volume situations. The presentation also discusses the details of
high-volume dynamic printing, interfacing with independent print vendors,
and how software support can facilitate that communication and ease the
fulfillment of large print jobs.
For the past five years, Joshua Kobrin served as the Data, Analytics
and Reporting Architect for The Grow Network, a McGraw-Hill company. The
Grow Network's need to provide fast, high-volume reporting on standardized
test results, led Kobrin to developed tools and techniques for the rapid
development of such reports and for the optimization of their performance,
using Oracle, Java, Python, and XSLT.Back to Top |
Fusion Track:
The Path to Fusion Using a Database-Centric Approach
The only portion of the Fusion platform that is not rapidly evolving or is
likely to be obsolete in the near future is the database. Enforcing
data-intensive logic in the database requires less code than when written in
Java in the middle tier. The logic also executes much faster and requires
less network traffic if placed in the database. This presentation describes
a number of techniques using SQL and PL/SQL in the database including
INSTEAD OF trigger views, views based on functions accessing object
collections and various bulk SQL operations. It will also discuss how to
successfully integrate these components into a Fusion application using ADF
BC. The main sources of poor performance in a web application are poorly
written SQL and high numbers of network round trips between the application
server and database. A “thick database” approach to web development improves
performance and reduces the amount of rewriting required as web development
tools continue to evolve.
Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting
firm specializing in business rules and web-based application development
and chief architect of Dulcian's BRIM® tool. Paul co-authored 7 Oracle Press
books on JDeveloper, UML Modeling, and Oracle database tools as well as
PL/SQL For Dummies (Wiley). He is an Oracle ACE Director, SELECT Journal
Associate Editor, ODTUG Symposium chairperson, IOUG and ODTUG volunteer of
the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a
Survey Generator built to collect data for The Preeclampsia Foundation was
the winner of the 2007 Oracle Fusion Middleware Developer Challenge.Back to Top |
Fusion Track:
Made from the Same Mold: Templating Approaches for Fusion Applications
Users will more easily understand your application and will therefore be
more productive if all pages of your web application are designed to look
and act the same. The requirement for a common look-and-feel has
traditionally been met by the use of templates. However, the methods for
implementing template systems change with each new technology. This
presentation discusses how to work with templates and other common
look-and-feel options in JDeveloper 10.1.3. It explains and provides code
examples for template systems using ADF Faces and JSP tags as well as
additional Java frameworks. It also describes the Oracle Browser Look and
Feel (BLAF), which is used for the E-Business Suite as well as the ADF Faces
skinning feature and the JHeadstart plug-in to JDeveloper templates.
Peter Koletzke is a technical director and principal instructor for
the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View,
California, and has over 23 years of industry experience. Peter has
presented at various Oracle users group conferences more than 200 times and
has won awards such as Pinnacle Publishing's Technical Achievement, Oracle
Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle
Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice.
He is an Oracle Certified Master, Oracle Ace Director, and coauthor of the
Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers
(with Duncan Mills); Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper
Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman); Oracle JDeveloper 3
Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer
Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul
Dorsey)Back to Top |
Fusion Track:
Building Rich Web Applications Based on SOA
Do you want to know how you can build rich Internet applications based on
SOA? Then this session is for you. Attendees will learn how to build rich
internet applications using ADF Faces, build a SOA using BPEL and the ADF
Business Components, and put together the web pages and the SOA using the
ADF Model framework. This presentation will also discuss the benefits of
using Oracle JDeveloper as a unique development tool.
A senior consultant in Fujitsu Consulting's Quebec City office, Éric
Marcoux is passionate about Java and Fusion Middleware. He acts as a
technical architect and system integrator on his projects and he is an
Oracle ACE Director and an Oracle Fusion Champion. Éric has written various
technical articles, has given numerous presentations about Java and its many
possibilities, has taught how to use Java and Oracle products. He has
previously presented at Oracle OpenWorld, IOUG Collaborate, ODTUG
Kaleidoscope and JavaOne.Back to Top |
|
|
|
KEYNOTE:
Secure Your
Data Transparently
Most applications developed
in last decade were not designed to meet today's challenges around
compliance (SOX, PCI), privacy, and insider threats. While security
technologies such as encryption have existed for many years for protecting
Personal Identifiable Information (PII), incorporating these technologies
has proven to be a costly, risky, and time consuming exercise. This
presentation will discuss how the transparency of security technologies is
critical in making significant progress in securing today's data and
applications. Mr. Samar will show how Oracle Database Vault, Oracle Audit
Vault, Transparent Data Encryption (TDE), and Oracle Label Security can be
applied to existing deployments to dramatically increase security, and lower
the costs for compliance. In addition, the key security features of the next
database release from Oracle will be discussed.
Vipin Samar is Vice President of the Database Security group at
Oracle, and is responsible for all database-related security technologies as
well as several Oracle security products including Database Vault, Audit
Vault, Label Security and Advance Security. Starting his career in Sun's OS
and networking group, he has been in the security space for 12+ years, and
has worked in the areas of OS security, PAM, secure RPC, PKI,
single-sign-on, and Identity Management. He is a local boy having completed
his Master's Degree in Computer Science at SUNY Stony Brook many years ago.
Back to Top
|
|
DBA TRACK:
Anatomy of a Database Attack
Corporate databases contain the crown jewels of an organization, and data
theft by hackers or insiders can cost millions in fines, lawsuits, and
customer attrition. The good news is there are 10 commonly used methods to
attack databases. Defend against these, and your databases will be virtually
impenetrable. Using real-world examples, this presentation will describe
each of the top 10 database security threats as well as demonstrate the
probable attack mechanisms. The potential damage will be illustrated, along
with detailed information regarding best practices in mitigation and defense
techniques and tools.
Idan Soen is a Senior Security Engineer for Imperva. He has been
in the IT security market for over 9 years. After spending two years at HP
and five years at Check Point he joined Imperva three years ago as a senior
security engineer covering Asia, EMEA and most recently the New York
metropolitan region. Idan is well versed in web application and database
security and has been involved in security implementations at many of the
fortune 500 companies. Idan has a BA in business with a minor in IT and he
is a CISSP.
Back to Top
|
|
DEVELOPER TRACK:
Introduction to Oracle Application Express
Attendees will learn about the functionality that Oracle Application
Express provides by exploring the three main working areas of Application
Express. This brief presentation will serve to introduce Oracle
professionals to the Application Express environment. It will show attendees
how they can rapidly create intra and internet based applications that
reference existing Oracle data. Attendees will also be shown how they can
rapidly integrate spreadsheets, PDFs and various business related documents
into their database and web application.
Karen Hackett is an IT professional with over 25 years experience.
She has been working with Oracle for over 5 years at SkillBuilders. She is
webmaster of www.skillbuilders.com
which uses Oracle and Coldfusion. She also designed, developed and
maintains www.RIOUG.org and
www.RIRenewableEnergy.com
Back to Top
|
|
Oracle Database 11g:
Unbreakable Meets Best Practices
This presentation covers the high availability capabilities in Oracle
Database 11g, which are designed to help organizations maintain a highly
available, scalable infrastructure that meet users' quality of service
expectations. Tim will detail many of the Maximum Availability Architecture
(MAA) and availability capabilities in Oracle Database 11g such as:
• Utilizing standby databases for real time query purposes
• Enabling standby databases to be easily used for testing purposes
• Significantly reducing recovery downtime with Data Recovery Advisor to
automate problem investigation and intelligently determine a recovery plan
• Applying patches to an Oracle database instance with zero downtime
• Further automating human error recovery using Flashback Transaction
Tim Chien is a senior product manager with Oracle's High
Availability and Storage Management Group.
He is an 8 year Oracle veteran and has extensive product management and
product marketing experience includes server systems, application server,
and database products.
Back to Top
|
|
DBA TRACK: Using RMAN
to Clone New and Refresh Existing Databases
This will be a detailed presentation using an RMAN script where
participants will learn step-by-step how to clone a new database and refresh
an existing database’s data. The author has used the RMAN feature in
production for several years. He will share his experience and script to
show step by step to clone or to refresh databases in same or in different
machines. Many production details will be talked such as refresh archived
production database to no archive develop database. The script will enable
the attendees to use just one command to do the entire job automatically. HP
OMNI Performance tips will also be introduced.
Yongan Cui has been an Oracle certified DBA since version 7.3. He
has presented at IOUG and authored a SELECT Journal article.
Back to Top
|
DEVELOPER TRACK:
Globally
Implementing Oracle Database Security
Participants will learn how to secure their Oracle databases and some of
what Novartis has done globally to implement Oracle Database Security.
Jonathan will discuss specific activities that DBAs and application teams
should perform to secure their databases. In addition, some specifics of
what Novartis has done to harden their database environment, including an
"Oracle Database Security Roadshow" will be presented.
Jonathan Intner has been an Oracle DBA for more than 15 years. In
addition to being a 9i OCP, he is a CISSP (Certified Information Systems
Security Professional).
Back to Top
|
|
DBA TRACK: Inside Oracle Database Vault
Oracle released Database Vault in August of 2006 to address rapidly
emerging security requirements around the world for restricting access to
sensitive data by privileged users, overcoming a long-standing security
problem. Along with such first-of-its-kind access control capability,
Database Vault also introduced custom access policies based upon
environmental, execution, as well as user factors to control how existing
databases, applications, and data are accessed. This presentation takes a
look inside Oracle Database Vault, its architecture, security threat model,
and how new controls were added to the Oracle Database kernel so that
privileged users and DBAs are restricted from accessing sensitive data, but
can still perform all of their authorized maintenance and tuning activities.
Mr. Samar will discuss the operational model and how it offers
separation-of-duty capabilities. In addition, a case study of how a
financial services company plans to leverage Database Vault to address its
compliance and security requirements for its world-wide operations will be
presented.
Vipin Samar is Vice President of the Database Security group at
Oracle, and is responsible for all database-related security technologies as
well as several Oracle security products including Database Vault, Audit
Vault, Label Security and Advance Security. Starting his career in Sun's OS
and networking group, he has been in the security space for 12+ years, and
has worked in the areas of OS security, PAM, secure RPC, PKI,
single-sign-on, and Identity Management. He is a local boy having completed
his Master's Degree in Computer Science at SUNY Stony Brook many years ago.
Back to Top
|
|
DEVELOPER TRACK:
Large
Issues with Large Objects
CLOBs/BLOBs/BFILEs (commonly called “large objects”) have been around for
a long time, but only recently have they become critical tools for database
systems. Handling large database objects requires in-depth understanding of
their proper handling. This presentation will provide a starting point by
explaining when, why, and how to use large objects in real-world situations.
Michael Rosenblum is a Development DBA at Dulcian, Inc. He is
responsible for system tuning and application architecture. He supports
Dulcian developers by writing complex PL/SQL routines and researching new
features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press,
2006). Michael is a frequent presenter at various regional and national
Oracle user group conferences. In his native Ukraine, he received the
scholarship of the President of Ukraine, a Masters Degree in Information
Systems, and a Diploma with Honors from the Kiev National University of
Economics.
Back to Top
|
|
|
|
KEYNOTE:
How Oracle Came to
Rule the Database World
This is a break from the
technical presentations, but not too much of a break. Sit back and listen to
the history of the relational database go by. Find out the crucial moves
that Oracle made at critical junctures of their history. See what drove the
product from inception, over the rocky road and eventual to the top of the
mountain. Learn what made Oracle the product a success, but also find out
the attributes that made Oracle the company a font of technological
wizardry. This talk will reveal several seldom heard facts and some unknown
secrets of Oracle's success.
Richard J. Niemiec is
chief executive officer and principal of TUSC. He is respected around the
world as a master in database administration. In 2001, Rich was named by
Oracle Corp. as an Oracle Certified Master -- one of the first six so
recognized around the world. In 2003, Rich authored Oracle9i Performance
Tuning Tips & Techniques, one of more than two dozen books TUSC has written
for various publishers and features a compilation of more than 20 years of
hands-on experience and real-life issues. Some Fortune 500 accounts he has
managed include M&M Mars, McDonald's Corp. and Pepsico. His experience in
data processing ranges from teaching to consulting, with emphasis in
database administration, performance tuning, project management and
technical education. Rich is a former president of the International Oracle
Users Group and currently serves as vice president for its Real Application
Clusters special interest group. In addition, Rich is the current president
of the Midwest Oracle Users Group. He previously was the executive editor of
Exploring Oracle DBMS magazine and editor of MOUG Newsletter. Rich has
delivered hundreds of lectures on Oracle to users around the world. Past
accomplishments include top presenter honors at international Oracle users
conferences. He has conducted numerous expert class presentations at Oracle
OpenWorld and other major conferences.
Back to Top
|
|
DBA TRACK: In Bed with Oracle -
Lifting The Covers on
Database Creation
Database creation, because of better GUI tools, has become an
increasingly overlooked area of Oracle. In this presentation, Sean pulls
back the covers, revealing what Oracle is doing at each stage. Why do we
have startup nomount, mount, restrict, and open? What OS resources is Oracle
using at each step? How do we issue CREATE DATABASE? What is the simplest
init.ora file? How many file descriptors does Oracle use and why?
Sean Hull is the founder of and senior consultant at Heavyweight
Internet Group in New York. He has worked as a database consultant and
expert for ten years, in the areas of Oracle and various Open Source
technologies. He is the co-author of Oracle and Open Source (2001, O'Reilly
& Associates) as well as various Open Source database tools, scripts, and
applications. Sean has also written articles for various online and print
publications such as the Oracle Technology Network. He can be reached at
shull@iheavy.com.
Back to Top |
|
DEVELOPER TRACK:
Build Your Own Instant Client
Attendees will learn how to build their own versions of Instant Client
with tools not included in Oracle's Instant Client. Oracle Instant Client is
a power tool that is easy to install and set up, but it only comes with
SQL*Plus. This presentation shows how to include other Oracle tools like
SQL*Loader and exp/imp to make your own instant client bundle.
Richard Ji is a Senior Principal DBA Manager at WiderThan Corp. He
has been working with Oracle databases since 1996. Richard had architected
high performance, large scale databases that perform in the range of several
hundred million transact
Back to Top |
|
DBA TRACK: Tuning
Oracle 9i Using Statspack & AWR What is a quick way to monitor, find
and solve performance problems? Statspack & the 10g AWR Report are easy ways
to solve many of your performance issues that plague your system. This
presentation will show how to use Statspack to evaluate and fix issues
related to the top 5 wait events, load profile, instance efficiency ratios,
wait events and wait histograms, latch waits, top SQL, instance activity,
file I/O issues. Attendees will also learn how Statspack compares to AWR
Report and some of the additions that AWR Report provides over Statspack,
even though 80% of the information is the as that in Statspack. Come to this
session to understand how to quickly solve performance issues without doing
a system evaluation that is more costly the system itself. This includes
both proactive tuning based on findings and reactive tuning based on wait
events.
Richard J. Niemiec is chief executive officer and principal of
TUSC. He is respected around the world as a master in database
administration. In 2001, Rich was named by Oracle Corp. as an Oracle
Certified Master -- one of the first six so recognized around the world. In
2003, Rich authored Oracle9i Performance Tuning Tips & Techniques, one of
more than two dozen books TUSC has written for various publishers and
features a compilation of more than 20 years of hands-on experience and
real-life issues. Some Fortune 500 accounts he has managed include M&M Mars,
McDonald's Corp. and Pepsico. His experience in data processing ranges from
teaching to consulting, with emphasis in database administration,
performance tuning, project management and technical education. Rich is a
former president of the International Oracle Users Group and currently
serves as vice president for its Real Application Clusters special interest
group. In addition, Rich is the current president of the Midwest Oracle
Users Group. He previously was the executive editor of Exploring Oracle DBMS
magazine and editor of MOUG Newsletter. Rich has delivered hundreds of
lectures on Oracle to users around the world. Past accomplishments include
top presenter honors at international Oracle users conferences. He has
conducted numerous expert class presentations at Oracle OpenWorld and other
major conferences.
Back to Top |
|
DEVELOPER TRACK:
Web
Application Security with JAZN – Implementing the Superstition in JDeveloper
10g
Security_Practices.zip
Participants will learn how the JAZN service of the Oracle Application
Server OC4J runtime provides solid security services for J2EE web
applications. They will also learn about the JAZN ability to access user
credentials stored in XML files and in LDAP repositories. They will hear
about and see how to set up and code security hooks into an application
using JDeveloper 10g so they can restrict and permit user access and
operations to valuable enterprise data.
Peter Koletzke is a technical director and principal instructor
for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain
View, California, and has over 22 years of industry experience. Peter has
presented at various Oracle users group conferences more than 170 times and
has won awards such as Pinnacle Publishing's Technical Achievement, Oracle
Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle
Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice.
He is an Oracle Certified Master, Oracle Fusion Middleware Regional
Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for
Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g
Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom
Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms
and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000
Handbook (all with Dr. Paul Dorsey).
Back to Top |
|
DBA TRACK:
Effective Use of Column Histograms
The use of column histograms can have a very positive impact on the
Cost-Based Optimizer's operation, but there is still much uncertainty about
when and how to take advantage of this functionality. This presentation
discusses how histograms are used, how to identify columns for which they
are appropriate, how to create them, and how to confirm their use.
Participants will learn how to determine if a column is a candidate for
histogram generation, how to create the histograms, and how optimizer
behavior changes in their presence.
Paul Baumgartel has been an Oracle DBA for many years, and
currently works as an independent consultant in the New York City financial
industry. He specializes in performance optimization, database server
architecture, and training.
Back to Top |
|
DEVELOPER TRACK:
BI Modeling and Forecasting with SQL
This paper and presentation with discuss important applications in
finance, marketing, research and development and other important areas of
management science, forecasting, and data mining. The key aspects of this
presentation, unlike most business intelligence analytics, is that it is
driven by Oracle10g SQL Model’s ability to achieve successful forecasting
utilizing traditional and scientific business models based on the
dimensions, measures, and rules implemented.
Anthony D. Noriega is an IT Consultant who has focused his efforts
in database technology, network computing, software engineering, and
object-oriented programming paradigms. At ADN, Anthony spends most of his
time as a database analyst, architect, and developer, and DBA. Anthony has
attained an MS in Computer Science from NJIT, an MBA from Montclair State
University, and a BS in Systems Engineering from University of the North. He
has been a consultant for IBM, AT&T, M&M Mars, Tosco, Allied-Signal, and an
associate for Deutsche-Bank, Bowne & Co, Reed-Elsevier, MCS Canon, and FMC.
Anthony is fluent in Spanish and French.
Back to Top |
|
|
|
KEYNOTE:
Soft Skills….Can’t Live Without Them
I don't care if you played bass guitar for the Quarrymen before Paul
McCartney or if you were a ghost writer for Dickens ... if your going to sit
in your cubicle all day, pound away at your keyboard, and bark at colleagues
who stray into your space ... you're not getting the job! Even though you
have Oracle skills second to none, it's not all about the software.
• Are you a team player?
• Can you compromise?
• Hows your grammar and spellnig?
• Ever heard of a deadline?
• The phone ... yes we do still use them here.
Soft skills .. often as
important, if not more important, than your technical skills. In this
keynote, Michael will share some of his experience of his north of 20 years
in the industry and highlight some experiences we have all gone through
which, when happening, were painful, but in hindsight are nothing but
comical. Michael Abbey is a recognized authority on database
administration, installation, development, application migration,
performance tuning, and implementation. Working with Michael Corey, he has
co-authored 12 books for McGraw-Hill's Oracle Press Series, including most
recently Oracle Database 10g: A Beginner's Guide. Active in the
international Oracle user community, Abbey is the director of conferences
for and serves on the board of directors of the Independent Oracle Users
Group (IOUG)
Back to Top
|
|
DBA
TRACK (single session):
11gR1 PLSQL New Features
A 60 minute overview of some of the many new
SQL/PLSQL features including much improved native compilation, result
caches, more granular dependency management, new trigger types and more.
Tom Kyte
is a Vice President in Oracle’s Public Sector division. Before starting at
Oracle, Kyte worked as a system integrator building large-scale,
heterogeneous databases and applications, mostly for military and government
customers. Kyte spends a great deal of time working with the Oracle
database, and more specifically working with people who are working with the
Oracle database. In addition, Kyte is the Tom behind the AskTom column in
Oracle Magazine answering people’s questions about the Oracle database and
its tools. Kyte is also the author of Expert One on One Oracle(Wrox
Press, 2001/Apress 2004), Beginning Oracle Programming (Wrox Press,
2002/Apress 2004, and Effective Oracle by Design (Oracle Press,
2003). These are books about the general use of the database and how to
develop successful Oracle applications.Back to Top |
|
DBA TRACK: Introduction
to Automatic Storage Management
This presentation is and
introduction to Oracle's new integrated file system and volume manager, ASM.
Demonstrations will illustrate the basic use of ASM, including creating disk
groups, migrating to and from ASM and using ASMCMD to manage ASM files.
Dave Anderson
has more than 24 years of hands-on experience in the I.T. industry. His
last 10 years have been spent working with Oracle - as a programmer and
administrator. Dave speaks regularly at Oracle conferences including IOUG,
NYOUG, CTOUG, VOUG, NOUG and SEOUC (where he won “Best of Conference” for
his RMAN presentation). In 1992 Dave founded and is still employed by
SkillBuilders, an Oracle Partner specializing in Oracle sales, training and
consulting.
Back to Top |
DEVELOPER TRACK:
JDeveloper with ADF Faces and JHeadstart –
Is It Oracle Forms Yet?
Oracle has long offered tools that assist with deploying applications;
its current focus is with the Java IDE, JDeveloper. JDeveloper 10g (release
10.1.3) offers a new set of features, libraries, and methods -- ADF Faces --
which greatly simplifies Java development tasks and takes advantage of the
popular J2EE (Java EE 5.0) technology JavaServer Faces. The tools that
JDeveloper provides to work with ADF Faces allow development of J2EE web
applications in an environment that is closer to Oracle Forms than anything
previously released.
This presentation describes Application Development Framework (ADF) and ADF
Faces and how they can assist with development of a Java-based application.
It also shows the various tools in JDeveloper that support the "ADF
development method" and how they ease the task of connecting Java front-end
code to the database. In addition, the presentation provides an overview of
the JHeadstart plugin and shows how its declarative environment might rival
that of Oracle Forms Builder. Finally, the presentation offers insights
about what type of development shop will benefit the most from ADF, ADF
Faces, and JHeadstart and whether it really is possible to achieve the
productivity of an Oracle Forms environment by using ADF Faces with
JHeadstart.
Peter Koletzke is a technical director and principal instructor
for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain
View, California, and has over 22 years of industry experience. Peter has
presented at various Oracle users group conferences more than 170 times and
has won awards such as Pinnacle Publishing's Technical Achievement, Oracle
Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle
Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice.
He is an Oracle Certified Master, Oracle Fusion Middleware Regional
Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for
Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g
Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom
Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms
and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000
Handbook (all with Dr. Paul Dorsey).
Back to Top |
|
DBA TRACK:
RBaby to RMAN – Simplifying the Transition
So many DBAs are postponing the move to Recovery Manager due to its
seemingly time-consuming learning curve. In this presentation, attendees
already fluent with backup and recovery strategies using Oracle's toolset
will see how the transition is nowhere near as time consuming as
anticipated. This presentation will cover the infrastructure setup to
support catalog-based RMAN, and present some scripts to get started. Michael
will discuss the three main backup scenarios and look at the recovery phase
of an RMAN restore exercise as well as cover the pesky management of and
backup of archived redo as well as a primer on catalog cleanup. With a
kick-start through the lessons learned in this presentation, the move to
RMAN is one of the least complicated hurdles DBAs will be asked to overcome.
Michael Abbey is a recognized authority on database
administration, installation, development, application migration,
performance tuning, and implementation. Working with Michael Corey, he has
co-authored 12 books for McGraw-Hill's Oracle Press Series, including most
recently Oracle Database 10g: A Beginner's Guide. Active in the
international Oracle user community, Abbey is the director of conferences
for and serves on the board of directors of the Independent Oracle Users
Group (IOUG)
Back to Top |
DEVELOPER TRACK:
The Tie That Binds: An Introduction to ADF Bindings
Normally, connecting database data to the user interface of a web
application requires some work. Oracle Application Development Framework (ADF)
provides a feature called ADF Bindings that you can use to accomplish this
task. ADF Bindings is part of the ADF Model layer, which is recognized as
the most innovative and remarkable technology in the ADF stack. This
presentation briefly reviews where ADF Model (ADFm) fits and how one of its
components, ADF Bindings, allows you to quickly connect components from any
user interface library such as ADF Faces and JSF Reference Implementation to
business services such as ADF Business Components. The presentation provides
details and shows examples of how ADF bindings work; how to automatically
bind data elements to visual elements; what types of bindings are available;
and where binding code appears. It also explains the basics of the
expression language used to bind Model layer components to View layer
components.
Peter Koletzke is a technical director and principal instructor
for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain
View, California, and has over 22 years of industry experience. Peter has
presented at various Oracle users group conferences more than 170 times and
has won awards such as Pinnacle Publishing's Technical Achievement, Oracle
Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle
Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice.
He is an Oracle Certified Master, Oracle Fusion Middleware Regional
Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for
Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g
Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom
Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms
and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000
Handbook (all with Dr. Paul Dorsey).
Back to Top |
DEVELOPER TRACK:
Knit Data Together - Cleansing & Matching Techniques
This presentation is a review of key techniques used to accomplish a huge
business imperative: high-confidence matching between huge, unrelated data
stores. Techniques discussed include data cleansing, a “learning
system” approach to improve tolerance for bad data over time, basic
confidence routines used to build tolerance for bad data and the value of a
'swarm' approach for Oracle 10g when comparing huge volumes of data between
sources. Topics covered include:
1. Data cleansing & matching techniques to help match up unrelated data.
2. Learning Systems-type techniques to improve Bad Data Tolerance over time.
3. Concurrency/"Swarm" techniques to take best advantage of Oracle's 10g
grid structure.
Matthew Williams is a Senior Oracle Programmer at LexisNexis
Corporation, and specializes in matching techniques to unite unrelated data
sources. He has a cat.
Back to Top |
|
|
|
KEYNOTE: Fusion Middleware Technical Overview and Roadmap
Oracle Fusion Middleware is not only the
fastest growing Oracle product. It is also innovating rapidly.
The keynote will first address the major technologies and components of
Fusion Middleware supporting SOA, Identity Management, Business Intelligence,
and Workplace. Vijay will also describe the release themes and some
high-level features anticipated for Oracle Fusion Middleware 11. Lastly,
for customers who have PeopleSoft, JD Edwards, and Seibel Applications, he
will highlight how they can leverage Fusion Middleware today.
Vijay Tella is the chief
strategy officer for Oracle Corporation's middleware platform product, Oracle
Application Server 10g. He is responsible for shaping the
technical and strategic direction of the product, ensuring Oracle's continued
leadership in the application platform suite (APS) market. Mr. Tella has more
than 15 years of experience innovating and delivering market leading products
in the middleware space. His expertise includes Enterprise Application
Integration, Business Process Management, Business Activity Monitoring, B2B
Integration, Web Services Infrastructure and Enterprise Portals. Prior to
joining Oracle, Mr. Tella was senior vice-president of engineering at TIBCO
Software Inc, delivering its business integration products: Active
Enterprise, Active Exchange and Active Portal. Mr. Tella holds a B.Tech.
degree in Computer Science from the Indian Institute of Technology and an
M.S. degree in computer science from University of California, Los Angeles .
Back to Top
|
|
DBA TRACK:
An Extensible Materialized View Architecture
This
presentation describes an extensible architecture modeled after Oracle
materialized views that has many of the features of Oracle materialized views
without many of the limitations. Most notable among its features are its
ability to support fast log-based refreshes of arbitrarily complex materialized
views under circumstances where an equivalent Oracle materialized view would
require a complete refresh. One such circumstance is the restoration of a
materialized view after a media failure on either the master or materialized
view database. The architecture allows us to resynchronize the materialized
view with the master(s) without performing a full refresh.
Claudio Fratarcangeli has 20 years of experience using Oracle (since V4)
in application development, software product development, and database
administration. In recent years he has also been involved in Java J2EE
architecture and development. He has presented at various regional and national
conferences and has authored articles in various database trade magazines and academic
journals.
Back to Top
|
|
DEVELOPER TRACK:
Customizing a Packaged
Application for a J2EE Environment: A Case Study
How does a Forms and Designer expert (relatively)
adjust to life in a Java and J2EE world? The author is finding out while customizing
a J2EE-compliant application to the requirements of several clients. This presentation
details some of the issues to be faced in making this transition. Topics
include the use of multiple technologies (including CSS, HTML, JavaScript, and
ColdFusion) to customize the user interface; development and deployment using
both proprietary and open source tools and servers; integrations with external
systems using XML and XSLT; and the learning curve in mastering Java and
JavaScript in a real-world environment.
Leslie Tierstein is
a Principal Technical Architect for newScale, Inc, a Silicon Valley-based
company which provides IT Portfolio Management and Service Catalog
applications. Her responsibilities have included customizing newScale’s
J2EE-compliant RequestCenter product suite for client implementations and
delivering and developing technical training materials on a wide range of
topics, including application integration, JavaScript programming, data
warehousing, and user interface customization. Before joining newScale, Leslie
had over 20 years of IT industry experience which has included leading the
implementation of mission-critical applications built using Oracle database
technology. She is an award-winning speaker at conferences including
NYOUG, Oracle Development Tools User Group (ODTUG), and IOUG.
Back to Top
|
|
DBA 101 TRACK:
Do-It-Yourself
Monitoring with OTop
The Oracle Wait Interface has become the one-stop shop
for diagnosing bottlenecks in your database. However querying it directly
remains somewhat laborious, and many a commercial tool just don't quite fit the
bill. Enter OTop, a PERL-based monitoring and diagnostic tool based on the
popular Unix top utility, and the MySQL mtop. In this presentation, attendees
will learn about the OWI, how to identify some typical bottlenecks, what wait
events to look out for, and how OTop can display that information for you.
Sean Hull is the founder of and senior consultant at Heavyweight
Internet Group in New York. He has worked as a database consultant and expert
for ten years, in the areas of Oracle and various Open Source technologies. He
is the co-author of Oracle and Open Source (2001, O'Reilly &
Associates) as well as various Open Source database tools, scripts, and
applications. Sean has also written articles for various online and print
publications such as the Oracle Technology Network. He can be reached at
shull@iheavy.com.
Back to Top
|
|
DEVELOPER 101 TRACK:
Oracle 10g for Developers
Attendees will be introduced to new and improved
features of Oracle10g 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 Oracle10g.
John King is
a Partner in King Training Resources, a firm providing instructor-led training
since 1988 across the United States and Internationally. John has worked with
Oracle products and the database since Version 4. John develops and presents
customized courses in a variety of topics including Oracle, DB2/UDB, SOA, Java,
XML, .NET, and C++. John presents frequently at various industry conferences.
Back to Top
|
|
ORACLE
FUSION TRACK: Securing Your Enterprise: Oracle Security & Identity Management
This session will focus on how Oracle's comprehensive
Identity and Access Management Suite helps organizations enhance
enterprise-wide compliance, lower operational costs, and strengthen security.
We’ll give a high level overview of the features and benefits of each of the
components of the suite to show how both Fusion and non-Oracle applications
benefit from using these best in class products.
Ranjeet Vidwans
is a Director of Product Management in Oracle’s Identity Management group
with responsibilities spanning the entire Identity Management portfolio.
Prior to Oracle, Ranjeet was with Thor Technologies for several years during
which he ran Product Management and then Technology Alliances. Previously he
has held sales, consulting, and product management positions at enCommerce,
Entrust, and Cambridge Technology Partners. Ranjeet holds a Bachelor’s
degree in Computer Science from Rutgers University.
Back to Top
|
|
DBA TRACK:
Introduction to DBMS_METADATA
DBMS_METADATA, introduced in Oracle9i, was a
breakthrough for DBAs and developers, eliminating the need to write tortuous
SQL statements in an attempt to construct DDL from data dictionary contents.
This presentation reviews DBMS_METADATA's extensive capabilities, and presents
a fully-developed example to illustrate how to use the package's API.
Participants will learn how to use the powerful DBMS_METADATA package to
extract and apply DDL programatically or save it for later use.
Paul Baumgartel has been an Oracle DBA for over fifteen years. He specializes in
performance optimization, training, and utility development. His consulting
clients have included Oxford Health Plans, TIAA-CREF, BMG, United Parcel
Service, and Credit Suisse.
Back to Top
|
|
DEVELOPER TRACK:
Six
Steps to Unit Testing Happiness
This
presentation will discuss the overall state of software quality -- and the
impact of low quality code. Steven will review high-level principles for unit testing,
introduce the concept of "test-driven deve | |