PowerDesigner正向工程和逆向工程

1、一.正向工程與逆向工程說明在前面幾篇里介紹了幾個PowerDesig ner的常用模型，參考：|PowerDesigner 概念數(shù)據(jù)模型（CDM）說明http:/blog.csd n.n et/tia nlesoftware/article/details/6871179PowerDesig ner 物理數(shù)據(jù)模型（PD M） 說明http:/blog.csd n.n et/tia nlesoftware/article/details/6874067PowerDesigner 面向對象模型（OOM ）說明http:/blog.csd n.n et/tia nlesoftware/article

2、/details/6879229PowerDesigner 業(yè)務處理模型（BPM ）說明http:/blog.csd n.n et/tia nlesoftware/article/details/6882109PowerDesig ner 企業(yè)架構模型（EAM ）說明http:/blog.csd n.n et/tia nlesoftware/article/details/6883772正向工程和逆向工程就是上面幾個模型相互之間轉換的過程。正向工程：CDM >PDM |PDM > DatabasePDM >OOME-R圖都不畫，直從CDM到PDM也是軟件工程中推薦的一種方法，

3、不過在實際的項目中，很少有公司會按照這個流程來走，甚至連 接上來就建表。逆向工程：從處理語言(Process Language )逆向生成業(yè)務處理模型(BPM |從對象語言(Object Language )逆向生成面向對象模型(OOM ）從數(shù)據(jù)庫(Database )或數(shù)據(jù)庫腳本逆向生成物理數(shù)據(jù)模型(PDM ）從XML定義(XMLDif inition )逆向生成 XML模型示例在這里演示2個例子：（1）CDM -> PDM -> Database.（2）Database -> PDM -> CDM2.1 正向工程：CDM ->PDM -> Databas

4、e 示例PD自帶的示例CDM :http:/blogxITeam number <pi> ISpeasLitytdfrf_5 <pi>Team0.”nDivisionDivi&ion n urn ter <pi>Divi&ion nameDMsion addressChief1.1 IBelongs to1.-. Is rpDnsibl-& for& mansgsf ©f! 廠 |!$ mem ter nf 繪呼!0.1CiJftG-mw n u mb<Ckfcjtomer * 且 m 電CiJstorrMEf

5、 sddteseCustofner activityGdstomef teleuhoCo-ataTMef tsxIdtf 3Suboo用tr且日：1 imntfsdl/ProjectPtqjed： n-umbe*Project nameProject labelW 2"Start date End date par)FarticipatEIdtf 4 <ni>Belongs toccom pcstd ofa.rO.-FtCompcw!我們將這個 CDM 轉換稱 PDM: Tools -> Generate Phy sical Data Model.ain diagr

6、am； D:Proram止點舁怦叨背 itoryTools Window HelpRUP DlUCtrl + F5Complete Links3啟|須可I國圍Check Model.Impact and Lin eage An alysis.Compare Models.Merge Model-Ctrl>FllCtrl + F6Extended Generation.1Generation LinksSpell Checking Options.rExecute Commands nMapping Editor.Gen erate Con ceptual Data Model.Ctrl+

7、Shift+CGen erate Logical Data Model.Ctrl+Shift+LGenerate Physical Data Model.Ctrl+Shft+PGenerate Object-Oriented Model.Ctrl+Shift+OLicense Parameters.ResourcesShift+F6TeamO.neam number <pi> pedalityf_5 <pi>Apply User Profile.Customize Toolbars.Display Prefere nces Model Options.General O

8、ptions.ChiefIs* 1n bys manager of0.1lapate ste (psr) ate par)Is responsible for° 5Sut1.1TaskTask name <pi>Belongs toO.n1.1fBelongs to/.O.nPDM Generabortftt0?/ Ll B生成的PDM圖如下:-j Workspace白宙：Pnojeot Management CDM福Fi 社 p:/b log.csdn. netZtian les(TearpTt3TiCustomer managenient Employe manage

9、ment Main diagramBussness jlesDivision丁匕皿 nurrbmrHOEr pv ，占弐知爲L英membdlteaml+. _j Domains匚!Dala Hems 由-亠j EntitiesDivbioTi Tikimbgi8 NUMBER <pfc>Di visionCHAR(30Division addreu CHAR80>TEmm，Ti>EtErMerTit&rRelationships + JrhefitancesPDMDavc 4t Customer management 訂 魚 Employe managemeri

10、 卜亀 Main diagram i Business Rules鈍-一j Domains!+!；_J TaHes+ _j References:;V Lx遼 J KepositoryEmpEmploynumtsj Divrsjon numberFirst ngrTiE測佃曰只怎pfc fidAEfezIoyeeumber 跑皿匪電 1切詩EmployesEmpl 刖ee numHUHEERn陽E：&fisl ruFEr NtAiBERQ <pk<fldA EeqIs* numbec MUM日ER;工 9竝 r'' j廠 *MaterialCompHe口曽t

11、日 isJLi!TibSINLff.1E&R(5) NiridB£R(S CHAR(30)CHAR30)CHARJ3O)MLFM&ERe,2jy cflcls <fk2>PjarticipsteEmplsii&e numb£：f 忖U：.1日ER；5：Proirt numb?ftUM&ER；?； <pk.Pt2>Taaf ns-meQHAR：3OjU試,fk2AStart date (p&r)DATEEnd dst& (par)DATEFEiGt nmt?e卜耳佢譏1 “J” LEf*Material

12、nameCHAF：33Material typeCHARl30>日EE啟Lmt 備曲舊1Limber 幷UhfBE良E； m：Start cate :act， End date :act)Fa放 ccf$t1DN再將我們的 PD M 生成對應的 SQL腳本： Database Generate Database何 PowerDesigner - PDM PDM?o File Edit View Model ' syrnrorCurrent DBMS.Edit Current DBMS.Default Physical Options.7 - nConnection Informa

13、tion.NUMBER(8.2)MmieriQl number NUMBEREmolowe number NUMBER(5) upk.ft2>日厲|廈3|為電a f ChangeJ Workspace曰 老 Project Management (CDM)*i 闘 Customer managementr 圃 Employe managementMain diagramBusiness RulesDomai nsData ItemsEntities Relationships Inheritances由匸i|毎Ii由少i由口白電 PDM.Dave *雖 Customer manageme

14、nt :匹 Employe management卜固 Main diagram Business Rules Domains TablesReferences®-;a-;s:s-Database Generationenerate Database.Ctrl+GCtrl+RApply Model Changes to Database. Update Model from Database.Estimate Database Size.Generate Test Data.Generate Extraction Scripts.Ctrl+Shift+DExecute SQL.Conf

15、igure Connections.Con nect.Ctrl+Shift+ECtrl + Shift+NDisc onn ect.FAKTICIP.KFZS3N_a!PL0YH2敍General Opti ons Format Selection Summary Previ ewDBMS：ORACLE Version 10gR2Directory: <一File name:crebas.sqlGeneration ty 曙Q Script generation/ One file only7 al回一丨 Edit generation scriptDirect gen eration!

16、 Check modelI Automatic archiveI 確走I 取消應用(A)幫助SQL這里有兩種選擇，一種是生成腳本，即Script generation ，還有一種是直接在數(shù)據(jù)庫里生成，即 directory generate , 一般都是先生成 腳本，然后在數(shù)據(jù)庫執(zhí)行腳本。以上就是一個典型的過程，也是軟件工程中建議的一種流程。2.2 逆向工程：Database -> PDM -> CDM在2.1節(jié)講了正向工程的一些概念，即從 CDM PD M a DATABASE.如果嚴格按照這個過程來執(zhí)行，在后期還可以參考這些Model。但是在國內的軟件開發(fā)流程中， 只有少數(shù)的公

17、司會按照這個流程來走，那么大多數(shù)情況都是拿到需求分析后直接在數(shù)據(jù)庫里建表。如果某個線上的系統(tǒng)，就是這么設計出來的，那么這時候，我們要得到它的PDM，就可以使用PD的逆向工程來實現(xiàn)。先連上測試環(huán)境，新建一個用戶，然后把我們2.1節(jié)導入的腳本執(zhí)行一遍：view p lain1. C:UsersAdmi ni strator.DavidDai>sqlplussys/oracleRACas sysdba;2. SQL*Plus: Release .0 Production onTue Oct 18 13:37:17 20113. Copyright (c) 1982, 2010,

18、 Oracle.All rights reserved.4.4. Connected to :5. Oracle Database 10g Enterprise Edition Release .0 - Production6. With the Partitioning,Real ApplicationClusters, OLAP, Data Mining7. and Real Application Testing options9.10.SQL> create user pd identifiedby pd;11.User created.12.13.SQL>

19、 grantconnect ,resource,dbato pd;14.Grant succeeded.15.16.SQL> conn pd/pdRAC;17.Conn ected.18.SQL> d:crebas.sql腳本執(zhí)行完畢后，相關的表和索引已經(jīng)創(chuàng)建完成，現(xiàn)在我們使用PD來進行逆向工程操作。File > Rev erse Engineer Database曲Powerigner十咖駆閃因憂甜門.口舷怕斤仏饕什可©'Model 1 SymboJ CWa base Report Repository Tools WindowNew Model.,New

20、 Project.Edit ViewOpen.,HSaveSave As New Model.CloeOpen Workspace.Save WorkspaceSave Workspace As,Close WorkspaceSave AllPage Setups.Print PreviewCtrl + NCtrl+Alt+JCtrl+OCtrl + SShift+F2Shift+F3Shft+F4Ctd + F3Ctrl + Alt-*- P匚trl+PImport>Reverse Engineer鼻r亡nd.”Recent FilesRecent Workspaces and Pro

21、jectsExitAlt+F4Print Sei ection修改PD M模塊名稱和 DBMS 類型，這里是 Oracle 10gR2HelpTemm wm&ef MUM日ERf5)Speciality CHARfSO)Ctrl+Alt+F4Lte叵oMemibwTw-L '.iBE - 9半:a Em口心丫£豈n-產！：兇 冷UF目£R；英, 仔應EmployeeEm匚Humb&rErnpEmpyEe numbtrDivision numbe<First nginsNUhl 呂 E 艮!5) NUMBERC5) NUMBER'S CH

22、AR30) CHARlMV dA圈刑 NUMBERS.2；NJMBER;：. 1ParticipateProcess Language.EW啟引6ER：5)ix.fk2>Object Lanuag亡”?I32i:A©c Debase.,肌曰i別；J£ih“AL-ze:Tsm namm (Start dBt« :acc： Ei-m a-4 rji 鼻 H I e jTXML Definition.NUh畑ER5.心咗 csd n m et/tianlesoftw 日 reEl巨1確走幫助確定取消萃助Opti«tis Targst Mdd電IsNew

23、Physical DataGeneral Ext ended lUdel Definiti ons取消配置數(shù)據(jù)源:ODBC machine data sourceDala sourceODBC fie data source:« Connection profile：QSWG_245.dcpPatsword:J Save passwordModel name:DBMS:ORACLE Version 10gR2o Share the DBMS definitionCopy the DBMS definition in model匚 onne(User ID:Current D6MSOF

24、.LE Version 1QgR2Using script files:Reverse engineer using administrtot permonsSelcticiiT Database Reverse Engineering® Using a datd source:QS'7G_245.dcpConfigure Data tomnectioOEKC NichineSourcesOBBJD-File D 廠sTL至iComecton profile nanne:Directory:C AUsers Vdmini 就咼 or. David DaiXDesktop

25、9;xDescription：Comecton tpe:DBMS type:NativeServer name:Database name;User name:Password:Connection parameters；Test Connection,tna CT3-T&Tais ioostRACanqmgpd*OKCancelConnection prof ile name : 生成連接文件名稱Directory :生成連接文件保存位置，我這里保存到桌面|Conn ection ty pe :連接類型，可是使用Native (tnsn ames.ora )或者 JDBCDataba

26、se Reverse Engineeringet/UanleseftwareData sourceODBC machine data source:ODBC file data source:Configure.Password: Save passwordConnedLoginUser ID:o Conn ection profile:我的這個測試，不到 1分鐘就搞完了。確定之后進行reverse。具體需要的時間要根據(jù)數(shù)據(jù)庫對象的多少來定。逆向工程之后的PDM如下圖:i/i ao 當華 i/i ad 堺丑:i/i ao 當華 i/i ad 堺丑(asJUYHO adsvai rrir.

27、9;.nN3Wdd|A1CiNAiO 慣r93X樸 TTasavriN nriNa TVH7 ITyTfJnN Ktiw5l宅'引爼日日料nNTVSdrt=(Ct'!dVH3Nnddd(C£ aYHOnwidna:cz-yvHOrmiddAi>rtnNAia舊；出WEdlF nn = .i= = .iZnnudvra33A OUf3ISESPPS :Gti 珊irN rfrrNd.'tz TTT：' TyTE.nrj iinNi?;QHSn<0£awo 3dAUy/i : CEfeVHO SMYNJy/i-7iaE iv/<

28、0S9|Ue!J/19UUpS3X CS5C-3S0d?JG?JdrinM AriNlTf/i w/tssoususp廠書ssiqEt n ilsiasn 廠！ h山也兀燈電f虧 * ad'wad 宙卑gaouajm 戶牡ssjqei$LHEUJO13E3|ny sssuiEngujefep ur|luaujaEeufui 諒恥陽-Eu串山包血ueuj jsujqsp陽:龍百L通丨 n-tj i l哂 廠侖I m-i j4| EF3-EL-由環(huán)由r4i.sAeaS93UeiUSLU| 嗓u。!厚忖H sailiug SUJS EJEQ SUIBUJOQ 帕1恂 ssauisn ujej

29、庁電 ip uie 序四宛蟲山5Ao|dugjuaujaEuEuj伺 _ (如a® luatuafipue pafadjort Repertory | Toolshttp:/blog；csdn,net/tianlesoftware>E昵向鬥邨k心kJATER(ALW Li LuzEH -二MAT麗出 ME CHAR (33UATTYPE CHAR30)AATNLK_E£FLOf2Check Model.,F4Impact arid Lineage Anafyek.,.Ctd + Fll1Compare ModelsMF6 |Merge ModeL,.ShiftreIE

30、xtended Generations1Generatron LinksSpetl Checking Options.Execute Commandst ：Mapping Editor.k|XML Builder Wizard*Ctrl + Shift+W jGenerate Physical Data Model.Ctrl + Shift+P jGenerate Conceptual D日ta ModeL.Ctrl +Shift+CGenerate Logkal Data Model.Ctrl + Shi ft+LrGenerate Obi&ct-Oriented Model.,.C

31、trl + Shift+OCtrf+F5Complete Link?R12)H(12；曰ER富m3,R(20TASKkiNUMNUVEEff-<pk.fk>NAE匚 H/.RlMrrrstGDATECAFEf<COSTNUMBER|d.2CDM Generatio最終的CD M如下:J iHtip:/ i a n lesoftvFK USED USE tLOYEE CH EF =V*_> EE j4-£at塵忖嵌 <oi> Nlnft停-1-r-TEASPECJ-jracitrs : iD'PlTEAM£k'=FNA? EkLNAV