Table of Contents

Oracle Designer Handbook

By Peter Koletzke and Dr. Paul Dorsey

[Back]

Thanks to Warren Capps for typing this.

Click on a chapter number

1

2

3

4

5

6 7 8 9 10

11

12

13

14

15

16 17 18 19 20

21

22

23

24

25

26 27 28 29  

 

Part I - Getting Started

1 - Introduction to System Design Methodology

Overview of CASE Application Development Method (CADM)

Beyond the Waterfall

Strategy

Pre-Analysis

Analysis

Pre-Design

Design

Build

Test

Implementation

Maintenance

Conclusion

2 - Introduction to Oracle Designer

The Repository

The Front-End Tools

The Oracle Designer Interface

How the Oracle Designer Tools Fit into CADM

Conclusion

Part II - Life Cycle Phases

3 - Strategy

Overview of the Strategy Phase

Deliverables

Strategy Document

Application Partitioning

Scope

Strategy Document Example

Modifications for Smaller Systems

When is the Strategy Phase Complete?

4- Oracle Designer in Strategy

Process Modeller

Entity Relationship Diagrammer

Tracking Documents in RON

5 - Pre-Analysis

Overview of the Pre-Analysis Phase

Deliverables

Goals of Pre-Analysis

Information Gathering

Requirements Analysis

The Analysis Plan

Analysis Plan Example

Modifications for Smaller Systems

When is the Pre-Analysis Phase Complete?

6 - Oracle Designer in Pre-Analysis

Repository Object Navigator

Repository Reports

Mapping System Requirements to Repository Elements

7 - Analysis - Information Gathering

Deliverables

Overview of Information Gathering

Eliciting Requirements from the Users

Legacy System Review

Security

Unit-Level Analysis

Modifications for Smaller Systems

When is Information Gathering Complete?

8 - Oracle Designer in Analysis - Information Gathering

Process Modeller and Entity Relationship Diagrammer in Information Gathering

Dataflow Diagrammer

Legacy System ERD

Tracking Report Audits with User Extensions

9 - Analysis - Requirements Analysis

Overview of Requirements Analysis

Deliverables

Security

Executive Information Systems (EIS) and Ad Hoc Query Needs

Modifications for Smaller Systems

When is Requirements Analysis Complete?

10 - Oracle Designer in Analysis - Requirements Analysis

Entity Relationship Diagrammer

Process Modeller in Requirements Analysis

Dataflow Diagrammer in Requirements Analysis

Function Hierarchy Diagrammer

Matrix Diagrammer

Repository Reports in Analyis Phase

11 - Pre-Design

Overview of Pre-Design Phase

Deliverables

Design Standards

Conceptual Design of Applications

Design Plan

Modifications for Smaller Systems

When is the Pre-Design Phase Complete?

12 - Oracle Designer in Pre-Design

Design Editor

Generator Preferences

Database Design Transformer

Application Design Transformer

Integrating the Storyboard Tables

Integrating the Storyboard Modules

Capture Design of Form and Report Utilities

Repository Object Navigator and API in the Pre-Design Phase

Repository Reports in the Pre-Design Phase

13 - Design - Database Design

Overview of Database Design

DBA Issues

Object-Relational Databases

Modifications for Smaller Systems

When is Database Design Complete?

14 - Oracle Designer in Design - Database Design

Server Model Diagram

Defining Data Elements

Logic Editor

Designing Objects with Oracle Designer

Database Navigator

Repository Reports in the Design Phase: Database Design

15 - Design - Application Design

Overview of Application Design

Deliverables

Internal Control and Security

Test Plan

Modifications for Smaller Systems

When is Application Design Complete?

16 - Oracle Designer in Design - Application Design

Module Network Viewer

Module Diagram

Module Component API

Module Application Guide

Reference Tables

Implementing the Control Exposure Matrix

Matrix Diagrammer in Application Design

Repository Reports in the Design Phase: Application Design

17 - Build

Overview of the Build Phase

Deliverables

Building the Database

Building the Modules

Tuning and Unit-Level Testing

Documentation and Help

Modifications for Smaller Systems

When is the Build Phase Complete?

Conclusion

18 - Oracle Designer in Build

Generate Database from Server Model Utility

Generating Modules

Forms Generator

Library Generator

WebServer Generator

Report Generator

Visual Basic Generator

MS Help Generator

Repository Reports in the Build Phase

19 - Test, Implementation, and Maintenance

Overview of the Test Phase

Modifications for Smaller Systems

When is the Test Phase Complete?

Implementation

Implementation Modifications for Smaller Systems

When is the Implementation Phase Complete?

Maintenance

Maintenance Modifications for Smaller Systems

When is the Maintenance Phase Complete?

Conclusion

20 - Oracle Designer in the Test, Implementation, and Maintenance Phases

The Test Phase in Oracle Designer

The Implementation Phase in Oracle Designer

The Maintenance Phase in Oracle Designer

21 - Change Control

Guarding Against "Scope Creep"

Change Control During Each Phase of the Process

Part III - Additional CADM Activities

22 - RAD-CADM

What is RAD-CADM?

Critical Success Factors for Making RAD-CADM Work

Details of the RAD-CADM Process

Conclusion

23 - "Start in the Middle"

Starting with a Failed Attempt

Assessing a Partially Completed Project

"Start in the Middle" Deliverables and Methodology

Conclusion

24 - Business Process Reengineering (BPR)

What is Reengineering?

Why Reengineer?

Keys to Successful Reengineering

25 - Data Migration

Overview

Why Data Migration Can Be Difficult

The Phases of Data Migration

Data Transformation Tool vs. Programmer

Decision Factors in Selecting a Data Transformation Tool

Conclusion

Part IV - Additional Oracle Designer Activities

26 - Application System and Repository Maintenance

Managing Application Systems with RON

Managing the Repository with RAU

Repository Reports for Administration

Bypassing the Oracle Designer Window

Additional Sources of Information

27 - User Extensibility

What are User Extensions?

Elements, Associations, and Text Types

Creating User Extensions

What's Next?

28 - Application Programming Interface

What is the API?

Getting Started with the API

Manipulating Multiline Text

Sample Uses for the API

29 - Information Flow

Repository Review

How the Information Flows in the Repository

Methods for Discovering Information Flows

Examples of Analysis to Design

Examples of Flow from Design Definitions to Generated Code

Examples of Database and Application Design Capture

Last updated 2 May, 2000