|
|
| Michael Richards, Oracle Subject Matter Expert
June 3, 2008 |
TOPIC:
Star Transformation & Optimization
This presentation illustrates how to utilize the Star Schema for
performance advantages leveraging "Star Query Transformation" vs. the
traditional Third Normal Form Snowflake schema. Mike will explain how
the Oracle Optimizer prunes a query's result set with its conversion of
many logical joins into a single operation using Bitmap Indexes. He will
also answer the question of why Bitmaps should not just be used for low
cardinality and are up to 100 times faster than traditional indexes.
PRESENTER: Michael Richards
Mike Richards is an Oracle Subject Matter Expert who has worked with
Oracle since Version 6. He has over fifteen years of Data Architecture,
DBA, Infrastructure Architecture, Business Analysis & Project Management
experience with Oracle Enterprise Data Warehouse methodology, data
encryption & expert systems. His recent work includes the above as well
as Quantum Computing, Parallelism & Encryption. Mike was the primary
author of the following SAMS Publishing series: Oracle Unleashed, Oracle
Server Unleashed, Oracle Development Unleashed, and Client/Server
Unleashed |
| David Gnau, Senior Sales Consultant - Oracle Corporation
January 30, 2008 |
11g
Partitioning - New Features and Information Lifecycle Management (ILM)
Learn about the evolution, benefits, and basic partition strategy in
Oracle from its introduction in 8.0 to our latest version in 11g. Learn
how partitioning can improve performance, simplify database
manageability and availability. David will review new partitioning
features in 11g, such as interval, reference, and virtual column based
partitioning. In addition, this presentation will touch upon how
partitioning can reduce the costs of ILM ( Information
Lifecycle Management). |
| Shyam Nath & Ratan Vakil, Oracle Corporation
August 17, 2006 |
An Inside Look at
Oracle OLAP with Advanced Analytics
The presentation covers the definition of OLAP and a comparison
of OLAP to OLTP technologies. A case will be made why organizations
require both OLTP and OLAP solutions. Examples of the wide ranging use
of OLAP tools across different industries, types of organizations and
expected business solutions will be highlighted.
The Oracle OLAP products are covered, together with a demonstration
of some of the OLAP tools. |
| Tina Yetman, Oracle Corporation |
Enterprise BI for Better Decisions
A look at building a complete business intelligence architecture. Focuse
on key business scenarios that will lead you through a complete process
of transforming / loading data into a data warehouse (both relational
and multi-dimensional data structures). Covers building end-user reports
and deploying them through a custom dashboard. There are 3 zip files
for this presentation
ORACLE BI PUBLISHER ENTERPRISE
REPORTING & DELIVERY
ORACLE ENTERPRISE BI
ORACLE BUSINESS ACTIVITY
MONITOR |
| David Friedland, CoSort/IRI |
Speeding High-Volume
ETL for Oracle Data by Combining Optimized Flat-File Tools |
| John McKenna, Counterpoint
Technologies, Inc. |
Aggregate Navigation - Using
Materialized Views And Query Rewrite |
| Jennifer Leung, Oracle |
Oracle Data
Warehousing - A Guided Tour |
| Richard Solari, Senior Product Manager
of Data Mining Technologies, Oracle |
Oracle9i
Data Mining 06/18/02 -
PAPER [505K]
PRESENTATION
[150K] - What is data mining and how it fits into the
world of business intelligence and more specifically, how it fits into
the Oracle 9i infrastructure.
Detailed focus will be on the 2 areas where data mining is being used
today.
1. The use of data mining technologies to solve business problems.
We will share some real world projects that we have used data mining
for.
2. The integration of data mining technologies into other applications,
such as CRM, to create analytical intelligence within these
applications. |
| Mary Rehus, Oracle |
Oracle9i Oracle
Reports 02/05/02 - 425k |
| Mary Rehus, Oracle |
Oracle9i Oracle
Discoverer 02/05/02 - 2M |
| Mary Rehus, Pat Larkin, Oracle |
Oracle9i OLAP
Services 10/30/01 - 515k |
| Rob Edwards |
Oracle9i Data
Warehouse Review 06/26/01 - 230K |
| Chris Muli |
SQL Extensions and Metadata |
| Rob Edwards |
Data Warehousing 101 |
| Rob Edwards |
Data Warehousing 102 |
| Chris Muli |
Data Warehouse Builder |
| Rob Edwards |
Data Warehousing: Extraction,
Transformation, & Loading |
| Rob Edwards |
Designing Star Schemas For Data
Warehousing |
| Oracle Corp. |
Data Warehouse Business
Intelligence |
| Meryl Surgan |
The Evolution Of Data Warehousing
|
| Angelo Bobak |
Three Parallel Paths to
Implementation of a Data Warehouse |
| Back |
Back to Top |
|
|
Tanel Poder
Researcher and Database EngineerMarch 4, 2008 |
Advanced Oracle Troubleshooting |
Arup Nanda
Lead DBA
Starwood Hotels
October 11, 2007 |
Real Life RAC
Performance Tuning
|
|
Sanjeev Jonglekar Technical Project - Advanced Customer Services. Oracle
February 28, 2007 |
Oracle
Streams
|
|
Mike Erwin - Hotsos Entreprise, Ltd. |
RAC
Performance Presentation Notes
|
|
Matthew
Zito, Chief Scientist for
GridApp Systems |
Strategies & Tools for
Centralizing and Automating Database Management |
Tom Kyte
Oracle Corporation |
Tom Kyte describes common SQL
techniques he has encountered and utilizes day to day to tune query
performance. Features such as scalar subqueries, using rownum (yes, to
'tune'), analytics, some hints and more will be demonstrated. Emphasis
is on when they work (where the 'trick' applies) as well as when they
don't work and where they do not apply. Care is taken to show these not
as a "top 10 things to do" but rather techniques to keep in mind when
looking at problems in general.
ZIP FILE |
| Logicworks |
Migrating To 10g On
Linux |
Jarugumilli, Barhmaiah, Entreprise
Architect
GE- Consumer Finance |
Analysis of Oracle System Load for Performance Management and Simulation
PRESENTATION
PAPER |
| Dave Anderson - SkillBuilders |
Oracle10g New Features:
Flashback Enhancements |
| Simay Alpoge |
Bulk Collections and Inserts
in Oracle 9i & 10g |
| Dave Anderson - SkillBuilders |
Oracle 10g Feature: RMAN
Incrementally Updated Backups |
| Larry Carpenter, Oracle Corporation |
Oracle DataGuard New
Features in 9i and 10g |
| Larry Carpenter, Oracle Corporation |
Introduction To DataGuard |
| Jeff Holt and Gary Goodman, Hotsos
Enterprises, Ltd. |
Using
10046 trace data to resolve Oracle performance issues - A review of
three case studies
Paper ;
Presentation -
This is a very interactive presentation where we will review 3 actual
case studies from the last year. We will examine our client's
performance problems and how the Hotsos method was utilized to rapidly
determine and repair the root cause issues. We will use these case
studies to show the effectiveness of using 10046 level 8 trace data as
the basis for Oracle optimization. We will close with a brief
discussion of Hotsos and a short demo of the Hotsos Profiler. |
| Bill Beauregard |
Oracle 9i Workspace
Manager Overview |
| Kristina M. Murray |
Automating Database
Startup and Shutdown on Unix 2/6/02 - 440k |
| Paul Baumgartel |
Designing For Performance
07/10/01 - 25k |
| Henry Pikner |
Oracle
Pipes- Presented on 05/17/00 |
Rachel Carmichael
Marlene Theriault |
DBA101: A Refresher Course -
50k |
Rachel Carmichael
Marlene Theriault |
Exploding
The Myths - by Rachel Carmichael & Marlene Theriault - 70k
Paper 40k |
| Marlene Theriault |
Oracle8 Challenges for DBAs |
| Megh Thakkar |
Oracle8 On Windows NT-
120k |
| Marlene Theriault |
Let's Tune Oracle8 For NT -
By Marlene Theriault 95k
Paper 60k
|
| Back |
Back to Top |
|
|
Jamon Bowen
Texas Memory SystemsMarch 13, 2008 |
Understanding Storage’s Impact on Oracle Performance
|
Nick Donatone
Grid Sales Consultant, Oracle Corporation January 29, 2008 |
PL/SQL Tips and Techniques
|
Geoffrey Wiland
SkillbuildersJanuary 29, 2008 |
XML in Oracle
|
Simay Alpoge
Next Information Systems, Inc.March 1, 2007 |
Oracle 10g analytical SQL for Business Intelligence Reporting
|
Larry Klein,
VP of Hotsos Entreprises, Ltd.June 27, 2006 |
Business consumers of an Oracle-based application
measure the success of "the system" based on the metrics of
availability, response time, and throughput.
Technical support staff measure that same system success using metrics
of utilization and transactions per second. These two views use
different vocabulary which often leads to miscommunication, ineffective
problem management, substandard performance, and over utilization of
hardware resources. This presentation suggests how "the system" can be
modeled as a factory, and common metrics can be established and shared
among all stakeholders in simple and meaningful ways.
Characterizing Workload thru an Oracle Database |
Prabhu Shanmugam
Arrow Electronics
June 27, 2006
LI & Web SIG Meeting |
Currently, application frameworks are very
prominent in software development whether you work with
home grown or COTS-based applications. This presentation
will describe the changes from function-oriented to
object-oriented to service-oriented development.
Attendees will learn how having a framework helps
application development with focus on some of the MVC
(Model-View-Controller) based frameworks, and how
component oriented development helps you work in the
service-oriented framework world.
Application
Frameworks |
|
Vikas Sawhney |
A Look at
Partitioning |
| Howard Horowitz - Oracle |
Oracle 10g (OCP)
Certification Preparation |
| Sandeepan
Banerjee - Oracle |
Integrating A Heterogeneous
Environment Using XML |
| Alex Hoyos, Senior Data Architect
Cablevision |
Accessing Oracle from C#
and Microsoft .NET |
Jack Raitto
CDC Development Manager, Oracle Corp. |
Change Data Capture in
Oracle 10g |
Martin Farber
Qualitec Inc. |
The Art Of SQL Tuning |
Michael Fargo
Cablevision/Data Modeler / Data Architect |
Materialized Views -
Euphoria, Reality and altering your Design |
| |
Backup Scripts (ZIP FILE)
Restore Scripts (ZIP FILE) |
Raj Sakthi
Senior Oracle DBA
NMHCrx |
GO LOCAL..! ALL ABOUT
LOCALLY MANAGED TABLESPACES - The audience will learn all about
LMT's. What makes them tick, Why it is a better choice, what are the
advantages, and more. |
Yomi Odedeyi,
Euro RSCG Circle |
Migrating
From Unix To Linux - An Oracle's Journey - Yomi discusses
his trials and tribulations migrating his Oracle Databases from Solaris
to Linux. He discusses topics such as cost justifications for doing it,
resources necessary, critical success factors, installation process,
lessons learned. |
| Rob Edwards, Dulcian |
Oracle 9i Data
Warehouse Review - Oracle9i Server presents
the latest move by Oracle in establishing a data warehouse platform for
supporting e-business intelligence applications. This new version
release of Oracle Server lays the foundation for a "Data Warehouse
Platform" that adds integrated OLAP services, data mining, an ETL
infrastructure, and additional analytical SQL functions to the
relational database. The new Oracle Warehouse Builder 3i, with its new
mapping architecture and enhancements, will also be reviewed. |
| Howard Horowitz |
Oracle
Certification Preparation (OCP) - Attendees
are introduced to general Oracle Certification Professional (OCP) exam
info, what's needed to pass the exams and an overview of each exam. This
45 minutes to one hour session is divided into two parts. First part
focuses on what OCP is and how it can help you in today's
market/economy. It examines the resources used to prepare for the exam
and discusses the structure of the exams and strategies used to pass
them.
The second part of the presentation discusses each section of the exam
and focuses on various topics
from each of the six sections. Exams discussed: (1Z0-001-Intro to SQL
and PL/SQL,
1Z0-023- Oracle 8i Architecture and Administration, 1Z0-025- Oracle 8i
Backup and Recovery,
1Z0-024-Oracle 8iPerformance and Tuning, 1Z0-026- Oracle 8i Network
Administration,
1Z0-030-Oracle 9I New Features). |
| Back |
Back to Top |
|
|
|
Dr.Paul Dorsey and Michael Rosenblum. Dulcian, Inc.
"Thick Database" Techniques in Web Architecture
August 7, 2008. |
Database
independence is frequently touted as a desirable quality in
applications. However, by placing logic in the database, applications
require less code, run faster, and will usually place less load on the
database than applications that are so called “database independent.”
The benefits of the "thick database" approach have been discussed
extensively at conferences in the last year or so. What is missing is
detailed information about how to implement this approach in real-world
projects. This presentation will provide a brief overview of the
benefits of the thick database approach as well as discussing specific
details about how to implement the approach in SQL and PL/SQL with
emphasis on collections and dynamic SQL/PL/SQL and will also demonstrate
a 100% thick database approach to application development where all code
and UI information is maintained in the database. This presentation is
targeted at experienced PL/SQL developers.
"Thick Database" Techniques in Web Architecture |
Eunhee Lee,
Returnpath
Oracle 10g Instant Client
May 3, 2007 |
This presentation addresses the
installation and issues one may encounter installing Oracle 10g Instant
Client onto an XP workstation.
Oracle 10g Instant Client XP Installation
|
Nick Dimtchev,
Oracle Corporation
Oracle overview of SOA reference architecture
May 3, 2007 |
This presentation will provide an
overview of SOA reference architecture, maturity model, and building
blocks. Nick will also discuss Process Orchestration with BPEL and
Business Rules, and Enterprise Services Bus for integration.
Oracle overview of SOA reference architecture
|
|
Tarek Abdelsalam, Oracle Corporation
Oracle Web Center Suite Overview and Demo
February 8, 2007 |
This presentation will discuss Oracle
WebCenter Suite, an integrated suite of technology designed to deliver a
unified, context-aware user experience specifically targeted at the
needs of information workers. Oracle WebCenter Suite combines the
standards-based, declarative development of Java Server Faces (JSF), the
flexibility and power of portal technology, and a set of horizontal, Web
2.0 services. Together these tools and services provide a unique ability
to build applications that eliminate context shifts and maximize
productivity.
Oracle Web Center Suite Overview and Demo
|
|
Prabhu Shanmugam Application frameworks - function oriented -to-
object oriented -to- service oriented
November 21, 2006 |
Application frameworks these days are
very prominent in software development whether you work in home grown
applications or COTS based applications. In this session you will learn
about the basics of how we have changed from being function oriented to
object oriented to service oriented. You will understand how having a
framework helps application development with focus on some of the MVC
(Model-View-Controller) based frameworks today. Towards the end of the
session, you will also understand how component oriented development
helps you work on the service oriented framework world.
Application frameworks - function oriented -to- object oriented -to-
service oriented
|
|
Greg Cranz
Model-Driven Architecture (MDA) with Java
October 05, 2006 |
There have been many articles written
recently extolling the virtues of Ruby on Rails as a technology that is
a "Java Killer" with regard to web application development. Claims have
been made that you can develop web applications in 1/3 the time using
Ruby than the time needed when using standard Java techniques. This
presentation will explore these claims and discuss how you can achieve
the same results using Java, MDA, "ruthless automation" and leveraging
open-source frameworks
Model-Driven Architecture (MDA) with Java
|
Prabhu Shanmugam
Arrow Electronics
June 27, 2006
LI & Web SIG Meeting
|
Currently, application frameworks are very
prominent in software development whether you work with
home grown or COTS-based applications. This presentation
will describe the changes from function-oriented to
object-oriented to service-oriented development.
Attendees will learn how having a framework helps
application development with focus on some of the MVC
(Model-View-Controller) based frameworks, and how
component oriented development helps you work in the
service-oriented framework world.
Application
Frameworks
|
| Back |
Back to Top |
|
|
Dave Anderson
SkillBuilders |
What's New For SQL Tuning?
Are you working on
Oracle9i but have yet to learn the new SQL tuning-related features? Are
you interested in what 10g delivers in this area? If so, this
presentation is for you. Dave will bring you up to speed on the latest
SQL statement performance and tuning features available with Oracle9i
and Oracle10g. Some of the new SQL language features available with
Oracle10g will also be presented. |