System i Application Design Recovery Rebuilding with

System i Application Design Recovery & Rebuilding with X-Analysis 8 Stuart Milligan – Databorough stuartm@databorough. com © 2007 Databorough Ltd, Weybridge Business Centre, 66 York Road, Weybridge, KT 13 9 DY, United Kingdom, Tel: +44 (0)1932 848564, Fax: +44 (0)1932 859211, E-mail: info@databorough. com, 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 Red. Book on X-Analysis Databorough X-Analysis successfully validated to Ready for IBM Rational software V 7. 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 2 E: Model All Objects All Source All Languages All Variables

The Modernization Evolution… Model Driven Development Analysis 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 XWE 4 NB Trn_Hst_Date FOR COLUMN Trn_Hst_Seq FOR COLUMN XWC 8 DT 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 XWT 8 TX Contract FOR COLUMN XWORDN numeric(6, 0) NOT NULL, XWDLDT NOT NULL, numeric(11, 0) NOT NULL, char(11) , char(2) , char(3) , char(11) , char(20) , 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 My. Eclipse. Blue RSx Borland Legacy Data Base & RPG/COBOL I/O Logic Object Relational Mapping BI and Reporting Tools DB 2 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: – DB 2 Web Query meta-data creation – Drill down DB 2 Web Query Application

DB 2 Web Query Quick Start Ready-to-build Queries DB 2 -WQ API Data Model Meta-Data • 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 DDS Production Data Convert Business Rule Bean regenera te Persistence Framework JSF Bean 3 export DDL Production Data 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 Function 2 Pre-Entry Biz Logic Validation 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