Inside ORACLE Designer/2000

KEY TOPICS: This book covers all components of the Oracle Designer/2000 suite, including tools for business modeling, system design and software development. It includes detailed coverage of Designer/2000 methodology; analysis and design; application partitioning; defining and implementing business rules; and developing for thin clients. It presents concepts and activities in an iterative fashion, helping you gradually build your knowledge, confidence and comfort level with the Designer/2000 tools. The book includes many examples, including the step-by-step construction of OLTP and data warehouse systems. The CD-ROM contains not only finished applications, but also ScreenCam "movies" that show how to perform many of the most important activities covered in the book.

MARKET: Database and application developers, programmers and administrators; modelers and architects.

• Understand the latest version of Oracle's suite of tools for business process modeling and reengineering.
  
• Use Designer/2000 for application partitioning and thin client application development.
  
• Walk step-by-step through the rapid design and development of applications with Designer/2000.

Table of contents :
I. INTRODUCTION TO DESIGNER/2000

1. Analyzing the Requirements

Creating a New Application System
Data Modeling
Function Modeling
Summary

2. Designing and Generating Database Objects

Database Design Transformer
Designing the Physical Database
Enhancing the Data Design
Generating Database Objects
Summary

3. Designing and Generating Software Modules

Generating the Initial Module Design
Enhancing the Design of User Interface Modules
Expanding Modules with Unbound and Action Items
Designing and Programming PL/SQL Modules
Generating the Application Modules
What Next?
Summary

4. Understanding the Designer/2000 Architecture

Overview of Designer/2000
Designer/2000 Repository Model
Repository Administration Utility
Extending and Customizing the Repository
Summary

5. Maintaining Application Systems

Creating and Maintaining Application Systems
Creating and Maintaining Application Objects
User-Defined Object Sets
Summary

6. Object Navigators in Designer/2000

Components of Object Navigators
Working with Navigator Windows
Working with Property Palettes
Summary

7. Diagrammers in Designer/2000

Diagrams and Diagrammers
Components of Diagrammers
Working with Diagrams
Working with Objects in Diagrams
Customizing Diagrammer Preferences
Enhancing Diagrams with OLE Technology
The Matrix Diagrammer
Summary

II. STRATEGIC PLANNING AND BUSINESS AREA ANALYSIS

8. Modeling the Business Direction of the Enterprise

Setting the Scene
The Enterprise Model Business Units Goals and Objectives
Problems
Critical Success Factors
Key Performance Indicators
Assumptions
Summary

9. The Enterprise Functional and Information Models

Defining the Functional Model of the Enterprise
Defining the Information Model of the Enterprise
Modeling Mutual Exclusivity of Data and Relationships
Associating Entities with Other Repository Objects
Summary

10. Modeling Business Processes

What Are Business Processes?
Why Model Business Processes?
Creating the Process Model of the Enterprise
Creating Processes in the Process Modeller
Modeling the Customer
Analyzing the Business Areas of the Enterprise
Summary

11. Business Area Analysis

Defining Business Area Processes
Analyzing Processes in Detail
Animation and Multimedia
Synthesizing the Business Area
Summary

12. Business Process Reengineering

Symptoms of Aching Processes
Prescriptions for Aching Processes
Preparing for Reengineering Business Processes
Reengineering
Reengineering TASC
Summary

III. SYSTEMS REQUIREMENTS DEFINITION AND ANALYSIS

13. Requirements Analysis

Business Requirements and System Requirements
Using Designer/2000 in Requirements Analysis
Building the High-Level System Model
Documenting the High-Level System Design
Defining the User Interface Requirements
Summary

14. Data Modeling

Techniques and Approaches to Data Modeling
Entity Modeling
Domains in Designer/2000
Relationship Modeling
Normalization and Denormalization of Data
Data Modeling for Data Warehouses
Maintaining Multiple Data Models
Summary

15. Business Rules Modeling

Function Data Usages
Business Rules
Data Definition Rules
Data Manipulation Rules
Access Privilege Rules
Summary

16. Quality Assurance of the System Requirements

Organizing the Diagrams
Verifying and Reporting the Data Model
Verifying and Reporting the Functional Model
Summary

IV. SYSTEM DESIGN

17. Creating the Initial Logical Database Design

Database Design Transformer Interface
Creating the Logical Database Design
Controlling the Settings of the Transformer
How the Transformer Creates the Database Design
Maintaining the Logical Database Design
Mapping Supertype and Subtype Entities to Tables
Summary

18. Enhancing the Logical Database Design

Maintaining Data Diagrams
Maintaining Tables
Providing for Data Auditing and Journaling
Creating and Maintaining Indexes
Maintaining Views
Maintaining Snapshots
Creating and Maintaining Sequences
Using the Database Object Guide
Summary

19. Implementing the Physical Database Design

Documenting the System's Foundations
Defining Database Components
Defining Database Users
Implementing Logical Design Objects in a Database Schema
Using the Database Administrator Guide
Preserving the Physical Database Design Flexibility
Summary

20. Implementing Business Rules with Constraints

Business Rules Reviewed
Implementing Business Rules
Creating and Maintaining Constraints
Primary and Unique Key Constraints
Foreign Key Constraint Properties
Check Constraint Properties
Deriving Column Values in Front-End Applications
Summary

21. Creating the Application Design

The Purpose of the Application Design Transformer
Generating Presentation Layer Modules
Accepting and Rejecting Candidate Modules
Generating Menu Modules
Summary

22. Maintaining Modules in the Design Editor

Modules in Designer/2000
Structure of Modules
Working with Modules
Creating and Maintaining Module Elements
Module Wizards
Reusable Components
Summary

23. PL/SQL in Designer/2000

Overview of PL/SQL
Procedural Constructs of PL/SQL
Data Types and Variables
Cursors in PL/SQL
PL/SQL Program Units
Exception Handling
Summary

24. Maintaining PL/SQL Objects in Designer/2000

Maintaining Server Side PL/SQL Objects
Understanding and Maintaining the Server API
Maintaining Application Logic Objects
The Logic Editor
Working with the Logic Editor
Summary

V. SOFTWARE GENERATION AND DEVELOPMENT

25. Generating Database Server Objects

Preparing for Generation
Designer/2000 Server Generator
Post-Generation Tasks
Different Scenarios of Using the Server Generator
Recovering the Design of Databases
Summary

26. Generating Front-End Software Modules

Repository-Based Software Development
Maintaining Preferences
Object Class Libraries
Generator Templates
Designer/2000 Front-End Generators
Summary

27. Introduction to Generating Developer/2000 Forms Modules

Preparing for Generation
Enforcing Application-wide GUI Standards
Implementing a Flexible Messaging Strategy
Generating Developer/2000 Forms Modules
Summary

28. Advanced Developer/2000 Forms Generation

Generating Forms with Multiple Table Usages
Item Lookups and Lists of Values
Adding GUI Controls to Modules
Adding Calendar Controls to Developer/2000 Forms Modules
Summary

29. C++ Object Layer Generator

The Purpose of the C++ Object Layer Generator
Preparing for C++ Generation
Using the C++ Object Layer Generator
Understanding the Output of the C++ Object Layer Generator
Summary

Index