The Power To Develop
i Develop
2000
i Develop
Oracle Designer 6i
Joung Bai Park
Technical Consultant Oracle Korea
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Oracle Designer
i Develop
What is Oracle Designer?
Modeling and generation toolset
BPR, Information Engineering
Design and build database applications Captures realrequirements real Oracle Repository Integrated team-working environment Flexible productive development approach
i Develop
Application modeling, management and generation
Generate Data & Applications
Model Business Processes
Complete Design and File/Folder Capture and Management
i Develop
Oracle Server Generator
Oracle Designer Repository Online database Database DBA Server objects objects API
Server Generator Capture Alter DDL scripts Reconcile
i Develop
Integrated... Design and Build Environment
Design Editor
File Edit View Navigator Utilities Messages Tools Help Run Options Window
Object Navigator
Travel
PASSPORT MNU01 Called CITIES
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Oracle8i Server Modelling
i Develop
Why model your Schema?
Ease of Design Clarity of communication Productivity Dependency management
i Develop
Model Driven Schema Design
Table Details Trigger Index Synonym Primary Key Unique Key Check Constraint
EMP (#)
[ [ [ [ o o [ o EMPLOYEE_NUMBER LAST_NAME FIRST_NAME MANAGER_NUMBER OTHER_INITIALS START_DATE POSITION EMAIL_ADDRESS
Foreign Key Sequence
Datatype icons Valid values?
EMPLOYEE_PK EMP_LAST_NAME_IX
Other Secondary Elements
i Develop
What can be Modeled?
Relational schema constructs
Tables / columns / constraints .
Object & warehouse structures Declarative extension to the schema
Auditing Auto-generated values Allowable values / domains ... Schema distribution Denormalized structures i Develop
Application architecture
Declarative Display Properties
Display type Prompt
Available Software
Image
Char
Products
Name
Oracle Developer Oracle Designer Oracle Discoverer
Logo
Description
RAD and internet deployment Model-driven and generation Drill, pivot and chart
The Product Name
Hint text
i Develop
Enhanced Data Schema Definition
Set extra declarative properties for defaulting
Schema definition properties Generator display properties
Action Edit Block Field Action Edit Block Field
Copies
+
Customers:
Name Data type Optionality
Display type Display sequence Prompt / length
i Develop
Reference Code Tables
Extracted from Columns & Domains
Values, abbreviations & meanings Improved data integrity Code reuse through Server API Reduced maintenance costs Forms, Reports, VB and PL/SQL Web Server API
i Develop
Advantages over hard-coding
Used by
Distributed Database Design
Network of Databases Generates
Replication groups / master objects Database links Snapshots Implementation properties Storage, tablespaces ...
i Develop
Multiple Schemas
D E M O N S T R A T I O N
Oracle Designer Server Modeling and Generation
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Capturing Existing Schemas
i Develop
Server Generation and Capture
Oracle
DB2/2 DB2 workbench DB2 MVS 4.x DB/2 CW Microsoft SQLServer
Repository
Sybase
ANSI SQL DDL
ODBC Databases
i Develop
Online Database Capture
Database Navigator File View NavigatorUtilities Utilities
scott@dev Recover Design dev scott Tables BONUS DEPT EMP SALGRADE Views Snapshots Sequences Clusters Functions Packages
Online tool for server capture Batch utility for large schemas Capture new objects Reconcile against existing definitions
i Develop
D E M O N S T R A T I O N
Oracle Designer Design Recovery
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Multi-Tier API Generation
i Develop
Oracle Server API Generator
Server API Encapsulate business rules Business logic Auto generation
Dynamic HTML
Support application architecture Transaction support Journaling & denormalization Validate constraints
Oracle Forms
Database objects
i Develop
Server API Generation
Server API
Module component API - module handler Dynamic HTML
Query Insert Update Delete Lock
Table API - table handler Insert Update Delete Lock
Oracle Forms
Database objects
i Develop
Oracle Server API Generator
Server API Oracle Designer Repository
Module component API - module handler Query Insert Update Delete Lock
Module components Tables / Views
Business logic event code Denormalization Derivations Journaling ...
Table API - table handler Insert Update Delete Lock
Database objects
i Develop
Server API - Triggers
Oracle Designer Repository Server API
Module component API - module handler Query Insert Update Delete Lock
Tables / Views
PRE-INS
Table API - table handler -
Table API triggers
PRE-UPD
Insert
Update
Delete
Lock
PRE-DEL
DML issued from any application
Database objects
i Develop
Customizing the API
Table API trigger DMLBEGIN
Before event User defined before event code Generated code After event User defined after event code END
Table API procedures Application
BEGIN BEGIN Pre event User defined pre event code Generated code Post event User defined post event code END
call
END
i Develop
D E M O N S T R A T I O N
Oracle Designer Server API Generation
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Configuration Management of Oracle8i
i Develop
Oracle Designer and Oracle Repository
Oracle Repository
Configurations Admin Tools
Workarea
Check Out Check In
Designer Tools
i Develop
Oracle Repository
Oracle Repository
Stores project resources
All project files & folders Element level versioning Branch, merge, difference Dependency analysis
i Develop
Dependancy Analysis
Oracle Repository
Designer Model
<?XML?>
XML Import
Parsers
<?XML?>
File system
Dependency Manager
Parser mappings
i Develop
Parser XML Output
Employees.sql
<parse_context workarea_name='my_workarea'> <parsed_object type='PRIMARY_ACCESS_FILE'> <source> <file name='d:\Employees.sql'/> </source> <dependency type='uses' subtype='select'> <target name='EMP.ENAME' type='COLUMN'/> <status value='certain'/> </dependency> <dependency type='uses' subtype='select'> <target name='EMP' type='RELATION_DEFINITION'/> <status value='certain'/> </dependency> </parsed_object> </parse_context>
select ENAME from EMP
i Develop
Server Generation and Versioning
Reconcile online database against workarea Design Capture new objects into a workarea Design Capture existing objects and reconcile against existing objects creating new versions - implicit branching
i Develop
D E M O N S T R A T I O N
Oracle Repository Dependancy Management
i Develop
Agenda
Oracle Designer Oracle8i Server Modeling Oracle8i Capturing Existing Schemas Multi-Tier API Generation Configuration Management of Oracle8i Oracle8i Summary
i Develop
Oracle8i Oracle8i
Oracle Designer Oracle8i Server modeling Oracle8i Design Capture Multi-tier applications Dependency management
Model-driven Design, Development and Deployment with Oracle Designer 6i
i Develop
Oracle Designer 6i 6i www.oracle.com Oracle Technology Network technet.oracle.com technet.oracle.com Oracle Certified Professional technet.oracle.com/training technet.oracle.com/training Oracle Support Services technet.oracle.com/support technet.oracle.com/support
i Develop
The Power To Develop
i Develop
2000
i Develop
