1 / 27

DATABASE MIGRATION The general method

DATABASE MIGRATION The general method. Source technical objects (DDL, programs, jcl,..). Source cartography & modeling. Source base model. Target base re-engineering. Target base structures. Data migration. Target base loaded. Programs adaptation. Application migrated.

luna
Download Presentation

DATABASE MIGRATION The general method

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATABASE MIGRATIONThe general method Source technical objects (DDL, programs, jcl,..) Source cartography & modeling Source base model Target base re-engineering Target base structures Data migration Target base loaded Programs adaptation Application migrated

  2. CARTOGRAPHY & MODELINGcartography – Galois connections

  3. CARTOGRAPHY & MODELINGmodeling – logical model

  4. CARTOGRAPHY & MODELINGmodeling – semantic model

  5. MODELING synthesis Physical model Logical model Semantic model # entity types 112 112 105 # relations 73 128 110 # attributes 1249 1509 1210

  6. DATABASE MIGRATIONThe general method Source technical objects (DDL, programs, jcl,..) Source cartography & modeling Source base model Target base re-engineering Target base structures Data migration Target base loaded Programs adaptation Application migrated

  7. DATA BASE RE-ENGINEERING Semantic model Relational model DB design • adding a primary ky to each table (good practise) • relations  foreign keys • relations N-N  intermediate table + foreign key • redefines  separate tables + foreign keys • composed attributes  decomposition • multivaluated attributes  separated tables + foreign keys OR attributes list • name treatment : “-”  “_”, reserved words

  8. DATABASE RE-ENGINEERING redefines

  9. DATABASE RE-ENGINEERING transformations

  10. DATABASE RE_ENGINEERINGgeneration of target base descriptive objects • Standard SQL or • DB2 • Oracle • SQL Server • MySQL • PostgreSql • …

  11. DATABASE RE-ENGINEERING synthesis Physical model Logical model Semantic model Relational model # entity type 112 112 105 147 # relations 73 128 110 144 (FK)‏ # attributes 1249 1509 1210 1841

  12. DATABASE RE-ENGINEERING mapping Source logical model Source physical model Target relational model The DB-MAIN transformation functions are maintaining the links between the models evolution steps

  13. DATABASE MIGRATIONThe general method Source technical objects (DDL, programs, jcl,..) Source cartography & modeling Source base model Target base re-engineering Target base structures Data migration Target base loaded Programs adaptation Application migrated

  14. DATA MIGRATIONunloading • Unloading model creation : • physical model • DB-key • “mvs” meta-properties

  15. DATA MIGRATIONunloading • Processing components generation : • PSB • PSB compilation Jcl • Unloading Cobol program • programs compilation JCL • file creation and execution JCL

  16. DATA MIGRATIONdata validation • Data validation and transformations generation : • type of records description (attributes, lenght, format, …) • programs to validate the conformity of the source data to the target model ( null char…) • transcoding programs for EBCDIC to ASCII conversion, add EOL characters, … • execution scripts scheduling the opertions sequence

  17. DATA MIGRATION data loading • Components generation for loading the target base : • CTL file for the loading utility of DB2, SQL*Loader, … • Shell scripts

  18. DATA MIGRATIONmigration validation – functional counters Generation of checksum onto source and target environments

  19. DATA MIGRATIONdation de la migration – data validation – content comparison process

  20. DATA MIGRATION migration validation – content comparison Common model

  21. DATA MIGRATION migration valiation – content comparison

  22. DATA MIGRATION migration validation – content comparison

  23. DATABASE MIGRATIONThe general method Source technical objects (DDL, programs, jcl,..) Source cartography & modeling Source base model Target base re-engineering Target base structures Data migration Target base loaded Programs adaptation Application migrated

  24. PROGRAMS ADAPTATION access modules generation COBOL Program IMS DB CALL “CBLTDLI” USING … EXEC DLI … USING … Transformation WRXXX.cob DELETE CALL COBOL Program’ FETCH Relational DB CALL WRYYY.cob INSERT CALL WRZZZ.cob UPDATE • Modification of the data and files “declarations” • Generated code insert • Replacement of the DML verbs by calls to the acces modules

  25. PROGRAMS ADAPTATION access modules generation • Access modules generation ( in this case C++) • Language dependant on the target environment (cobol, java, …)

  26. PROGRAMS ADAPTATION access modules generation Some DML verbs are not automatically resolved : ex: within IMS SSA not qualified : (GU, GN, GNP without segment name) PROCOPT parameter in the PSB within IDS2 FIND within AREA without record name

  27. PROGRAMS ADAPTATION programs source code transformation FIND FIRST USING ART-KEYB. … FIND NEXT RONTB WITHIN DUMMY-RONTB EVALUATE DB-STATUS WHEN "0000000" GET RONTB ... **ReVeR: FIND FIRST USING ART-KEYB MOVE 390000 TO REC-CALL-ID OF WR-LOG PERFORM WR-FFXU-ART-KEYB … **ReVeR: FIND NEXT RONTB WITHIN DUMMY-RONTB MOVE 37060000 TO REC-CALL-ID OF WR-LOG PERFORM WR-FNRW-RONTB-DUMMY-RONTB EVALUATE DB-STATUS WHEN "0000000" **ReVeR: GET RONTB MOVE 37070000 TO REC-CALL-ID OF WR-LOG PERFORM WR-GR-RONTB ...

More Related