Life Cycle Management Using Oracle 9i Warehouse Builder - PowerPoint PPT Presentation

About This Presentation
Title:

Life Cycle Management Using Oracle 9i Warehouse Builder

Description:

Life Cycle Management Using Oracle 9i Warehouse Builder. Anissa Stevens ... Life Cycle Management. Re-import: Update the Warehouse Builder repository ... – PowerPoint PPT presentation

Number of Views:68
Avg rating:3.0/5.0
Slides: 16
Provided by: downloa6
Category:

less

Transcript and Presenter's Notes

Title: Life Cycle Management Using Oracle 9i Warehouse Builder


1
Life Cycle Management Using Oracle 9i Warehouse
Builder
  • Anissa Stevens
  • Avanco International, Inc.
  • anissa_at_avanco.com
  • 703-749-7749

Mark Van De Wiel Oracle Corporation
2
Avanco Corporate Oracle Expertise
  • ORACLE Customer Advisory Program (BI and Oracle
    Portal)
  • ORACLE Certified Developers
  • Oracle 9iAS Portal, Discoverer, Developer,
    JDeveloper
  • Known Oracle authors (Oracle Press)
  • Steve Vandivier Oracle 9iAS Portal Handbook
  • Anissa Stevens Oracle Security Handbook
  • Oracle Data Warehousing expertise
  • Oracle 9iAS expertise

3
Agenda
  • Introduction
  • Oracle Warehouse Builder Overview
  • Metadata Repository
  • Version Control
  • Life Cycle Management
  • Demo
  • Questions

4
Data Warehousing Process
Store
Use
Feed
  • Feed from various operational and external data
    sources, using a controlled process for data
    integration
  • Storage specific to the needs of decision
    support, separate system/function from
    operational systems
  • Used by a wide variety of people within an
    organization with a range of an job functions,
    responsibilities

5
Oracle Warehouse Builder
6
Design and Deployment With Warehouse Builder
  • Relational
  • Flat Files
  • Applications
  • Mainframe

Oracle8i or Oracle9i
7
Metadata Repository
  • Data Definitions
  • Allows you to recreate the environment
  • Import definitions from a variety of systems
  • Add metadata through GUI, public Java API or
    scripting used with OWB
  • Extensible with user-defined properties

8
Version Control
  • OWB creates snapshots at any point/level in the
    repository
  • OWB manages two types of snapshots
  • Full entire definition of every object
    captured. Can migrate from one repository to
    another
  • Signature signature of the object definition
    captured. Used for comparison purposes.

9
Change Manager
10
Life Cycle Management
  • Scenarios
  • Change to Source System
  • OWB analyzes metadata, creates impact analysis
    diagrams
  • Changes to Target System
  • OWB provides graphical lineage diagrams to
    locate reverse impact for a change

11
Life Cycle Management
  • Re-import Update the Warehouse Builder
    repository
  • Warehouse Upgrade Update the target schema

Oracle8i/Oracle9i Target
OWB Repository
Data Source
Re-import
Re-import
Warehouse Upgrade
12
Impact Analysis
13
Upgrading the Target
  • OWB analyzes metadata and generates scripts for
    all changes
  • OWB generates alter object scripts for objects
    that contain data
  • OWB will rename the object definition and create
    the object, then reload from old object

14
Demo
15
QUESTIONS?
Anissa Stevens Avanco International,
Inc. anissa_at_avanco.com 703-749-7749
Mark Van De Wiel Oracle Corporation
Write a Comment
User Comments (0)
About PowerShow.com