Manuals / Sybase / Power Tools / Impact Driver

Sybase XML manual Generating an annotated schema for Oracle, 230

Models: XML

1 290

Download 290 pages 48.58 Kb

Page 242

Generating an annotated schema for Oracle 9i2

Generating an annotated schema for Oracle 9i2

Oracle 9i2 is a database server with a native XML storage and retrieval technology called Oracle XML DB. There is no mapping between XML data and relational data. Tables, columns and abstract data types (ADT) are created from annotated schemas (XSDs). Annotated schemas are XML- coded files, targeted with an XML language and tagged with specific DBMS annotations, that allow 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) for Oracle 9i2. You just need to attach the Oracle 9i2 extended model definition to the XML model. Oracle 9i2 uses by default the name of the XML elements present in the annotated schema to generate SQL objects. You can override the creation of SQL objects by defining extended attributes for elements, complex types and the XML model.

Caution

The following procedure assumes you have an XML model open in the workspace and targeted with XSD.

To generate an annotated schema for Oracle 9i2:

1Select Model→Extended Model Definitions. The List of Extended Model Definitions appears.

2 Click the Import an Extended Model Definition tool.

230	PowerDesigner

Image 242

Sybase XML manual Generating an annotated schema for Oracle, ™ To generate an annotated schema for Oracle, 230

Contents

Sybase PowerDesigner 11.1Last Revised June Contents 101 Managing external shortcuts through references and data100 102Working with an XML model 139 169 Why reverse engineer an XSD, a DTD or an XDRHow to reverse engineer an XSD, a DTD or an XDR Mapping XML Model objects to OOM objects 171Exchanging data with databases supporting XML 215 ViiViii Documentation primer SubjectAudience Object Oriented Model Getting Started Conceptual Data Model User’s Guide To work with the CDMPhysical Data Model User’s Guide 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 Not certified resource file Defining the XML model environmentChoosing the XML language of an XML model Language Description Changing the XML language of an XML model™ To change the XML language of an XML model 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 ™ To define the properties of an XML model Defining an XML modelDefining model properties Model General Property DescriptionModel Detail Tool Tooltip Description Model ItemsButton Moves item 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 ™ To open an existing XML model Opening an existing XML modelDetaching an XML model from the workspace ™ To detach an XML model from a workspaceModel Saving and closing an XML modelSaving an XML Closing an XML modelDefining an XML model Building an XML model XML diagram basics Defining an XML diagramWhy build an XML diagram? Expand/Expand All/Collapse/Arrange Symbols features Creating an XML diagramGroup Symbols feature 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 Sources Element constraints propertiesElement mapping properties ™ To create an element from the palette Creating an elementAttributes Mapping 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 values™ To add an attribute to an element Adding an attribute to an elementElement values with XDR Preference Description Modifying element display preferencesLinking child elements to a parent element Group particle Value of the order attribute in XDR Defining group particlesGroup particles 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 Key fields properties Defining a keyRef constraintKey general properties Defining identity constraints KeyRef fields properties Creating an identity constraintKeyRef general 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 propertiesProperties Attribute groupAttributes 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 Type of derivation Description What is a simple type?Defining simple types Creating a simple type Defining simple type propertiesModifying the simple type display preference ™ 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 propertiesSources Complex type mapping propertiesComplex Type 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 ™ To create a simple content Defining simple content propertiesSimple content General property™ To create a complex content Defining complex content propertiesComplex content General propertiesDerivation in element property sheet Defining derivationsDeriving by extension 102103 Defining extension™ To define a derivation by extension 104 Deriving by restrictionRestriction on a simple type Restriction detail Defining restriction facetsRestriction general 105Enumerations Facet generalRestriction 106Restriction patterns 107108 Creating a restriction on a simple type™ To create a restriction on a simple type 109 110 ™ To create a restriction on a complex type Restriction on a complex typeEnumeration and Pattern facets 111Deriving by list 112113 Deriving by union™ To define a simple type derivation by list ™ To define a simple type derivation by union Union generalUnion types 114Defining annotations 115Annotation general property Defining annotation propertiesDefining documentation properties Annotation items propertiesDocumentation general properties Documentation contentDefining application information properties Application information general properties118 Application information contentCreating an annotation 119 120 Defining notationsDefining notation properties 121 Creating a notation™ To create a notation from the Browser tree view 122 Defining entitiesDefining entity properties Entity name Reference Value123 Creating an entity™ To create an entity from the Browser tree view 124 Defining import properties Defining import, include and redefineDefining an import Import general126 Creating an import™ To create an import from the Browser tree view Include general Defining an includeDefining include properties 127™ To create an include from the Browser tree view Defining a redefineCreating an include 128129 Defining redefine propertiesRedefine general ™ To create a redefine from the Browser tree view Creating a redefineRedefine items 130131 Defining business rule properties What is a business rule?Defining business rules Business rule general properties133 Creating a business ruleBusiness rule expression property 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 139XML model check options Levels of problem severityChecking an XML model 140Automatic correction Selecting objects in the diagramXML model object selection in the Check Model 141142 Checking an XML model™ To check an XML model Selecting all or clearing all check boxes 143Dockable result window ™ To display errors and warnings selected in the last checkDisplaying previously applied check options in an XML model 144Contextual menu Making corrections based on XML model check resultsDisplay the Check toolbar 145™ To make manual corrections to an XML model Making manual corrections to an XML modelMaking automatic corrections to an XML model ™ To make automatic corrections to an XML modelExistence of particle XML Model objects verified by Check ModelGroup particle check Invalid cardinalityUndefined identifier Model checkIdentifier uniqueness Shortcut code uniquenessMissing namespaces Business rule check in an XSMData source check Business rule name and code uniquenessExistence of model File checkData source name and code uniqueness 150Existence of external file location Entity checkEmbedded file name uniqueness Entity name and code uniquenessComplex type check Include checkSimple type check Element name and code uniqueness Element checkExistence of attribute Undefined typeUndefined reference 154155 Group checkGroup name and code uniqueness Attribute name and code uniqueness Attribute checkNotation check 156Undefined notation Attribute group checkNotation name and code uniqueness Attribute group name and code uniquenessRedefine check Undefined schema location and namespaceImport check Existence of attributesKey name and code uniqueness Key checkExistence of component Existence of fields160 KeyRef checkKeyRef name and code uniqueness 161 Unique checkUnique name and code uniqueness Extended object name and code uniqueness Extended object checkExtended link check Extended link name and code uniquenessRestriction check Replication checkExtension check Partial object replication164 Simple type list checkExistence of facet Existence of items Simple type union checkAnnotation check 165Defining data sources in an XML model Mapping objects in an XML modelUnderstanding object mapping 166™ To create a data source in an XML model Data source properties in an XML modelCreating a data source in an XML model 167168 169 Mapping XML Model objects to PDM objectsMapping elements XML Model object PDM objectTool Description Mapping complex types170 XML Model object OOM object Mapping XML Model objects to OOM objects171 172 Creating a mapping for an XML object™ To create a mapping for an element 173 Create From Sources and Generate Mapping tools 174175 Modifying the mapping of an attribute™ To modify the mapping of an attribute Move Manipulating XML objects graphicallyLocal objects 176™ To convert a local object into a global object Global objectsExample converting a local object into a global object Drag and dropAfter conversions 178Comparing and merging XML models 179180 Generating an XML model from a Physical Data ModelGenerating XML Model objects PDM object Generated object in an XML modelGenerate new XML Generating and updating an XML modelXML model naming conventions 181XML model Update existingDefining XML model generation options Clearing the Preserve modifications check boxCheck model before generation 183184 Generating a new XML model from a PDM™ To generate a new XML model from a PDM 185 Updating an existing XML modelGenerating an XML model from a package Preserve modifications Result186 ™ To update an existing XML model by generating from a PDMPreserve modifications Merging models 187OOM Object Generated object in an XML model Generating an XML model from an Object- Oriented Model188 189 190 191 192 Generating a new XML model from an OOM™ To generate a new XML model from an OOM 193 ™ To update an existing XML model by generating from an OOM 194195 Creating an XML model report What is a report?Editing an XML model report ™ To create a model report197 198 Inserting diagramLanguage in a template 199 200 201 Why generate an XDR file? Why generate an XSD file?Why generate a DTD file? Generating an XSD, a DTD or an XDR fileDefining generation targets Defining generation parametersCheck model 203Defining generation tasks Using the Move up or down arrowsDefining generation options 204205 How to generate an XSD, a DTD or an XDR file?Parameter entities during DTD generation Model targeted with Generated file206 207 How to reverse engineer an XSD, a DTD or an XDR file? What is reverse engineering?Why reverse engineer an XSD, a DTD or an XDR file? Reverse engineering an XSD, a DTD or an XDR fileReverse engineering to a new XML model Reverse engineering optionsReverse engineering target models 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? 216217 Generating an annotated schema for Microsoft SQL ServerMapping XML objects to PDM objects 218 219 220 221 Extended model definitions 222Annotated schema preview 223224 Reinforcing mapping with extended attributes 225226 Annotation Description227 228 229 230 Generating an annotated schema for Oracle™ To generate an annotated schema for Oracle 231 232 233 234 235 236 237 Generating a DAD file for IBM DB2™ To generate a DAD file for IBM DB2 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 249 Generating SQL/XML queries™ To generate SQL/XML queries Generating SQL/XML queries 250251 252 253 254 Generating from an XML model 255256 Generation basicsTarget models parameters Generation option DescriptionGenerating from an XML model 257258 259 Why generate an XML model from an XML model?Generating an XML model from an XML model 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 XML language UnionUnique XPathIndex 271PowerDesigner 272273 274 IBM DB2275 276 277 XML278