Translating OOM data types for a PDM, 217

Chapter 7 Generating a Physical Data Model from an Object-Oriented Model

Translating OOM data types for a PDM

PowerDesigner supports both Java and physical data types. Data types that you select in the OOM are not always supported by the current DBMS. In this case, the data type is translated to a data type supported by the DBMS when you generate the PDM.

Translating Java data types for a PDM

The following table lists the Java data types to which the object language file assigns translations:

Java data type

char

boolean

byte

short

integer

long

float

double

String

Code in

CDM

TXT

What it stores

Character

Two opposing values (true/false; yes/no; 1/0)

256values 16-bit integer 32-bit integer 32-bit integer

32-bit floating decimal numbers

Numbers with a fixed decimal point

Character strings

Translation example for SQL Anywhere

char

numeric(1)

smallint

integer

float

numeric

long varchar

217

Page 227

Image 227

Sybase 7.5 manual Translating OOM data types for a PDM, Translating Java data types for a PDM, 217

Contents

User’s Guide Page Contents 103 Modifying the code of an implementation operation100 Changing an association into an associative class 102 112 111 Generating Objects from an OOM 179 Vii Using Object Languages 229 Viii About This Book Subject Audience Where to find information Use these parts of the book If you want to Object-Oriented Model Basics Contents Build an Object-Oriented Model OOM Functional overview UML and object-oriented modeling OOM creation What is an OOM?OOM roles Selection Tool Description Objects in an OOMAn OOM represents the interaction of the following objects Object To create an OOM Creating a new OOM Object-Oriented Model Basics To open an existing OOM Opening an existing OOMAn OOM has the file extension .OOM You can set the following option for classes in an OOM Defining OOM model optionsClasses Result To define OOM model optionsNon-divergence Length Defining OOM propertiesTo modify the model properties Defining OOM properties Building an Object-Oriented Model Package properties Defining packages Preference Displaying text in package symbolsTo modify the package display preferences Defining packages Defining classes Maximum length Class propertiesClass has the following general properties Property Description New stereotypes Analyzing class propertiesStereotype Modify or creating Stereotype Type Visible Creating a classVisibility Cardinality To create a class from the Browser Accessing the list of classesCreating a class from the Browser Creating a class from the list of classes Inner classes Creating a class from a diagramTo create a class in a diagram To declare an inner class within a class Opening property sheets at last accessedAttaching an inner class to a class Building an Object-Oriented Model To detach an inner class from a class Detaching an inner class from a class To modify class properties from its property sheet ClassifiersModifying class properties Modifying class properties from its property sheet To modify class properties from the list of classes Modifying class properties from the list of classes Adding objects to a class To add an attribute to a class Adding an attribute to a class To add an operation to a class Adding an operation to a class Defining classes To preview the code of a class Preview the code of a class or an interface To modify the class display preferences Displaying text in class symbols Building an Object-Oriented Model An interface has the following properties Defining interfacesInterface properties Visibility Analyzing interface propertiesCreating an interface Creating an interface from the Browser Creating an interface from the list of interfaces Creating an interface from a diagramAccessing the list of interfaces To create an interface in a diagram To modify interface properties from its property sheet Modifying interface propertiesModifying interface properties from its property sheet Select Model Interfaces Modifying interface properties from the list of interfacesInterface property sheet opens to the General To modify interface properties from the list of interfaces Adding objects to an interface Adding inner classes to an interface To add an attribute to an interface Adding an attribute to an interfaceYou can add the following objects to an interface Building an Object-Oriented Model To add an operation to an interface Adding an operation to an interface To preview the code of an interface Preview the code of an interface Code Preview page appears Click OK Displaying text in interface symbols To modify the interface display preferences Defining attributes An attribute has the following properties Attribute properties Data Type Analyzing attribute properties To create an attribute from the Browser Creating an attributeMultiplicity Creating an attribute from the Browser Select Model Attributes. The list of attributes appears Accessing the list of attributesCreating an attribute from the list of attributes To create an attribute by inserting it in the list To create an attribute from a class in a diagram Creating an attribute from a class in a diagram Modifying attribute properties To modify attribute properties from its property sheet Modifying attribute properties from its property sheet Select Model Attributes Modifying attribute properties from the list of attributesTo modify attribute properties from the list of attributes To attach an attribute to a domain Attaching an attribute to a domain Attribute property sheet opens to the General To copy an attribute to another class Copying an attribute to another class To modify the display preferences Displaying text in attribute symbolsWhen selected An attribute has the following display preferences Building an Object-Oriented Model An identifier has the following properties Defining identifiersIdentifier properties To create an identifier Creating an identifierYou can create an identifier from a class To add attributes to an identifier Adding attributes to an identifierYou can add attributes to an identifier To modify identifier properties from its property sheet Modifying identifier propertiesModifying identifier properties from its property sheet Modifying identifier properties from the list of identifiers An operation has the following properties Defining operationsOperation properties To create an operation from the Browser Analyzing operation propertiesCreating an operation Creating an operation from the Browser Select Model Operations. The list of operations appears Accessing the list of operationsCreating an operation from the list of operations To create an operation by inserting it in the list To create an operation from a class in a diagram Creating an operation from a class in a diagram To modify operation properties from its property sheet Modifying operation propertiesModifying operation properties from its property sheet Select Model Operations Modifying operation properties from the list of operationsOperation property sheet opens to the General To modify operation properties from the list of operations Adding constructors and destructors to a class To add a Default constructor and destructor to a class Adding a Default constructor and destructor to a class Building an Object-Oriented Model To add a Copy constructor to a class Adding a Copy constructor to a class To add a duplicate operation to a class Adding operations to a classAdding a duplicate operation to a class To add an inherited operation to a class Adding an operation from a parent class Operation Adding Getter and Setter operations to a class Defining operations Creating an implementation operation To create an implementation operation To modify the code of an implementation operation Modifying the code of an implementation operation To copy an operation to another class Copying an operation to another class An operation has the following display preferences Displaying text in operation symbols To modify the display preferences Modify the operation display preferences Click OK Direction Defining parametersParameter properties To create a parameter Creating a parameter Parameter property sheet opens to the General Generalization has the following properties Defining generalizationsGeneralization properties To create a generalization Analyzing generalization propertiesCreating a generalization Dragging a generalization to a different class Link appears between the two objects To modify generalization properties from its property sheet Modifying generalization propertiesModifying generalization properties from its property sheet Generalization has the following display preferences Displaying text in generalization symbols To modify the display preferences Class plays as viewed by the opposite class Omitted when end names are usedDefining associations Association Ends An association has the following properties Association properties Dragging an association to a different class Creating an association outside of a diagramTo create an association in a diagram Creating an association 100 Analyzing cardinality propertiesAssociation property sheet opens to the General Indicates Association role propertiesOrdering 101 Right-click an association Changing an association into an associative classAggregation/composition of an Association To change an association into an associative class 103 Modifying association propertiesModifying association properties from its property sheet To modify association properties from its property sheet 104 Modifying cardinality propertiesTo modify association cardinality properties Double-click the association in the model 105 106 Displaying text in association symbolsTo modify the association display preferences 107 108 Defining dependenciesDependency properties Dependency has the following properties 109 Creating a dependencyTo create a dependency 110 Dragging a dependency to a different class 111 Modifying dependency propertiesModifying dependency properties from its property sheet To modify dependency properties from its property sheet 112 Displaying text in dependency symbolsDependency has the following display preferences 113 114 Defining realizationsRealization properties Realization has the following properties 115 Creating a realizationTo create a realization Dragging a realization to a different class 116 Modifying realization propertiesModifying a realization from its property sheet 117 To modify realization properties from its property sheet 118 Displaying text in realization symbolsModifying a realization from the list of realizations Realization has the following display preferences 119 120 Defining domainsDomain properties Each domain definition includes the following properties To create a domain Accessing the List of DomainsCreating a domain You create a domain from the list of domains 122 Indicating data type, length, and precisionLength Precision 123 Selecting a data type for a domainSelecting a data type for a domain from the list To select a data type for a domain from the list Selecting a data type from a list of standard data types Selecting a data type for a domain from its property sheetUndefined data type To select a data type for a domain from its property sheet 125 Selecting a data type from a list of standard data typesChange of data type appears in the list of domains 126 Numeric data typesCharacter data types Selecting from the Data Type dropdown listbox Time data typesOther data types To select a data type from a list of standard data types 128 129 Accessing a property sheet from the BrowserModifying domain properties To modify domain properties 130 Setting standard check parameters for objectsDefining check parameters Variable Defining additional check parameters for objectsTo set standard parameters 131 132 Using a validation rule in check parametersTo define additional check parameters 133 To use a validation rule in check parametersValidation rule expressions 134 135 Managing Object-Oriented Models 136 Checking an OOMObject parameters verified by Check model Message Description Indicating error severityOOM check options 137 To check a OOM Objects selected in the diagramObject selection in the Check Model Checking a OOM 139 140 Selecting all or clearing all checkboxes 141 Symbol OptionMaking corrections based on OOM check results Dockable result window Making manual corrections to an OOM Making automatic corrections to the OOM 143 144 Merging two OOM 145 To open a Rose model in PowerDesignerOpening a Rose model in an OOM 146 Objects importedAll objects Class Generalization Association Attribute Objects not importedPackage Class Interface 148 OperationGeneralization Dependency 149 Reverse Engineering 150 What is reverse engineering?Parsing Outer class Reverse engineering JavaTogether classes that logically belong together Inner classes To define Java reverse engineering options Reverse engineering Java optionsJava code Comments 153 Loading a JDK library model in the workspaceTo load a JDK library model 154 Reverse engineering Java source files without code bodyTo reverse java without code body Select the .java radio button 155 156 Reverse engineering Java source filesSelect the Ignore operation body checkbox Click OK To reverse engineer .java files 157 Reversing without the body of the code 158 To reverse engineer compiled Java files to a diagramReverse engineering compiled Java files Multi-selection 159 160 161 Reverse engineering Java files from a source directoryTo reverse engineer Java files from a source directory 162 163 To reverse engineer .jar or .zip files to a diagramReverse engineering archived .jar or .zip files 164 165 166 Reverse engineering PowerBuilderReverse engineering PowerBuilder options 167 To define PowerBuilder reverse engineering options 168 Loading a PowerBuilder library model in the workspaceTo load a PowerBuilder library model 169 Reverse engineering objects from a PowerBuilder application 170 171 To reverse engineer PowerBuilder objects from SRU filesReverse engineering objects from SRU files 172 173 XML Data XML SchemaReverse engineering XML Reverse engineering XML options 175 Reverse engineering XML filesTo define XML reverse engineering options XML files can be reversed into an OOM 176 To reverse engineer an XML file 177 Reverse engineering into a new OOMTo reverse engineer object language files into a new OOM 178 This product includes XML4C 3.0.1 software developed by 179 This chapter describes how to generate objects from an OOMAbout this chapter 180 Generating objectsSelecting objects to include in the generation Selection tips Graphically selected objectsSelecting objects Select tools Visibility sort Generating Java source filesDefining Java generation options Check model 183 To define Java generation options 184 Generating Java class definition filesTo generate .java files 185 Select the classes that you want to generate from the listSelect Tools 186 Creating Java BeanInfo classesNavigating between pages 187 To create Java BeanInfo classes 188 Sru files Generating objects for PowerBuilderDefining PowerBuilder generation options Pbl application 190 To define PowerBuilder generation options 191 Generating objects for a PowerBuilder applicationClick Apply Click Cancel 192 193 Generating PowerBuilder objects in sru filesTo generate PowerBuilder user objects in sru files 194 195 Generating for XMLDefining XML generation options To define XML generation options 196 Generating XML objects 197 To generate XML files 198 199 Customizing scripts 200 201 OOM object Generating OOM objects to a CDMTranslating OOM objects into CDM objects 202 Java data type Translating OOM data types for a CDMTranslating Java data types for a CDM 203 204 Generating a CDM from an OOMGenerating and updating a CDM You can set the following general generation options Update existingCDM generation options Clearing the Preserve Modifications checkbox 206 Object selection parametersCheck model before generation Objects selected in the model 207 Generating a new CDMTo generate to a new CDM from an OOM 208 209 Generating a CDM from a package Preserve Modifications To update an existing CDM by generating from an OOMUpdating an existing CDM 210 211 Preserve modifications 212 213 Merging models 214 215 Associations Generating OOM objects to a PDMTranslating OOM objects into PDM objects Generating from Translation example for SQL Anywhere Translating OOM data types for a PDMTranslating Java data types for a PDM 217 218 Generating a PDM from an OOMGenerating and updating a PDM Generate new Physical Data 219 Physical Data 220 Defining PDM generation optionsYou select objects for PDM generation from the Selection 221 Generating a new PDMTo generate to a new PDM from an OOM Select Tools Generate Physical Data Model 222 223 Generating a PDM from a package 224 To update an existing PDM by generating from an OOMUpdating an existing PDM 225 226 227 228 229 Using Object Languages Object language type Object languagesTypes of object language 230 Open an OOM Select Language Edit Current Object Language Accessing object language propertiesModifying the current object language To modify a value of a current object language 232 233 Modifying linked object language propertiesTo modify the parameters of a linked object language 234 To create a new object language Changing the object language of an OOMCreating a new object language To change the object language of an OOM 236 237 238 Values Using the object language editorCategories Fields Following editing options appear Modifying values in the object language editorObject language Editor edit menu Stereotypes Object language editor categoriesGeneral category UML category 242 Class has the following default stereotypesClass stereotypes Generalization stereotypes An operation has the following default stereotypeGeneralization has the following default stereotype Operation stereotypes 244 Dependency has the following default stereotypesDependency stereotypes 245 Package has the following default stereotypesScript category Package stereotypes 246 Default constantsFollowing constant values are defined by default Object scripts Example Specification247 248 Default data typesXML Mapping You can modify the following basic data types 249 Extended Attributes categoryNamings Event 250 251 Using Business Rules 252 What is a business rule? Rule type Defining business rules in an OOMTypes of business rule 253 254 Business rule propertiesCreating a business rule Business rule definition includes the following properties 255 To create a business rule 256 Applying business rules to objectsApplying a business rule to an object To apply a business rule to an object 257 Attaching an expression to a business rule 258 259 Glossary 260 Glossary 261 Stereotype Transient object Visibility 262 263 Index OOM 264 265 Class 266 267 268 269 JDK 270 Model 271 272 Open 273 274 Role 275 276 277 278