copyright oracle corporation, 1999. all rights reserved. 6 cmis 570 - powell oracle designer:...

Copyright Oracle Corporation, 1999. All rights reserved.

66Oracle Designer:

Prototype Application Generation

CMIS 570 - PowellCMIS 570 - Powell

12-12-22 Copyright Oracle Corporation, 1999. All rights reserved.

Setting the SceneI’d like a checkboxto indicate if the order is paid in full.

We have three different screens that show order information.

And I want a Paid in Full checkbox on all three of them.


Overview

• Preparing for application generation– Refining column display properties– Defining GUI display types

• Transforming the function model• Accepting candidate modules• Generating an Oracle Form module


Which is More Efficient?• What you want:

• How to achieve it:

– Define it once, then use it

Paid in Full?

Paid in Full?

PromptPromptDisplay TypeDisplay Type

– Define it every time you use it

Paid in Full?

Paid in Full?

Paid in Full?

Paid in Full?


Two Types of Column Properties

Display Display propertiesproperties

DefinitionDefinitionpropertiesproperties

Other Database

Browser:http://

HollywoodHollywood XXAction Edit Block Filed

++Customers:


Column Definition Properties

…..

…..

DefinitionColumn Name

DisplayDisplay Type

Sequence

Display Sequence

Data Type

Length

• Define how a column is implemented

Other Database


Display Properties at Work

Speedy Pizza

CustomerCustomers

Last Name Photograph Work Telephone No

Jones

El MokriCheeks 407-575-5555

44-116-66-7878

888-555-9000

Display TypeDisplay Type

ImageImage CharChar

The Last Name of the Customer

PromptPrompt

Hint TextHint Text


…..

…..

DefinitionColumn Name

DisplayDisplay Type

Sequence

Display Sequence

Data Type

Length

Column Display Properties

• Provide defaults for how modules use the column

• Promote standards• Save time

Browser:http://

HollywoodHollywood XXAction Edit Block Filed

++Customers:


Flowdown from Analysis Work

NameCommentFormatLengthHeightDomain

PromptHint textDisplay TypeDisplay Length Display HeightDomain

Attribute Column


How Domains Flow Down

Attribute

Column

Edit Domain

Detail Values Domain valid values

Display TypeDisplay Length

FormatMax Length


DisplayControls UI

Edit Table PRODUCTS

Where to Set Display Properties(in Design Editor – Server Model)

DisplayDisplaySequenceSequence PromptPrompt

Display TypeDisplay Type

Display Height and WidthDisplay Height and Width

Hint textHint text

Display FormatDisplay Format

AlignmentAlignment


What Display Properties to Consider

• Prompt• Display Type• Format Mask• Hint Text• For large text items or image items:

– Display Height and Display Length


Display Type: GUI Items

Charge

• Available only for columns with allowable values

Radio groupRadio groupPaid in fullPaid in full

CheckboxCheckbox

PoplistPoplist

CashCashChargeCheck

Form ofPayment

Cash

Check


Guidelines for Display Type• Check boxCheck box

– Use for columns with 2 possible values

– Has to have allowable values and mandatory property

• RadiogroupRadiogroup– Use if you have 3-5 allowable values

• PoplistPoplist– Use if you have 6-20 allowable values


Practice 1

In the HOLLYWOOD application:• Change FHD to remove hyphensremove hyphens (-) from

Function names (e.g., ADD3 - Record…)• Check and refine Prompt and Hint Text

for all columns in the TITLES table• Set MONOCHROME column in TITLES

table to display as a checkbox• Make sure no fields or domains use

CHAR data type (need to use VARCHAR2)


Overview of Tasks to Transform and Generate Application Prototype

1. Verify Function: Data Usages2. Refine Column Display Properties3. TRANSFORM into an application design using the ADT4. ACCEPT candidate modules using Design Editor5. GENERATE and run the prototype


Transforming the Function Model

• Transform the Function Model into a module design– Use the ADT (Application Design

Transformer)– In general, each atomic (leaf) function

becomes a candidate module


Transforming the Function into a Working “Form”

BlockModule ComponentEntity Usage

FormModuleFunction

Physical BuildPhysical BuildDesignDesignConceptualConceptualModelModel

ADTADT GenGen


Understanding the Process

Leaf functionsLeaf functions

CRUD matrixCRUD matrix

InputInput OutputOutputModulesModules

ORD0030ORD0030

CUS_MCCUS_MC

CUSTOMERS

ORD0020ORD0020

CUS_MCCUS_MC

CUSTOMERS

ORD0010ORD0010CUS_MC

CUSTOMERS


Data Usages Transformed

CRUD matrixCRUD matrix

CUSTOMERSORDERS

Module data usagesModule data usages

PRODUCTSITEMS

Data used by a formData used by a formSpeedy Pizza

Order

Items


Using the Transformer

1. Click the Application Design Transformer icon

2. Click Generate3. View / print the report4. In Design Editor,

accept candidate modules

??


DEMO (watch me)

Create a First-Cut Application Design: Run the ADT Review the transformation report

THIS IS A HUGE TASK FOR ORACLE !THIS IS A HUGE TASK FOR ORACLE !Don’t interfere with my demo !!!Don’t interfere with my demo !!!


DEMO Questions

1. What kind of function becomes a candidate module?

2. What makes a function become a Form vs. a Report?


Rules for Transforming Functions• Results depend on Response property

and data usages• See the ADT report . . .

Immediate Screen Screen Manual

Entity Usages

Overnight Utility Report Manual

Response R only noneany ofC/U/D


Candidate Modules

• Output of the Application Design Wizard

• Use the Design Editor to accept or delete (via Module Properties Module Properties )

Candidate Module A module created by the Application Design Transformer from data entered during analysis. You can either accept or reject the candidate module.

??


Accepting the Candidates

ModulesORD0010ORD0020ORD0030

PlanningStatusCandidate?

Speedy: Module Properties

YesNoModulesORD0010ORD0020ORD0030


DEMO (watch me)

Select candidate modules for HOLLYWOOD prototype application generation:

• By setting the Candidate? Field to NO.


Is Generation the Next Step?

• Generating a prototyperequires:– A module– Data usages

• Generating a production application requires:– A module– Data usages– Refinements to the module designRefinements to the module design

ORD0010ORD0010CUS_MC

CUSTOMERS


Generating a Module

1. Select a module

ORD0030

Modules

ORD0020

ORD0010

3. Click Start

2. Click

Generation complete.You can save, delete . . .

Generating the binary ...Generating the executable ...

4. Read the messages

5. Save or revert the changes


Generating a Module (cont.)

6. Click “List Actions” icon

7. Select “Run Form” and click Run button to view the prototype application

Generating the binary ...Generating the executable ...


DEMO (watch me)Generate a Form prototype application:• Select HOLLYW0070• Generate• Save• Click “List Actions” to select Run Form• View the prototype form

• Note the checkbox display type on the form


SummaryAfter your database is generated, you can

generate prototype application modules following this process:

1. In Design Editor, refine Column Display Properties

2. Verify Function: Data Usages3. Run the ADT4. View the report and print it out (click on Show

Results)


Summary

5. In Design Editor, click on the Modules tab. Expand Modules.

6. Highlight the first candidate module. Click on the long box, then click the pencil icon.

7. Click NO next to the Candidate? field. Click Save.

8. Click the next candidate module, and repeat step 7. Continue until all candidate modules have been set to NO.


Summary

9. In Design Editor, select a design module and Generate it

copyright oracle corporation, 1999. all rights reserved. 6 cmis 570 - powell oracle designer:...

Documents