Sybase XML - page 238

Generating an annotated schema for Microsoft SQL Server 2000

226 PowerDesigner

To generate an annotated schema by reinforcing mapping with

extended attributes:

1 Double-click an element symbol in the diagram to display its property

sheet.

2 In the Extended Attributes page, type the name of a database column in

the Value column of the field annotation, if you want to map the element

with a database column.

or

Type the name of a database table in the Value column of the relation

annotation, if you want to map the element with a database table.

You can define a value for the following annotations regar ding an

element (E) and/or an attribute (A):

Annotation E A Description

encode 99When an XML element or attribute is

mapped to a SQL Server BLOB column,

allows requesting a reference (URI) to be

returned and used later to return BLOB data

field 99Maps an XML item to a database column

hide 99Hides the element or attribute specified in

the schema in the resulting XML document

is-constant 9— Creates an XML element that does not map

to any table. The element appears in the

query output

Contents

Main LAST REVISED: June 2005 Contents 2 Building an XML model....................................................31 Page 3 Working with an XML model......................................... 139 Page Page Page About This Book Page Page Page CHAPTER 1 XML Model Basics Functional overview What is an XML model? About XML Objects in an XML model Page Page How to link a child object to a parent object in an XML model? For more information, see sections How to link a child object to an Defining the XML model environment Choosing the XML language of an XML model For more information on XML languages, see chapter XML Language s For more information on resource files, see chapter The Resource Changing the XML language of an XML model Changes concerning simple and complex types For more information on simple and complex types, see sections Selecting extended model definitions at model creation Defining model options For more information on requirements, see the Requirements Model For information on naming conventions, see section Defining naming XML model extended dependencies Page Defining an XML model Defining model properties For information on the generic pages of a model property sheet, see Model General page Chapter 1 XML Model Basics Model Detail page types, see chapter Building an XML model. For more information on elements, attributes, simple and complex Model Items page For more information on these items, see chapter Building an XML Model External Schemas page For more information on these items, see chapter Building an XML Model Namespaces page Page Model Preview page Creating an XML model Creating an XML model using the New model option For more information on attaching extended model definitions to a Creating an XML model using the New model from template option For more information on model templates, see section Creating a Opening an existing XML model Detaching an XML model from the workspace Saving and closing an XML model Page CHAPTER 2 Building an XML model XML diagram basics Defining an XML diagram Why build an XML diagram? Creating an XML diagram For information on creating an XML diagram from a new XML model, For information on creating an XML diagram from an existing XML Page Page Element general properties For more information on group particles, see section Linking child For more information on derivations, see section Defining der ivations. Model Defining elements in XDR files Defining elements 40 Example of an XDR file: Element detail properties The Detail page of an element property sheet displays the following Element attributes properties Element constraints properties For more information on constraints, see section Defining identity Element mapping properties For more information on element mapping, see section Mapping objects Creating an element For more information on the different ways to create an element, see Page How to link a child object to an element? Defining the attributes of an element Page Attribute general properties Defining attributes in XDR files Attribute detail properties Attribute values page Adding an attribute to an element Modifying element display preferences Linking child elements to a parent element Defining group particles Group particles properties Creating a group particle For more information on the namespace concept, see section Managing How to link a child object to a group particle? Defining Any properties Any general properties Page Page Page Any Attribute general properties The General page of an Any Attribute property sheet displays the following Defining identity constraints Defining a unique constraint Unique general properties Unique fields properties Defining a key constraint Key general properties Key fields properties Defining a keyRef constraint Page KeyRef general properties KeyRef fields properties For information on XPath expressions, see section Defining an identity Creating an identity constraint Defining an identity constraint selector XPath abbreviated syntax You can use the following abbreviated syntax to define an XPath expression: Defining identity constraints 72 Defining selector general properties The General page of a selector property sheet displays the following To display a selector property sheet: Defining an identity constraint field For information on XPath expressions, see section Defining an identity Defining field general properties Page Defining groups Defining a group of elements Defining group properties Page Creating a group of elements For more information on the different ways to create a group, see Page How to link a child object to a group of elements? Modifying the group display preference Defining a group of attributes Defining attribute group properties Page Creating an attribute group For more information on the different ways to create an attribute group, Page Managing external shortcuts through references and data types Page Defining simple types What is a simple type? For more information on simple type derivations, see section Defining Defining simple type properties Modifying the simple type display preference Creating a simple type Page Defining complex types What is a complex type? Defining complex type properties Complex type general properties Defining complex types 94 Complex type detail properties The Detail page of a complex type property sheet displays the following Complex type attributes properties Complex type mapping properties For more information on complex type mapping, see section Mapping Modifying complex type display preferences Creating a complex type For more information on the different ways to create a complex type, Page How to link a child object to a complex type? Pointer indications Defining simple content properties Defining complex content properties Defining derivations Deriving by extension Page Deriving by restriction Restriction on a simple type Defining restriction facets Page Page Creating a restriction on a simple type Page Page Restriction on a complex type Deriving by list Deriving by union Page Defining annotations Defining annotation properties Annotation general property Annotation items properties Defining documentation properties Documentation general properties Defining application information properties Application information general properties Application information content Creating an annotation Page Defining notations Defining notation properties Creating a notation Defining entities Defining entity properties Creating an entity Page Defining import, include and redefine Defining an import Defining import properties Creating an import Defining an include Defining include properties Creating an include Defining a redefine Defining redefine properties Creating a redefine Page Defining business rules What is a business rule? Defining business rule properties Business rule general properties Business rule expression property Creating a business rule Page Page Page Page Page CHAPTER 3 Working with an XML model Checking an XML model XML model check options Levels of problem severity Automatic correction For more information on objects available for automatic correction, see XML model object selection in the Check Model Checking an XML model Page Displaying previously applied check options in an XML model Making corrections based on XML model check results Making manual corrections to an XML model Making automatic corrections to an XML model XML Model objects verified by Check Model Group particle check Model check Identifier uniqueness Undefined identifier Shortcut code uniqueness Undefined target namespace Business rule check in an XSM Business rule name and code uniqueness Unused business rule Data source check Data source name and code uniqueness File check Embedded file name uniqueness Existence of external file location Entity check Entity name and code uniqueness Undefined entity Include check Undefined schema location Simple type check Simple type name and code uniqueness Complex type check Element check Element name and code uniqueness Undefined type Existence of attribute Group check Group name and code uniqueness Attribute check Attribute name and code uniqueness Undefined type Notation check Notation name and code uniqueness Attribute group check Attribute group name and code uniqueness Existence of attributes Import check Undefined schema location and namespace Redefine check Undefined schema location Existence of component Key check Key name and code uniqueness Undefined selector KeyRef check KeyRef name and code uniqueness Undefined selector Unique check Unique name and code uniqueness Undefined Selector Extended object check Extended object name and code uniqueness Extended link check Extended link name and code uniqueness Replication check Partial object replication Extension check Restriction check Existence of facet Simple type list check Simple type union check Annotation check Existence of items Mapping objects in an XML model Understanding object mapping Defining data sources in an XML model Data source properties in an XML model Creating a data source in an XML model Page Mapping XML Model objects to PDM objects Mapping elements Mapping complex types Mapping XML Model objects to OOM objects Mapping elements Mapping complex types Creating a mapping for an XML object Page Page Modifying the mapping of an attribute Manipulating XML objects graphically Local objects Global objects Example: converting a local object into a global object Page Comparing and merging XML models For more information on comparing and merging models, see chapter Generating an XML model from a Physical Data Model Generating XML Model objects Page Defining XML model generation options Chapter 3 Working with an XML model For more information on conversion scripts, see chapter Ma na ging Models in the General Features Guide. Check model before generation Generating a new XML model from a PDM Updating an existing XML model Page For more information on merging models, see Comparing and Generating an XML model from an Object- Oriented Model Generating XML Model objects Page Defining XML model generation options Chapter 3 Working with an XML model For more information on conversion scripts, see chapter Ma na ging Models in the General Features Guide. Check model before generation Generating a new XML model from an OOM Updating an existing XML model Page For more information on merging models, see Comparing and Editing an XML model report For more information on reports, see the Reports Users Guide. What is a report? Creating an XML model report Page For more information on the Report Editor, see chapter Using the For more information on building a report structure, see chapter How can a report underline the hierarchical structure of an XML model? Page Page Page Generating an XSD, a DTD or an XDR file Why generate an XSD file? Why generate a DTD file? Why generate an XDR file? Defining generation parameters Check model For more information on the Check model feature, see section Checking Defining generation targets For more information on how to create or import an extended model Defining generation options Defining generation tasks How to generate an XSD, a DTD or an XDR file? For more information on changing the XML language of an XML Page Page 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? Reverse engineering options Reverse engineering target models Reverse engineering to a new XML model Page For more information on shortcuts, see section Target models Reverse engineering to an existing XML model For more information on merging models, see section Merging Page CHAPTER 5 Exchanging data with databases supporting XML Why use XML in databases? Generating an annotated schema for Microsoft SQL Server 2000 Mapping XML objects to PDM objects For more information on reverse engineering a database into a PDM, Page Page Page For more information on building an XML hierarchy, see section Page Page Page Reinforcing mapping with extended attributes Page Chapter 5 Exchanging data with databases supporting XML Page Page Generating an annotated schema for Oracle 9i2 Page Page Chapter 5 Exchanging data with databases supporting XML Page Page Page Generating a DAD file for IBM DB2 Page Page Page For more information on building an XML hierarchy, see section Page Page Page Page Page Page Page Generating SQL/XML queries For more information on the XML Builder Wizard, see Generating an Page Page Page Page Page CHAPTER 6 Generating from an XML model Generation basics For more information on merging two models, see chapter Comparing Target models parameters For more information on shortcuts, see chapter Managing Shortcuts Page Generating an XML model from an XML model Why generate an XML model from an XML model? Page Defining generation options Generating a new XML model from an XML model Page Updating an existing XML model Page For more information on merging models, see chapter Comparing Page XML Model Glossary Page Page For more information on XPath, see XPath abbreviated syntax in Index A B 272 C D E F 274 G I K L M N O P S T U V W X