Summary of the content on the page No. 1
XML Model
User's Guide
® ®
Sybase PowerDesigner
11.1
Windows
Summary of the content on the page No. 2
DOCUMENT ID: DC20014-01-1110-01 LAST REVISED: June 2005 Copyright © 1991-2005 Sybase, Inc. All rights reserved. Information in this manual may change without notice and does not represent a commitment on the part of Sybase, Inc. and its subsidiaries. Sybase, Inc. provides the software described in this manual under a Sybase License Agreement. The software may be used only in accordance with the terms of the agreement. No part of this publication may be reproduced, transmitted, or translated in
Summary of the content on the page No. 3
Contents About This Book ............................................................................................ix 1 XML Model Basics..............................................................1 Functional overview .................................................................. 2 What is an XML model? ........................................................... 3 About XML.......................................................................... 4 Objects in an XML model ...............
Summary of the content on the page No. 4
Defining Any Attribute properties...................................... 61 Defining identity constraints.................................................... 64 Defining a unique constraint............................................. 64 Defining a key constraint.................................................. 66 Defining a keyRef constraint ............................................ 67 Creating an identity constraint.......................................... 69 Defining an identity constrain
Summary of the content on the page No. 5
Defining an include......................................................... 127 Defining a redefine ......................................................... 128 Defining business rules......................................................... 132 What is a business rule?................................................ 132 Defining business rule properties................................... 132 Creating a business rule................................................. 133 Applying a business rule
Summary of the content on the page No. 6
Understanding object mapping ...................................... 166 Defining data sources in an XML model ........................ 166 Mapping XML Model objects to PDM objects ................ 169 Mapping XML Model objects to OOM objects................ 171 Creating a mapping for an XML object........................... 172 Modifying the mapping of an attribute ............................ 175 Manipulating XML objects graphically................................... 176 Local objects .........
Summary of the content on the page No. 7
5 Exchanging data with databases supporting XML ......215 Why use XML in databases?................................................ 216 Generating an annotated schema for Microsoft SQL Server 2000 .......................................................................... 217 Mapping XML objects to PDM objects ........................... 217 Reinforcing mapping with extended attributes ............... 225 Generating an annotated schema for Oracle 9i2.................. 230 Generating a DAD file fo
Summary of the content on the page No. 8
viii PowerDesigner
Summary of the content on the page No. 9
About This Book Subject This book describes the PowerDesigner XML Model environment. It shows you how to do the following: ♦ Build an XML model ♦ Work on an XML model ♦ Generate and reverse engineer a DTD file ♦ Generate and reverse engineer an XSD file ♦ Generate and reverse engineer an XDR file ♦ Generate an annotated schema ♦ Generate a DAD file ♦ Generate an SQL/XML query ♦ Generate an XML model from a PDM ♦ Generate an XML model from an OOM ♦ Generate an XML model from another XML model Aud
Summary of the content on the page No. 10
About This Book ♦ Object Oriented Model (OOM) to model a software system using an object-oriented approach for Java or other object languages ♦ Business Process Model (BPM) to model the means by which one or more processes are accomplished in operating business practices ♦ XML Model (XSM) to model the structure of an XML file using a DTD or an XML schema ♦ Requirements Model (RQM) to list and document the customer needs that must be satisfied during a development process ♦ Information Liquidity
Summary of the content on the page No. 11
About This Book Repository Getting Started To learn the basics of the Repository. Repository User’s Guide To work in a multi-user environment using a central repository. Typographic PowerDesigner documentation uses specific typefaces to help you readily conventions identify specific items: ♦ monospace text (normal and bold) Used for: Code samples, commands, compiled functions and files, references to variables. Example: declare user_defined…, the BeforeInsertTrigger template. ♦ UPPER CASE
Summary of the content on the page No. 12
About This Book xii PowerDesigner
Summary of the content on the page No. 13
CHAPT ER 1 XML Model Basics About this chapter This chapter presents PowerDesigner XML Model. It provides you with an introduction to the basic notions of XML modeling. Contents Topic Page Functional overview 2 What is an XML model? 3 Defining the XML model environment 10 Defining an XML model 17 XSM User's Guide 1
Summary of the content on the page No. 14
Functional overview Functional overview With the graphical interface and the Browser tree view of PowerDesigner XML Model, you can design an XML diagram which represents the content of an XML Schema Definition file (.XSD), a Document Type Definition file (.DTD) or an XML-Data Reduced file (.XDR). Since XML structures can be very complex, it is much easier to visualize them through comprehensive and explicit diagrams, than to read XML-coded pages. Once you have created an XML diagram, you can gen
Summary of the content on the page No. 15
Chapter 1 XML Model Basics What is an XML model? An XML model is a graphical representation of an XML Schema Definition file (.XSD), a Document Type Definition file (.DTD) or an XML-Data Reduced file (.XDR). With its Browser tree view and diagram, an XML model gives you a global and schematic view of all the elements composing an XSD, a DTD or an XDR file. This is very helpful when you need to understand, check or modify the complex structure of an XSD, a DTD or an XDR file. Example of an XML
Summary of the content on the page No. 16
What is an XML model? About XML Why use XML? The eXtensible Markup Language is used for different reasons: ♦ It describes and structures data, whereas HTML only displays data ♦ It uses a self-describing and personalized syntax ♦ It can be exchanged between incompatible systems, since data is stored in plain text format DTD, XSD or XDR The structure of an XML model is described by a DTD, an XSD or an XDR file: ♦ A DTD file is a basic way to describe the structure of an XML document. It is a raw l
Summary of the content on the page No. 17
Chapter 1 XML Model Basics Extract of an XSD file: An XSD file always starts with the tag (root element). All objects created in the model will appear in the XSD file between the schema start-tag and end-tag ♦ An XDR file is a simplified XSD file (or schema). It does not support simple and complex user-defined data types Extract of an XDR file: An XDR file always starts with the tag (root element). All objects created in the model will appear in the XDR file between the sche
Summary of the content on the page No. 18
What is an XML model? An XML model is a tree structure of child elements attached to parent elements. Elements are the basic describing items of an XML model. They can be made of other elements combined in different ways through group particles. Elements are specified by attributes and data types which can be predefined or user-defined. Simple and complex data types can be defined as global (directly linked to the tag) or local (embedded in an element declaration). The following table d
Summary of the content on the page No. 19
Chapter 1 XML Model Basics Tool Object Description — Notation A notation is used to define and process non- XML objects within an XML model These tools are available in the palette of the diagram window. The main objects of an XML model are represented by symbols in its diagram. Objects in a diagram Some objects may not appear in a diagram because they do not have a symbol or this symbol has been deleted or hidden. Always check the existence of objects in the Browser tree view. Example of an
Summary of the content on the page No. 20
What is an XML model? How to link a child object to a parent object in an XML model? XML objects do not support standard link objects. To link a child object to a parent object, you must click the child object tool in the palette and then click the symbol of the parent object in the diagram. This will automatically create a link between both objects. See the following table for allowed links: Complex type Tool Element symbol Group symbol symbol Any No link No link No link All Tool Sequence symbo
