Transcript WDSc Plus - Databorough

System i Application
Design Recovery &
Rebuilding with
X-Analysis 8
Stuart Milligan – Databorough
[email protected]
© 2007Databorough Ltd, Weybridge Business Centre, 66 York Road, Weybridge, KT13 9DY, United Kingdom, Tel: +44 (0)1932 848564, Fax: +44 (0)1932
859211, E-mail: [email protected], Website: www.databorough.com
Databorough
20 Years i series experience
Experts in state-of-art modern technologies
Experts in legacy technologies and applications
Automated Modernization Technology Experts
(X-Analysis)
Large Projects Experience
Global presence and workload distribution
– Asia Pacific
– Europe
– Americas
Certified Consultants
System i Specialization
Some of X-Analysis Users
Lab Services
Global Services
IBM RedBook on X-Analysis
Databorough X-Analysis
successfully validated to Ready for
IBM Rational software V7.0.3!
X-Analysis qualified for the Best
Practice Indicator.
White Paper
Modernizing System i
Applications Using
Design Recovery
http://www.databorough.co
m/papers/index.html
X-Analysis Architecture
Automated Repository Generation
Business Logic
Existing
System
Displays
Programs
Data Base
Automated
Extraction &
Refresh
X-Analysis
Repository
Business Rule
Logic
Data Model
Source
Data
Validation
Calculations
Secondary Reads
Secondary Updates
Batch Calls
Data Model
Data Dictionary
Logical Files/Views
Key Map
Relationships
Special Fields
Cross-Reference
Data
Cross-Ref Data
2E: Model
All Objects
All Source
All Languages
All Variables
The Modernization Evolution…
Analysis
Model Driven
Development
Modern
Development
Design
Recovery
Semi
Automated
Re-Build
X-Analysis
Analysis & Documentation
Familiarization
System wide perspective
Visualization of Design
Drill-Down from high-level to detail
Non System/Technology Expert Inclusion
Consistent & Current Information Sharing
Scope & Metrics
Design Recovery
Application Areas
–
–
–
–
Rules Based
Hierarchical
Diagrams
Pervasive throughout XA
Data Model
–
–
–
Relational & Physical
Date Fields
Logical Views
Business Rule Logic
–
–
–
–
–
Validations
Calculations
Summaries/Narratives
Indexed
Mapped to Screens
Transaction Model
–
–
–
–
Screen Formats/Layouts
Screen Actions
Screen Fields/Files/Attributes
Data Model Mapping
Model Driven Modernization
Recovered Relational Database Models
Exported DDL
CREATE TABLE Transaction_History (
Period FOR COLUMN
XWE4NB
Trn_Hst_Date FOR COLUMN
Trn_Hst_Seq FOR COLUMN XWC8DT
Debtor FOR COLUMN
XWBCCD
DGrp FOR COLUMN
XWBNCD
Del_Area FOR COLUMN
XWBDCD
Rep FOR COLUMN
PERSON
Store FOR COLUMN
XWAACS
Product FOR COLUMN
XWABCD
Stk_Grp_1 FOR COLUMN
XWAGCD
Stk_Grp_2 FOR COLUMN
XWAHCD
Stk_Grp_3 FOR COLUMN
XWAICD
Doc_Ref FOR COLUMN
XWT8TX
Contract FOR COLUMN
XWORDN
numeric(6, 0) NOT NULL,
XWDLDT
NOT NULL,
numeric(11, 0) NOT NULL,
char(11) ,
char(2) ,
char(3) ,
char(3) ,
char(11) ,
char(20) ,
char(2) ,
char(2) ,
char(2) ,
char(15) ,
numeric(6, 0) ,
ALTER TABLE Contract_Header
ADD CONSTRAINT Contract_Header_REFERS_Order_status_description FOREIGN KEY (Status)
REFERENCES Order_status_description (Status_code);
ALTER TABLE Contract_Header
ADD CONSTRAINT Contract_Header_REFERS_Salespersons FOREIGN KEY (Rep)
REFERENCES Salespersons (Person);
ALTER TABLE Sites
ADD CONSTRAINT Sites_REFERS_Distributors FOREIGN KEY (Product_Code)
REFERENCES Distributors (Code);
ALTER TABLE Purchases
ADD CONSTRAINT Purchases_REFERS_Sites FOREIGN KEY (Prospect_No)
REFERENCES Sites (Cus_No);
Data Model Export
Explicit Definition
Table/File Attributes
Indices/Logical Views/Access Paths
Field Attributes
Foreign Keys
DDL format for RSA/MS SQL/Oracle or DDS
Regeneration
Using the Derived Relational Model
MyEclipseBlue
RSx
Borland
Legacy
Data Base
& RPG/COBOL I/O
Logic
Object
Relational
Mapping
BI and
Reporting Tools
DB2 Web Query
DDL/SQL
Data Model
Test
Data
Extraction
Referential
Integrity
Reports
BI & Reporting
Mapping a database into a BI tool is a manual, laborintensive job.
With the Derived, Explicitly-defined Schema
You/X-Analysis can:
– DB2 Web Query meta-data creation
– Drill down DB2 Web Query Application
DB2 Web Query Quick Start
Ready-to-build
Queries
Meta-Data
DB2-WQ
API
Data Model
•Synonyms
•Attributes
•Date Fields
•Foreign Keys
Instant
OLAP
UML Diagrams use case, activity, class
Business Rules Extraction
Activity Diagram
UML Diagrams
Use Case
Diagram
Application
Area
Activity
Diagram
Business
Rule
Database
Transaction
Model
Elements
Class
Diagram
Data
Model
Diagram
Rebuilding Legacy Applications
The objective a true modernization
exercise is to extract the essence or
design of the legacy application, and reuse
these design as appropriate in rebuilding
the application using modern languages,
development tools and techniques,
tapping into more widely available skills
and resources.
Re-Building Applications from Designs
Database Modernization
–
DDS to SQL conversion
–
Optional I/O RPG/SQL Service Modules Created
–
Optional Persistence Framework Generation
Business Logic Rebuild
–
Business Rules database and XML Output
–
Business Logic Model converted to Java , EGL, or kept in RPG
MVC Web Application generation
–
UML Extension from Transaction Model as XML
–
UI - JSF Facelets, JSF & EGL page Handlers, or PHP
–
Generic I/O & Validation Classes per table – Java, EGL, or PHP
–
Business Logic Classes
Model Driven Modernization
Generate New Application
RPG Stored
Procedure
Transaction
Model
JSF
JSF
Bean 3
Business
Rule
Bean
Persistence
Framework
DDS
Production
Data
Convert
DDL
Production
Data
regenerate
export
Business
Rule
Logic
Derived
Data Model
UML Extension – Transaction Model
XML
Screen Format 1
= Function Definition 1
Screen Format 2
= Function Definition 2
Screen Format 3
= Function Definition 3
•Fields & Attributes
•Layout
•Foreign Key
Validations
•Foreign Key Joins
•Navigation Actions
-Command Keys/
-Options/
-Default Enter
Restructuring Business Rules
Legacy RPG Programs
Multiple Screen Formats
Business Rule Logic
Screen & DB I/O Logic
Other
Business Rule
Logic
Database
All Rules
Re-factored Source For
Review
Biz Logic Function 1
•Pre-Entry Biz Logic
•Validation Biz Logic
Biz Logic Function 2
Pre-Entry Biz Logic
Validation Biz Logic
Biz Logic Function 3
Pre-Entry Biz Logic
Validation Biz Logic
Subroutines
XML
Business Rules
Abstraction
Java
PHP
C#
EGL
Manual Intervention
Look and Feel
Java/EGL Surrounding Framework
–
–
–
–
File Overrides
LDA type constructs
Soft Security
Commitment Control
Java/EGL Object Specific Logic
– Conditional Navigation
– Conditional Screen Rendering Management
Web Service Programs
– Make stateless
– Optimize redundant logic
Thank You
Stuart Milligan
1 800 605 5023
+1 705 719 7952
www.databorough.com