Oracle 9i - Designer_overview

2UDFOHL'HVLJQHU7HFKQLFDO 2YHUYLHZ  $Q2UDFOH:KLWH3DSHU $SULO  



2UDFOHL'HVLJQHU7HFKQLFDO2YHUYLHZ

([HFXWLYH2YHUYLHZ  7KH%HQHILWVRIXVLQJ2UDFOHL'HVLJQHU  6LQJOH3RLQWRI7UXWKIRU$SSOLFDWLRQ0HWD'DWD  $FFXUDWH$QDO\VLVRI6\VWHP5HTXLUHPHQWV  3RZHUIXO'HIDXOW'DWDEDVHDQG$SSOLFDWLRQ'HVLJQ7UDQVIRUPHUV   5DSLG&UHDWLRQRI'DWDEDVHVDQG$SSOLFDWLRQV8VLQJ*HQHUDWRUV   (IIHFWLYH'HVLJQ&DSWXUHRI([LVWLQJ$SSOLFDWLRQV   &RPSOHWH,WHUDWLYH'HVLJQDQG'HYHORSPHQW  &RPSUHKHQVLYH5HSRVLWRU\0DQDJHPHQW)DFLOLWLHV  9HUVLRQLQJDQG&RQILJXUDWLRQ0DQDJHPHQW  3RZHUIXO'HSHQGHQF\$QDO\VLV   2YHUYLHZRI2UDFOHL'HVLJQHUWRROV  0RGHOLQJ6\VWHP5HTXLUHPHQWV   7UDQVIRUPLQJ3UHOLPLQDU\'HVLJQV   'HVLJQLQJDQG*HQHUDWLQJ'DWDEDVHVDQG$SSOLFDWLRQV  2UDFOHL)RUPV*HQHUDWRUDQG2UDFOHL5HSRUWV*HQHUDWRU  2UDFOH:HE3/64/*HQHUDWRU   2UDFOH6HUYHU*HQHUDWRU   6WRULQJDQG0DQDJLQJ$SSOLFDWLRQ0HWD'DWD   5HSRVLWRU\2EMHFW1DYLJDWRU   0DQDJLQJ0XOWLSOH9HUVLRQVRU2EMHFWV  9HUVLRQ+LVWRU\9LHZHUDQG'HSHQGHQF\0DQDJHU   9HUVLRQ(YHQW9LHZHU   'HSHQGHQF\$QDO\VLV   7KH'HSHQGHQF\0DQDJHU  7KH0DWUL['LDJUDPPHU   5HSRVLWRU\5HSRUWV   6XPPDU\   

Oracle9i Designer: Technical Overview

Page 2

2UDFOHL'HVLJQHU7HFKQLFDO2YHUYLHZ

EXECUTIVE OVERVIEW

2QO\RQHSURGXFW2UDFOHL'HVLJQHURIIHUVDWRROVHWWRPRGHOJHQHUDWHDQG FDSWXUHWKHUHTXLUHPHQWVDQGGHVLJQRI\RXUZHEEDVHGDSSOLFDWLRQVTXLFNO\ DFFXUDWHO\DQGHIILFLHQWO\DQGDOVRWRDVVHVVWKHLPSDFWRIFKDQJLQJWKRVHGHVLJQV RUDSSOLFDWLRQV2UDFOHL'HVLJQHULVSDUWRI2UDFOH·V,QWHUQHW'HYHORSHU6XLWHRI GHYHORSPHQWWRROV 2UDFOHL'HVLJQHURIIHUVDOOWKHIHDWXUHVUHTXLUHGIRUWKHFRPSOHWH¶HQGWRHQG· GHYHORSPHQWRIWKHVHDSSOLFDWLRQV7KHIOH[LEOHDQGLQWHJUDWHGHQYLURQPHQWRI 2UDFOHL'HVLJQHUHQDEOHV\RXWR •

'HVLJQGDWDEDVHVDQGDSSOLFDWLRQVWRLPSOHPHQWDQGXQGHUSLQH EXVLQHVVVROXWLRQV

•

3URWHFW\RXUFXUUHQWLQYHVWPHQWE\FDSWXULQJWKHQUHGHVLJQLQJOHJDF\ DSSOLFDWLRQV

•

&RPSOHWHO\JHQHUDWHVRSKLVWLFDWHGZHEHQDEOHGDSSOLFDWLRQV

6XSSRUWLQJWKHVHH[WHQVLYHIHDWXUHVLV2UDFOHL6&06RIWZDUH&RQILJXUDWLRQ 0DQDJHU ZKLFKLVXVHGWRVWRUHDQGPDQDJHWKHPHWDGDWDIRU\RXUDSSOLFDWLRQV 2UDFOHL6&0HQDEOHV\RXWRPDQDJHPXOWLSOHYHUVLRQVDQGFRQILJXUDWLRQVRI VRIWZDUHGHYHORSPHQWREMHFWVWRIDFLOLWDWHWHDPZRUNLQJDQGSURMHFWPDQDJHPHQW 7KHEHQHILWVRI2UDFOHL'HVLJQHUPDWFK\RXUSUHIHUUHGGHYHORSPHQWDSSURDFK 2UDFOHL'HVLJQHUGRHVQRWHQIRUFHDQ\PHWKRGRORJ\EXWLQFOXGHVVXSSRUWIRU (QG8VHU'ULYHQ5DSLG$SSOLFDWLRQ'HYHORSPHQW ,QIRUPDWLRQ'ULYHQ ,QIRUPDWLRQ(QJLQHHULQJ 3URFHVV0RGHODQG'HVLJQ&DSWXUHGULYHQ GHYHORSPHQW 2UDFOHL'HVLJQHULVDOVRWKHEDVLVRIWKH2UDFOHGHYHORSPHQWPHWKRGRORJ\DQG WRRONLW2UDFOH&XVWRP'HYHORSPHQW0HWKRG&'0 XVHGE\2UDFOH&RQVXOWLQJ RUJDQL]DWLRQVDURXQGWKHZRUOG&'0LVDIXOOOLIHF\FOHPHWKRGRORJ\IRUGHOLYHULQJ FXVWRPVROXWLRQV 7KHUHIRUH2UDFOHL'HVLJQHULVWKHSURGXFWWRXVHWRUDSLGO\GHYHORSDSSOLFDWLRQV IRUZHEEDVHGHQYLURQPHQWV7KLVZKLWHSDSHUVXPPDUL]HVLWVIHDWXUHVDQG EHQHILWVDQGRXWOLQHVWKHSXUSRVHDQGIXQFWLRQDOLW\RIHDFKWRRO

Oracle9i Designer: Technical Overview

Page 3

THE BENEFITS OF USING ORACLE9i DESIGNER Single Point of Truth for Application Meta Data

7RHQDEOH\RXWRUHVSRQGWRFKDQJHVLQWHFKQRORJ\UDSLGO\2UDFOHL'HVLJQHU RIIHUVWKHDELOLW\WRVLQJOHVRXUFHDSSOLFDWLRQPHWDGDWDIURPRQHFHQWUDOUHSRVLWRU\ WKHHQJLQHEHKLQG2UDFOHL6&0 IRUH[DPSOHDWDEOHGHILQLWLRQ7KLVVWLPXODWHV SURGXFWLYHDQGHIILFLHQWPRGHOEDVHGDSSOLFDWLRQGHYHORSPHQWIRUGHSOR\LQJLQD ZHEEDVHGHQYLURQPHQW Accurate Analysis of System Requirements

2UDFOHL'HVLJQHUSURYLGHVLQWHJUDWHGJUDSKLFDOPRGHOLQJWRROVWRUHSUHVHQWWKH UHTXLUHPHQWVRIQHZRUOHJDF\DSSOLFDWLRQVDFFXUDWHO\TXLFNO\DQGHDVLO\7KHWRROV LQWHJUDWHWLJKWO\ZLWKWKH2UDFOHL6&0WRROVHWWRHQDEOHWHDPEDVHGZRUNLQJLQD PXOWLXVHUHQYLURQPHQWLQZKLFKUHTXLUHPHQWVDUHDYDLODEOHLPPHGLDWHO\ $OO2UDFOHL'HVLJQHUV\VWHPVPRGHOLQJWRROVVXSSRUWVWDQGDUGPRGHOLQJ WHFKQLTXHVIRUDQDO\]LQJUHODWLRQDOGDWDEDVHV\VWHPUHTXLUHPHQWV8VHWKHPWR UDSLGO\UHFRUGDQGYHULI\WKHUHOHYDQWLPSRUWDQWIHDWXUHVRI\RXUEXVLQHVVWR GHOLYHUWKHUHTXLUHGDSSOLFDWLRQILUVWWLPH Powerful Default Database and Application Design Transformers

2UDFOHL'HVLJQHUSURYLGHVSRZHUIXOWUDQVIRUPHUVIRUTXLFNO\DQGVHDPOHVVO\ FUHDWLQJGHIDXOWGDWDEDVHDQGDSSOLFDWLRQGHVLJQVIURP\RXUYDOLGDWHGV\VWHP UHTXLUHPHQWV7KH'DWDEDVH'HVLJQ7UDQVIRUPHUEXLOGVDGDWDEDVHVFKHPDZLWK WDEOHVFROXPQVLQGH[HVDQGUHIHUHQWLDOLQWHJULW\FRQVWUDLQWVZKLOHWKH$SSOLFDWLRQ 'HVLJQ7UDQVIRUPHUEXLOGVFRPSOHWHPRGXOHGHILQLWLRQVIRUVFUHHQVUHSRUWVDQG PHQXV 7KHVHILUVWFXWGDWDEDVHDQGDSSOLFDWLRQGHVLJQVDUHLPPHGLDWHO\UHDG\IRUUHYLHZ DQGIXUWKHUGHVLJQXQWLO\RXJHQHUDWHWKHILQLVKHGDSSOLFDWLRQ7UDQVIRUPHUV HVWDEOLVKFRPSUHKHQVLYHEDVHOLQHVIRU\RXUGHVLJQV8VLQJWKHPSURPRWHVIRFXVLQJ RQDQDO\]LQJLQLWLDOV\VWHPUHTXLUHPHQWVPRUHHIILFLHQWO\ZKLFKLQFUHDVHV SURGXFWLYLW\DQGLPSURYHVWKHTXDOLW\RIWKHILQLVKHGDSSOLFDWLRQ Rapid Creation of Databases and Applications Using Generators

2UDFOHL'HVLJQHUJHQHUDWRUVFUHDWHKLJKTXDOLW\XVDEOHDSSOLFDWLRQVXVLQJPHWD GDWDLQWKH2UDFOHL6&0UHSRVLWRU\7KHVHJHQHUDWRUVSURYLGHIDFLOLWLHVIRU VSHFLI\LQJDQGJHQHUDWLQJDOOWKHFUXFLDOHOHPHQWVIRUDZHEEDVHGDSSOLFDWLRQIRU H[DPSOH •

2UDFOHL'DWDEDVHREMHFWV

•

2UDFOHL)RUPV

•

3/64/$SSOLFDWLRQ3URJUDPPDWLF,QWHUIDFHV$3,V 

•

:HE3/64/

Oracle9i Designer: Technical Overview

Page 4

7KH2UDFOHL'HVLJQHUJHQHUDWRUVDUHDSURGXFWLYHDFFXUDWHDQGWURXEOHIUHH PHWKRGIRUJHQHUDWLQJDQGLPSOHPHQWLQJWKHULJKWDSSOLFDWLRQIRUWKHULJKW SODWIRUP7KH\KHOS\RXWRUHDSWKHEHQHILWVRILQYHVWLQJLQWKHHDUOLHUDQDO\VLVDQG GHVLJQVWDJHVRIWKHGHYHORSPHQWOLIHF\FOH Effective Design Capture of Existing Applications

5REXVWGHVLJQFDSWXUHIHDWXUHVLQ2UDFOHL'HVLJQHUZLOOFDSWXUHDOOWKHGHVLJQ LQIRUPDWLRQIRUDOHJDF\DSSOLFDWLRQHDVLO\DQGHIILFLHQWO\$SSOLFDWLRQVGHYHORSHG XVLQJ2UDFOHL)RUPVRUWKDWXVHDQRQ2UDFOHGDWDEDVHPD\DOVREHFDSWXUHG LQFOXGLQJWKHDSSOLFDWLRQORJLFZULWWHQLQWKHQDWLYHVFULSWLQJHQYLURQPHQW8VLQJ 2UDFOHL'HVLJQHUWRGHVLJQFDSWXUH\RXUDSSOLFDWLRQVRIIHUVVHYHUDODGYDQWDJHV UHJDUGOHVVRILWVVRXUFH0LJUDWLQJDQ2UDFOHRUQRQ2UDFOHGDWDEDVHIURPDOHJDF\ DSSOLFDWLRQLVQRWDQLVVXHEHFDXVH2UDFOHL'HVLJQHUZLOOFDSWXUHWKHGHVLJQRI DQ\2'%&FRPSOLDQWGDWDEDVH,WSURYLGHVDQHQWHUSULVHYLHZRIDOORI\RXU H[LVWLQJEXVLQHVVGDWDUHFRUGLQJOHJDF\PHWDGDWDIRUDPHQGLQJDQGUHJHQHUDWLQJ ODWHURUDVDEDVHOLQHIRUQHZUHTXLUHPHQWV Complete, Iterative Design and Development

2UDFOHL'HVLJQHUVXSSRUWVWKHSURFHVVRIFKDQJLQJDQDSSOLFDWLRQDIWHUJHQHUDWLQJ LWFDSWXULQJWKHFKDQJHVLQWR2UDFOHL'HVLJQHUWKHQUHJHQHUDWLQJWKHDSSOLFDWLRQ ZKLOHSUHVHUYLQJWKHFKDQJHV7KLVUHIOHFWVKRZ2UDFOHL'HVLJQHULVLQWHJUDWHG WLJKWO\ZLWKWKHODWHVW2UDFOHL)RUPVDQG2UDFOHL5HSRUWVIXQFWLRQDOLW\7KLV LWHUDWLYHGHVLJQLVDNH\HOHPHQWRIDFRPSOHWHSURGXFWLYHHQYLURQPHQWUHTXLUHG IRUGHVLJQLQJDQGGHYHORSLQJQHZDSSOLFDWLRQVIURPVFUDWFKRUEDVHGRQOHJDF\ DSSOLFDWLRQV Comprehensive Repository Management Facilities

7RIDFLOLWDWHWKHUDSLGSURGXFWLYHDQGHIILFLHQWGHVLJQDQGJHQHUDWLRQRI DSSOLFDWLRQV2UDFOHL'HVLJQHUXVHV2UDFOHL6&0DFRPSUHKHQVLYHVHWRIWRROV IRUVWRULQJDQGPDQDJLQJDSSOLFDWLRQPHWDGDWD Versioning and Configuration Management

2UDFOHL6&0VXSSRUWVHDFKVWDJHRIWKHGHYHORSPHQWSURFHVVLQDWUXHPXOWLXVHU HQYLURQPHQWZKLFKIDFLOLWDWHVVPRRWKWHDPZRUNLQJRQVPDOORUODUJHVFDOH DSSOLFDWLRQVLQDVHFXUHFRQWUROOHGHQYLURQPHQW3DUDOOHOGHYHORSPHQWRI DSSOLFDWLRQVIURPDVLQJOHVRXUFHLVDVVXUHGEHFDXVH2UDFOHL6&0FDQEHXVHGWR •

&UHDWHFRQILJXUDWLRQVRIDOOWKHDSSOLFDWLRQPHWDGDWDIRUDSDUWLFXODU YHUVLRQRUUHOHDVH

•

0DQDJHPXOWLSOHYHUVLRQVRIVRIWZDUHGHYHORSPHQWREMHFWV

•

&RPSDUHDQGLIQHFHVVDU\PHUJHYHUVLRQVRIVRIWZDUHGHYHORSPHQW REMHFWV

Oracle9i Designer: Technical Overview

Page 5

'HILQLQJFKDQJLQJDQGXSGDWLQJDSSOLFDWLRQVXVLQJ2UDFOHL'HVLJQHULVWURXEOH IUHHNQRZLQJWKDW2UDFOHL6&0ZLOOV\QFKURQL]HWKHDSSOLFDWLRQDQGLWVPHWDGDWD LQVWDQWO\8VHUV·DFFHVVWRWKHUHSRVLWRU\LVVWULFWO\FRQWUROOHGDQGXVHUV¶FKHFNLQ· DQG¶FKHFNRXW·VRIWZDUHGHYHORSPHQWREMHFWVXQGHUYHUVLRQFRQWUROSURYLGLQJDQ HVVHQWLDOPHWKRGIRUUHFRUGLQJDQGUHSRUWLQJRQWKHVWDWXVDQGKLVWRU\RIFKDQJHV WRWKHVHREMHFWV Powerful Dependency Analysis


)LJXUH'HSHQGHQFLHV9LHZHGLQWKH'HSHQGHQF\0DQDJHU

2UDFOHL6&0FRQWDLQVDQRSHQDQGSXEOLVKHG$3,DQGVXSSRUWVFUHDWLQJFXVWRP VRIWZDUHGHYHORSPHQWREMHFWVWRKHOSPHHWDQ\DFWLYLWLHVRUPHWDGDWDQHHGV VSHFLILFWR\RXUEXVLQHVV

Oracle9i Designer: Technical Overview

Page 6

OVERVIEW OF ORACLE9i DESIGNER TOOLS


)LJXUH7KH2UDFOHL'HVLJQHU)URQW3DQHO Modeling System Requirements

7KH3URFHVV0RGHOHUUHSUHVHQWVFXUUHQWDQGIXWXUHWDUJHWEXVLQHVVSURFHVVHV LQFOXGLQJPHWULFVVXFKDVWLPHFRVWDQG\LHOG,WDOVRSURYLGHVIOH[LEOHVXSSRUWIRU %XVLQHVV3URFHVV5HHQJLQHHULQJWHFKQLTXHV 7KH(QWLW\5HODWLRQVKLS'LDJUDPPHUUHSUHVHQWVWKHGDWDFHQWULFV\VWHP UHTXLUHPHQWVRIDEXVLQHVVDQGSURYLGHVDFFHVVWRWKH'DWDEDVH'HVLJQ 7UDQVIRUPHUIRUFUHDWLQJGHIDXOWGDWDEDVHGHVLJQV,WXVHVVWDQGDUGLQIRUPDWLRQ HQJLQHHULQJQRWDWLRQWRUHSUHVHQWWKLQJVRILPSRUWDQFHHQWLWLHV WKHLUSURSHUWLHV DWWULEXWHV DQGKRZHQWLWLHVUHODWHWRHDFKRWKHUUHODWLRQVKLSV  7KH)XQFWLRQ+LHUDUFK\'LDJUDPPHUUHSUHVHQWVWKHHOHPHQWDU\EXVLQHVV IXQFWLRQVWKDW\RXUEXVLQHVVSHUIRUPVZKLFKLOOXVWUDWHKRZ\RXXVHHQWLWLHVDQG WKHLUDWWULEXWHVNH\WRFUHDWLQJDSSOLFDWLRQGHVLJQV,WVXSSRUWV)XQFWLRQ3RLQW $QDO\VLVIRUSURMHFWPDQDJHPHQWSXUSRVHVDQGDOVRSURYLGHVDFFHVVWRWKH $SSOLFDWLRQ'HVLJQ7UDQVIRUPHUIRUFUHDWLQJGHIDXOWDSSOLFDWLRQGHVLJQV 7KH'DWDIORZ'LDJUDPPHUUHSUHVHQWVKRZGDWDIORZVWKURXJK\RXUEXVLQHVVDW DQ\OHYHOWRLGHQWLI\LIGDWDGHSHQGHQFLHVH[LVWIRUH[DPSOHEHWZHHQGDWDVWRUHVDQG HOHPHQWDU\EXVLQHVVIXQFWLRQV,WRIIHUVUDSLGWUHHZDONLQJDFURVVWKHIXQFWLRQDO PRGHODQGSURYLGHVDFFHVVWRWKH$SSOLFDWLRQ'HVLJQ7UDQVIRUPHUIRUFUHDWLQJ GHIDXOWDSSOLFDWLRQGHVLJQV

Oracle9i Designer: Technical Overview

Page 7

Transforming Preliminary Designs

7KH'DWDEDVH'HVLJQ7UDQVIRUPHUFUHDWHVILUVWFXWGDWDEDVHGHVLJQVRUVHUYHU PRGHOV EDVHGRQWKH(QWLW\5HODWLRQVKLS'LDJUDPVFUHDWHGZKHQGHILQLQJV\VWHP UHTXLUHPHQWV,WFUHDWHVIRUH[DPSOHWDEOHVWRUHFRUGLQVWDQFHVRIHQWLWLHVFROXPQV WRVWRUHDWWULEXWHVDQGLQGH[HVWRVXSSRUWIRUHLJQNH\V
)LJXUH7KH2UDFOHL'HVLJQHU'HVLJQ(GLWRU

7KH'HVLJQ(GLWRULVWKHFRQWUROFHQWHUIRUGDWDEDVHDQGDSSOLFDWLRQGHVLJQ JHQHUDWLRQDQGGHVLJQFDSWXUH)HDWXUHVVXFKDVPXOWLSOHGLDJUDPW\SHVSUHIHUHQFH SDOHWWHVREMHFWOLEUDULHVDQGZL]DUGVIRUPDZRUNEHQFKIRUQHZRUH[SHULHQFHG

Oracle9i Designer: Technical Overview

Page 8

XVHUVWRGHILQHXVHULQWHUIDFHVWDQGDUGVRQFHDQGWKHQHQIRUFHWKHPDFURVVDQ DSSOLFDWLRQ 7KH'HVLJQ(GLWRU·VGHFODUDWLYHDSSURDFKUHSUHVHQWVEXVLQHVVUXOHVJUDSKLFDOO\ IXOO\VXSSRUWLQJWKHGHVLJQDQGJHQHUDWLRQRIUHODWLRQDODQGREMHFWUHODWLRQDO GDWDEDVHVWUXFWXUHV •

*HQHUDWHDSSOLFDWLRQVIRUDQ\WDUJHWSODWIRUPIURPPHWDGDWDVWRUHGLQ WKHUHSRVLWRU\

•

*HQHUDWH2UDFOHL)RUPV2UDFOHL5HSRUWVDQGRU:HE3/64/ IURPWKHVDPHVLQJOHGLDJUDP

•

'HILQHDQGJHQHUDWHDSSOLFDWLRQORJLFIRU3/64/RU-DYD6FULSW

•

*HQHUDWHDQGGHVLJQFDSWXUH2UDFOHDQGQRQ2UDFOHGDWDEDVHV

•

'HVLJQFDSWXUHDSSOLFDWLRQVIRUDQDO\VLVUHGHVLJQDQGUHJHQHUDWLRQ

Oracle9i Forms Generator and Oracle9i Reports Generator

8VHGWKURXJKWKH'HVLJQ(GLWRUWKH2UDFOHL)RUPV*HQHUDWRUDQG2UDFOHL 5HSRUWV*HQHUDWRUIXOO\VSHFLI\JHQHUDWHRUFDSWXUHWKHGHVLJQRI2UDFOHL )RUPVDQG2UDFOHL5HSRUWV7KLVIDFLOLWDWHVWKHUDSLGFUHDWLRQRIDSSOLFDWLRQVIRU GHSOR\LQJLQDZHEEDVHGHQYLURQPHQW2UDFOHL)RUPV*HQHUDWRUKDVWKH IXQFWLRQDOLW\WRIXOO\LQWHJUDWHZLWKWKHSRZHUIXOIXQFWLRQDOLW\DYDLODEOHLQ2UDFOHL )RUPV7KLVIXQFWLRQDOLW\LQFOXGHV •

7KHDELOLW\WRFDSWXUHIRUPVLQWR2UDFOHL'HVLJQHUGLUHFWO\IURP 2UDFOHL)RUPVLQFOXGLQJDQ\FKDQJHVPDGHWRJHQHUDWHGIRUPVLQ )RUP%XLOGHUIRUH[DPSOHFKDQJHVWRJHQHUDWHGDSSOLFDWLRQORJLF 

•

6HSDUDWLQJ/LVWVRI9DOXHV/29V IURPORRNXSWDEOHXVDJHVWRPDNH WKHPHDVLHUDQGTXLFNHUWRJHQHUDWH8VHUVFDQDOVRGHILQH/29VIRU XQERXQGLWHPVGHILQHPXOWLSOH/29VIRUWKHVDPHEORFNDQGUHXVHWKH VDPH/29DFURVVPXOWLSOHEORFNVDQGPXOWLSOHIRUPV

•

6XSSRUWIRUVSOLWWLQJEORFNVDFURVVPXOWLSOHFDQYDVHVE\JHQHUDWLQJ PXOWLUHJLRQEORFNVDQGDOVRIRUVLGHE\VLGHEORFNVRQWKHVDPH FDQYDV

•

5HODWLYHWDEVWRSVQRWDEVROXWHWDEVWRSVIURPSUHYLRXVUHOHDVHV IRU SRVLWLRQLQJDQGDOLJQLQJLWHPVDQGLWHPJURXSVZKLFKWKH'HVLJQ (GLWRUUHSUHVHQWVJUDSKLFDOO\

•

7KHDELOLW\WRFDSWXUHWKHGHVLJQRIPXOWLUHJLRQEORFNVVSHFLI\UHDO XQLWVZKHQVHWWLQJGHFRUDWLRQSUHIHUHQFHVDQGJHQHUDWH%HDQ$UHD LWHPVWRFRQWDLQ-DYD%HDQV

Oracle9i Designer: Technical Overview

Page 9

)LJXUH*HQHUDWLQJ2UDFOHL)RUPVIURP2UDFOHL'HVLJQHU0RGXOH 'HILQLWLRQV Oracle Web PL/SQL Generator

8VHGWKURXJKWKH'HVLJQ(GLWRUWKH:HE3/64/*HQHUDWRUJHQHUDWHV DSSOLFDWLRQVIRUGHSOR\LQJLQDZHEEDVHGHQYLURQPHQWXVLQJ2UDFOHL$SSOLFDWLRQ 6HUYHUL$6 7KHJHQHUDWHGDSSOLFDWLRQVUXQLQDQLQGXVWU\VWDQGDUGEURZVHUDQG FRQVLVWRI3/64/SDFNDJHVZKLFKJHQHUDWHDG\QDPLF+70/XVHULQWHUIDFHZLWK -DYD6FULSWYDOLGDWLRQFRGH 7KH:HE3/64/*HQHUDWRUXVHVWKHVDPHPRGXOHGHILQLWLRQVDVWKRVHXVHGWR JHQHUDWH2UDFOHL)RUPV,WSURYLGHVDUREXVWPHWKRGIRUSXEOLVKLQJLQIRUPDWLRQ VWRUHGLQWKHUHSRVLWRU\DQGWKHVXSSRUWIRU-DYD6FULSWDGGVGDWDPDQLSXODWLRQ FDSDELOLWLHVWRWKH+70/SODWIRUP )XOOVXSSRUWIRUFDVFDGLQJVW\OHVKHHWVPXOWLSOHIUDPHVRQDSDJHDQGJUDSKLFV UHVXOWVLQJHQHUDWLQJDWWUDFWLYHDQGSRZHUIXO+70/EDVHGDSSOLFDWLRQV Oracle Server Generator

8VHGWKURXJKWKH'HVLJQ(GLWRUWKH6HUYHU*HQHUDWRUFUHDWHV\RXUDSSOLFDWLRQ GDWDEDVHREMHFWVGDWDEDVHDGPLQLVWUDWLRQREMHFWVDQG3/64/6HUYHU$3,
Oracle9i Designer: Technical Overview

Page 10

FDQFKRRVHZKHWKHUWRJHQHUDWHWKHVHREMHFWVGLUHFWO\LQWRWKHWDUJHWGDWDEDVHRU JHQHUDWHWRVFULSWILOHV7KHDELOLW\WRFDSWXUHDOOWKLVLQIRUPDWLRQIURPH[LVWLQJ GDWDEDVHVDOORZV\RXWRPDLQWDLQDQGUHGHVLJQ\RXUDSSOLFDWLRQVXVLQJ2UDFOHL 'HVLJQHU 7KH6HUYHU*HQHUDWRUH[SORLWVDOOWKHVRSKLVWLFDWHGIHDWXUHVDQGFDSDELOLWLHVRI 2UDFOHLUHODWLRQDOGDWDEDVHWHFKQRORJ\IRUH[DPSOHGLVWULEXWHGGDWDEDVHVVHUYHU VLGHYDOLGDWLRQDQGORJLFUROHEDVHGVHFXULW\PRGHOVGDWDUHSOLFDWLRQDQGVRRQ,W RIIHUVIXOOVXSSRUWIRUJHQHUDWLQJWKHGLIIHUHQWIODYRUVRI2UDFOHUHODWLRQDO GDWDEDVHV •

2UDFOHL

•

2UDFOHL

•

2UDFOH5'%069/'%DQG2EMHFWH[WHQVLRQV

•

2UDFOH

•

2UDFOH5'%

$GGLWLRQDOO\WKH6HUYHU*HQHUDWRURIIHUVH[WHQVLYHJHQHUDWLRQDQGGHVLJQFDSWXUH FDSDELOLWLHVIRUDQ\2'%&FRPSOLDQWQRQ2UDFOHGDWDEDVHIRUH[DPSOH'% 0LFURVRIW64/6HUYHU6\EDVHRU$16,VWDQGDUG64/''/ *HQHUDWLQJWKH3/64/6HUYHUWDEOH$3,7$3, IRUDOOWKHWDEOHGHILQLWLRQV FUHDWHGLQWKHGDWDEDVHSURYLGHVVHUYHUVLGHYDOLGDWLRQRIWKHFRQVWUDLQWVWKDW HQIRUFHWKHUHODWLRQVKLSVEHWZHHQGDWDEDVHREMHFWVIRUH[DPSOHGHQRUPDOL]DWLRQ 7KLVIDFLOLWDWHVPXOWLWLHUDSSOLFDWLRQVWKDWHQFDSVXODWHGDWDEDVHGDWDZLWKLQWKH GDWDEDVHORJLF

Oracle9i Designer: Technical Overview

Page 11

STORING AND MANAGING APPLICATION META DATA

7KH5HSRVLWRU\$GPLQLVWUDWLRQ8WLOLW\5$8 LVWKHQHUYHFHQWHURI2UDFOHL 6&0XVHGWRDGPLQLVWHUWKH6&0UHSRVLWRU\IURPGD\WRGD\7KLVJUDSKLFDOWRRO LVWKHPHFKDQLVPIRULQVWDOOLQJDQHZUHSRVLWRU\IRU2UDFOHL'HVLJQHURU PLJUDWLQJRUXSJUDGLQJDUHSRVLWRU\IURPDSUHYLRXVUHOHDVH,W·VKHUHWKDW\RXDGG FXVWRPL]HGVRIWZDUHGHYHORSPHQWREMHFWVWRPHHWPHWDGDWDQHHGVVSHFLILFWR\RXU EXVLQHVV 8VLQJWKH5$8WRSHUIRUPDGPLQLVWUDWLYHWDVNVIRUH[DPSOHFKHFNLQJUHSRVLWRU\ REMHFWVDQGV\VWHPUHTXLUHPHQWVEDFNLQJXSUHSRVLWRU\REMHFWVDQGPDLQWDLQLQJ XVHUDFFHVVXQGHUSLQVWKHWUXHPXOWLXVHUHQYLURQPHQWRI2UDFOHL6&0 Repository Object Navigator

7KH5HSRVLWRU\2EMHFW1DYLJDWRU521 LVWKHWRROWKDWH[SRVHVWKH LQIUDVWUXFWXUHIRUVWRULQJDQGPDQDJLQJDOO\RXUVRIWZDUHGHYHORSPHQWREMHFWVDQG UHODWHGILOHVVWRUHGLQWKH6&0UHSRVLWRU\8VHLWZLWKWKH5$8WRFRPSOHWHWDVNV UHODWLQJWRUHSRVLWRU\DGPLQLVWUDWLRQDQGWRDFFHVVREMHFWVLQLWEXWVSHFLILFDOO\IRU PDLQWDLQLQJPXOWLSOHYHUVLRQVRIWKRVHUHSRVLWRU\REMHFWV &UHDWLQJDQGPDQDJLQJ\RXUVRIWZDUHFRQILJXUDWLRQVLVHDV\DQGHIILFLHQWXVLQJWKH 5HSRVLWRU\2EMHFW1DYLJDWRUDQG3URSHUW\3DOHWWHWRVHHGHWDLOVRIWKHREMHFWVLQ HDFKFRQILJXUDWLRQ

)LJXUH7KH2UDFOHL'HVLJQHU5HSRVLWRU\2EMHFW1DYLJDWRU

Oracle9i Designer: Technical Overview

Page 12

Managing Multiple Versions or Objects Version History Viewer and Dependency Manager

7KH9HUVLRQ+LVWRU\9LHZHULVDJUDSKLFDOWRROXVHGWRGLVSOD\DKLVWRU\RIWKH GLIIHUHQWYHUVLRQVRIDQREMHFWVWRUHGLQWKH6&0UHSRVLWRU\
)LJXUH7KH9HUVLRQ+LVWRU\RID5HSRVLWRU\2EMHFW Version Event Viewer

7RFRPSOHWHDFRPSUHKHQVLYHDQGHDV\WRXVHJUDSKLFDOYLHZRIWKHPXOWLSOH YHUVLRQVRI\RXUUHSRVLWRU\REMHFWVWKH9HUVLRQ+LVWRU\9LHZHULVFRXSOHGZLWKWKH 9HUVLRQ(YHQW9LHZHU7KLVLVDQRWKHUJUDSKLFDOWRROXVHGWROLVWLQFKURQRORJLFDO RUGHUGHWDLOVRIWKHGLIIHUHQWYHUVLRQVRIDQREMHFWVWRUHGLQWKHUHSRVLWRU\'HWDLOV GLVSOD\HGLQFOXGHIRUH[DPSOHWKHQXPEHURIYHUVLRQVFUHDWHGVLQFHDSDUWLFXODU WLPHDQGGDWHDQGZKLFKXVHUPDNHVWKHPRVWFKDQJHVWRDQREMHFW Dependency Analysis

7RDQDO\]HDVVRFLDWLRQVEHWZHHQVWUXFWXUHGDQGXQVWUXFWXUHGGDWDVWRUHGLQWKH 6&0UHSRVLWRU\HQDEOLQJHIIHFWLYHLPSDFWDQDO\VLVRIFKDQJLQJREMHFWVDQG PDQDJHPHQWRIFRQILJXUDWLRQVWKH521DOVRSURYLGHVDFFHVVWRWKH'HSHQGHQF\ 0DQDJHU The Dependency Manager

8VLQJWKH'HSHQGHQF\0DQDJHUHQVXUHVQRGHSHQGHQFLHVUHPDLQXQNQRZQ2YHU WLPHDZHDOWKRIGHSHQGHQF\LQIRUPDWLRQEXLOGVXSIRU\RXUDSSOLFDWLRQDOOVWRUHG LQWKH6&0UHSRVLWRU\IRULPPHGLDWHDFFHVVDQGDQDO\VLV7KHUHVXOWLVPRUH

Oracle9i Designer: Technical Overview

Page 13

HIILFLHQWGHYHORSPHQWDFWLYLWLHVZLWKFRPPRQFRPSRQHQWVLGHQWLILHGWRUHGXFH GXSOLFDWLQJHIIRUW The Matrix Diagrammer

7KH0DWUL['LDJUDPPHULVDJHQHUDOSXUSRVHFURVVUHIHUHQFLQJWRROWKDW VXSSRUWVDVVHVVLQJWKHVFRSHRIDSURMHFWLPSDFWDQDO\VLVQHWZRUNSODQQLQJDQG TXDOLW\FRQWURO7KHFURVVUHIHUHQFLQJRILQIRUPDWLRQLQWKHUHSRVLWRU\LVLPSRUWDQW WKURXJKRXWWKHGHYHORSPHQWOLIHF\FOH7KH0DWUL['LDJUDPPHUFRXOGDQVZHU TXHVWLRQVVXFKDV •

7RZKDWVWUDWHJLFREMHFWLYHRUFULWLFDOVXFFHVVIDFWRUGRHVWKLVSURJUDP FRQWULEXWH"

•

'R,KDYHDQ\IXQFWLRQVWKDWGRQRWXVHHQWLWLHVLQDQ\ZD\"

•

$WZKLFKQHWZRUNQRGHVDUHP\GDWDEDVHWDEOHVFXUUHQWO\UHVLGLQJ"

7KH0DWUL['LDJUDPPHUFURVVUHIHUHQFHVWZRRUWKUHHW\SHVRIREMHFWVDQG SURYLGHVWKHDELOLW\QRWMXVWWRYLHZWKHREMHFWVEXWDOVRWRFUHDWHDQGXSGDWHWKHP Repository Reports

5HSRVLWRU\5HSRUWVSURYLGHVDSSUR[LPDWHO\SUHGHILQHGUHSRUWVIRUH[DPLQLQJ WKHFRQWHQWVRIWKH6&0UHSRVLWRU\7KHJUDSKLFDO5HSRUWV1DYLJDWRUGLVSOD\V WKHUHSRUWVE\QDPHRUGLYLGHGLQWRJURXSVGHSHQGLQJRQWKHLUXVDJHRUWKHW\SH RILQIRUPDWLRQWKH\VKRZ7KHUHIRUHVHOHFWLQJWKHULJKWUHSRUWWRUXQLVHDV\ 5HSRVLWRU\UHSRUWVRIIHULQGHSWKLQIRUPDWLRQIRUPRQLWRULQJSURJUHVVDQG LGHQWLI\LQJWKHDVVRFLDWLRQVEHWZHHQHOHPHQWVRIWKHDSSOLFDWLRQGHYHORSHGXVLQJ GLIIHUHQW2UDFOHL'HVLJQHUWRROV&XVWRPEXLOWUHSRUWVDUHDYDLODEOHWRRIIHUD FRPSOHWHUHIHUHQFHRI\RXUDSSOLFDWLRQFRYHULQJDQ\EXVLQHVVVSHFLILFPHWDGDWD QHHGVQRWLQFOXGHGLQWKHSUHGHILQHGUHSRUWV

Oracle9i Designer: Technical Overview

Page 14

SUMMARY

2QO\2UDFOHL'HVLJQHURIIHUVWKHFRPSUHKHQVLYHWRROVHWWKDWHQDEOHV\RXWR¶IDVW WUDFN·\RXUGHYHORSPHQWDFWLYLWLHVIRUZHEEDVHGHEXVLQHVVDSSOLFDWLRQV,W VXSSRUWVWKHODWHVWUHOHDVHRIWKH2UDFOHGDWDEDVH2UDFOHLDQGLQWHJUDWHVIXOO\ ZLWKRWKHUGHYHORSPHQWWRROVVXFKDV2UDFOHL)RUPV&RXSOHGZLWK2UDFOHL 6&02UDFOHL'HVLJQHUGHOLYHUVDSURGXFWLYHHQYLURQPHQWIRUGHYHORSLQJVPDOORU ODUJHUVFDOHFRPSOH[DSSOLFDWLRQV 2UDFOHL'HVLJQHURIIHUVDSRZHUIXOIOH[LEOHHIILFLHQWDFFXUDWHDQGDXWRPDWLF DSSURDFKWKDWLVHDV\WRPDQDJHDQGPDLQWDLQ8VHLWWRUHGXFHWKHDPRXQWRI FRGLQJQHFHVVDU\IRFXVRQDQDO\VLVDQGGHVLJQDQGWKHUHIRUHLPSURYHWKHTXDOLW\RI WKHILQLVKHGDSSOLFDWLRQE\KLWWLQJWKHWDUJHWILUVWWLPH 

Oracle9i Designer: Technical Overview

Page 15

Oracle9i Designer: Technical Overview April 2002 Author: Simon W. Day Contributing Authors: Dominic Battiston, Dave Brown, Mark Pirie Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 www.oracle.com Oracle is a registered trademark of Oracle Corporation. Various product and service names referenced herein may be trademarks of Oracle Corporation. All other product and service names mentioned may be trademarks of their respective owners. Copyright © 2002 Oracle Corporation All rights reserved.