|
Below you will find several abstracts of published papers and presentations
by our consultants. We'd love to share our vast knowledge and experiences
with you personally. These papers are sometimes available as both
Word docs and PowerPoint presentations. All of the files will require
you to have an application capable of "unzipping" the
compressed files.
|
ANALYZE THIS -
NEW SQL OLAP FUNCTIONS FOR EVERYONE
Kenneth M. Guion
|
|
Introduces new OLAP and BI functions, including the
basics of Oracle’s new Analytic Functions such as ROLLUP
and CUBE, new functionality of the Aggregate functions
such as SUM and AVG and how to use new “windowing” and
“lag/lead” functionality to calculate cumulative totals,
moving averages, and inter-row calculated values such
as period-to-period growth.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
ODTUG
IOUGA
SCOUG
|
|
Back to top
|
NEW ORACLE 8I
PL/SQL PERFORMANCE FEATURES
Kenneth M. Guion
|
|
Covers performance enhancements to PL/SQL in Oracle8i
Release 2 including Native Dynamic SQL, Global Temporary
Tables, Autonomous Transactions, Bulk Bind Operations,
the RETURNING clause and the NOCOPY parameter hint.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
IOUGA
SCOUG
|
|
Back to top
|
24X7 DATA WAREHOUSE
USING ORACLE 8I - A CASE STUDY
Hemal Solanki
|
|
Presents a real-world example using Oracle 8i’s advanced
features to achieve high-frequency data loads with minimal
impact to the users. Examines the use of Oracle 8’s
table partitioning, partition exchange and direct path
SQL*Loader, as well as how these features can be effectively
used to load and publish gigabytes of data on a daily
basis. Focuses on the data loading and publishing phases
of a data warehouse.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
IOUGA
SCOUG
OpenWorld
|
|
Back to top
Back to top
|
AUDITING: A SOPHISTICATED
AND FLEXIBLE SOLUTION
Jeff Garner
|
|
Discusses different types and aspects of auditing and
then presents a practical solution for creating an application
auditing architecture that is data-driven, including
an in-depth discussion of an actual functioning example.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
ODTUG
IOUGA
SCOUG
|
|
Back to top
Back to top
|
DATA WAREHOUSE
WITH ORACLE 8I
Manoj Kumar
|
|
Introduces data warehousing concepts, terminology,
architecture and techniques, then explains the data
warehousing features used specifically with Oracle 8i.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
DIVIDE AND CONQUER:
ORACLE PARTITIONING
Stephen George
|
|
Discusses multiple aspects of partitioning, beginning
with an overview, and including the performance enhancements,
greater data availability and successful partitioning
techniques of using partitions.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
Back to top
Back to top
|
NEW TRICKS FOR
OLD ORACLE DOGS
Kenneth M. Guion
|
|
This paper and presentation provides an overview of
some new Oracle 8i SQL and PL/SQL features including
ROLLUPs, Analytic Functions, Native Dynamic SQL, Temporary
Tables and even some lesser-known features like In-Line
Views and Autonomous Transactions.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
OpenWorld
|
|
Back to top
|
TKPROF: YOUR
"GET OUT OF JAIL FREE" CARD
Kenneth M. Guion
|
|
This presentation and paper covers the old, but powerful
tools, SQL Trace and TKPROF. Specifically it will cover
tried and true techniques on how to enable tracing,
how to analyze it using TKPROF, and how to read and
make use of the output it generates. It wraps up with
an overview how events can be used to dump bind values,
wait events, and cost-based optimizer information to
the trace file.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
OpenWorld
|
|
Back to top
Back to top
Back to top
Back to top
Back to top
Back to top
|
TRICK OR TREAT,
GIVE ME A WELL DESIGNED HOME PAGE TO READ
Kenneth M. Guion
|
|
This presentation will not teach you the features or
functionality of any Web Development tool, but will
discuss the need for designing efficient, aesthetic,
and easily “navigable” home pages and applications.
Presented from a graphical design point of view, attendees
will learn typography tricks, media delivery techniques,
page layout design, etc. that will make their web sites
easy and pleasing to use.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
Back to top
|
A JUMP START TO 9i BUSINESS INTELLIGENCE FUNCTIONS (Part 1 and Part 2)
Kenneth M. Guion
|
|
Did you ever want to find the top two salary earners in each department or a three month moving
average? Now with Oracle 9i you can write SQL statements you always wanted and the one 's you
thought never possible. Oracle has added a plethora of new analytical functions that can be
called by any SQL statement in any application. This presentation will help attendees learn about
new OLAP (on-line analytical procession) and Business Intelligence functions. It will
specifically cover Oracle ' s new ROLLUP and CUBE processing including the new Grouping Sets
feature; and new Ranking functions including Top-N processing and Hypothetical Ranks. It will
also include Oracle's new Reporting Aggregate functions which extend the power of SUM(), AVG()
etc.; and how to use Windowing and Lag/Lead functionality to calculate cumulative totals, moving
averages and inter-row calculated values such as period-to-period growth.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO 9i SQL AND PL/SQL ENHANCEMENTS
Kenneth M. Guion
|
|
Come to this presentation and learn about new PL/SQL and SQL performance improvement features
that have come along since you first learned Oracle. Attendees will learn the features and
benefits of Oracle's new Temporary Tables and Bulk Bind Operations as well as some lesser-known
SQL performance features such as the DML Returning clause, the subquery factoring (WITH) clause,
the MERGE statement, Multi Table Inserts, and the ANSI CASE expression.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO SQL
Doug Burkhart
|
|
SQL is the foundational language for the Oracle RDBMS. Oracle tools,
including Forms, Reports, and even PL/SQL all rely on SQL to retrieve and
manipulate data in the Oracle database. See the power of why SQL is the language
of choice for relational databases and its ease of use with its simplistic syntax.
This presentation will lay the foundation for the SQL Language and show the SQL
techniques used to make information out of all that data.
|
DOWNLOADS AVAILABLE
|
|
Word
Paper
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO ENTITY RELATIONAL MODELING
Doug Burkhart
|
|
Come to this presentation and learn the fundamentals of Relational Modeling, including some
advanced techniques commonly used in today's applications. Discover why all those database
constraints are there and the integrity they give to your applications. Learn why the Entity
Relationship Diagram (ERD) is still one of the most widely used tools used for designing,
developing and documenting your relational business applications. If you do not have an ERD
of your system, get one!
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO PL/SQL SERVER PAGES
Don Sheara
|
|
Oracle powers the Internet. And Oracle tools provide a number of means for creating web
applications. Two of those means, of interest to experienced PL/SQL programmers, are PL/SQL
Pages (PSP) and PL/SQL Servlets. This presentation will introduce these two methods to show
how they can be used to create applications (specifically of interest to programmers who know
PL/SQL, but that may not know much else in terms of web technology)
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO JAVA FOR PL/SQL DEVELOPERS
Anand Raj
|
|
PL/SQL provides the procedural capabilities that are not available in SQL. Oracle has moved
towards an object-oriented world by including Object types and supporting Java both on the client
and server side. What does that mean to a PL/SQL programmer? Is Java going to replace PL/SQL or
is it going to compliment PL/SQL? As the Oracle database is evolving each year, so is the support
for Java. This means that in order to keep up with the pace, developers have to learn Java to be
successful. Most of the Oracle developers are excellent PL/SQL programmers, but when it comes to
Java, they don't know where to start. This presentation will guide the PL/SQL programmers through
the process of transitioning from PL/SQL to Java demonstrating the similarities and the differences
between these two languages.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
ODTUG
IOUGA
SCOUG
|
|
Back to top
|
A JUMP START TO XML FOR ORACLE DEVELOPERS
Anand Raj
|
|
XML has gained lot of ground in the IT industry and Oracle’s support for the XML technology
is phenomenal. Businesses are racing to get into this technology for their own benefit. But how
many of the Oracle developers know what XML is and what are the advantages of this markup
language and how it can be manipulated in PL/SQL. This presentation is for developers who are
interested in learning the basics of XML and the features in Oracle supporting this technology.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO FORM MIGRATION TO THE WEB
Mark Ruddock
|
|
This session will cover some "How to" advice for getting your Oracle forms application to
the web with minimal pain and maximum functionality. Getting Host calls handled. Forms.FFI
fun, and not loosing your functionality. These are just a couple of the items covered. Get
practical information and advice on getting there fast.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO 9i SQL AND PL/SQL TUNING
Hemal Solanki
|
|
I am sure that many of you have come across the situation where application developers and
DBAs blame each other for poor application performance. So the question is, who tunes? Believe
it or not but everyone involved with the system has a role in tuning. Business analyst,
application designer, application developers, DBAs and System administrator are equally
responsible for tuning. This session provides tips and techniques for application developers
to boost the performance of their SQL and PL/SQL. Learn how small change in a code can boost
the performance by more the 100%.
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO ORACLE WEB SERVICES
Akshay Mistry
|
|
Web Services has recently because an important and hot issue. The presentations will explain:
- What are web services?
- Why do we need them?
- How to develop and deploy them?
- Its advantages over Microsoft's .NET
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
A JUMP START TO ORACLE 9iAS WEB CACHE
Akshay Mistry
|
|
All web Sites present a common issue, performance. This presentation address that issue teaching you:
- What is 9iAS web cache?
- How it works?
- Edge Side Includes (ESI)
- How to use ESI to speed up your existing web applications?
|
DOWNLOADS AVAILABLE
|
|
PPT
Presentation
|
|
PRESENTED AT
|
|
SCOUG
|
|
Back to top
|
