Manuals / Sybase / Power Tools / Impact Driver

Sybase XML manual Annotated schema preview, 223

Models: XML

1 290

Download 290 pages 48.58 Kb

Page 235

Image 235

Chapter 5 Exchanging data with databases supporting XML

11 In the XML in Database page, select Microsoft SQL Server.

Note: In the General Purpose page, you can select the XML Document extended model definition to generate a simplified XML file that will help you understand the annotated schema.

12Click OK.

Microsoft SQL Server appears in the List of Extended Model Definitions.

13Click OK.

The Microsoft SQL Server extended model definition appears in the Browser tree view, attached to the generated XML model.

Annotated schema preview

By clicking the Preview page of the model property sheet, you can have a preview of the annotated schema.

14Select Language→Generate XML Schema Definition File.

Select Language→Generate XML-Data Reduced File.

XSM User's Guide

223

Page 235

Image 235

Sybase XML manual Annotated schema preview, 223

Contents

11.1 Sybase PowerDesignerLast Revised June Contents 102 Managing external shortcuts through references and data100 101Working 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 169Vii Exchanging data with databases supporting XML 215Viii Audience SubjectDocumentation primer 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 StartedTypographic 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 ™ To detach an XML model from a workspace Opening an existing XML modelDetaching an XML model from the workspace ™ To open an existing XML modelClosing an XML model Saving and closing an XML modelSaving 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 ™ To create a simple type from the Browser tree view Defining simple type propertiesModifying the simple type display preference Creating a simple typeBuilding 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 propertiesIcon Tool Description Complex type mapping propertiesComplex Type SourcesCreating 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 contentGeneral properties Defining complex content propertiesComplex content ™ To create a complex content102 Defining derivationsDeriving by extension Derivation in element property sheet™ To define a derivation by extension Defining extension103 Restriction on a simple type Deriving by restriction104 105 Defining restriction facetsRestriction general Restriction detail106 Facet generalRestriction Enumerations107 Restriction patterns™ To create a restriction on a simple type Creating a restriction on a simple type108 109 110 111 Restriction on a complex typeEnumeration and Pattern facets ™ To create a restriction on a complex type112 Deriving by list™ To define a simple type derivation by list Deriving by union113 114 Union generalUnion types ™ To define a simple type derivation by union115 Defining annotationsAnnotation items properties Defining annotation propertiesDefining documentation properties Annotation general propertyApplication information general properties Documentation contentDefining application information properties Documentation 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 Entity name Reference Value Defining entitiesDefining entity properties 122™ To create an entity from the Browser tree view Creating an entity123 124 Import general Defining import, include and redefineDefining an import Defining import properties™ To create an import from the Browser tree view Creating an import126 127 Defining an includeDefining include properties Include general128 Defining a redefineCreating an include ™ To create an include from the Browser tree viewRedefine general Defining redefine properties129 130 Creating a redefineRedefine items ™ To create a redefine from the Browser tree view131 Business rule general properties What is a business rule?Defining business rules Defining business rule propertiesType Description Example Creating a business ruleBusiness rule expression property 133134 ™ 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 model140 Levels of problem severityChecking an XML model XML model check options141 Selecting objects in the diagramXML model object selection in the Check Model Automatic correction™ To check an XML model Checking an XML model142 143 Selecting all or clearing all check boxes144 ™ To display errors and warnings selected in the last checkDisplaying previously applied check options in an XML model Dockable result window145 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 modelInvalid cardinality XML Model objects verified by Check ModelGroup particle check Existence of particleShortcut code uniqueness Model checkIdentifier uniqueness Undefined identifierBusiness rule name and code uniqueness Business rule check in an XSMData source check Missing namespaces150 File checkData source name and code uniqueness Existence of modelEntity name and code uniqueness Entity checkEmbedded file name uniqueness Existence of external file locationSimple type check Include checkComplex type check Undefined type Element checkExistence of attribute Element name and code uniqueness154 Undefined referenceGroup name and code uniqueness Group check155 156 Attribute checkNotation check Attribute name and code uniquenessAttribute group name and code uniqueness Attribute group checkNotation name and code uniqueness Undefined notationExistence of attributes Undefined schema location and namespaceImport check Redefine checkExistence of fields Key checkExistence of component Key name and code uniquenessKeyRef name and code uniqueness KeyRef check160 Unique name and code uniqueness Unique check161 Extended link name and code uniqueness Extended object checkExtended link check Extended object name and code uniquenessPartial object replication Replication checkExtension check Restriction checkExistence of facet Simple type list check164 165 Simple type union checkAnnotation check Existence of items166 Mapping objects in an XML modelUnderstanding object mapping Defining data sources in an XML model167 Data source properties in an XML modelCreating a data source in an XML model ™ To create a data source in an XML model168 XML Model object PDM object Mapping XML Model objects to PDM objectsMapping elements 169170 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 176 Manipulating XML objects graphicallyLocal objects MoveDrag and drop Global objectsExample converting a local object into a global object ™ To convert a local object into a global object178 After conversions179 Comparing and merging XML modelsPDM object Generated object in an XML model Generating an XML model from a Physical Data ModelGenerating XML Model objects 180181 Generating and updating an XML modelXML model naming conventions Generate new XMLClearing the Preserve modifications check box Update existingDefining XML model generation options XML model183 Check model before generation™ To generate a new XML model from a PDM Generating a new XML model from a PDM184 Preserve modifications Result Updating an existing XML modelGenerating an XML model from a package 185Preserve 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 ™ To create a model report What is a report?Editing an XML model report Creating an XML model report197 Language in a template Inserting diagram198 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 targets204 Using the Move up or down arrowsDefining generation options Defining generation tasksModel targeted with Generated file How to generate an XSD, a DTD or an XDR file?Parameter entities during DTD generation 205206 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 model210 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 Type of storage Type of mapping Description Generating a DAD file for IBM DB2™ To generate a DAD file for IBM DB2 237238 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 modelGeneration option Description Generation basicsTarget models parameters 256257 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 XPath UnionUnique XML language271 Index272 PowerDesigner273 IBM DB2 274275 276 XML 277278