DB MAIN Reference Manual
DB-MAIN-Reference-Manual
User Manual: Pdf
Open the PDF directly: View PDF .
Page Count: 300
Download | ![]() |
Open PDF In Browser | View PDF |
DB-MAIN 9 The Modelling Tool for your Information System Reference Manual DB-MAIN 9 Reference Manual DB-MAIN http://www.db-main.eu A product of the LIBD Laboratory Faculty of computer sciences • University of Namur Rue Grandgagnage, 21 - B-5000 Namur • Belgium http://www.info.fundp.ac.be/libd Developed and Distributed by REVER S.A. Rue du séminaire, 22 - B-5000 Namur • Belgium http://www.rever.eu • Table of contents i Table of contents Table of contents - - - - - - - - - - - - i Chapter 1 Introduction - - - - - - - - - - - - - - - 1 What is a CASE tool ? About DB-MAIN Downloading DB-MAIN Installing DB-MAIN About this manual Contact Chapter 2 Projects, products and processes - - - - - 7 Project Data Schema Base Data Schema Processing Schema View Schema Text file Set of products Engineering process Inter-product relationship Chapter 3 7 8 9 10 10 11 12 13 13 Data schemas: Entity types, Relationship types and attributes15 Entity type (or object class) Relationship type (rel-type) Collection Attribute Object-attribute Non-set multivalued attribute Group Inter-group constraint Anchored processing units 22 juin 2009 3 3 4 4 5 5 15 17 20 22 25 26 27 30 32 ii • Table of contents Alternate representations Chapter 4 35 Processing schemas: UML activity and use case diagrams37 UML activity diagram 37 Action state 37 Object 38 State 38 Decision state 39 Signal 39 Synchronization state 40 Control flow relation 41 Object flow 41 UML use case diagram 42 Use case 42 Actor 43 Use case relationship 43 Actor relationship 44 Chapter 5 Text files - - - - - - - - - - - - - - - 47 Structure of a text file Patterns in text files Dependency graph in program text files Program slice in program text files Chapter 6 47 47 48 48 Common rules - - - - - - - - - - - - - 51 Common characteristics of schemas Names 51 52 Rules for data schemas 52 Rules for processing schemas 52 General rules 53 Dynamic properties Marked and coloured objects Notes Stereotypes Chapter 7 Engineering process control - - - - - - 59 Methods History 22 juin 2009 54 54 55 56 59 60 • Table of contents Chapter 8 iii Sample DB-MAIN schemas - - - - - - - 65 An Entity-Relationship conceptual schema A NIAM/ORM conceptual schema An UML conceptual schema A relational logical schema A CODASYL-DBTG logical schema A COBOL file logical schema An object-oriented logical schema A relational (ORACLE) physical schema An activity diagram An use case diagram An organizational structure model References Chapter 9 65 66 68 69 70 73 74 76 78 78 79 80 The components of the DB-MAIN environment (Version 9)83 The DB-MAIN environment 83 Program files 83 Input/output files 84 The DB-MAIN Application Library 86 DDL extractor: XML 86 DDL generators: COBOL, CODASYL, Oracle, DB2 and XML 87 DocBook generator 87 Mapping assistant 87 NATURAL : Paraphraser 87 METRICS : Schema metrics computation 87 Chapter 10 List of the DB-MAIN functions - - - - - 89 Chapter 11 The File menu (File) - - - - - - - - - - 91 The commands of the File menu - Summary Managing projects 92 94 New project... 94 Open project... 94 Save project 94 Save project as... 94 Close project 94 Exporting and importing 94 Export... 94 Import... 95 Executing a user-defined plug-in 22 juin 2009 95 iv • Table of contents Execute Plug-in... 95 Rerun Plug-in... 95 User tools 96 Extracting and generating DDL text files 96 Extract 96 Generate 98 Using external texts 99 Edit text file... 99 Reporting and printing 99 Report textual view... 99 Print... 100 Printer setup... 100 Configuring the DB-MAIN environment 101 Configuration... 101 Opening a recently used project 105 Recent projects 105 Quitting DB-MAIN 105 Exit 105 Chapter 12 The Edit menu (Edit) - - - - - - - - - - 107 The commands of the Edit menu - Summary Preserving and restoring the state of a schema 108 109 Save point 109 Rollback 109 Undo 109 Copying/pasting parts of a schema 109 Copy+C 109 Paste +V 110 Copy graphic 110 Selecting, marking, coloring 110 Select all +A 110 Mark selected +M 110 Select marked 110 Color selected 110 Remove color 110 Deleting objects 111 Delete 111 Goto between objects 111 Goto... 111 Managing colors and fonts 111 Change color... 111 Change font... 111 Chapter 13 22 juin 2009 The Product menu (Product) - - - - - - 113 • Table of contents v The commands of the Product menu - Summary Managing products 114 114 New schema... 114 Add text... 114 New set... 114 Open... 115 Properties... 115 Copy product... 115 View 115 Managing meta-objects and user-defined domains 116 Meta-properties... 116 User-domains... 118 Locking products 119 Lock/Unlock 119 Chapter 14 The New menu (New) - - - - - - - - - 121 The commands of the New menu - Summary Adding new objects to a data schema 123 124 Collection... 124 Entity type... 124 Rel-type... 125 Attribute 125 Role... 126 Group... 126 Constraint... 126 Processing unit... 126 Adding new objects to an activity schema 126 Action state... 126 Initial state... 127 Final state... 127 Horizontal synchronisation... 127 Vertical synchronisation... 127 Decision... 127 Object... 128 State... 128 Signal sending... 128 Signal receipt... 128 Control flow... 128 Object flow... 129 Adding new objects to an use case schema Use case... 129 Actor... 129 Extend relationship... 129 Include relationship... 129 Use case generalization... 130 Association... 130 Use case association role... 130 22 juin 2009 129 vi • Table of contents Actor association role... 130 Actor generalization... 130 Adding notes to a schema 131 Note... 131 Link note... 131 Chapter 15 The Transform menu (Transform)- - - - 133 The commands of the Transform menu - Summary 134 Transforming entity types, rel-types, attributes, roles or groups 134 Entity type 135 Rel-type 136 Attribute 137 Role 138 Group 138 Processing names 139 Change prefix... 139 Name processing... 139 Transforming an ERA schema into UML class diagram (and conversely) 140 ERA -> UML class... 140 UML class -> ERA... 140 Transforming into relational model 140 Relational model 140 Generating SQL 140 Quick SQL 140 Chapter 16 The Assist menu (Assist) - - - - - - - - 141 The commands of the Assist menu - Summary Transforming schema 142 142 Global transformations... 142 Advanced global transformations... 147 Analyzing schema 151 Schema Analysis... 151 Integrating objects 157 Schemas... 157 Objects... 159 Analyzing text 162 Text Analysis 162 Finding referential key Referential key... 165 22 juin 2009 165 • Table of contents Chapter 17 vii The Engineering menu (Engineering) - - 173 The commands of the Engineering menu - Summary Managing primitive or engineering processes 174 175 Use primitives 175 Copy schema & use primitives 175 End use of primitives 175 New engineering process 176 End current process 176 Continue process 176 Taking decision 176 Take decision 176 Controlling history 177 Control 177 Chapter 18 The Log menu (Log) - - - - - - - - - - 179 The commands of the Log menu - Summary Adding information in schema logs 180 180 Trace 180 Add check point... 180 Add schema... 180 Add desc... 181 Managing schema logs 181 Clear log 181 Save log as... 181 Replaying log files 181 Replay 181 Chapter 19 The View menu (View) - - - - - - - - - 183 The commands of the View menu - Summary Choosing graphical and textual views 184 185 Text compact 185 Text standard 186 Text extended 187 Text sorted 187 Graph. compact 188 Graph. standard 188 Graph. dependency 189 Setting graphical views Graphical settings 189 Alignment 197 UML role positioning 199 Move window 200 Auto-Draw 200 22 juin 2009 189 viii • Table of contents Displaying engineering method window 200 Engineering method 200 Navigating in graphical and textual views 201 The textual data schema window 201 The graphical data schema window 203 The textual processing schema window 204 The graphical processing schema window 207 The graphical process window 208 The source file window 210 Chapter 20 The Window menu (Window) - - - - - - 213 The commands of the Window menu - Summary Displaying or hiding tool bars 213 214 Standard tools 214 Graphical tools 216 UML role position tools 218 RE tools 218 Transfo tools 218 Process tools 220 User tools 220 Displaying or hiding properties box, project explorer and status bar 221 Property box 221 Project explorer 222 Status bar 222 Chapter 21 The Help menu (Help or F1 key) - - - - 223 The commands of the Help menu - Summary Displaying help and other informations 223 224 Help () 224 First steps 224 About DB-MAIN... 224 225 Annexe 1 Elementary constraints of schema analysis assistant225 Constraints on schema 225 ET_per_SCHEMA 225 RT_per_SCHEMA 225 COLL_per_SCHEMA 225 DYN_PROP_of_SCHEMA 226 22 juin 2009 • Table of contents ix SELECTED_SCHEMA 226 MARKED_SCHEMA 226 PLUGIN_CONSTRAINT_on_SCHEMA 226 Constraints on collections 226 ALL_COLL 226 ET_per_COLL 226 DYN_PROP_of_COLL 227 SELECTED_COLL 227 MARKED_COLL 227 PLUGIN_CONSTRAINT_on_COLL 227 Constraints on entity types 227 ALL_ET 227 ATT_per_ET 227 ATT_LENGTH_per_ET 228 ROLE_per_ET 228 ONE_ROLE_per_ET 228 N_ROLE_per_ET 228 MAND_ROLE_per_ET 228 OPT_ROLE_per_ET 228 GROUP_per_ET 228 ID_per_ET 229 PID_per_ET 229 ALL_ATT_in_ID_ET 229 ALL_ATT_ID_per_ET 229 HYBRID_ID_per_ET 229 KEY_ID_per_ET 229 ID_NOT_KEY_per_ET 229 KEY_ALL_ATT_ID_per_ET 230 EMBEDDED_ID_per_ET 230 ID_DIFF_in_ET 230 KEY_per_ET 230 ALL_ATT_KEY_per_ET 230 HYBRID_KEY_per_ET 230 ID_KEY_per_ET 231 KEY_PREFIX_in_ET 231 REF_per_ET 231 REF_in_ET 231 COEXIST_per_ET 231 EXCLUSIVE_per_ET 231 ATLEASTONE_per_ET 231 PROCUNIT_per_ET 232 COLL_per_ET 232 DYN_PROP_of_ET 232 SELECTED_ET 232 MARKED_ET 232 PLUGIN_CONSTRAINT_on_ET 232 Constraints on is-a relations 22 juin 2009 233 x • Table of contents ALL_ISA 233 SUB_TYPES_per_ISA 233 SUPER_TYPES_per_ISA 233 TOTAL_in_ISA 233 DISJOINT_in_ISA 233 DYN_PROP_of_ISA 233 SELECTED_ISA 233 MARKED_ISA 234 PLUGIN_CONSTRAINT_on_ISA 234 Constraints on rel-types 234 ALL_RT 234 ATT_per_RT 234 ATT_LENGTH_per_RT 234 ROLE_per_RT 234 ONE_ROLE_per_RT 235 N_ROLE_per_RT 235 MAND_ROLE_per_RT 235 RECURSIVITY_in_RT 235 GROUP_per_RT 235 ID_per_RT 235 PID_per_RT 235 ALL_ATT_ID_per_RT 236 HYBRID_ID_per_RT 236 EMBEDDED_ID_per_RT 236 ID_DIFF_in_RT 236 KEY_per_RT 236 COEXIST_per_RT 236 EXCLUSIVE_per_RT 237 ATLEASTONE_per_RT 237 PROCUNIT_per_RT 237 DYN_PROP_of_RT 237 SELECTED_RT 237 MARKED_RT 237 PLUGIN_CONSTRAINT_on_RT 237 Constraints on roles 238 ALL_ROLE 238 MIN_CON_of_ROLE 238 MAX_CON_of_ROLE 238 ET_per_ROLE 238 DYN_PROP_of_ROLE 238 SELECTED_ROLE 238 MARKED_ROLE 238 PLUGIN_CONSTRAINT_on_ROLE 239 Constraints on attributes ALL_ATT 239 MIN_CARD_of_ATT 239 MAX_CARD_of_ATT 239 22 juin 2009 239 • Table of contents xi DEPTH_of_ATT 239 SUB_ATT_per_ATT 240 TYPES_ALLOWED_for_ATT 240 TYPES_NOTALLOWED_for_ATT
240 SET_TYPES_ALLOWED_for_ATT
240 SET_TYPES_NOTALLOWED_for_ATT
240 TYPE_DEF_for_ATT
240 PART_of_GROUP_ATT 241 ID_per_ATT 241 PID_per_ATT 241 PART_of_ID_ATT 241 KEY_per_ATT 241 REF_per_ATT 242 PART_of_REF_ATT 242 DYN_PROP_of_ATT 242 SELECTED_ATT 242 MARKED_ATT 242 PLUGIN_CONSTRAINT_on_ATT 242 Constraints on groups 243 ALL_GROUP 243 COMP_per_GROUP 243 ATT_per_GROUP 243 ROLE_per_GROUP 243 GROUP_per_GROUP 243 ID_in_GROUP 243 PID_in_GROUP 244 KEY_in_GROUP 244 REF_in_GROUP 244 COEXIST_in_GROUP 244 EXCLUSIVE_in_GROUP 244 ATLEASTONE_in_GROUP 244 LENGTH_of_ATT_GROUP 244 TRANSITIVE_GROUP 244 DYN_PROP_of_GROUP 245 SELECTED_GROUP 245 MARKED_GROUP 245 PLUGIN_CONSTRAINT_on_GROUP 245 Constraints on entity type identifiers ALL_EID 245 COMP_per_EID 245 ATT_per_EID 246 OPT_ATT_per_EID 246 MAND_ATT_per_EID 246 SINGLE_ATT_per_EID 246 MULT_ATT_per_EID 246 MULT_ATT_per_MULT_COMP_EID 246 SUB_ATT_per_EID 246 COMP_ATT_per_EID 247 22 juin 2009 245 xii • Table of contents ROLE_per_EID 247 OPT_ROLE_per_EID 247 MAND_ROLE_per_EID 247 ONE_ROLE_per_EID 247 N_ROLE_per_EID 247 GROUP_per_EID 247 ALL_EPID 248 COMP_per_EPID 248 ATT_per_EPID 248 OPT_ATT_per_EPID 248 MAND_ATT_per_EPID 248 SINGLE_ATT_per_EPID 248 MULT_ATT_per_EPID 248 MULT_ATT_per_MULT_COMP_EPID 249 SUB_ATT_per_EPID 249 COMP_ATT_per_EPID 249 ROLE_per_EPID 249 OPT_ROLE_per_EPID