Manuals / Sybase / Power Tools / Impact Driver

Sybase XML manual Generating an annotated schema for Microsoft SQL Server, 217

Models: XML

1 290

Download 290 pages 48.58 Kb

Page 229

Chapter 5 Exchanging data with databases supporting XML

Generating an annotated schema for Microsoft SQL Server 2000

Microsoft SQL Server 2000 is an XML-enabled database server. It supports annotations that can be used on XSD or XDR files, to map XML data to relational data.

An annotated schema is an XML-coded file, targeted with an XML language and tagged with specific DBMS annotations, that allows you to store or retrieve data in an XML format, from relational databases supporting XML. An XML model allows you to generate an annotated schema (XSD or XDR) for SQL Server 2000. You need first to map an XML model to a PDM, then to attach the Microsoft SQL Server extended model definition to the mapped XML model. If need be, you can complete the mapping by defining extended attributes to XML objects.

Mapping XML objects to PDM objects

There are several ways to map XML objects to PDM objects:

♦Using the XML Builder Wizard (See following procedure)

♦Generating an XML model from a PDM

♦Generating a PDM from an XML model

♦Manually

The best way to map an XML model to a PDM is to use the XML Builder

Wizard.

If you do not have a PDM, you can reverse engineer a database into a PDM.

For more information on reverse engineering a database into a PDM, see chapter Reverse engineering in a PDM, in the PDM User’s Guide.

Caution

The following procedure assumes you have a PDM open in the workspace and targeted with Microsoft SQL Server 2000 as DBMS.

If the PDM is not targeted with the proper DBMS, select Database→Change Current DBMS.

XSM User's Guide

217

Image 229

Sybase manual Generating an annotated schema for Microsoft SQL Server, Mapping XML objects to PDM objects, 217

Contents

11.1 Sybase PowerDesignerLast Revised June Contents 100 Managing external shortcuts through references and data101 102Working with an XML model 139 How to reverse engineer an XSD, a DTD or an XDR Why reverse engineer an XSD, a DTD or an XDR169 Mapping XML Model objects to OOM objects 171Vii Exchanging data with databases supporting XML 215Viii Audience SubjectDocumentation primer Physical Data Model User’s Guide Conceptual Data Model User’s Guide To work with the CDMObject Oriented Model Getting Started Business Process Model User’s GuideTypographic conventions Bibliography BeforeInsertTrigger templateXii XML Model Basics ContentsFunctional overview Demo models What is an XML model?About XML Objects in an XML model XSD Tool Object DescriptionObjects in a diagram Tool Sequence symbol Choice symbol All symbol Tool Element symbol Group symbol Complex type symbolAll Choosing the XML language of an XML model Defining the XML model environmentNot certified resource file ™ To change the XML language of an XML model Changing the XML language of an XML modelLanguage Description Changes concerning simple and complex types Option Description Selecting extended model definitions at model creationDefining model options ™ To define XML model options XML model extended dependenciesDefining the XML model environment Defining model properties Defining an XML model™ To define the properties of an XML model Property Description Model GeneralModel Detail Button Moves item Model ItemsTool Tooltip Description 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 optionDefining an XML model List of templates Detaching an XML model from the workspace Opening an existing XML model™ To open an existing XML model ™ To detach an XML model from a workspaceSaving an XML Saving and closing an XML modelModel Closing an XML modelDefining an XML model Building an XML model Defining an XML diagram XML diagram basicsWhy build an XML diagram? Group Symbols feature Creating an XML diagramExpand/Expand All/Collapse/Arrange Symbols features Defining elements Defining element properties Global and local elements in XDR files Element general propertiesDefining elements Property or XDR filesElement detail properties Building an XML model Element attributes propertiesElement mapping properties Element constraints propertiesElement Sources Attributes Mapping Creating an element™ To create an element from the palette Defining elements Tool Action Result How to link a child object to an element?Pointer indications Defining the attributes of an elementBuilding an XML model Global and local attributes in XDR files Attribute general propertiesDefining attributes Attribute values Attribute detail propertiesElement values with XDR Adding an attribute to an element™ To add an attribute to an element Linking child elements to a parent element Modifying element display preferencesPreference Description Group particles Defining group particlesGroup particle Value of the order attribute in XDR Items list Group particles properties™ To create a group particle from an element property sheet Creating a group particleFrom the palette Name and code uniquenessClicking 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 preferenceFor example Any Attribute general properties Defining a unique constraint Defining identity constraintsUnique fields properties Unique general propertiesDefining a key constraint Key general properties Defining a keyRef constraintKey fields properties Defining identity constraints KeyRef general properties Creating an identity constraintKeyRef fields properties Defining an identity constraint selector Syntax Description XPath abbreviated syntax™ To display a selector property sheet Defining selector general propertiesDefining an identity constraint field ™ To create an identity constraint field Defining field general propertiesBuilding an XML model Defining a group of elements Defining groupsDefining group properties Groups in DTD and XDR files ™ To create a group of elements from the palette Creating a group of elementsDefining groups How to link a child object to a group of elements? Defining a group of attributes Modifying the group display preferenceAttribute group general properties Defining attribute group propertiesAttributes Attribute groupProperties ™ To create an attribute group from the Browser tree view Creating an attribute groupDefining groups Data types ReferencesExample of shortcuts through a reference and a data type Defining simple types What is a simple type?Type of derivation Description Modifying the simple type display preference Defining simple type propertiesCreating a simple type ™ To create a simple type from the Browser tree viewBuilding an XML model Defining complex types What is a complex type?Complex type general properties Defining complex type propertiesComplex type attributes properties Complex type detail propertiesComplex Type Complex type mapping propertiesSources Icon Tool DescriptionCreating 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 Simple content Defining simple content properties™ To create a simple content General propertyComplex content Defining complex content properties™ To create a complex content General propertiesDeriving by extension Defining derivationsDerivation in element property sheet 102™ To define a derivation by extension Defining extension103 Restriction on a simple type Deriving by restriction104 Restriction general Defining restriction facetsRestriction detail 105Restriction Facet generalEnumerations 106107 Restriction patterns™ To create a restriction on a simple type Creating a restriction on a simple type108 109 110 Enumeration and Pattern facets Restriction on a complex type™ To create a restriction on a complex type 111112 Deriving by list™ To define a simple type derivation by list Deriving by union113 Union types Union general™ To define a simple type derivation by union 114115 Defining annotationsDefining documentation properties Defining annotation propertiesAnnotation general property Annotation items propertiesDefining application information properties Documentation contentDocumentation general properties Application information general propertiesCreating an annotation Application information content118 119 Defining notation properties Defining notations120 ™ To create a notation from the Browser tree view Creating a notation121 Defining entity properties Defining entities122 Entity name Reference Value™ To create an entity from the Browser tree view Creating an entity123 124 Defining an import Defining import, include and redefineDefining import properties Import general™ To create an import from the Browser tree view Creating an import126 Defining include properties Defining an includeInclude general 127Creating an include Defining a redefine™ To create an include from the Browser tree view 128Redefine general Defining redefine properties129 Redefine items Creating a redefine™ To create a redefine from the Browser tree view 130131 Defining business rules What is a business rule?Defining business rule properties Business rule general propertiesBusiness rule expression property Creating a business rule133 Type Description Example134 ™ To create a business rule from the List of Business Rules135 Applying a business rule to an XML object136 ™ To apply a business rule to an XML object137 Column in the List of business rules138 139 Working with an XML modelChecking an XML model Levels of problem severityXML model check options 140XML model object selection in the Check Model Selecting objects in the diagramAutomatic correction 141™ To check an XML model Checking an XML model142 143 Selecting all or clearing all check boxesDisplaying previously applied check options in an XML model ™ To display errors and warnings selected in the last checkDockable result window 144Display the Check toolbar Making corrections based on XML model check resultsContextual menu 145Making automatic corrections to an XML model Making manual corrections to an XML model™ To make manual corrections to an XML model ™ To make automatic corrections to an XML modelGroup particle check XML Model objects verified by Check ModelExistence of particle Invalid cardinalityIdentifier uniqueness Model checkUndefined identifier Shortcut code uniquenessData source check Business rule check in an XSMMissing namespaces Business rule name and code uniquenessData source name and code uniqueness File checkExistence of model 150Embedded file name uniqueness Entity checkExistence of external file location Entity name and code uniquenessSimple type check Include checkComplex type check Existence of attribute Element checkElement name and code uniqueness Undefined type154 Undefined referenceGroup name and code uniqueness Group check155 Notation check Attribute checkAttribute name and code uniqueness 156Notation name and code uniqueness Attribute group checkUndefined notation Attribute group name and code uniquenessImport check Undefined schema location and namespaceRedefine check Existence of attributesExistence of component Key checkKey name and code uniqueness Existence of fieldsKeyRef name and code uniqueness KeyRef check160 Unique name and code uniqueness Unique check161 Extended link check Extended object checkExtended object name and code uniqueness Extended link name and code uniquenessExtension check Replication checkRestriction check Partial object replicationExistence of facet Simple type list check164 Annotation check Simple type union checkExistence of items 165Understanding object mapping Mapping objects in an XML modelDefining data sources in an XML model 166Creating a data source in an XML model Data source properties in an XML model™ To create a data source in an XML model 167168 Mapping elements Mapping XML Model objects to PDM objects169 XML Model object PDM object170 Mapping complex typesTool Description 171 Mapping XML Model objects to OOM objectsXML Model object OOM object ™ To create a mapping for an element Creating a mapping for an XML object172 173 174 Create From Sources and Generate Mapping tools™ To modify the mapping of an attribute Modifying the mapping of an attribute175 Local objects Manipulating XML objects graphicallyMove 176Example converting a local object into a global object Global objects™ To convert a local object into a global object Drag and drop178 After conversions179 Comparing and merging XML modelsGenerating XML Model objects Generating an XML model from a Physical Data Model180 PDM object Generated object in an XML modelXML model naming conventions Generating and updating an XML modelGenerate new XML 181Defining XML model generation options Update existingXML model Clearing the Preserve modifications check box183 Check model before generation™ To generate a new XML model from a PDM Generating a new XML model from a PDM184 Generating an XML model from a package Updating an existing XML model185 Preserve modifications ResultPreserve modifications ™ To update an existing XML model by generating from a PDM186 187 Merging models188 Generating an XML model from an Object- Oriented ModelOOM Object Generated object in an XML model 189 190 191 ™ To generate a new XML model from an OOM Generating a new XML model from an OOM192 193 194 ™ To update an existing XML model by generating from an OOM195 Editing an XML model report What is a report?Creating an XML model report ™ To create a model report197 Language in a template Inserting diagram198 199 200 201 Why generate a DTD file? Why generate an XSD file?Why generate an XDR file? Generating an XSD, a DTD or an XDR fileCheck model Defining generation parametersDefining generation targets 203Defining generation options Using the Move up or down arrowsDefining generation tasks 204Parameter entities during DTD generation How to generate an XSD, a DTD or an XDR file?205 Model targeted with Generated file206 207 Why reverse engineer an XSD, a DTD or an XDR file? What is reverse engineering?How to reverse engineer an XSD, a DTD or an XDR file? Reverse engineering an XSD, a DTD or an XDR fileReverse engineering target models Reverse engineering optionsReverse engineering to a new XML model Convert Unique References210 211 212 Reverse engineering to an existing XML model213 Auto-layout214 215 Exchanging data with databases supporting XML216 Why use XML in databases?Mapping XML objects to PDM objects Generating an annotated schema for Microsoft SQL Server217 218 219 220 221 222 Extended model definitions223 Annotated schema preview224 225 Reinforcing mapping with extended attributesAnnotation Description 226227 228 229 ™ To generate an annotated schema for Oracle Generating an annotated schema for Oracle230 231 232 233 234 235 236 ™ To generate a DAD file for IBM DB2 Generating a DAD file for IBM DB2237 Type of storage Type of mapping Description238 Generating a DAD file for IBM DB2239 240 241 242 243 DAD file previewExtended attribute Description 244245 246 247 248 ™ To generate SQL/XML queries Generating SQL/XML queries249 250 Generating SQL/XML queries251 252 253 254 255 Generating from an XML modelTarget models parameters Generation basics256 Generation option Description257 Generating from an XML model258 Generating an XML model from an XML model Why generate an XML model from an XML model?259 260 Generating an XML model from an XML model261 Generating a new XML model from an XML model262 ™ To generate a new XML model from an XML model263 Updating an existing XML model264 265 266 267 268 XSM User’s Guide 269 Unique UnionXML language XPath271 Index272 PowerDesigner273 IBM DB2 274275 276 XML 277278