Exchanging data with databases supporting XML, 215

C H A P T E R 5

Exchanging data with databases supporting XML

About this chapter This chapter describes how to use an XML model to store or retrieve data in databases supporting XML.

Topic	Page
Why use XML in databases?	216
Generating an annotated schema for Microsoft SQL Server 2000	217
Generating an annotated schema for Oracle 9i2	230
Generating a DAD file for IBM DB2	237
Generating SQL/XML queries	249

XSM User's Guide

215

Page 227

Image 227

Sybase manual Exchanging data with databases supporting XML, 215

Contents

11.1 Sybase PowerDesigner Last Revised June Contents 102 Managing external shortcuts through references and data100 101 Working with an XML model 139 Mapping XML Model objects to OOM objects 171 Why reverse engineer an XSD, a DTD or an XDRHow to reverse engineer an XSD, a DTD or an XDR 169 Vii Exchanging data with databases supporting XML 215 Viii Documentation primer SubjectAudience Business Process Model User’s Guide Conceptual Data Model User’s Guide To work with the CDMPhysical Data Model User’s Guide Object Oriented Model Getting Started Typographic conventions Bibliography BeforeInsertTrigger template Xii XML Model Basics Contents Functional overview Demo models What is an XML model? About XML Objects in an XML model XSD Tool Object Description Objects in a diagram Tool Sequence symbol Choice symbol All symbol Tool Element symbol Group symbol Complex type symbol All Not certified resource file Defining the XML model environmentChoosing the XML language of an XML model Language Description Changing the XML language of an XML model™ To change the XML language of an XML model Changes concerning simple and complex types Option Description Selecting extended model definitions at model creation Defining model options ™ To define XML model options XML model extended dependencies Defining the XML model environment ™ To define the properties of an XML model Defining an XML modelDefining model properties Property Description Model General Model Detail Tool Tooltip Description Model ItemsButton Moves item Model External Schemas Model Namespaces XML Model Basics Model Preview Creating an XML model ™ To create a new XML model using the New model option Creating an XML model using the New model option Defining an XML model List of templates ™ To detach an XML model from a workspace Opening an existing XML modelDetaching an XML model from the workspace ™ To open an existing XML model Closing an XML model Saving and closing an XML modelSaving an XML Model Defining an XML model Building an XML model Defining an XML diagram XML diagram basics Why build an XML diagram? Expand/Expand All/Collapse/Arrange Symbols features Creating an XML diagramGroup Symbols feature Defining elements Defining element properties Global and local elements in XDR files Element general properties Defining elements Property or XDR files Element detail properties Building an XML model Element attributes properties Element Sources Element constraints propertiesElement mapping properties ™ To create an element from the palette Creating an elementAttributes Mapping Defining elements Tool Action Result How to link a child object to an element? Pointer indications Defining the attributes of an element Building an XML model Global and local attributes in XDR files Attribute general properties Defining attributes Attribute values Attribute detail properties ™ To add an attribute to an element Adding an attribute to an elementElement values with XDR Preference Description Modifying element display preferencesLinking child elements to a parent element Group particle Value of the order attribute in XDR Defining group particlesGroup particles Items list Group particles properties ™ To create a group particle from an element property sheet Creating a group particle From the palette Name and code uniqueness Clicking an element symbol with the Element tool How to link a child object to a group particle? Defining Any properties Any general properties ™ To create an Any Defining Any Attribute properties Modifying the Any display preference For example Any Attribute general properties Defining a unique constraint Defining identity constraints Unique fields properties Unique general properties Defining a key constraint Key fields properties Defining a keyRef constraintKey general properties Defining identity constraints KeyRef fields properties Creating an identity constraintKeyRef general properties Defining an identity constraint selector Syntax Description XPath abbreviated syntax ™ To display a selector property sheet Defining selector general properties Defining an identity constraint field ™ To create an identity constraint field Defining field general properties Building an XML model Defining a group of elements Defining groups Defining group properties Groups in DTD and XDR files ™ To create a group of elements from the palette Creating a group of elements Defining groups How to link a child object to a group of elements? Defining a group of attributes Modifying the group display preference Attribute group general properties Defining attribute group properties Properties Attribute groupAttributes ™ To create an attribute group from the Browser tree view Creating an attribute group Defining groups Data types References Example of shortcuts through a reference and a data type Type of derivation Description What is a simple type?Defining simple types ™ To create a simple type from the Browser tree view Defining simple type propertiesModifying the simple type display preference Creating a simple type Building an XML model Defining complex types What is a complex type? Complex type general properties Defining complex type properties Complex type attributes properties Complex type detail properties Icon Tool Description Complex type mapping propertiesComplex Type Sources Creating a complex type Modifying complex type display preferences ™ To create a complex type from the palette How to link a child object to a complex type? Pointer indications General property Defining simple content propertiesSimple content ™ To create a simple content General properties Defining complex content propertiesComplex content ™ To create a complex content 102 Defining derivationsDeriving by extension Derivation in element property sheet 103 Defining extension™ To define a derivation by extension 104 Deriving by restrictionRestriction on a simple type 105 Defining restriction facetsRestriction general Restriction detail 106 Facet generalRestriction Enumerations 107 Restriction patterns 108 Creating a restriction on a simple type™ To create a restriction on a simple type 109 110 111 Restriction on a complex typeEnumeration and Pattern facets ™ To create a restriction on a complex type 112 Deriving by list 113 Deriving by union™ To define a simple type derivation by list 114 Union generalUnion types ™ To define a simple type derivation by union 115 Defining annotations Annotation items properties Defining annotation propertiesDefining documentation properties Annotation general property Application information general properties Documentation contentDefining application information properties Documentation general properties 118 Application information contentCreating an annotation 119 120 Defining notationsDefining notation properties 121 Creating a notation™ To create a notation from the Browser tree view Entity name Reference Value Defining entitiesDefining entity properties 122 123 Creating an entity™ To create an entity from the Browser tree view 124 Import general Defining import, include and redefineDefining an import Defining import properties 126 Creating an import™ To create an import from the Browser tree view 127 Defining an includeDefining include properties Include general 128 Defining a redefineCreating an include ™ To create an include from the Browser tree view 129 Defining redefine propertiesRedefine general 130 Creating a redefineRedefine items ™ To create a redefine from the Browser tree view 131 Business rule general properties What is a business rule?Defining business rules Defining business rule properties Type Description Example Creating a business ruleBusiness rule expression property 133 134 ™ To create a business rule from the List of Business Rules 135 Applying a business rule to an XML object 136 ™ To apply a business rule to an XML object 137 Column in the List of business rules 138 139 Working with an XML model 140 Levels of problem severityChecking an XML model XML model check options 141 Selecting objects in the diagramXML model object selection in the Check Model Automatic correction 142 Checking an XML model™ To check an XML model 143 Selecting all or clearing all check boxes 144 ™ To display errors and warnings selected in the last checkDisplaying previously applied check options in an XML model Dockable result window 145 Making corrections based on XML model check resultsDisplay the Check toolbar Contextual menu ™ To make automatic corrections to an XML model Making manual corrections to an XML modelMaking automatic corrections to an XML model ™ To make manual corrections to an XML model Invalid cardinality XML Model objects verified by Check ModelGroup particle check Existence of particle Shortcut code uniqueness Model checkIdentifier uniqueness Undefined identifier Business rule name and code uniqueness Business rule check in an XSMData source check Missing namespaces 150 File checkData source name and code uniqueness Existence of model Entity name and code uniqueness Entity checkEmbedded file name uniqueness Existence of external file location Complex type check Include checkSimple type check Undefined type Element checkExistence of attribute Element name and code uniqueness 154 Undefined reference 155 Group checkGroup name and code uniqueness 156 Attribute checkNotation check Attribute name and code uniqueness Attribute group name and code uniqueness Attribute group checkNotation name and code uniqueness Undefined notation Existence of attributes Undefined schema location and namespaceImport check Redefine check Existence of fields Key checkExistence of component Key name and code uniqueness 160 KeyRef checkKeyRef name and code uniqueness 161 Unique checkUnique name and code uniqueness Extended link name and code uniqueness Extended object checkExtended link check Extended object name and code uniqueness Partial object replication Replication checkExtension check Restriction check 164 Simple type list checkExistence of facet 165 Simple type union checkAnnotation check Existence of items 166 Mapping objects in an XML modelUnderstanding object mapping Defining data sources in an XML model 167 Data source properties in an XML modelCreating a data source in an XML model ™ To create a data source in an XML model 168 XML Model object PDM object Mapping XML Model objects to PDM objectsMapping elements 169 Tool Description Mapping complex types170 XML Model object OOM object Mapping XML Model objects to OOM objects171 172 Creating a mapping for an XML object™ To create a mapping for an element 173 174 Create From Sources and Generate Mapping tools 175 Modifying the mapping of an attribute™ To modify the mapping of an attribute 176 Manipulating XML objects graphicallyLocal objects Move Drag and drop Global objectsExample converting a local object into a global object ™ To convert a local object into a global object 178 After conversions 179 Comparing and merging XML models PDM object Generated object in an XML model Generating an XML model from a Physical Data ModelGenerating XML Model objects 180 181 Generating and updating an XML modelXML model naming conventions Generate new XML Clearing the Preserve modifications check box Update existingDefining XML model generation options XML model 183 Check model before generation 184 Generating a new XML model from a PDM™ To generate a new XML model from a PDM Preserve modifications Result Updating an existing XML modelGenerating an XML model from a package 185 186 ™ To update an existing XML model by generating from a PDMPreserve modifications 187 Merging models OOM Object Generated object in an XML model Generating an XML model from an Object- Oriented Model188 189 190 191 192 Generating a new XML model from an OOM™ To generate a new XML model from an OOM 193 194 ™ To update an existing XML model by generating from an OOM 195 ™ To create a model report What is a report?Editing an XML model report Creating an XML model report 197 198 Inserting diagramLanguage in a template 199 200 201 Generating an XSD, a DTD or an XDR file Why generate an XSD file?Why generate a DTD file? Why generate an XDR file? 203 Defining generation parametersCheck model Defining generation targets 204 Using the Move up or down arrowsDefining generation options Defining generation tasks Model targeted with Generated file How to generate an XSD, a DTD or an XDR file?Parameter entities during DTD generation 205 206 207 Reverse engineering an XSD, a DTD or an XDR file What is reverse engineering?Why reverse engineer an XSD, a DTD or an XDR file? How to reverse engineer an XSD, a DTD or an XDR file? Convert Unique References Reverse engineering optionsReverse engineering target models Reverse engineering to a new XML model 210 211 212 Reverse engineering to an existing XML model 213 Auto-layout 214 215 Exchanging data with databases supporting XML 216 Why use XML in databases? 217 Generating an annotated schema for Microsoft SQL ServerMapping XML objects to PDM objects 218 219 220 221 222 Extended model definitions 223 Annotated schema preview 224 225 Reinforcing mapping with extended attributes Annotation Description 226 227 228 229 230 Generating an annotated schema for Oracle™ To generate an annotated schema for Oracle 231 232 233 234 235 236 Type of storage Type of mapping Description Generating a DAD file for IBM DB2™ To generate a DAD file for IBM DB2 237 238 Generating a DAD file for IBM DB2 239 240 241 242 243 DAD file preview Extended attribute Description 244 245 246 247 248 249 Generating SQL/XML queries™ To generate SQL/XML queries 250 Generating SQL/XML queries 251 252 253 254 255 Generating from an XML model Generation option Description Generation basicsTarget models parameters 256 257 Generating from an XML model 258 259 Why generate an XML model from an XML model?Generating an XML model from an XML model 260 Generating an XML model from an XML model 261 Generating a new XML model from an XML model 262 ™ To generate a new XML model from an XML model 263 Updating an existing XML model 264 265 266 267 268 XSM User’s Guide 269 XPath UnionUnique XML language 271 Index 272 PowerDesigner 273 IBM DB2 274 275 276 XML 277 278