1 technical objects functional objects persistent objectsdescriptive objectsprocessing objects files...
TRANSCRIPT
1
technical objectsfunctional objects persistent
objectsdescriptive objects
processing objects
files content
copybook, programs, DTD,
…,directly
managed by the programs
modules
(programming unit)
programs
(set of modules, linked together and where at
least one is not called by another one)
programs chain
(orderly suite of programs)
applications(set of programs
and chain of programs)
database content
DDL, scripts managed by the
DBMS
DB-procedure, triggers, …Managed by the DBMS
DEFINITIONS
2
processing objects
chain 1
chain j
prog 1
prog i
persistent objects
file a
file z
DB A
DB Z
functional objects
application A
application Z
IS modelingDB Z
models
IS modelingapplication Z
models
DEFINITIONS
3
Descriptive objects (DDL, copybook,..)
Refined physical model
cartography
Logical model
analysis
conceptualisation
Macroscopic analysis
Microscopic analysis & data analysis
Semantic model
processing source code(JCL, programs,..)
data
CARTOGRAPHY & MODELINGthe general method
4
DDL code DDL analyzer Physical model
Modeling : descriptive objects analysis – VSAM files
5
MODELINGdescriptive objects analysis – database (DDL IMS –
DBD)
DDL code DDL analyzer Physical model
6
MODELING physical model refinement – integration of the detailed
structures
Source code programs
analyzer
Integrated physical modelSource code
copybook
physical model
+
7
Descriptive objects (DDL, copybook,..)
Refined physical model
cartography
Logical model
analysis
conceptualisation
Macroscopic analysis
Microscopic analysis & data analysis
Semantic model
processing source code(JCL, programs,..)
data
CARTOGRAPHY & MODELINGthe general method
8
CARTOGRAPHY
MACROSCOPIC PROGRAMS ANALYSIS
Looking for calls between modules
Looking for the use of persistent objects
results integration from the various analyzed procesing code
langage independance
presentation under graph form or directly by programs
maintain the links between the different source codes
9
feb1001
TW OBUFF
feb1002feb1003
feb1004
PCONC27
feb1040feb1040dfeb1050feb1060
feb2005
ACCLIB
febcanon
PCHARCOD
febind
febjj2
CDAT4
febmajpp
fet000
ZDRELS
CDGET
CDSEND
FREER
CDRECV
PAUTCOD
CDMECH
CDATTR
fet100
fet110
fet120
fet130
fet200
fet210
fet220
fet230
fet240
fet300
fet310
fet320
fet330
fet340
fet350
fet360
fet370
fet400
fet410
fet420
fet430
fet440
fet490
fet500
fet510
fet511
fet51iPURGE
fet530
PVALIS
ABORT
fet7001
fet711
fet721
fet750
CALL GRAPH
10
i
i
iu
u
i
ii
i
i
o
u
i
feb2005.cob
febctlpp.cob
febind.cob
febjjj.cob
febmajpp.cob
fet440.cob
fet511.cob
fet711.cob
fet721.cob
februe.cob
fet100.cob
fet220.cob
fet240.cob
ADRESSE-SIEGE-SOCIAL
i
i
i
i
i
i
i
i
i
i
ii
i
i
i
i
i
feb2005.cob
ASSOCIATIONS
ADRESSE-SIEGE-SOCIAL
PADICO
PERSONNES-HORS-ENTITE
INFORMATIONS
SIGNALETIQUES
RUES-HORS-ENTITE
CODES-POSTAUX
FEC-PROFESSIONS
FE-LIBELLES
CODE-PROFESSION
TYPE-PERSONNE
ENSEIGNE
RAISON-SOCIALE
ADRESSE-SUCCURSALE
SIEGE-SOCIAL
SUCCURSALES
USAGE GRAPH
11
NCL
NCL
NCL
NCL
NCL
NCL
NCL
NCL
NCL
NCL
OpenSCR
Select
SqlProc
NCL
NCL
NCL
Select
Select
Select
Select
Select
Select
Select
D_MORDRE.SCR
DMORDRE_EF_ORDRE_LOSEFOCUS%
AJOUT0$
DMORDRE_PBANNULER_EXECUTED%
DMORDRE_PBVALIDER_EXECUTED%
AFFICHEMESSAGE
VERIFORDREDANSSECTEUR%
UPDATEORDREDUPDS%
DMORDRE_INIT%
AFFICHEADRESSE%
DMORDRE_TERMINATE%
D_MESERR.SCR
COMMUNE
PAYS
VOIE
EXTENSION_VOIE
ACHEMINEMENT
ADRESSE
REG_PAY
GESTION_POINT_SERVICES.UPDATE_ORDRE_PDS
POINT_SERVICES
APPLICATION CARTOGRAPHY
12
Usage
0
20
40
60
80
100
120
0 20 40 60 80 100 120 140 160 180 200
Procédures
Tables
GALOIS CONNECTIONS
13
LINKS WITH THE PROCESSING CODES
14
Descriptive objects (DDL, copybook,..)
Refined physical model
cartography
Logical model
analysis
conceptualisation
Macroscopic analysis
Microscopic analysis & data analysis
Semantic model
processing source code(JCL, programs,..)
data
CARTOGRAPHY & MODELINGthe general method
15
MODELING refinement of the physical model – discovery of the data rules
programs source code
microscopic analyzer
Enriched physical model = logical model
Integrated physical model
+
16
MODELING refinement of the physical model – discovery of the data rules
programs source code
microscopic analyzer
Enriched physical model = logical model
Integrated physical model
+
17
MODELINGphysical model refinement – data rules validation
data analyzer
validated logical model
logical model
+
18
Descriptive objects (DDL, copybook,..)
Refined physical model
cartography
Logical model
analysis
conceptualisation
Macroscopic analysis
Microscopic analysis & data analysis
Semantic model
processing source code(JCL, programs,..)
data
CARTOGRAPHY & MODELINGthe general method
19
conceptualisation Semantic modelValidated logical model
transformations examples ( IMS base) :
virtual logical segment N-M relation
redefines super type + relation “IS-A” + sub-types
fields “lchild” secondary index
“logical” base relations
MODELINGconceptualisation
20
SEMANTIC MODEL
1-1
0-N
TYPE_1
1-1
0-N
TYPE
1-1
0-N
TP-PERS
1-1
0-N
SUC-TP
1-1
0-N
SUC-ENS
1-1
0-N
SUC-CPR
1-1
0-NSUC-ASU
1-1
0-N
SUC-AS
1-1
0-N
SIE-SUC
1-1
0-N
SIE-RS
1-1
0-N
SIE-ASS
0-N
1-1
SI-IN
1-1
0-N
SI-AD
1-1
0-N
RUE_1
1-1
0-N
RUE-CP
1-1
0-N
RS-PERS
1-1
0-N
RP-NU
1-1
0-N
PER_PAD
1-1
0-1
PERS-POP
1-1
0-1
PERS-HORS-ENTITE
1-1
0-N
PAYS_1
1-1
0-N
PAYS
1-1
0-N
NUM-QUARTIER
1-1
0-N
NU-SIT
1-1
0-NNU-AD
1-1
1-1
INF_INF
1-1
0-N
CUR_RUE
0-N
0-N
CURATEURS-NN
1-1
0-N
CUR-PERS
1-1
0-N
CODE-PROF
1-10-N C
1-1
0-NADR_RUE_1
1-1
0-N
ADR_RUE
P
TYPE-PERSONNETELEPHONEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
TI-889DATE-001
DT-001-AADT-001-MMDT-001-JJ
DATE-005DT-005-AADT-005-MMDT-005-JJ
020-CP020-CR020-NUMERO020-APPART
TI-886NO-BREVETLIDHEURE
H-HHH-MMH-SS
CHT-ADRESSEDATE-LISTE
DL-AAAADL-MMDL-JJ
COMMENT
TI-401TYPEDOSSIERCOMMENT
TI-320CODESTADEAUTORITELEVEENUMERO-IDF
IDF-1IDF-JJIDF-MMIDF-AAIDF-2
COMMENT
TI-306CPNUMREGIMECOMMENT
TI-305CPNUMINSCOMMENT
TI-303DECISION
AAMMJJ
COMMENTTI-302CODEPRISEINSCOMMENT
TI-252DATE-DEB
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
COMMENT
TI-246COMMENT
TI-214ORGCPCODE-RUENUMEROAPPARTCOMMENT
TI-213TYPENATDATE
AAMMJJ
NOMCODE[15-15] array
COMMENT
TI-212CODELIEUCOMMENT
TI-211TYPECOMMENT
TI-210CODEEPCOMMENT
TI-208PNNPNN-R
PNN-1PNN-2PNN-3PNN-4
COMMENT
TI-207INSCODECOMMENT
TI-206K1ORGK2INSLIEUTERDATE
AAMMJJ
REFOC-A
OCCODRECORGORIGCOMMENT
TI-205TYPECOMMENT
TI-202COMMENT
TI-200NUMEROCOMMENT
TI-199NUMERODELIVRTYPEINSORDREPROROGPEREMPTION
AAMMJJ
OLD-NUMEROCOMMENT
TI-198NUMEROECHEANCE
AAMMJJ
COMMENT
TI-197NUMEROECHEANCE
AAMMJJ
COMMENT
TI-194TYPEATTRIBNUMERO-E
NUMEROCATEGORIES
CAT[9-9] arrayINSBOITEMEDICFIN-DECHEANCE
AAMMJJ
COMMENTTI-193
NUM-CARTENUM-SUI
NUM-SUITE1NUM-SUITE2
CATEGORIESCATCAT-R
CAT1CAT2CAT3CAT4
INSDATE
AAMMJJ
COMMENT
TI-192CODEINSCOMMENT
TI-191TYPEINSPAYSNUMEROFIN-DECHEANCE
AAMMJJ
COMMENT
TI-190TITRECOMMENT
TI-161COMMENT
TI-160CLASSESITUATIONINSMATRICULEUNITECOMMENT
TI-153CODEINSDATE
AAMMJJ
T1T2NN-T
NN-E[10-10] arrayNN-N
COMMENT
TI-152CODESIECLENN-N
NNIDENTCOMMENT
TI-151COMMENT
TI-150ACTERSINSCPCOMMENT
TI-140CODE
TI-132CODEINSDIPLTERRITCODADRSIECLENN-N
NNIDENTCOMMENT
TI-131CATINSPAYSDATE-DECH
AAMMJJ
COMMENT
TI-130INSSITUATIONCATEGDATE-DECH
AAMMJJ
COMMENT
TI-123CODEINSDATE-ENREG
DE-AADE-MMDE-JJ
SSNN-N
NNCODES-N
CODE-N[6-6] arrayNOTAIRE
NOT-INSNOT-IDENTITE
COMMENT
TI-122CODEINSCOMMENTAIRE
TI-121INSLIEU
TI-120CODE-ETACTERSINSCPSSNN-N
NNCODES
CODE[6-6] array41-51
INSC-DATEINSC-AAINSC-MMINSC-JJ
TRIB-DATETRIB-AATRIB-MMTRIB-JJ
TRIB-INSTRIB-CODE
COMMENTAIRE
TI-111REPRESJUSTIFCOMMENT
TI-110TYPENBR-NNINSCPSS1NN1SS2NN2ACTERSCOMMENTAIRE
COMMENT0COMMENT1-R
CODES1CODE1[6-6] array
COMMENT1COMMENT2-R
CODES2-1CODE2-1[6-6] array
CODES2-2CODE2-2[6-6] array
COMMENT2
TI-101DATE
AAMMJJ
CODECOMMENT
TI-100REG-SUPPLCPCOMMENT
TI-073CATEGNUMEROCOMMENT
TI-070CDEPRFSTATUTCOMMENT
TI-031NATACQUIINSCPOSPAYSCOMMENT
TI-028CODEDATE
AAMMJJ
COMMENT
TI-027COMMENT
TI-026COMMENT
TI-024COMMENT
TI-023ADRESSECOMMENT
TI-022CPOSTDIPPAYSADRESSECOMMENT
TI-021INSCPCOMMENT
TI-020CPCODE-RUENUMEROAPPARTSORTIE
SO-AASO-MMSO-JJ
RENUMCODE-ANCDATE-ANC
ANC-AAANC-MMANC-JJ
COMMENT
TI-019INSCPCODE-RUENUMEROAPPARTCOMMENT
TI-018PAYSADRESSECOMMENT
TI-013TYPE-MODIFDATE-MODIF
AAMMJJ
COMMENT
TI-012CDENOBLECOMMENT
TI-011COMMENT
TI-010USUELNOM
CODE[15-15] array
TI-008DATE
AAMMJJ
COMMENT
TI-007CODEDATE
AAMMJJ
COMMENT
TI-006PAYSLIEUCOMMENT
TI-005INSCOMMENT
TI-004CODECOMMENT
TI-003CODECOMMENT
TI-002SSNNCOMMENT
TI-001INSFUSIONADRCOMCOMMENTPROPRO-DATE
PRO-AAPRO-MMPRO-JJ
SUCCURSALESSUPERFICIENBR-PERSNUMINSTALLATION
INS-AAINS-MMINS-JJ
SUPPRESSIONSUP-AASUP-MMSUP-JJ
CESSATIONCES-AACES-MMCES-JJ
TERMINEFERMETURE
LUNDIMARDIMERCREDIJEUDIVENDREDISAMEDIDIMANCHE
COMMENTAIRE-1COMMENTAIRE-2COMMENTAIRE-3MAG-PRIVNUITid: SIE-SUC.SIEGE-SOCIAL
NUM
SITUATIONSTYPESALUBRESIT-DEBUT
SID-AASID-MMSID-JJ
SIT-FINSIF-AASIF-MMSIF-JJ
SAL-DEBUTSAD-AASAD-MMSAD-JJ
SAL-FINSAF-AASAF-MMSAF-JJ
COMMENT1COMMENT2id: NU-SIT.NUMEROS
SIT-DEBUT
SIGNALETIQUESSIECLENUMNAT
CONTROLAAMMJJNN
CDMAJDATE-MAJ
MAJ-AAMAJ-MMMAJ-JJ
LID-MAJACTE-NAISSLIEU-NAISSDATE-SANG
SA-AASA-MMSA-JJ
GR-SANGMENAGEPRESENCESSUPPRESSid: NUMNAT
SIEGE-SOCIALRC
RC-1RC-2RC-3
ABREGETVA
TVA-NUMTVA-CD
COMMENTAIRECOMMENTAIRE-1COMMENTAIRE-2COMMENTAIRE-3
DATE-MAJMAJ-AAMAJ-MMMAJ-JJ
LID-MAJRADIATION
RAD-AARAD-MMRAD-JJ
FAILLITEFAI-AAFAI-MMFAI-JJ
CESSATIONCES-AACES-MMCES-JJ
EXTRAITEXTRAIT-NOEXTRAIT-AAAA
id: RC
RUES-POPCPRUEDATE
MMJJ
LIBELLECLE-TRIHISTOCLE
CPRUE
id: RUECP
RUES-HORS-ENTITECPRUEDATE
AAMMJJ
LIBELLECLE-TRIHISTOCLE
CPRUE
id: RUECP
RAISON-SOCIALEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
LIBELLEid: SIE-RS.SIEGE-SOCIAL
DATE-DEBUT
QUARTIERRUENUM-DEBNUM-FINTYPE
PERSONNES-HORS-ENTITENN
TESTAAMMJJNUM
CDNOMPRENOMSNUMEROINDEXCOMMENTid: NN
PERSONNES
at-lst-1: PERS-HORS-ENTITE.PERSONNES-HORS-ENTITEPERS-POP.SIGNALETIQUES
PADICOCLECLE-TRIINS-PILOTEFUSION
FU-AAFU-MMFU-JJ
LIBELLENATIONALITEJOLI-PAYSid: CLE
NUMEROSNUMEROAPPARTid: RP-NU.RUES-POP
APPARTNUMERO
LIBELLESRNCLELIBELLEid: CLE
INFORMATIONSCODECREATION
CR-AACR-MMCR-JJ
NUMEROSUPPRESSION
SU-AASU-MMSU-JJ
id: SI-IN.SIGNALETIQUESNUMEROCREATIONCODE
INFO
FEC-PROFESSIONSCODELIBELLEid: CODE
FE-LIBELLESCLELIBELLEid: CLE
ENSEIGNEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
LIBELLEid: SUC-ENS.SUCCURSALES
DATE-DEBUT
CURATEURSTELEPHONENUMEROINDEXCOMMENTAIRE
CODES-POSTAUXCLEINSLIBELLECLE-TRIid: CLE
CODE-PROFESSIONDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
P-Aid: SUC-CPR.SUCCURSALES
DATE-DEBUT
ASSOCIATIONSDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
RCRC-1RC-2RC-3
COMMENTAIREid: SUC-AS.SUCCURSALES
DATE-DEBUT
ADRESSESENTREE
EN-AAEN-MMEN-JJ
SORTIESO-AASO-MMSO-JJ
id: NU-AD.NUMEROSENTREE
id': SI-AD.SIGNALETIQUESENTREE
ADRESSE-SUCCURSALEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
NUMEROINDEXTELEPHONEid: SUC-ASU.SUCCURSALES
DATE-DEBUT
ADRESSE-SIEGE-SOCIALDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
NUMEROINDEXINDEX-TYPETELEPHONEADRESSEid: SIE-ASS.SIEGE-SOCIAL
DATE-DEBUT
redefines
inter-base relations
21
1-1
0-N
TP-PERS
0-N
1-1
0-N
RS-PERS
1-1
0-1
PERS-POP
1-1
0-1
PERS-HORS-ENTITE
1-1
0-N
CUR-PERS
TYPE-PERSONNETELEPHONEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
SIGNALETIQUESSIECLENUMNAT
CONTROLAAMMJJNN
CDMAJDATE-MAJ
MAJ-AAMAJ-MMMAJ-JJ
LID-MAJACTE-NAISSLIEU-NAISSDATE-SANG
SA-AASA-MMSA-JJ
GR-SANGMENAGEPRESENCESSUPPRESSid: NUMNAT
RAISON-SOCIALEDATE-DEBUT
DEB-AADEB-MMDEB-JJ
DATE-FINFIN-AAFIN-MMFIN-JJ
LIBELLEid: SIE-RS.SIEGE-SOCIAL
DATE-DEBUT
PERSONNES-HORS-ENTITENN
TESTAAMMJJNUM
CDNOMPRENOMSNUMEROINDEXCOMMENTid: NN
PERSONNES
at-lst-1: PERS-HORS-ENTITE.PERSONNES-HORS-ENTITEPERS-POP.SIGNALETIQUES
CURATEURSTELEPHONENUMEROINDEXCOMMENTAIRE
SEMANTIC MODELinter-base relations
22
SEMANTIC MODELredefines
23
121015091249# attributes
11012873# relations
105112112# entity types
semantic
model
logical
model
physical
model
MODELINGsummary
24
EXTRACTION FROM THE DB-MAIN DICTIONARY
documentation