Manuals / Sybase / Power Tools / Impact Driver

Sybase manual Why use XML in databases?, 216

Models: XML

1 290

Download 290 pages 48.58 Kb

Page 228

Why use XML in databases?

Why use XML in databases?

XML is becoming a universal data exchange format. An XML file can be read with any plain text editor. Most of relational databases (RDB) now support XML so that you can store or retrieve data through XML files.

With an XML model, you can generate an annotated schema that will allow you to store or retrieve data in a relational database supporting XML. To generate an annotated schema, you need to attach the appropriate extended model definition (XEM file) to an XML model mapped (or not) to a PDM.

The following table lists the databases supporting XML for which you can generate annotated schemas:

	Mapped XML	Targeted XML	Required XEM
Database	model	language	file

Microsoft SQL	Yes	XSD or XDR	Microsoft SQL
Server 2000			Server
Oracle 9i2	No	XSD	Oracle 9i2
IBM DB2 v8.1	Yes	DTD	IBM DB2 DAD

By attaching the SQL/XML extended model definition to an XML model mapped to a PDM, you can also generate SQL/XML queries to retrieve data in an XML format, from relational databases supporting SQL/XML.

The best way to generate SQL/XML queries is to use the XML Builder

Wizard which helps you build an XML model from a PDM. The generated

XML model is mapped to the PDM and automatically linked to the

SQL/XML extended model definition. (See Generating SQL/XML queries)

216	PowerDesigner

Image 228

Sybase manual Why use XML in databases?, 216

Contents

Sybase PowerDesigner 11.1Last Revised June Contents Managing external shortcuts through references and data 100101 102Working with an XML model 139 Why reverse engineer an XSD, a DTD or an XDR How to reverse engineer an XSD, a DTD or an XDR169 Mapping XML Model objects to OOM objects 171Exchanging data with databases supporting XML 215 ViiViii Subject AudienceDocumentation primer Conceptual Data Model User’s Guide To work with the CDM Physical Data Model User’s GuideObject Oriented Model Getting Started Business Process Model User’s GuideBeforeInsertTrigger template Typographic conventions BibliographyXii Contents XML Model BasicsFunctional overview What is an XML model? Demo modelsAbout XML Objects in an XML model Tool Object Description XSDObjects in a diagram Tool Element symbol Group symbol Complex type symbol Tool Sequence symbol Choice symbol All symbolAll Defining the XML model environment Choosing the XML language of an XML modelNot certified resource file Changing the XML language of an XML model ™ To change the XML language of an XML modelLanguage Description Changes concerning simple and complex types Selecting extended model definitions at model creation Option DescriptionDefining model options XML model extended dependencies ™ To define XML model optionsDefining the XML model environment Defining an XML model Defining model properties™ To define the properties of an XML model Model General Property DescriptionModel Detail Model Items Button Moves itemTool Tooltip Description Model External Schemas Model Namespaces XML Model Basics Creating an XML model Model PreviewCreating an XML model using the New model option ™ To create a new XML model using the New model optionDefining an XML model List of templates Opening an existing XML model Detaching an XML model from the workspace™ To open an existing XML model ™ To detach an XML model from a workspaceSaving and closing an XML model Saving an XMLModel Closing an XML modelDefining an XML model Building an XML model XML diagram basics Defining an XML diagramWhy build an XML diagram? Creating an XML diagram Group Symbols featureExpand/Expand All/Collapse/Arrange Symbols features Defining elements Defining element properties Element general properties Global and local elements in XDR filesDefining elements XDR files Property orElement detail properties Element attributes properties Building an XML modelElement constraints properties Element mapping propertiesElement Sources Creating an element Attributes Mapping™ To create an element from the palette Defining elements How to link a child object to an element? Tool Action ResultDefining the attributes of an element Pointer indicationsBuilding an XML model Attribute general properties Global and local attributes in XDR filesDefining attributes Attribute detail properties Attribute valuesAdding an attribute to an element Element values with XDR™ To add an attribute to an element Modifying element display preferences Linking child elements to a parent elementPreference Description Defining group particles Group particlesGroup particle Value of the order attribute in XDR Group particles properties Items listCreating a group particle ™ To create a group particle from an element property sheetName and code uniqueness From the paletteHow to link a child object to a group particle? Clicking an element symbol with the Element toolDefining Any properties Any general properties ™ To create an Any Modifying the Any display preference Defining Any Attribute propertiesFor example Any Attribute general properties Defining identity constraints Defining a unique constraintUnique general properties Unique fields propertiesDefining a key constraint Defining a keyRef constraint Key general propertiesKey fields properties Defining identity constraints Creating an identity constraint KeyRef general propertiesKeyRef fields properties Defining an identity constraint selector XPath abbreviated syntax Syntax DescriptionDefining selector general properties ™ To display a selector property sheetDefining an identity constraint field Defining field general properties ™ To create an identity constraint fieldBuilding an XML model Defining groups Defining a group of elementsDefining group properties Groups in DTD and XDR files Creating a group of elements ™ To create a group of elements from the paletteDefining groups How to link a child object to a group of elements? Modifying the group display preference Defining a group of attributesDefining attribute group properties Attribute group general propertiesAttribute group AttributesProperties Creating an attribute group ™ To create an attribute group from the Browser tree viewDefining groups References Data typesExample of shortcuts through a reference and a data type What is a simple type? Defining simple typesType of derivation Description Defining simple type properties Modifying the simple type display preferenceCreating a simple type ™ To create a simple type from the Browser tree viewBuilding an XML model What is a complex type? Defining complex typesDefining complex type properties Complex type general propertiesComplex type detail properties Complex type attributes propertiesComplex type mapping properties Complex TypeSources Icon Tool DescriptionModifying complex type display preferences Creating a complex type™ To create a complex type from the palette How to link a child object to a complex type? Pointer indications Defining simple content properties Simple content™ To create a simple content General propertyDefining complex content properties Complex content™ To create a complex content General propertiesDefining derivations Deriving by extensionDerivation in element property sheet 102Defining extension ™ To define a derivation by extension103 Deriving by restriction Restriction on a simple type104 Defining restriction facets Restriction generalRestriction detail 105Facet general RestrictionEnumerations 106Restriction patterns 107Creating a restriction on a simple type ™ To create a restriction on a simple type108 109 110 Restriction on a complex type Enumeration and Pattern facets™ To create a restriction on a complex type 111Deriving by list 112Deriving by union ™ To define a simple type derivation by list113 Union general Union types™ To define a simple type derivation by union 114Defining annotations 115Defining annotation properties Defining documentation propertiesAnnotation general property Annotation items propertiesDocumentation content Defining application information propertiesDocumentation general properties Application information general propertiesApplication information content Creating an annotation118 119 Defining notations Defining notation properties120 Creating a notation ™ To create a notation from the Browser tree view121 Defining entities Defining entity properties122 Entity name Reference ValueCreating an entity ™ To create an entity from the Browser tree view123 124 Defining import, include and redefine Defining an importDefining import properties Import generalCreating an import ™ To create an import from the Browser tree view126 Defining an include Defining include propertiesInclude general 127Defining a redefine Creating an include™ To create an include from the Browser tree view 128Defining redefine properties Redefine general129 Creating a redefine Redefine items™ To create a redefine from the Browser tree view 130131 What is a business rule? Defining business rulesDefining business rule properties Business rule general propertiesCreating a business rule Business rule expression property133 Type Description Example™ To create a business rule from the List of Business Rules 134Applying a business rule to an XML object 135™ To apply a business rule to an XML object 136Column in the List of business rules 137138 Working with an XML model 139Levels of problem severity Checking an XML modelXML model check options 140Selecting objects in the diagram XML model object selection in the Check ModelAutomatic correction 141Checking an XML model ™ To check an XML model142 Selecting all or clearing all check boxes 143™ To display errors and warnings selected in the last check Displaying previously applied check options in an XML modelDockable result window 144Making corrections based on XML model check results Display the Check toolbarContextual menu 145Making manual corrections to an XML model Making automatic corrections to an XML model™ To make manual corrections to an XML model ™ To make automatic corrections to an XML modelXML Model objects verified by Check Model Group particle checkExistence of particle Invalid cardinalityModel check Identifier uniquenessUndefined identifier Shortcut code uniquenessBusiness rule check in an XSM Data source checkMissing namespaces Business rule name and code uniquenessFile check Data source name and code uniquenessExistence of model 150Entity check Embedded file name uniquenessExistence of external file location Entity name and code uniquenessInclude check Simple type checkComplex type check Element check Existence of attributeElement name and code uniqueness Undefined typeUndefined reference 154Group check Group name and code uniqueness155 Attribute check Notation checkAttribute name and code uniqueness 156Attribute group check Notation name and code uniquenessUndefined notation Attribute group name and code uniquenessUndefined schema location and namespace Import checkRedefine check Existence of attributesKey check Existence of componentKey name and code uniqueness Existence of fieldsKeyRef check KeyRef name and code uniqueness160 Unique check Unique name and code uniqueness161 Extended object check Extended link checkExtended object name and code uniqueness Extended link name and code uniquenessReplication check Extension checkRestriction check Partial object replicationSimple type list check Existence of facet164 Simple type union check Annotation checkExistence of items 165Mapping objects in an XML model Understanding object mappingDefining data sources in an XML model 166Data source properties in an XML model Creating a data source in an XML model™ To create a data source in an XML model 167168 Mapping XML Model objects to PDM objects Mapping elements169 XML Model object PDM objectMapping complex types 170Tool Description Mapping XML Model objects to OOM objects 171XML Model object OOM object Creating a mapping for an XML object ™ To create a mapping for an element172 173 Create From Sources and Generate Mapping tools 174Modifying the mapping of an attribute ™ To modify the mapping of an attribute175 Manipulating XML objects graphically Local objectsMove 176Global objects Example converting a local object into a global object™ To convert a local object into a global object Drag and dropAfter conversions 178Comparing and merging XML models 179Generating an XML model from a Physical Data Model Generating XML Model objects180 PDM object Generated object in an XML modelGenerating and updating an XML model XML model naming conventionsGenerate new XML 181Update existing Defining XML model generation optionsXML model Clearing the Preserve modifications check boxCheck model before generation 183Generating a new XML model from a PDM ™ To generate a new XML model from a PDM184 Updating an existing XML model Generating an XML model from a package185 Preserve modifications Result™ To update an existing XML model by generating from a PDM Preserve modifications186 Merging models 187Generating an XML model from an Object- Oriented Model 188OOM Object Generated object in an XML model 189 190 191 Generating a new XML model from an OOM ™ To generate a new XML model from an OOM192 193 ™ To update an existing XML model by generating from an OOM 194195 What is a report? Editing an XML model reportCreating an XML model report ™ To create a model report197 Inserting diagram Language in a template198 199 200 201 Why generate an XSD file? Why generate a DTD file?Why generate an XDR file? Generating an XSD, a DTD or an XDR fileDefining generation parameters Check modelDefining generation targets 203Using the Move up or down arrows Defining generation optionsDefining generation tasks 204How to generate an XSD, a DTD or an XDR file? Parameter entities during DTD generation205 Model targeted with Generated file206 207 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? Reverse engineering an XSD, a DTD or an XDR fileReverse engineering options Reverse engineering target modelsReverse engineering to a new XML model Convert Unique References210 211 Reverse engineering to an existing XML model 212Auto-layout 213214 Exchanging data with databases supporting XML 215Why use XML in databases? 216Generating an annotated schema for Microsoft SQL Server Mapping XML objects to PDM objects217 218 219 220 221 Extended model definitions 222Annotated schema preview 223224 Reinforcing mapping with extended attributes 225226 Annotation Description227 228 229 Generating an annotated schema for Oracle ™ To generate an annotated schema for Oracle230 231 232 233 234 235 236 Generating a DAD file for IBM DB2 ™ To generate a DAD file for IBM DB2237 Type of storage Type of mapping DescriptionGenerating a DAD file for IBM DB2 238239 240 241 242 DAD file preview 243244 Extended attribute Description245 246 247 248 Generating SQL/XML queries ™ To generate SQL/XML queries249 Generating SQL/XML queries 250251 252 253 254 Generating from an XML model 255Generation basics Target models parameters256 Generation option DescriptionGenerating from an XML model 257258 Why generate an XML model from an XML model? Generating an XML model from an XML model259 Generating an XML model from an XML model 260Generating a new XML model from an XML model 261™ To generate a new XML model from an XML model 262Updating an existing XML model 263264 265 266 267 268 XSM User’s Guide 269 Union UniqueXML language XPathIndex 271PowerDesigner 272273 274 IBM DB2275 276 277 XML278