Sybase XML manuel d'utilisation

XML Model User's Guide Sybase ® Pow erDesigner ® 11.1 W indows[...]

DOCUMENT ID: DC20014-01-1110- 01 L AS T REV I SED : June 2005 Copyri ght © 1991- 2005 Sybase, Inc. A ll rig hts reserved. Inf orm ati on in thi s m anu al m ay chan g e with out n oti ce and does n ot represen t a com m i tm ent on th e part of Sybase, I nc. an d its sub sid iar ies . Sybase, I nc. prov i des the sof tware descr ibed i n t hi s m [...]

XSM Us er 's G ui de iii Contents A bout T his Book ............................................................................................ ix 1 XML Mod el Ba sics .............................................................. 1 Functional overview .................................................................. 2 W hat is an XML m odel[...]

iv PowerDesigner Defining Any Attribute properties ...................................... 61 Defining identity constraints .................................................... 64 Defining a unique constr aint ............................................. 64 Defining a k ey constraint .................................................. 66 Defining a [...]

XSM Us er 's G ui de v Defining an include ......................................................... 127 Defining a redef ine ......................................................... 128 Defining business rules ......................................................... 132 W hat is a business r ule? ............................................[...]

vi PowerDesigner Understanding objec t mapping ...................................... 166 Defining data sourc es in an XML m odel ........................ 166 Mapping XML Model objects to PDM objects ................ 169 Mapping XML Model objects to OOM objec ts ................ 171 Creating a m apping for an XML obj ect........................... [...]

XSM Us er 's G ui de vii 5 Exchanging data w ith da tabases supporti ng XML ...... 215 W hy use XML in databases? ................................................ 216 Generating an annotated sc hema f or Micros oft SQL Server 2000 .......................................................................... 217 Mapping XML objects to PDM objects [...]

viii PowerDesigner[...]

XSM Us er 's G ui de ix About This Book This book des cribes th e Pow erDesig ner XML Model env ironm ent . It show s you how to do the followin g: ♦ Build an XML m odel ♦ Work on an XML m odel ♦ Generate and revers e engin eer a DTD file ♦ Generate and revers e engin eer an XSD file ♦ Generate and reve rse engin eer an XDR f ile ♦[...]

About This Book x PowerDesigner ♦ Object Oriented Model (OOM) to model a so ftware system using an obj ec t -orie nted a ppr oac h for J ava o r ot he r ob je c t language s ♦ Business Pr o cess M odel (BP M) to model the m ean s by wh ich on e or more process es are accom plished in operatin g bus iness practices ♦ XML M odel (XSM ) to model[...]

About This Book XSM Us er 's G ui de xi Repository Getting Started To learn the basics of th e Repository . Repository User’s G uide T o w ork in a mu lti-user en vironmen t using a central repository . PowerDesig ner docum entation u ses specifi c typef aces to help y ou readily identify specific items: ♦ monospace text (normal and bold )[...]

About This Book xii PowerDesigner[...]

XSM Us er 's G ui de 1 CHAPTER 1 XML Model Basics This chapter presents PowerDesig ner XML Model . It provides y ou w it h an introduction to the basic notions of XML modeling. Topic Page Functional ov ervie w 2 What is an X ML model? 3 Def ining the XML m odel env ironm ent 10 Def ining a n XML m odel 17 About this chapter Contents[...]

Functional over view 2 PowerDesigner Functional ov erv iew With the graphi cal interface and th e B r owser tree view of PowerDesig ner XML Model, y o u can design an XML diagram which repres ents the con tent of an XML Sch ema Defi nition file (.XSD), a Docum ent Type Definition f ile (.DTD) or an XML-Data Redu ced file (.XDR). Since XML stru ctur[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 3 What is an XML model? An XML model is a graphical representation of an XML Schem a Definition file (.XSD), a Documen t Type Definition f ile ( . DT D) or an XML-Data Reduced f ile (.XDR). With its Brow ser tree view and diagram , an XML m odel gives y ou a global and schem atic view of all the [...]

What is an XML model? 4 PowerDesigner A bout XM L The eXtensi ble M arkup Language is use d for differ ent r e asons: ♦ It describes an d structures data , wh ereas HTML only di splay s data ♦ It uses a s elf-describin g and personalized sy ntax ♦ It can be exchan ged between in compatible sy stems, s ince data is stored in plain text f ormat[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 5 Extract of an XSD f ile: An XSD f ile alw ays s tarts w ith the <schema> tag (root element). All objects cr eated in the model will appear in the XSD f ile between th e schem a start-tag and en d-tag ♦ An XDR fi le is a s im plifie d XSD fi le (or sch ema). It does not s upport sim p le[...]

What is an XML model? 6 PowerDesigner An XML model is a tree structu re of child elem ents attached to parent elemen ts. Elem ents are the bas ic describing item s of an XML m odel. T hey can b e made o f other elements c ombine d in di ffe rent ways thro ugh group particles. Elem ents are specifi ed by attribu tes and data ty pes which can be pred[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 7 Tool Object Description — Notation A nota tion is used to de fine and proce ss non- XML objec ts within an XML mode l These tools are available in th e palette of the diag ram w indow . The mai n objects of an XML model are repres ented by sy mbols i n its diagram . Objects in a diagram Some [...]

What is an XML model? 8 PowerDesigner How to link a child object to a parent object in an XM L model? XML objects do n o t support standard l ink objects. To link a ch ild object to a parent object, you must click the child ob j ect tool in the palette and then click the sym bol o f the parent obj ect in the diagram . This will autom atically creat[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 9 Tool Sequence sy mbol Choice sy mbol All sy mbol No link No link All No link No link No link Caution A group parti cle (s equence, choice, all) cannot be created f rom scr atch in a diagram. It must be the chi ld element of an elem ent, a group or a complex t ype.  For more information , see[...]

Defining the XML model environment 10 PowerDesigner Defining the XML model env ironment The XML m odel environ men t includes a set of parameters and conf iguration options t hat def ine vari ous aspect s of th e model conten t and behavior. You can set thes e parameters: ♦ At m o d el creation ♦ After creating a m odel with default options and[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 11 Changing the XML language of an XM L model If you cha nge the X M L language of an XM L model , you have to defi ne the status o f t he language: XML language Description Share To use th e sh ared XM L language stor ed in th e X ML Languages director y of your installa tion. Any cha n ges ma d[...]

Defining the XML model environment 12 PowerDesigner 4 Click OK. A message bo x i nfo rms you that the c urrent XML langua ge has be en chang ed. 5 Click OK. Changes concerning simple and compl ex ty pes Sim ple types an d comple x ty pes are only s upported by XSD s (schem as). When chan ging an XSD into a DTD or an XDR, sim ple types and g lobal c[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 13 Selecting extended model definitions at model creation Extended model definitions (.XEM f iles) provide means for customizin g and extend ing Po werD esigner meta classes, par a meters and genera tion. E xtende d model definitions are ty pe d like models in PowerDesigner. You create an extende[...]

Defining the XML model environment 14 PowerDesigner  For more inform ation on extended model definitions, see ch ap ter Extended Model Definitions Referen ce Guide, in the Advanced Us er Documentatio n . Defining model options You can define the case sens itivity of n ames and codes for all objects in the current m odel. When this check box is s[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 15  To define XM L model options: 1 Select Tools → Model Options. or Right-click the diagram backg round and select Model Optio ns in the contextual m enu. The Model Options dialog box opens to t he Model Sett ing s pane. 2 Select or clear the Name/Code case sensitiv e check box in the A ll [...]

Defining the XML model environment 16 PowerDesigner You can ty pe stereotypes directly in the Stereotype colum n of the object property sheet or s elect a val ue from the dropdow n listbox if you hav e previous ly defin ed stereoty pes in an em bedded or imported ex tended model definition (.XEM).  For more inform ation on extended model definit[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 17 Defining an XML model This section presents the main operations you h ave to perform before starting to build or w ork on an X ML m odel. Defining model properties The model prop er ty sh eet d isplays th e definition of the current m o d e l. Only the specific pag es of an XML model are expla[...]

Defining an XML model 18 PowerDesigner If you want to d ispla y the X ML language , clic k the P r ope rties t ool besid e the X ML language box in t he Gener al p a ge to d ispla y the pro per ty sheet o f t he XML la nguage. 3 Click OK. Model General page The General pag e of th e model propert y s heet dis plays the follow ing properties: Proper[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 19 Model Detail page The Detail page of a m odel property sheet (only available in a m odel targeted with XSD) displays the follow ing properties: Property Description Targe t Namespace Namespace of all the model ob jects. Its n ame is a URI which does not ref er to any f ile but only to an a ssi[...]

Defining an XML model 20 PowerDesigner Model Items page The Item s page of the m odel property sh eet displays the lis t of g lobal objects (with no parent sym bo l in the diagram , d ir ectly linked to the <schem a> tag) created in the model. This list reflects the order in which global obj ects ar e being declared in th e schema. If y ou wa[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 21 Tool Tooltip Description Add A nnotation Adds an annotation to the mode l, to provide docum entation or a pplication inf o rmation. Only a vailable in a mode l targeted with XSD  For more inform ation on these item s, see chapter Building an XML model . Model External Schemas page A schem a[...]

Defining an XML model 22 PowerDesigner Model Namespaces page A nam espace is a URI indicating a loca tion w here objects are declared. The prefix of a namespace, follow ed by a colon (:) an d the name of an object, indicates that th is object is declared in that nam espace. Namespaces are not support ed by DTDs. You can u se the follow ing tools to[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 23 ♦ In the case of a model targeted w ith XDR, two n amespaces are predefined in th e list of names paces.[...]

Defining an XML model 24 PowerDesigner Model Preview page The Preview page of the m odel property s heet display s a preview of the XSD, DTD or XDR file generated from th e XML m odel. Exam ple of an XSD f ile (or schema file): The schem a file starts w ith the XML declaration follow ed by th e <schem a> (root elemen t) declaration. All objec[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 25 Creating an XML model using t he New model opt i on When you c reat e a new XML mod e l using the N e w m o del o pti o n, you have to sel ect an X ML langua ge . You can then select one of the follow ing options: Option Description Share To use th e sh ared XM L language stor ed in th e X ML [...]

Defining an XML model 26 PowerDesigner 6 <optional> If you w ant to attach one or more extended m odel definitions to the model, click the Ex tended Model Definitions tab, and select the extended model defin itions of y our choice.  For more information on attach ing extended model definitions to a model, see section Selecting ex tended mo[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 27 Creating an XML model using t he New model f r om t em pl ate option  To create a new XM L model using the New model from template option: 1 Select File → New to display the New dialog box . 2 Select XML Model in the list of m od el types. 3 Select the New model from tem p late radio butt[...]

Defining an XML model 28 PowerDesigner Opening an existing XML model An XML model has the file ex tension .XSM. If P o werDes i gner ca nnot find the XM L language atta c hed t o the XM L model you want to o p en, the Choos e XML Langua ge dia log b o x app ear s t o let you selec t anothe r XML la ngua ge to a ttach t o the mode l. Yo u can sele c[...]

Chapter 1 XML Model Basics XSM Us er 's G ui de 29 Saving and closing an XML model To save an XML model, choose on e of the follow ing option s: ♦ Select File → Save ♦ Click the Save tool in the stan dard to o lb ar ♦ Right-click the XML m o d el in the Browser tree view and select Save in the contextu al menu If it is the first tim e [...]

Defining an XML model 30 PowerDesigner[...]

XSM Us er 's G ui de 31 CHAPTER 2 Building an XML model This chapter describ es how to build an XML m odel (XSM). I t explains the role of each object in an XML m odel and how to create and m odify th em. Topic Page XML dia gram basics 32 Defining element s 35 Defining identity constraints 64 Def ining groups 76 Manag ing ex ternal shortcuts t[...]

XML diagram basics 32 PowerDesigner XML diagram basics You can create XML diagram s in an XML model. Defining an XML diagram An XML diagram is a graph ical view of an XML m odel. The follow ing ex ample sh ows the diagram of the Resu me XML model: The mai n objects of an XML model are repres ented by sy mbols i n its diagram .[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 33 Objects in a diagram Some objects m ay not appear in a diag ram becau se they do not have a sy mbol or thi s sy mbol has been delete d or hidden. Alw ays check the existen ce of objects in the Browser tree v iew . If an XML model is too large or too com p lex, you can create s everal diag[...]

XML diagram basics 34 PowerDesigner Creating an XML diagram There are two w ays to create an XML diagram : ♦ From a new XML m odel ♦ From an exis ting XML m odel  For inform ation on creating an XML diagram from a new XML model, see section Creatin g an XML model in chapter XML Model Basics.  For inform ation on creating an XML diagram fr[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 35 Defining elements Elemen ts are the basic bu ilding blocks of an XML m odel. An XML model is a tree structu re of elem ents w here child elemen ts are attached to parent elem ents. For exam ple (B row ser tree view an d diagram ) :[...]

Defining elements 36 PowerDesigner Gener ated sc hema: In a schem a, elements are declared w ith <elemen t> tags. Defining element properties To display an elem ent property sheet, dou ble-click its sym bol in a diag ram.[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 37 Element general properties There are global and local elem ents: ♦ Global elemen ts have n o parent elem ent in a diagram . T hey are directly linked to the <s chema> tag (root elem ent) in a schem a. T hey can be reuse d in the mod el thr o ugh refe renci ng e lements (S ee “XM[...]

Defining elements 38 PowerDesigner Property Description Refe rence Nam e of a globa l element. T he current elem ent will hav e the same properties as t he glob al el ement. The Reference prop erty is only availa ble for child elem ents. Use the dropdown lis tbox to select a gl obal element i n the cu rren t model. Use th e Browse tool to selec t a[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 39 In a mod el tar geted with the XML-D ata Red uced language , elements a re defin ed by di ffe rent attri butes: XDR attribute for an element Description Property or page in element property sheet Mod el To specify if a global el ement can contai n new local el ements. Set to closed by de [...]

Defining elements 40 PowerDesigner Exam ple of an XDR file: Element deta i l pr oper t i e s The Detail page of an elem ent property sh eet displays the follow ing properties: Property Description Minimum Min imum number of times the element can o ccur. To specify that th e el ement is opt i onal, set this attribute to zero Maximum Maximum number o[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 41 Property Description Nillable Property def ining if the e lem ent is null or not In the case of a m o d el targeted with XDR, the Detail page is only available for local elem ents. Element attributes properties Attributes give additional inform atio n about an elem ent. The Attributes pag[...]

Defining elements 42 PowerDesigner Element constr ai nt s pr oper t i e s Identity constraints allow you to indicate that elem ent values m ust be unique with in their specified scope. You can us e the Constraints pag e of an elem ent property sh eet to add the follo wing constra i nts to an element declaration : Tool Tooltip Description Key Constr[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 43 The Attrib utes Ma ppi ng p age a l l ows you to de fine the map ping b e tween PDM columns or OOM class attribut es and the elem ent attributes. Tool Tooltip Description Add Ma pping Use this tool to se lect the attribute s in the current ele me nt that will be ma pped to PDM columns o r[...]

Defining elements 44 PowerDesigner 3 Click the Pointer tool in the palette. or Right-click to recover the Po inter. 4 Double- click the elem ent sym bol in the diagram. The element property sheet appears. 5 Type a nam e and a code for the elem ent. 6 Select a dat a type f or the element . You can u se the Ty pe dropdown list box or the Brow se tool[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 45 How to link a child object to an element? XML objects do n o t support stan dard link objects. To link a ch ild object to an elem ent, you must click the child ob j ect tool in the palette and then click the elem ent sym bol in the diagram. This will autom atically create a link betw een [...]

Defining elements 46 PowerDesigner Tool Action Result If you click an element symbol with the Com plex Ty pe tool, a com plex ty pe sym bol appears superpose d, but not linked, to the element symbol. A glob al comple x type ca nnot be the child of an element No link If you click an element symbol with the Sequence tool, a sequenc e group particle a[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 47 For exam ple: Gener ated sc hema: In a schem a, attributes are d eclared w ith <attribute> tags.[...]

Defining elements 48 PowerDesigner A ttribute general pr oper t i es There are global and local attribut es: ♦ Global attributes are defined with th e Model menu. In a schem a, they are directly lin ked to the <sch ema> tag (root elem ent). They can be reused for a ny element in t he model t hrough r efer e nces ( See “NU MBE R” attribu[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 49 Property Description Ref erenc e Nam e of an attribute in the current m odel or anothe r mode l open ed in th e worksp ace. A reference allows you to reu se an attribute w ith all its properties w ithout having to def ine it aga in. Use the dropdown lis tbox to sele ct an attr ibute in th[...]

Defining elements 50 PowerDesigner Exam ple of an XDR file: A ttribute detail pr oper t i es The Detail page of an attribute prop er ty sh eet d isplays th e followin g properties: Property Description Defa ult Def ault value. Ente r a default va lue only if there is no fixed value Fixed Fixed va lue. Enter a fixe d value only if there is no defa u[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 51 Element values with XDR In a mod e l tar ge ted with the X ML-Data Reduce d langua ge, ther e is al so a Values page in the elem ent property sheet. A dding an attribute to an element  To add an attribute to an element: 1 Double- click the elem ent sym bol in the diagram. The element p[...]

Defining elements 52 PowerDesigner The element s ym bol appears in the diagram with the attribu te nam e. In the exam ple, <None> indicates that no data ty pe has been defined f or the attribute. Modifying element display preferences You can m odify the f ollowi ng display preferences for an elem ent by selecting Tools → Display Preferences[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 53 Child e lements ar e linked to the ir pa rent e l ement thro ugh a gro up par ticle . Defining gr oup par t i cles Group particles indicate how child elem ents are related with th eir parent elemen t. You can choose a group particle from the f ollowing list: Tool Tooltip Description Seque[...]

Defining elements 54 PowerDesigner Group parti cles properties To display a group parti cle property sheet, double- click its s ym bol in a diagram . The General pag e of a grou p particle property s heet display s the f ollowing properties: Property Description Ty pe Ty pe of the g roup particle . You can change its type by selec ting a value in t[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 55 You can access directly to th e Items page of a g roup particle property sheet thro ugh t he cont e xtual menu. Right -c lick a gr oup p arti cle symbol in t he diagram and select Item s in the contextual m enu. Creating a group par t i cle There are differen t w ays to create a group par[...]

Defining elements 56 PowerDesigner 7 Click OK. The group parti cle sy mbol appears se lected, w ith an Expan d tab on its right sid e. 8 Click an empty space in the diagram , to deselect the group particle sy mbol, an d click the Expan d tab to reveal the ch ild elemen t symbols and their link . Name and code uniqueness To respect the name an d cod[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 57 The child elemen ts appear one by one in the diagram, link ed to the group particle symbol. 5 Right -click to recover the Pointer. Clicking an element symbol with the Element tool When y ou click an elem ent sym bol with the Elem ent tool, a sequence sy mbol (by default) appears in the di[...]

Defining elements 58 PowerDesigner Tool Sequence sy mbol Choice sy mbol All sy mbol A re ferenc ing gr oup is created. Yo u must now s elect a group for the reference A re ferenc ing gr oup is created. Yo u must now s elect a group for the reference No link No link No link No link No link No link All No link No link No link Pointer indications When[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 59 ♦ Generated XSD file: In an XSD file, A ny is declared with th e <any> tag . ♦ Generated DTD file: In a DTD file, Any is declar ed within an <! ELEMENT > tag w ith the key word “ ANY ”. ♦ Generated XDR file: In an X D R file, Any is d e clar ed thr ough of a n <El[...]

Defining elements 60 PowerDesigner Property Description ID ID of the Any . Its value must be of ty pe ID and unique w ithin the m odel containing the Any. Only a vailable in a m odel targete d with XSD Namespace Nam espaces con t ai ning th e objects t hat can b e u sed. If you select ##any , objects fro m any namespace can b e u sed. If you select[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 61 5 Defi ne the A ny propertie s in th e different pag es of the property sheet. 6 Click OK. Modifying the A ny display preference You can m odify the Stereoty pe display preferen ce for An y by selecting Tools → Display Preferences. Defining A ny A ttribute properties The Any Attribute f[...]

Defining elements 62 PowerDesigner For exam ple: Caution Any Attribut e only appears in a s chema (see t he Preview page of a model property s heet). The Any Attribute feature is av ailable via a check box in th e bottom- left corner of an Attribut es page. To display an An y Attribute property sheet, select the A ny Attribute ch eck box and then c[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 63 A ny A ttribute general pr oper t i e s The General page of an Any Attribute pro perty sheet display s the follow ing properties: Property Description ID ID of the Any A ttribute. Its value m ust be of ty pe ID and unique w ithin the mode l containing the A n y Attribute Namespace Nam esp[...]

Defining identity constr aints 64 PowerDesigner Defining identity constraints Identity constraints en ab le you to indicate th at element v alues must be unique with in their specified scope. There are three kinds of identity cons traints: unique, k ey and k eyRef . Each identity con straint has tw o specific attributes: selector and field. In a sc[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 65 The UNIQUENUM unique con straint, defined on the project elemen t, specifies that the nu mEm plo yee attribute must be uniqu e or null with in the employ ee element To display a uniqu e property sheet , double-cl ick it s nam e or its icon i n the Brows er tree view . Unique general pr op[...]

Defining identity constr aints 66 PowerDesigner Defining a key constraint A key constraint specifies that an elem ent or an attribute value (or s et of values) m ust be a key within a specif ied scope. A key means that data should be unique, not nu ll and alway s present within a specified sc ope. For exam ple: Gener ated sc hema: The KEYCODE key c[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 67 Key genera l pr oper t i e s The General pag e of a ke y property sheet displ ays the follow ing properties: Property Description Nam e Nam e of the ke y constra int. It m ust be a no- colon-nam e (See Glossary) Code Code of the key constra int. It m ust be a no-colon-nam e Comm ent Desc [...]

Defining identity constr aints 68 PowerDesigner For exam ple: Gener ated sc hema: The KEYREF_UNIGOLD key Ref, defin ed on the produ ct elemen t, by reference to th e UNIGOLD uni que constrain t , specifies that the g old attribute mu st be unique or null w ithin the component_2 elemen t, as well as it m ust be uniqu e or null w ithin the com ponent[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 69 Key Ref gener al pr oper t i es The General pag e of a key Ref property sheet display s the follow ing properties: Property Description Nam e Nam e of the ke yRef constra int. It m ust be a no- colon-nam e (See Glossary) Code Code of the key Ref constra int. It m u st be a no-colon-na me [...]

Defining identity constr aints 70 PowerDesigner  To create an identity constraint from an element property sheet: 1 Click th e Constraints tab of an elemen t property sh eet. 2 Cli ck th e Add Un ique, A dd Key or Add Ke yR ef Con strain t tool in the Constra ints page . An identity constraint appears in the list with predefined nam e and cod e [...]

Chapter 2 Building an XML model XSM Us er 's G ui de 71 XPath abbrevi a t ed sy ntax You can u se the follow ing abbreviated sy ntax to defin e an XPath expression: Sy ntax Description / Root node of the XML doc ument. It is the root elem ent with its ramif ications . Selects the context node. It is the curre nt elem ent (on which an identity [...]

Defining identity constr aints 72 PowerDesigner Sy ntax Description /book/cha pter[2]/section[3] Select s the third se ction in the second cha pter of the book employee[@dep t=”doc”] Sel ect s all the emplo yee child elements o f the contex t node with a dept attribute set to doc employee[@dep t=”doc”] [3 ] Selects the th ird emplo yee chil[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 73 2 Click A pply. 3 Cli ck th e Properties t ool beside th e XP ath box. The selector property s heet appears. 4 Defi ne the s elector properties in th e different pag es of th e property sheet . 5 Click OK. Defining an identity constraint field The Fields page of an identity cons traint le[...]

Defining identity constr aints 74 PowerDesigner Defining f i el d general properties The General pag e of a f ield property sheet display s the follow ing properti es: Property Description XP ath A n XP ath exp ression rel ative to each el ement selected b y the selector of the identity constraint. It ide ntifies a sing le elem ent (with a sim ple [...]

Chapter 2 Building an XML model XSM Us er 's G ui de 75 The field property sheet appears. 6 Defi ne the f ield properties in t he diff erent pages of t he property sheet. 7 Click OK.[...]

Defining groups 76 PowerDesigner Defining groups You can def ine grou ps of elem ents or attributes in an XML model. Defining a group of elements A grou p of elemen ts is a s et of elem ents arrang ed by a group parti cle (all, choice or sequ ence). You create a group of elements w hen you n eed to reuse a set of elem ents in severa l par ts of you[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 77 ♦ In the generated XSD file, th e group is first declared with th e <gro up> tag and then re use d thr o ugh a re fe rence (ref) set to descr ipti o nLines: ♦ In the generated DTD file, the group is expanded directly w ithin its parent elem ent: ♦ In the ge nerat ed XD R file,[...]

Defining groups 78 PowerDesigner ♦ Referencin g groups are created in a diagram within an elem ent, a compl ex ty pe or a global group. You mu st select a global group f o r their Reference property (See the follow ing table) Groups in DTD and XDR files In a mod el tar geted with DTD o r XD R l anguage, there a re no gl oba l or refe r encing gr [...]

Chapter 2 Building an XML model XSM Us er 's G ui de 79 Once you ha ve de fined t he refe r ence o f a re ferenc ing gro up , you ca n loca te the re fere nc ed gr oup i n t he dia gram by right -c licking t he refe renci ng group sy mbol an d selecting Fin d Referenced Grou p in the contextual m enu. The referenced g roup appears w ith handle[...]

Defining groups 80 PowerDesigner 5 Type a n ame an d a code for the group. 6 Click OK. 7 Select a group particle tool in the palette (Sequence, Choice or All). 8 Click the g r oup sym bo l in the diagram . The group parti cle sy mbol appears at tached to th e group sym bol. 9 Select the Elem ent tool in the palette. 10 Click th e group particle sym[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 81 How to link a child object to a group of elements? XML objects do n o t support standard l ink objects. To link a ch ild object to a group, you m ust click the child object too l in the palette and then click the group sym bo l in the diagram . T his will au to matically create a link bet[...]

Defining groups 82 PowerDesigner Pointer indications When y o u cann ot click a sy mbol or an empty space in a diagram, th e Pointer displays a forbidden sign (See complex ty p e in Tool column). When there is a possibility to create a sym bo l ab o ve, below or nex t to another on e, the Pointer displays an arrow indicatin g the correspon ding dir[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 83 ♦ Generated XSD file: In a sch ema, a g roup of attribu tes is declared w ith th e <attributeGroup> tag. It can contain th e followin g tags: <attribute>, <attributeGroup> or <anyA ttrib ute>. ♦ Generated DTD file: Att ribute g roups are n ot support ed by X DR[...]

Defining groups 84 PowerDesigner The General pag e of an at tribute g roup property sheet display s the foll owi ng properties: Property Description Nam e Nam e of the attribute group. It must be a no-c olon-nam e (See Glos sary ). Required w hen the attribute group is global Code Code of the attribute group. It must be a no-c olon-nam e. Required [...]

Chapter 2 Building an XML model XSM Us er 's G ui de 85 Tool Tooltip Description Add A ttribute Group w ith Refe rence to A ttribute Group f rom a Sele ction Adds one or several a ttribute groups w ith a ref erence to a ttribute groups defined in the curre nt mode l. Select one or sev eral attribute g roups in the Se lection dialog box Any A t[...]

Defining groups 86 PowerDesigner 3 Type a nam e and a code for the attribu te group. 4 Click OK. 5 Select the A ttributes page. 6 Select different tools to add items to the attribute group. 7 Click A pply. 8 Doubl e-click on the left of a row to display an item property sheet. 9 Type a nam e and a code for the item . 10 Repeat s teps 8 and 9 f or e[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 87 Managing external shortc uts through references and data types External sh ortcuts allow y ou to share objects betw een diff erent m odels. You can defin e external sh ortcuts in an XML m odel, but you cann o t use th em directly in the m odel, except as substitution groups for elements ([...]

Managing external shortcuts through references and data types 88 PowerDesigner Example o f short c uts thro ugh a refe r ence a nd a d ata type :[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 89 Defining simple types You can only define simple ty pes in a model targeted with XSD. What is a simple ty pe? A sim p le type is a data ty pe definition for elements or attributes w ith text- only content. A sim ple type cannot contain elemen ts or attributes. A sim p le type is defined b[...]

Defining simple types 90 PowerDesigner Defining simple ty pe properties To d isp lay a simple ty pe pro p erty sh eet, double-click its nam e or its icon in the Brow ser tree view . The General pag e of a sim ple type property sheet displa ys the fol low ing properties: Property Description Nam e Nam e of the sim ple type. I t must be a no-c olon-n[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 91 The sim p le type property sheet appears. 3 Type a nam e and a code for the sim ple type. 4 Click OK. The simple ty pe sym bol appears in the diagram . Caution If the simpl e type symbol does not appear i n the diagram, se lect Show Symbols i n the Symbol menu, then cli ck the Simple Type[...]

Defining complex types 92 PowerDesigner Defining complex types You can only define complex ty pes in a model targeted with XSD. What is a complex ty pe? A com plex type is a data type definition used to define attributes and child elemen ts of a parent elemen t. It is a template for a data type defin itio n that can be reus ed and derived by extens[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 93 Caution Global complex ty pes appear in the model as objects, w ith their corres ponding symbol in the diagr am. Local complex types only appear in the schem a (see Previ ew page of an element property sheet) . Defining complex ty pe properties To display a comple x ty pe property sheet ,[...]

Defining complex types 94 PowerDesigner Complex ty pe detail propert i es The Detail page of a complex type property sheet display s the follow ing properties: Property Description Final Proper ty to pr eve nt deriva tion of the c u rrent comple x ty pe Block Property to prevent another comple x type w ith the specifi ed ty pe of derivatio n from b[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 95 Tool Tooltip Description Add A ttribute Group w ith Refe rence to A ttribute Group f rom a Sele ction Adds one or several a ttribute groups w ith a ref erence to a ttribute groups defined in the curre nt mode l. Select one or sev eral attribute g roups in the Se lection dialog box Any A t[...]

Defining complex types 96 PowerDesigner Icon Tool Description Create from Sources To copy abstract data type att r i butes o r cl ass attributes to the c u rrent complex ty pe attributes Ge nerate Ma pping To autom atically gener ate a m apping betw een abstract d at a type attribu tes or class att r i butes and com p lex type a ttributes w ith sam[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 97  To create a complex type from the palette: 1 Select the Com plex Type tool in the palette. 2 Click an empty space in the diagram . A complex type sy mbol appears in the diagram at th e click position. 3 Click the Pointer tool in the palette. or Right-click to recover the Po inter. 4 D[...]

Defining complex types 98 PowerDesigner 10 Click th e group particle sym bol in the diagram for each child elem ent you w ant to create. The child elemen t sym bols appear attached to the g roup particle sy mbol. 11 Double-click a child elem ent sym bo l to display its property sheet. 12 Type a na me an d a code for the child elem ent. 13 Repeat st[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 99 Tool Action Result If y ou click a com plex type sy mbol w ith the Group tool, a ref erencing g roup is created. Yo u can modify the group partic le via its property sheet. Y ou mus t now s elect a group f or the reference If y ou click a com plex type sym bol with the Com plex Ty pe tool[...]

Defining complex types 100 PowerDesigner Defining simple content properties A sim ple content allow s you to extend or restrict th e values of a complex ty pe supportin g character data or a sim ple type. It cannot contain elements . The General page of a s im ple content property sheet allows y ou to define an id for the simple content. The id val[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 101 Defining complex content properties A com plex content allow s you to extend or restrict the v alues of a complex type w ith mix ed content (character data and elem ents) or elements only . The General page of a com plex content property sheet displays th e follow ing properties: Propert[...]

Defining derivations 102 PowerDesigner Defining deriv ations You use d eriva tions when you want to exte nd or restr i ct the val ues of simple and com p lex ty pes. An XML model allows you to derive: ♦ Simple ty pes by restriction, list or union ♦ Complex ty pes by extension or restriction Derivation in element property sheet When y o u define[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 103 Gener ated sc hema: The General page of an extension property sheet displays the follow ing properties: Property Description ID ID of the e xtension. Its v alue m ust be of ty pe ID and unique within the m odel containing the extension Base Ty pe Data type on whic h the ex tension is ba [...]

Defining derivations 104 PowerDesigner 4 Type an ID an d select a base ty pe. 5 Click OK. Deriving by restriction You derive a simple ty p e or a complex ty pe by restriction w hen y o u w ant to restrict the valu es of their base ty pe. Restriction on a simple ty pe The p roper ty sheet of a simple type restrictio n displays severa l specific page[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 105 The General pag e of a sim ple type res triction property s heet display s the following properties: Property Description ID ID of the simple ty pe restriction. Its value m ust be of ty pe ID and unique w ithin the model conta ining the sim ple ty pe restriction Base type Data ty pe on w[...]

Defining derivations 106 PowerDesigner Icon Facet Description Fraction dig its Maxim um numbe r of decim al digits in the fra ctional par t Whitespace Way o f handli ng white spaces. If the value is Preserve , white spaces are u nchanged . If the value is Replace , tabs, lin e feeds an d carriage returns are rep laced with spaces. If the value is C[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 107 For exam ple: the m eetings s imple ty pe, based on the xs:g MonthDay data ty pe, is rest ricted to th e follow ing date s: 01/20, 03/20, 05/ 20 and 07/20. Gener ated sc hema: The Patter ns page o f a simple type restriction prope r ty sheet allows y ou to enter the exact s equence of ac[...]

Defining derivations 108 PowerDesigner For exam ple: the zipCode si mple type, bas ed on the xs:s tring data ty pe, is restricted to the following pattern: tw o uppe r case letter s, from A to Z, follow ed by a five- digit number, each digit ranging f rom 0 to 9. Gener ated sc hema: Creating a restriction on a simpl e ty pe You derive a simple ty p[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 109 2 Select Restri ction in the dropdown listbox of t he Deriv ation box . 3 Click Apply. 4 Click the Prop erties tool besid e the Derivation box. The restriction property sheet appears. 5 T ype an ID and a base ty pe for the simple ty pe restriction.[...]

Defining derivations 110 PowerDesigner If y ou select Em bedded ty pe, the base t ype dis appears and a sim p le type is created in the schem a with in the current sim ple type. Click Apply, and then the Properties tool beside the Em bedded type box, to def ine a derivati on and a base t ype f or the embedded sim ple type. 6 Click the Detail tab to[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 111 10 Type an ID and select the Fix ed box, if needed. 11 Click OK. Enumeration and Pattern facets For Enum eration and Pattern facets, click th eir corresponding tabs in th e restriction property sheet and double- click the arrow left of an enum er atio n or a pattern value to display its [...]

Defining derivations 112 PowerDesigner The Content box is set to Co mplex. 2 Click Apply. 3 Click the Prop erties tool besid e the Derivation box. The restriction property sheet appears. 4 T ype an ID and a base ty pe for the complex ty pe restriction. 5 Click OK. Deriving by list You derive a simple ty pe by list w hen y o u w ant to de fine it as[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 113  To define a simple type derivation by list: 1 Select Lis t in th e Derivation dropdow n listbox of a simpl e ty pe property sheet. 2 Click Apply. 3 Click the Prop erties tool besid e the Derivation box. The simple type list property sheet appears. 4 Enter an ID and a type for the sim[...]

Defining derivations 114 PowerDesigner The General pag e of a si mple t ype u nion property sheet di splay s the following properties: Property Description ID ID of the sim ple type union. Its value m ust be of ty pe ID and unique w ithin the m odel containing the simple ty pe union Member Ty p es White space separated list of built-in data types. [...]

Chapter 2 Building an XML model XSM Us er 's G ui de 115 Defining annotations You d efine a nno tati o ns when you want to ad d infor mation a b out a n XML model . Annotations are m ade o f Documentation and A pplication Information: ♦ Documen tation allows y ou to write a URI reference or any w ell-formed XML content that w ill give extra [...]

Defining annotations 116 PowerDesigner This global annotation is composed of a documentation, w ith a well- formed XML conten t (extract of a DTD file), and an application inf ormation. Ann otations are only available in m odels tar geted with XSD. Defining annotation properties To d isp lay an annotation property sheet, double-click its nam e or i[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 117 You can dis p lay a docum entation property sheet: ♦ By double-clickin g its nam e o r icon in the Browser tree vi ew ♦ By double-clickin g left of its row in the Items page of an an notation property sheet Documentati on gener al pr oper t i es The General pag e of a docum entation [...]

Defining annotations 118 PowerDesigner A pplication inform a t i on cont ent The Content page of an application information property sheet allow s you to w rite or paste any well-form ed XML content. Creating an annotation You can create a gl obal annotation f r om the Item s page or the Ex ternal Schem as page of a m odel property s heet.  To c[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 119 6 T ype an ID for the ann otation. 7 Click OK.[...]

Defining notations 120 PowerDesigner Defining notations Notations allow y o u to d e fine and process non-XML objects within an XML model . For exam ple: picture files w ith a .GIF extension. Gener ated sc hema: Notations are not available on models targeted w ith XDR. Defining notation properties To d isp lay a n otation prop er ty sh eet, d ouble[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 121 Creating a notation You can create a notation : ♦ From th e B row ser tree view ♦ From the Li st of Notations in the Model menu  To create a notation from the Brow ser tree view: 1 Right-click the n ame or the icon of the m odel to display the contex tual menu. 2 Select New → No[...]

Defining entities 122 PowerDesigner Defining entities Entities enable y ou to include predefined values, external XML o r non-XML files in an XML model targeted with a DTD. When an XML processor reads an entity reference in an XML document, it will replace th is entity ref erence by its value defined in th e DTD file of the XML docum ent. An en tit[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 123 Property Description Value Value of the entity. A string of cha racter s in the case of a predef ined value. A URI in the ca se of an XML or a non-XML file. For e xam ple: http://som ething.c om/pic tures/logo.gif Public URI re fer ence ide ntify ing the non-XML obje ct. For exam ple: pi[...]

Defining entities 124 PowerDesigner 4 T ype a valu e. 5 Click OK.[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 125 Defining import, in clude and redefine Import, Include and Redefine allow you to enrich y our XML m odel with external n ames paces, schem a files or schem a components. Import, In clude and Redef ine are only av ailable in a m odel targeted w ith XSD. Defining an import An im port ident[...]

Defining import, include and redefine 126 PowerDesigner Property Description Comm ent Descriptive labe l of the import Stereot ype Sub- classification used to extend t h e semantics of an ob ject without c hanging its structure. It ca n be predefine d or user- def ined Creating an i m por t You can create an im port: ♦ From th e B row ser tree vi[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 127 Defining an include An in clude allow s you to in clude a specified schema f ile in the target nam espace of the cu rrent schem a. With an inclu de, you can u se schema com ponents from any schem a with the sam e target nam espace as the current schem a or with n o specified targ et nam [...]

Defining import, include and redefine 128 PowerDesigner Creating an include You can create an in clude: ♦ From th e B row ser tree view ♦ From th e List of Includes in the Model m enu  To create an include from the Brow ser tree view: 1 Right-click the n ame or the icon of the m odel to display the contex tual menu. 2 Select New → Inclu de[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 129 With a redefine, y ou can use sch ema compon ents from any sch ema w ith the sam e target nam espace as the current schem a or with n o specified targ et nam espace. In a schem a, a redefine is declared w ith the <redefine> tag . For exam ple: Defining r edef i ne properties To dis[...]

Defining import, include and redefine 130 PowerDesigner The Item s page of a redefine property s heet display s a list of item s to be redefin ed. Tool Tooltip Description Group Adds a group of elem ents to be re defined Attribute Group Adds a group of attributes to be re defined Simple Ty pe Adds a sim ple type to be redef ined Comple x T ype A dd[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 131 3 Define redefi ne properties in th e diff erent pages . 4 Click OK.[...]

Defining business rules 132 PowerDesigner Defining business rules You can def ine busi ness ru les in an XML model and attach th em to objects. What is a business rule? A business rule is a w ritten statement specify ing w hat an XML model mu st contain or how it mus t be structured to s upport bus iness needs. A business r ul e is a rule that your[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 133 You can de fine several types o f business rules in an XML model: Ty pe Description Example Constrai nt Additional chec k constr aint on a va lue T he start date should be infer ior to the end da te of a project Definition P roperties of a n elem ent in the XML m odel A customer is a per[...]

Defining business rules 134 PowerDesigner  To create a business rule from the List of Business Rules: 1 Select Model → Business Rule s to displa y the List of Busine ss Rule s. 2 Click the Add a Row tool. or Click a blank line in th e list. A rule appears w ith generic nam e, cod e and rule type (Definition, by default). 3 T y pe a nam e and a[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 135 6 In the General page, select a busin ess rule ty pe in the Type dropdow n listbox. 7 Click OK. A pplying a business rule to an XML object Once you have d efined a b usiness rule in the List o f Business Rules, you ca n apply this business rule to an XML object.[...]

Defining business rules 136 PowerDesigner  To apply a business rule to an XML object: 1 Double-click an object in the m odel to display the object property sheet. 2 Click the Rules tab to disp lay th e Rules page. 3 Click the Add Rules tool to d isplay the list of business rules. The Selection w indow appears. It contains a list of all the busin[...]

Chapter 2 Building an XML model XSM Us er 's G ui de 137 4 Select the busines s rules y ou wan t to add to the object. 5 Click OK. The busines s rules are added to th e obj ect and appear in th e list of business rule s fo r the ob jec t . 6 Click OK. U Column in the Li st of business rules When y o u apply a busin ess rule to an object, the U[...]

Defining business rules 138 PowerDesigner[...]

XSM Us er 's G ui de 139 CHAPTER 3 Working w ith an XML model This chapter describes h o w you can w ork with an XML m odel and how y ou can gen erate an XML m odel from a PDM or an OOM. When building an XML m odel, you can check the validity of y our model at any time, w ith the Check Model feature. You can also map XML obj ects to PDM or OOM[...]

Checking an XML model 140 PowerDesigner Checking an XML model The XML Model is a very flexible tool. It should allow you to build y our model w ithout any controls or constraint s on data exch ange an d consisten cy of the system. Howev er, you can use th e Check Model feature at any time to control the consisten cy an d correctness of the model y [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 141 These m essag es represent tw o different lev els of problem severity . You can modif y the level of problem s everity for each object param eter verified by the Check m o d el. This severity level can depend on the degree of normalization you want to ac hieve in your model. A utoma[...]

Checking an XML model 142 PowerDesigner Checking an XML model You can check the validity of an XML m odel at any time.  To check an XML model: 1 Select T ools → Check Model. or Righ t-click th e diagram backgroun d and select C heck Model from the contextual m enu. The Check Model Parame ters dialog box opens to the Opt ions pag e. 2 Expand an[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 143 7 Click an object tab at the bo ttom of th e Selection page. The corresponding object page displays all the objects in the cu rrent XML m odel. 8 Select check boxes on ly f o r obj ects y ou w ant to be checked. 9 Clear check boxes f or obj ects that y ou do not wan t to be checked.[...]

Checking an XML model 144 PowerDesigner The Check Model Resu lt List dis plays errors and warn ings based on the check o ptio ns you have d efined . Dockable result w indow When you rig ht-click an object p arameter in the Resu lt List, a contextu al men u appears listin g corr ection options. Am ong these, y o u can also select option s to clear, [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 145 Making corrections based on XM L model check results You use th e Check Model feature to locate and correct problem s in an XML model . Using the Ch eck toolbar generally located in the upper part of the PowerDesig ner m ain window , you ha ve access to th e follow ing correction op[...]

Checking an XML model 146 PowerDesigner Making manual correcti ons t o an XML model Some errors cannot be corrected auto m atically, they have to be corrected manually.  To make manual corrections to an XML model: 1 Select an object parameter from the Result Lis t. 2 Right-click the object parameter an d select Correct from the contextual men u [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 147 XML Model objects v erified by Check Model The Check Model verifies the validity of XML m odel ob j ects. When errors are en countered du ring a check m odel, corrections can be m ade man ually or autom atically. Manual corrections depend on how y ou are using you r model. Some chec[...]

XML Model objects verified by Check Model 148 PowerDesigner Model check This check only applies to models built on a schem a. During a m odel check, the f ollowin g object controls are made. Identifi er uniqueness Two or more objects cannot have the same identif ier (ID). Manual correction Automatic correction Give a uniq u e ident ifier to each o [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 149 Missing namespaces There should be at least on e namespace defi ned for the m odel. Manual correction Automatic correction Ty pe a URI and a pref ix in the Namespaces page of the model p roperty sheet Adds the target n amespace URI and a pref ix “ns ” follow ed by a num ber (e.g[...]

XML Model objects verified by Check Model 150 PowerDesigner Data source name and code uni queness There cannot be tw o data sources with iden tical names and/or codes in a model . Manual correction Automatic correction Renam e one of the data sources Rena me s the data source by appending a num ber to its na me or code Existence of m odel A data so[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 151 Embedded fil e nam e uni queness A m o del cannot contain tw o embedded files w ith identical nam es. Manual correction Automatic correction Renam e one of the em bedded f iles Rena me s the f ile by appending a numbe r to its nam e Existe nce of e xterna l file locatio n An extern [...]

XML Model objects verified by Check Model 152 PowerDesigner Include check During an include check, the follow ing object control is m ade. Undefined schema location You must de fine a sche ma locat ion for an incl ud e. Manual correction Automatic correction Define a URI or select a sch ema f ile for the schema locat ion. F or example: profor ma .x[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 153 Existence of at t r i but e A complex type should have at least one attribute. Manual correction Automatic correction Define an attribute f or the com plex ty pe — Existe nce of p article A com plex type m ust cont ain elem ents, grou ps, grou p particles an d/or Any . Manual corr[...]

XML Model objects verified by Check Model 154 PowerDesigner Undefined ref er ence An elem ent with out a defin ed data type m ust have a ref erence. Manual correction Automatic correction In the el ement p roperty sheet, d efine a ref erence w ith the Refe rence dropdown listbox or the Brow se tool — Existence of at t r i but e An elem ent withou[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 155 Group check During a group check , the followin g object controls are m ade. Group name and code uni queness A m odel cannot contai n tw o groups w ith identical nam es and/or codes. Manual correction Automatic correction Renam e one of the groups Renam es the g roup by appending a [...]

XML Model objects verified by Check Model 156 PowerDesigner A ttribute check During an attribute check, the follow ing object controls are m ade. A ttribute name and code uniqueness The parent of an attribute cannot contain tw o attr ib utes w ith identical names and/or codes. Manual correction Automatic correction Renam e one of the attributes Re [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 157 Notation nam e and code uni queness A m o del cannot contain tw o notations w ith identical names and/or codes. Manual correction Automatic correction Renam e one of the notations Rename s the nota tion by a ppending a numbe r to its nam e or code Undefined notat i on A notation m u[...]

XML Model objects verified by Check Model 158 PowerDesigner Existence of at t r i but es An attribu te group m ust contain at leas t one attribute. Manual correction Automatic correction Add a ttributes to attribute group or delete attribute g roup Delete s unassi gned attribute group Import check During an import check, the f o llowing object cont[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 159 Existence of com ponent A redefine m ust contain at least one of the followin g items : simple ty pe, compl ex ty pe, group or attribu te group. Manual correction Automatic correction Add ite ms to the redefine — Key check During a k ey check, the f ollowing object controls are ma[...]

XML Model objects verified by Check Model 160 PowerDesigner  For more in form ation on XPath expres sions , see section Def ining an identity cons traint selector in chapter Building an XML m od e l. Key Ref check During a k eyRef check , the followin g object controls are m ade. Key Ref nam e and code uni queness An elem ent cannot contain tw o[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 161 Undefined select or You m ust define an XPath ex pression for a key Ref selector attribute. Manual correction Automatic correction In the ke yRef property sheet, def ine an XP ath expressi on for th e sel ector attrib u te. Fo r exampl e: s:company/s:employee —  For more in for[...]

XML Model objects verified by Check Model 162 PowerDesigner Undefined Select or You m ust define an XPath expressi on for a un ique constraint selector attribute. Manual correction Automatic correction In the unique c onstraint pr operty sheet, def ine an XPat h expre ssion for the unique constr aint sele ctor attribute . For example: s:compan y/s:[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 163 Replication check During a replication check, the follow ing object control is made. Partial o bject rep lication A replica object is p a r tially synch ronized with its replicated object. Manual correction Automatic correction Modify the list of replicate d attributes from the repl[...]

XML Model objects verified by Check Model 164 PowerDesigner Undefined base ty pe You m ust define a bas e type w hen y ou derive a sim ple or a complex type by restriction . Manual correction Automatic correction In the sim ple or complex type propert y sheet, clic k the Properties tool beside the Derivation box to display the Exte nsion property s[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 165 Simple ty pe union check During a s imple type un ion check, the follow ing object control is m ade. Undefined base ty pe You m ust define at least tw o data types w hen y ou derive a sim ple type by union. Manual correction Automatic correction In the sim ple type property sheet, c[...]

Mapping objects in an XML model 166 PowerDesigner Mapping objects in an XML model Object mapping is the ability to establish a correspondence between objects belo nging to he tero geneous mod els and diagr ams. The following table sh ows all the allow ed mappings between XML Mo del objects and PDM or OO M objects: XML Model objects PDM objects OOM [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 167 Data source propert i es i n an XM L model To display a dat a source property sheet, double- click its n am e or its icon in the Brow ser tree view . The General pag e of a data sou r ce property sheet di splay s the follow ing properties: Property Description Nam e The na me of the[...]

Mapping objects in an XML model 168 PowerDesigner 5 Click the Proper ties to ol to display the data source prop erty sheet. 6 In the General page, select a model type i n the Model Type dropdow n listbox. 7 In the Models pag e, click the A dd Models tool. A m odel selection dialog box appears. Select th e model(s) f o r the current data source. 8 C[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 169 Mapping XML M odel objects to PDM objects You can m ap elements or com plex types an d their correspondin g attributes to PDM objects. The following table sh ows all the allow ed mappings between XML Mo del objects and PDM objects : XML Model object PDM object Element Table, view, c[...]

Mapping objects in an XML model 170 PowerDesigner In the Mapping page, you can u se the follow ing tools to select a data sou rce for the curren t elemen t: Tool Description Adds a mappin g between th e cu rrent element an d an exist ing dat a source. Th e first t ime y ou d efin e a mapping for an element, the Mapping f or dropdown listbox is em p[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 171 You ha ve to use t he Map p ing pa ge of a co mplex type p rop erty shee t to de fine compl ex ty pe mappin gs.  For more in formation on how to select a data s ource, see section Mapping elem ents. The Complex Type Sources pag e allows you to associate one or sev eral abstract d[...]

Mapping objects in an XML model 172 PowerDesigner  For more in formation on how to select a data s ource, see section Mapping elem ents. The Element Sou r ces page allows y ou to associate one or several class es in the data source to the cu rrent elem ent. You can u se the A dd Objects tool to select c lasses from the OOMs o p ened in the curre[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 173 2 Select the Mappin g tab to dis play the Mappin g page. 3 Click the Add a Mappin g for a Data Source tool to select a data s ource for th e mappi ng. or Select a data s o urce in the Mappin g For dropdow n listbox if y ou have already s elected one or several data s ources. Caution[...]

Mapping objects in an XML model 174 PowerDesigner 8 Select the Attributes Mapping tab in the Mapping page. 9 Click the Add Mapping tool to disp lay an attribute selection box. Create From Sources and Generate Mapping tools Click the C reate From Sou rces tool to automatically create attr ib utes from the colum ns selected in the data source. Click [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 175 Modifying the mapping of an attribute You can m odify the def ault mapping creat ed for an attribute. The A ttribute Mappings property sheet can be used to fine tu ne the m apping bet ween an attribute in the cu rrent element and colu m ns or attrib utes in data source tab les or cl[...]

Manipulating XML objects graphically 176 PowerDesigner Manipulating XML objects graphically The graphical interf ace of Po werDesigner allow s you to man ipulate XML objects with in or between th e Browser tree v iew and the diag ram wi ndow . A global object is right under the m o del item in th e B rowser tree view . It has no parent s ym bol in [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 177 Global objects You can m ove global objects with in or betw een the Browser tree v iew and the diag ram w indow . Mov e Select Tools → General Options to make sure that Move is the Def ault action of the Drag & Drop option. You can m ove a global obj ect within the Brow ser to[...]

Manipulating XML objects graphically 178 PowerDesigner If the n ew g lobal obj ect does not appear in th e diagram, select Sy mbol → Show Sy mbols and click the corres ponding tab t o select th e object sy mbol . Job is a child elem ent of the C ustomer elem ent. Nicknam e is the attribute of the Nam e element. Job became Job2, a g lobal element.[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 179 Comparing and merging XML models You c a n compa re and merge two XM L model s with the same XML la nguage. The comparison process allow s you to highlight the d iffere nces b etween two XML m odels. The merg e process allow s you to form a single m odel that combines des ign effort[...]

Generating an XML model from a Physic al Data Model 180 PowerDesigner Generating an XML model from a Phy sical Data Model This section explains how to generate an XML model from a Phy sical Data Model. Generating XML M odel objects When y o u generate an XML m odel from a PDM, PowerDes igner translates PDM objects into specified XML Model objects a[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 181 Select Sym bo l → Show Sym bols to reveal th e other generat ed XML Model objects (sim ple types an d complex ty pes). XML model naming conventions If th e code of th e generat ed XML Model objects does not corres pond to the ta r get la ngua ge naming conve ntions, you can de fin[...]

Generating an XML model from a Physic al Data Model 182 PowerDesigner You can generate a PDM into an existin g XML m od e l. If y o u choos e to update an exis ting XML model w hen the curren t P DM has never been generated, th e Select m odel dropdown listbox is em pty by default. You have to click the Ellipsis button to display the Select a m od [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 183 Option Description Save gener a t ion depende ncies W hen selected, PowerDe signer k eeps track of the identity of each generated object . It is useful when merging two XM L mode ls whic h have been g enera ted fr om the sam e P DM. Objects can be compared an d recogni zed as the sa[...]

Generating an XML model from a Physic al Data Model 184 PowerDesigner Generating a new XM L model from a PDM You can g enerate an XML model f r om a PDM or from a pack age in a PDM. PowerDesig ner creates a new XML model con taining all the objects that y o u selected to generate in the XML model. The new ly created XML m odel appears in t he brow [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 185 5 Click the Detail tab to define options and generation parameters. 6 Click the Target Mod els tab to select the target models of shortcuts in the current m odel. 7 Click the Selection tab to disp lay the Selection page. 8 Select the na me of a PDM from th e Select Location dropdow [...]

Generating an XML model from a Physic al Data Model 186 PowerDesigner You can only generate an XML model f rom th e active PDM diagram w indow .  To update an existing XM L model by generating from a PDM : 1 Select T ools → Generate XML Model to d isplay the XML Mo d el Generati on Option s dialog box. If y o u do not have an XML model open ed[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 187 4 Click the Detail tab to define options and generation parameters. 5 Click the Target Mod els tab to select the target models of shortcuts in the current m odel. 6 Click the Selection tab to disp lay the Selection page. 7 Select the na me of a PDM from th e Select Location dropdow [...]

Generating an XML model from an Object- Oriented Model 188 PowerDesigner Generating an XML mode l from an Object- Oriented Model This section explain s how to gen erate an XML m odel from an Object- Oriented Model. Generating XML M odel objects When y o u generate an XML m odel from an OOM, Pow erDesigner translates OOM objects into specified XML M[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 189 XML model naming conventions If th e code of th e generat ed XML m odel objects does not correspon d to the ta r get la ngua ge naming conve ntions, you can de fine a c o de na ming convent ion scr i pt to c onvert o bj ect names into cod es. For mor e informatio n on co nversio n s[...]

Generating an XML model from an Object- Oriented Model 190 PowerDesigner You can generate an OOM in to an existin g XML m o d e l. If y o u choos e to update an exis ting XML model w hen the curren t OOM has never been generated, th e Select m odel dropdown listbox is em pty by default. You have to click the Ellipsis button to display the Select a [...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 191 Option Description Save gener a t ion depende ncies W hen selected, PowerDe signer k eeps track of the identity of each generated object . It is useful when merging two XM L mode ls whic h have been g enera ted fr om the sam e OOM. Objects can be compared an d recogni zed as the sam[...]

Generating an XML model from an Object- Oriented Model 192 PowerDesigner Generating a new XM L model from an OOM You can g enerate an XML model f rom an OOM or from a package in an OOM. PowerDesig ner creates a new XML model con taining all the objects that y ou selected to generate in the XML model. The new ly created XML model appears in t he bro[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 193 5 Click the Detail tab to define options and generation parameters. 6 Click the Target Mod els tab to select the target models of shortcuts in the current m odel. 7 Click the Selection tab to disp lay the Selection page. 8 Select the nam e of an OOM f rom the Select Location dropdow[...]

Generating an XML model from an Object- Oriented Model 194 PowerDesigner You can only generate an XML model f rom th e active OOM diagram w indow .  To update an existing XM L mode l by generating from an OOM: 1 Select T ools → Generate XML Model to d isplay the XML Mo d el Generati on Option s dialog box. If y o u do not h ave an XML model in[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 195 4 Click the Detail tab to define options and generation parameters. 5 Click the Target Mod els tab to select the target models of shortcuts in the current m odel. 6 Click the Selection tab to disp lay the Selection page. 7 Select the nam e of an OOM f rom the Select Location dropdow[...]

Editing an XML model report 196 PowerDesigner Editing an XML model report You can edit a report of y our XML m odel. The Report Ed ito r allows y ou to use a predefined repo r t template or to b uild you r own report.  For more information on reports, see the Reports User’s Guide . What is a report? A report is an easy to consult docum ent tha[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 197 The List of Reports appear s. I t displays the alph abetical list of all repor ts saved in the m o del. If there are no existing reports, all the tools in the List of Reports dialog box are gray ed, except for th e New Report tool. 2 Select the New Report tool. The New Report dialog[...]

Editing an XML model report 198 PowerDesigner Language in a template When you use a templ a te cr eate d in a la nguage d i fferent fr om the o n e you select to create y o ur report, only user-def ined items su ch as T itle or T ext par agraph will keep the la nguage of the template. Other items will be displayed in the r epor t la ngua ge. 6 Clic[...]

Chapter 3 W orking with an XML model XSM Us er 's G ui de 199 In the f ollowin g structu r e, the graphical representation of the diagram w ill appear in th e report just bef ore the descript ive paragraph s. To have a preview of y our re p o rt, click the Print Preview tool in th e Rep ort Editor window .[...]

Editing an XML model report 200 PowerDesigner[...]

XSM Us er 's G ui de 201 CHAPTER 4 Generating and reverse engineering an XSD, a DTD or an XDR file This chapter describes h o w to generate an d reverse en gineer an XML Schem a Definition file (.XSD), a Docum ent Type Definition file (.DTD) or an XML- Data Reduced file (.XDR). The same pro cedur es ap ply to al l XML la ngua ges. Topic Page G[...]

Generating an XSD, a DTD or an XDR file 202 PowerDesigner Generating an XSD, a DTD or an XDR file PowerDesign er allows y ou to generate an XSD, a DTD or an XDR file from an XML m odel. File preview You can hav e a preview of an XSD, a DTD or an XDR file by clicking the Preview tab of an XML model property sheet. Why generate an XSD file? You c a n[...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 203 Defining generation parameters You c a n define vario us par ameters b efor e gener ating a n X SD, a D TD o r an XDR file. Check model You can check your model bef o re generation if you select the C heck m odel check b ox. T his c he ck bo x i[...]

Generating an XSD, a DTD or an XDR file 204 PowerDesigner Defining gener at ion options If you do not see the Options page in th e Generation dialog box, it means th at no op tio n ha s bee n d efine d in the c orr espo nding XM L language (.XS L file) . You c a n however c ust omize your X ML language at any time, a nd ad d any opt ions you may ne[...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 205 How to generate an XSD, a DTD or an XDR file? The type of ge ne rate d file d epe nds on which XM L language the mode l has been targeted w ith: Model targeted with Generated file XML Sche ma Def inition 1.0 XSD Docum ent Type Def inition 1.0 DT[...]

Generating an XSD, a DTD or an XDR file 206 PowerDesigner 2 T ype a destination directory for the gen e r a ted file in th e Directory box. or Click the Sel ect a Path bu tton besi de the Direct ory box and browse t o select a directory path. In the case of an XDR file, the Generation dialog box display s an Opti o ns page where the gener atio n o [...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 207 A Result box appears indicating that the XSD, DTD or XDR file has been generated in the destination directory. The result is also disp layed in the Generation page of the Output wi ndow, located in the bottom part of th e main w indow. 5 Click E[...]

Reverse engineer ing an XSD, a DTD or an XDR file 208 PowerDesigner Rev erse engineering an XSD, a DTD or an XDR file PowerDesigner allow s you to reverse engineer an XML Schema Definition file, a Docum ent T ype Def inition file or an XML -Data Reduced file to create or update an XML m odel. What is reverse engineering? Reverse en gineering is th [...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 209 Reverse engi neer i ng opt i ons The O ptio ns page o f the Rever se Engine ering d i alog b ox disp lays the following options: Option Description Show sy mbols If s electe d, the generate d model appea rs in the diagra m (not only in the Brow [...]

Reverse engineer ing an XSD, a DTD or an XDR file 210 PowerDesigner The New XML Model dialog box appears. 2 In the G enera l page , sele ct an XM L language in the XM L language dropdow n li stbox. 3 Select the Share or Copy radio button. 4 <op tional> In the Exten d ed Model Definitions page, y o u can select one or several extended model de[...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 211 6 In the Options page, click the Select a File tool beside the File name box to select the XSD, DTD or XDR file you w ant to reverse engineer. Select or clear options (See Reverse engi neering o ptio ns). 7 In the Target Models pag e, select the[...]

Reverse engineer ing an XSD, a DTD or an XDR file 212 PowerDesigner 9 Click OK. The XML diagram corresponding to the rev erse engineered XSD, DTD or XDR file appears in the diagram w indow. The Brow ser tree view reveals the new XML model with all its objects. The result is also displayed in the Reverse page of th e Output w indo w, located in the [...]

Chapter 4 Generating and rev erse engineering an XSD, a DTD or an XDR file XSM Us er 's G ui de 213 The Merge Models dial og box appears , w ith th e newly generated XML model in the lef t pane, and the existing XML m odel in the right pane. You can select or clear object check boxes in th e right pane for objects that y ou wan t to include or[...]

Reverse engineer ing an XSD, a DTD or an XDR file 214 PowerDesigner[...]

XSM Us er 's G ui de 215 CHAPTER 5 Exchanging data w ith databases supporting XML This chapter describ e s how to use an XML m ode l to store or retrieve da ta in databases supporti ng X ML. Topic Page Why use XML in data bases? 216 Ge nerating an annotat ed sche ma for Mic rosof t SQL Se rver 2000 217 Ge nerating an annotated sche ma for Orac[...]

Why use XML in databases? 216 PowerDesigner Why use XML in databases? XML is becom ing a univ ersal data exchange f ormat. A n XML f ile can be read with an y plain tex t editor. Mo st o f relatio nal d atab ases (RDB) now support XML so that y ou can st ore or retrieve data thro ugh XML file s. With an XML m odel, you can generate an a nnotate d s[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 217 Generating an annotated schema for Microsoft SQL Serv er 2000 Microsoft SQL S erver 2000 is an XML-enable d database se rver. It su pports annotations that can be used on XSD or XDR files, to map XML data to relational data. An a nno tated schema is an XML-coded [...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 218 PowerDesigner  To generate an annotated schema by mapping through the XML Builder Wizard: 1 I n the P D M menu bar , select T oo ls → XML Builder Wizard. The Model Selecti on dialog box appears. 2 Select the new model option. Type a n ame and a code f or the new model, and sele[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 219 The Tables and Views Selection dial og box appears w ith the PD M tables list. All tables are selected by default. 4 <o p tional> Click the Deselect All tool an d select the tables y ou want to generate into XML elem ents. 5 Click N e xt.[...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 220 PowerDesigner The XML Hierarchy Design dialog box appears. 6 Click the Elem ent radio button, if you wan t to create columns as elemen ts. or Click the Attribu te radio button, if y ou wan t to create colum ns as attributes.[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 221 7 Drag and drop tables from left to righ t panel, an d build an XML hierarchy .  For more in form ation on buildin g an XML hierarchy , see section Generating an XML model via th e XML Builder Wizard, in chapter Generating f rom a PDM, in the PDM User’s Guid[...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 222 PowerDesigner In the case of an existing XML m odel, the generated elem ents appear next to the ex isting elem ents. Extended model definitions The SQL/XML extended model definition is automatically attached to the generated XML m odel. You can attach th e XM L Document extended m o[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 223 11 In th e XM L in Database page, select Microsoft SQL Serv er. Note: In the General Purpos e page, y ou can select the XML Docum ent extended model definition to generate a sim p lified XML file that w ill help you und ersta nd the anno tate d schema. 12 Click O[...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 224 PowerDesigner The Generati on dialog box appears w ith Micros oft SQL Serv er selected in the Targets page. 15 Click the Select a Path bu tton, beside the Direct ory box , to select a path for the annotated schem a file. 16 Click OK. The Result dialog box appear s w ith the path of [...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 225 The annotated sche ma appears in the editor w indow. Note the SQL nam espace (with th e sql prefix) and th e SQL annotations for tables (sql:relation), co lum ns (sql:field) and reference (sql:relationship). 18 Cli ck Close in the Res ult dialog box . Reinforcing[...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 226 PowerDesigner  To generate an annotated schema by reinforcing mapping w ith extended attributes: 1 Do uble-click an elemen t sym b o l in the diagram to d isplay its property sheet. 2 In the Extended Attributes page, ty pe the nam e of a database colum n in the Value colum n of t[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 227 Annotation E A Description key-fields 9 — Allow s specifica tion of colum ns that uniquely identify the rows in a ta ble limit-f ield 99 Allow s limiting the v alu es that ar e returned on the basis of a lim iting value limit-v alue 99 Allows limiting the valu [...]

Generating an annotated sc hema for Microsoft SQL Serv er 2000 228 PowerDesigner 5 Sele c t Language → Generate XML Schem a Definition File. or Selec t Language → Generate XML-Data Reduced File. The Generati on dialog box appears w ith Micros oft SQL Serv er selected in the Targets page. 6 Click the Select a Path butt on, beside th e Directory [...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 229 8 Click Edit. The annotated sche ma appears in the editor w indow. Note the SQL nam espace (with th e sql prefix) and th e SQL annotations for tables (sql:relation), co lum ns (sql:field) and reference (sql:relationship). 9 Click Close in the Result dialog box.[...]

Generating an annotated sc hema for Oracle 9i2 230 PowerDesigner Generating an annotated schema for Oracle 9i2 Oracle 9i2 is a database serv er with a native XML storage an d retrieval technology called Oracle XML DB. There is no mapping betw een XML data and relational data. T ables, column s and abstract data types (ADT) are created from a nno ta[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 231 The Extended Model Definition Selection dialog box appears. 3 In the XML in Database pag e, select Oracle XML DB 9.2. 4 Click OK. Oracle XML DB 9.2 appear s in the List of Extended Model Definitions. 5 Click OK. The extended model definition appears in the Browse[...]

Generating an annotated sc hema for Oracle 9i2 232 PowerDesigner 7 In the Extended Attributes page, ty pe the nam e of a table or a column in the Value colum n of the SQLName annotati o n, if you want to c reat e a table or a colum n from the s elected elemen t. You c a n defi ne a value for the follo wing annotat ions: Annotation Description beanC[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 233 Annotation Description javaClassname Used to sp ecify the name of a Java class that is deri ved from the corresponding bean class, to e nsure that an object o f this class is i n stantiat ed duri ng bean access. If a JavaClassname is not specified, Oracle X ML DB[...]

Generating an annotated sc hema for Oracle 9i2 234 PowerDesigner 11 In the Exten ded Attributes page, type the n ame of an abstract data type (ADT) in the Value colum n of the SQLType anno tatio n, if you want to create an ADT from the selected complex type. You c a n defi ne a value for the follo wing annotat ions: Annotation Description beanClass[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 235 15 In th e Extended Attribu tes page, you can select a value (f alse or true) for the followi ng annotations: Annotation Description ma pUnboundedStringToL ob If true, unbounded s trings are ma pped to CLOB by de fault. Simila rly , unbounded binary data get m ap[...]

Generating an annotated sc hema for Oracle 9i2 236 PowerDesigner The Resu lt dialog box appears w ith the pat h of th e generated sch em a file. 20 Click Edit. The annotated sche ma appears in the editor w indow. Note the Oracle nam espace (with the s ql prefix) and an notations for tables (sql:SQLName) and A DTs (sql:SQLT ype) 21 Cli ck Close in t[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 237 Generating a DA D file for IBM DB2 IBM DB2 v8.1 (or hig her) is a database se rver w ith an add-i n for XML storage and retrieval called IBM DB2 Extender. XML data (elem ents, attr i b utes) a re mapp ed to rela t i onal d ata (t able s, columns) thr o ugh Doc um[...]

Generating a DAD file for IBM DB2 238 PowerDesigner The Model Selecti on dialog box appears. 2 Select the new model option. Type a nam e and a code for the new model , and select Docum ent Type Def inition 1.0 in t he XML la nguage dropdow n li stbox. or Select the existing model option. Select a model in the XML Model dropdow n lis tbox. This mode[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 239 The Tables and Views Selection dial og box appears w ith the PD M tables list. All tables are selected by default. 4 <Op tio nal> Click the Deselect All tool and select the tables you w ant to generate into XML elem ents. 5 Click N e xt.[...]

Generating a DAD file for IBM DB2 240 PowerDesigner The XML Hierarchy Design dialog box appears. 6 Click the Elem ent radio button, if you wan t to create columns as elemen ts. or Click the Attribu te radio button, if y ou wan t to create colum ns as attributes.[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 241 7 Drag and drop tables from left to righ t panel and buil d an XML hierarchy .  For more in form ation on buildin g an XML hierarchy , see section Generating an XML model via th e XML Builder Wizard, in chapter Generating f rom a PDM, in the PDM User’s Guide[...]

Generating a DAD file for IBM DB2 242 PowerDesigner In the case of an existing XML m odel, the generated elem ents appear next to the ex isting elem ents. Extended model definitions The SQL/XML extended model definition is automatically attached to the generated XML m odel. You can attach th e XM L Document extended m odel definition to generate a [...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 243 11 In the XML in Database page, select IBM DB2 DAD. Note: In the General Purpos e page, y ou can select the XML Docum ent extended model definition to generate a sim p lified XML file that w ill help you und ersta nd the anno tate d schema. 12 Click OK in the Ex [...]

Generating a DAD file for IBM DB2 244 PowerDesigner 15 In the Exten ded Attributes page, click the DB2XM LExtender tab and select a value f or the StorageType (Xcollection or Xcolum n). In the case of an Xcollection , select a value for the MappingTy pe (RDB or SQL). You can def ine a value f o r the followin g extended attribu tes: Extended attrib[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 245 Extended attribute Description Stor ageName If StorageType is X colu mn, t hen it i s the name of the s idetable colum n Storage Type T ype of st orage (Xcollection or Xcolum n) 16 Click OK. 17 Repeat st eps 14 to 16 for each g lobal elemen t you w ant to determi[...]

Generating a DAD file for IBM DB2 246 PowerDesigner 19 <optional> In the Options page, generation options are set by default. You can chan ge their value. Option Description Character end ing an inst ru ction Ch aract er en ding in st ru ctions i n the SQL f ile for store d procedure s Ge nerate s proce dures de ployme nt Ge neration of a SQL[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 247 The Resu lt dialog box appears w ith the pat hs of the gen erated DAD, DTD and SQL files. 22 Select the path of a DA D file and click Edit. The selected DAD file appears in the Editor win dow. ♦ Extract of a DAD f ile defined w ith Xcollectio n as StorageTy pe,[...]

Generating a DAD file for IBM DB2 248 PowerDesigner ♦ DAD file defin ed with Xcolumn as Storag eT ype: 23 Repeat st ep 22 to edit another DA D file. or Click Close in the Result dialog box.[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 249 Generating SQL/XML queries SQL/XM L i s an XML e xtensio n o f the Str ucture d Quer y Language. W ith SQL/XML, y ou retr ieve relatio nal data using extended SQL sy ntax, and pro duce a resul t using XML. SQL/XM L i s mad e of five main functio ns: ♦ XM LELEME[...]

Generating SQL/XML queries 250 PowerDesigner The List of Extended Model Definitions appears. 2 Click the Import an Extended Model Definition button. The Extended Model Definition Selection dialog box appears. 3 In the General Purpose page, select SQL /XML. 4 Click OK. SQL/XML appears in the L ist of Extended Model Definitions. 5 Click OK.[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 251 The SQL/XML extended m o del definition appears in the Browser tree view , attached to the model. 6 < o p tio nal > Double-click a gl obal elem ent in the diagram to display its property sheet. 7 In the Preview page, click the SQL /XML.Query tab to display [...]

Generating SQL/XML queries 252 PowerDesigner The Generation dialog box appears w ith SQL/XML selected in the Targ ets pag e. 10 Click the Select a Path bu tton beside the Direct ory box to select a path for t he SQ L/ XML q ueri es.[...]

Chapter 5 Exchanging data with databas es supporting XML XSM Us er 's G ui de 253 11 In the Selection page, select the global elem ents for which y ou want to generate a SQL /XML query . (Only one g lobal elemen t in the example) 12 Click OK. The Result dialog box appears w ith a path for each SQL/ XML query . (Only one in the exam ple) 13 Sel[...]

Generating SQL/XML queries 254 PowerDesigner 14 Repeat st ep 13 to edit another SQL /XML query. or Click Close in the Result dialog box. Once generated, SQL/XML queries are processed by SQL interpreters in databases supporti ng XML.[...]

XSM Us er 's G ui de 255 CHAPTER 6 Generating from an XML model This chapte r describes h ow t o generate an XML m odel from an XML m odel. Topic Page Ge neration ba sics 256 Ge nerating an XML mode l from a n XML m odel 259 About this chapter Contents[...]

Generation basic s 256 PowerDesigner Generation basics You can g enerate an XML m odel from an XML m odel. There are two options to generate an XML m odel from an XML m od el: Generation option Description Ge nerate new XML m odel It crea tes a copy of the source XML m odel, conve rting the s ource languag e (DTD, XSD or XDR) into the targe t langu[...]

Chapter 6 Generating from an XML model XSM Us er 's G ui de 257 The model generation process allows y ou to define the target object of a shortcut in a generated m odel. For exam ple, here is the proper sequence of events for extern al shortcuts gener ation: ♦ Model 1 is the target model of a shortcut in Model 2 ♦ Model 1 is g enerated t o[...]

Generation basic s 258 PowerDesigner You can also preserv e the link between an external replication and its targ et model t hrough ge ne rati o n.  For more information on th e generation of object rep licatio ns, see section Generating replications, in chapter Managin g Obj ect Replications, in the General Featur es Guide .[...]

Chapter 6 Generating from an XML model XSM Us er 's G ui de 259 Generating an XML mode l from an XML model This section explains how to generate an XML model from an XML m od el. Why generate an XM L model from an XML model? You can g enerate an XML model f rom an XML m odel when y ou need to keep tw o models s ynchron ized during th e design [...]

Generating an XML model from an XML model 260 PowerDesigner  For more information on model options wh en generating an XML model from an XML m o d el, see section Definin g model optio ns in chapter XML Model Bas ics. You can generate an XML model into an existing XML m odel. In th e Update Exis ting Model grou pbox, the Select Model dropdow n l[...]

Chapter 6 Generating from an XML model XSM Us er 's G ui de 261 Defining gener at ion options The Detail page of the XML Model Generation Options dialog box displays the followin g options: Option Description Check model W hen sele cted, verif ies the m odel before g enerating the XML mode l, and stops g eneration if a n error is found Save ge[...]

Generating an XML model from an XML model 262 PowerDesigner You can only generate an XML model from the active XML m odel d iagram.  To generate a new XM L model from an XM L model: 1 Select Tools → Generate XML Model to disp lay the XML Model Generati on Option s dialog box. 2 Select the Gen erate new XML Model radio but ton. 3 Se l ect a n X[...]

Chapter 6 Generating from an XML model XSM Us er 's G ui de 263 11 Select the ch eck boxes f or the objects you wan t to generate, and clear the check box es for the objects y ou do not wan t to generate. 12 Click OK. The Output w indow show s the progress of the generati on process. The diagram of the n ew XML m odel appears in the w ork area[...]

Generating an XML model from an XML model 264 PowerDesigner 3 Select a m odel from th e Select model dropdow n listbox , if the current model h as already been gen erated. or Click the Ellips is button , beside the Select m odel dropdown listbox , and select a m odel model available in the workspace in th e Select a model dialog box . Preserve modi[...]

Chapter 6 Generating from an XML model XSM Us er 's G ui de 265 9 Click OK. If y o u selected the Preserve modif ications check box, th e Merge Models w indow appears. If y o u cleared the Preserve modif ications check box, th e updated XML model diag ram appears in the w ork area. Merging models The Merge Models di alog box s how s the new ly[...]

Generating an XML model from an XML model 266 PowerDesigner[...]

XSM Us er 's G ui de 267 XML Model Glossary A grou p particle indicating th at child elements can appear in any order, each of th em on ce or not Additional inform ation about a model and its objects p roceeding from documentation an d/or app licatio ns Allow s you to attach any type of object to a choice or a sequence g roup particle Allow s [...]

XML Model Glossary 268 PowerDesigner Derivation of a complex ty pe to extend the values of its base type A constraint on th e set of values of a sim p le type An XPath ex pression th at specifies the value (or on e of the v alues) us ed to define an identity constraint (unique, key or keyRef) A gl obal object has a g lobal scope. It h as no parent [...]

XML Model Glossary XSM User’s G uide 269 A nam e beginnin g w ith a prefix and a colon (:). The prefix is associated w ith a nam espace URI. For exam ple: xs:schem a, xs being associated w ith ht t p: / /www. w3 . o r g/ 2001/XMLS chem a Relational database. A database or ganized in terms of relations between data Allow s you to redefine simple a[...]

XML Model Glossary 270 PowerDesigner Derivation of a simple ty pe to r estrict its values to a collection of built-in and simple data types An identity constraint used to specify that an elemen t or attribute value (or set of valu es) m ust be un ique or null w ithin a specified scope Uniform Resource Identifier. A string of characters which identi[...]

Index XSM Us er 's G ui de 271 A all 53 annotate d schem a for Mic rosof t SQL Se rver 2000 217 for O racle 9i2 230 annotation 115 application inf ormation 115 check 16 5 crea te annota tion 118 docum entation 115 global 115 local 115 any 58 namespace 58 proces s contents 58 any attribu te 61 namespace 61 proces s contents 61 application inf o[...]

272 Pow erDesigner C check model 140 annotation 165 attribute 156 attribute g roup 157 autom atic corr ection 140, 145 business rule (X SM) 149 com plex ty pe 152 correct error 145 data sour ce 149 display details 145 element 15 3 entity 151 error list 145 exte nded link 162 exte nded object 162 exte nsion 163 file 150 group 155 group par ticle 147[...]

XSM Us er 's G ui de 273 databas e ( continue d ) Orac le 9i2 230 SQL/XML queries 216, 249 XML in data base 216 defa ult 40, 50 deriv ation 102 exte nsion 102 restr iction 104 simple ty pe list 112 sim ple ty pe union 113 diagra m 32 displ ay preference any 61 comple x ty pe 96 element 52 group 82 sim ple type 90 docum entation 115 DTD 3 E ele[...]

274 Pow erDesigner facet ( continued ) whitespace 1 0 5 fie ld 64, 66, 67, 73 stereotype 73 XPath 73 file check 15 0 fina l 19, 40, 90, 94 fix ed 40, 50, 105 form 40, 50 fra ction digits 104 functiona l overview 2 G gene rate 256 basic s 256 check model 182 check model 261 check model para mete r 203 DTD file f rom XML m odel 202 enable tra nsforma[...]

XSM Us er 's G ui de 275 L length 104 level of problem se verity error 140 wa rning 140 link 8, 45, 57, 81, 98 child object to c omplex type 98 child object t o element 45 child object to g roup 81 child object to g roup particle 57 child object to pa rent object 8 local o bjects 17 6 M ma nipulate XML objects graphic ally 176 ma p object 166 [...]

276 Pow erDesigner redef ine 128 check 15 8 create redefine 13 0 schem a location 128 ref erenc e 37, 48, 67, 76, 82 replicat i o n check 1 63 report 196 crea te m odel report 196 underline hie rarchic al structure 198 restr iction 104 check 16 3 crea te res triction on com plex ty pe 111 crea te res triction on sim ple type 108 enum eration 104 fr[...]

XSM Us er 's G ui de 277 V value attribute (DT D, XDR) 50 element (XDR) 50 W wa rning 140 whitespace 1 0 4 workspace 28 X XDR 3 any 58 attribute ty pe 48 Attribute Ty pe 48 element type 37 ElementType 37 XML 3 diagra m 32 mode l 3 objects 5 XML lang uage 10, 259 change XML languag e 11 choose XML language 28 XPath 73 abbrev iated sy ntax 70 ex[...]

278 Pow erDesigner[...]