Product Documentation
ER Studio Data Architect
User Guide
Version 10.0.2
© 2015 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies
logos, and all other Embarcadero Technologies product or service names are
trademarks or registered trademarks of Embarcadero Technologies, Inc. All other
trademarks are property of their respective owners.
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for
application developers and database professionals so they can design systems right,
build them faster and run them better, regardless of their platform or programming
language. Ninety of the Fortune 100 and an active community of more than three million
users worldwide rely on Embarcadero products to increase productivity, reduce costs,
simplify change management and compliance and accelerate innovation. The
company's flagship tools include: Embarcadero® Change Manager™, CodeGear™ RAD
Studio, DBArtisan®, Delphi®, ER/Studio®, JBuilder® and Rapid SQL®. Founded in
1993, Embarcadero is headquartered in San Francisco, with offices located around the
world. Embarcadero is online at www.embarcadero.com.
March, 2015
Embarcadero Technologies 2
CONTENTS
Before you Start ..................................................................................................................... 24
Introducing ER/Studio Data Architect ............................................................................. 24
Notice for Developer Edition Users ................................................................................. 24
Important Name Change Notice ..................................................................................... 25
Product Benefits by Audience .......................................................................................... 25
Overview ................................................................................................................................ 26
ER/Studio Family Products ............................................................................................ 26
Application Design ........................................................................................................ 27
Application Interface ............................................................................................................. 28
Data Model Explorer ............................................................................................................. 31
Data Model..................................................................................................................... 31
Data Dictionary .............................................................................................................. 32
Data Lineage .................................................................................................................. 33
Macros ............................................................................................................................ 34
Data Model Window ............................................................................................................. 35
Data Lineage Window ........................................................................................................... 36
Pop-up Windows ................................................................................................................... 37
Zoom Window ....................................................................................................................... 38
Overview Window ................................................................................................................. 39
Menus ..................................................................................................................................... 40
Application Menus ......................................................................................................... 40
Accessing Shortcut Menus ............................................................................................ 40
Toolbars ................................................................................................................................. 41
Moving Toolbars ............................................................................................................ 41
Undock a Toolbar .......................................................................................................... 41
Dock a Toolbar ............................................................................................................... 41
Displaying Toolbars ....................................................................................................... 41
Keyboard Commands ........................................................................................................... 42
Basic Functions .............................................................................................................. 42
Function Keys ................................................................................................................. 42
Shortcuts ......................................................................................................................... 42
Hot Keys ......................................................................................................................... 43
Full Undo Redo .............................................................................................................. 43
Status Bar ............................................................................................................................... 44
Configuring and Customizing .............................................................................................. 45
Customizing the Display of Diagrams and Objects............................................................ 46
Diagram tab ................................................................................................................... 47
Entity/Table tab ............................................................................................................. 47
Relationship tab ............................................................................................................. 48
View tab .......................................................................................................................... 48
Schema Objects tab ...................................................................................................... 49
Transformation tab ........................................................................................................ 49
Drawing Shapes tab ...................................................................................................... 49
Embarcadero Technologies 3
Security Objects tab ...................................................................................................... 49
Apply To tab ................................................................................................................... 49
Defining Model Options for the Selected Model ............................................................... 50
General Options tab ...................................................................................................... 50
Name Handling Options tab ........................................................................................ 51
Customizing Standard Model Features for New Models .................................................. 53
Application tab .............................................................................................................. 53
Logical tab ...................................................................................................................... 54
Physical tab ..................................................................................................................... 54
Name Handling tab ....................................................................................................... 55
Display tab ...................................................................................................................... 56
Directories tab................................................................................................................ 57
Tools tab ......................................................................................................................... 57
Diagram tab ................................................................................................................... 57
View tab .......................................................................................................................... 58
Schema Objects tab ...................................................................................................... 58
Object Types tab ........................................................................................................... 59
Object Names tab ......................................................................................................... 59
Automation Options tab ............................................................................................... 59
Data Dictionary tab ........................................................................................................ 59
Comments tab ............................................................................................................... 60
Where Used tab ............................................................................................................. 60
ERX File Import tab ........................................................................................................ 60
Undo tab ......................................................................................................................... 60
Repository Options tab ................................................................................................. 60
Specifying the Location of Shared Data .............................................................................. 63
Changing Cursor Popup Help Options ............................................................................... 64
Data Modeling Fundamentals .............................................................................................. 65
Data Modeling Concepts ..................................................................................................... 66
The Logical Model ......................................................................................................... 66
The Physical Design ....................................................................................................... 66
Data Model Design Principals ...................................................................................... 66
The Purpose of a Data Model ....................................................................................... 66
The Relational Model .................................................................................................... 67
The Entity-Relationship Model ..................................................................................... 67
The Dimensional Model ................................................................................................ 68
Developing a Data Model .................................................................................................... 69
Starting With a Basic Data Model ................................................................................ 69
Creating a Basic Data Model ........................................................................................ 69
Reverse Engineering a Database ................................................................................. 69
Importing a File to Create a New Database ................................................................ 69
Ensuring Data Integrity .................................................................................................. 69
Automating Data Model Creation and Maintenance ................................................. 70
Fine Tuning the Data Model ......................................................................................... 70
Securing the Data Model .............................................................................................. 70
Embarcadero Technologies 4
Preparing for Review and Implementation .................................................................. 70
Maintaining the Data Model ......................................................................................... 71
Using ER/Studio Data Architect ........................................................................................... 72
Creating and Working With Data Models ........................................................................... 73
Creating a New, Blank Data Model ..................................................................................... 74
Reverse Engineering an Existing Database ........................................................................ 75
Page 1 ............................................................................................................................. 75
Page 2 ............................................................................................................................. 77
Page 3 ............................................................................................................................. 77
Page 4 ............................................................................................................................. 78
Page 5 ............................................................................................................................. 79
Notes .............................................................................................................................. 79
Specifying Application Options for Reverse Engineering .......................................... 80
MongoDB Advanced Login Options ................................................................................... 81
Authentication ................................................................................................................... 81
Connection Options .......................................................................................................... 82
Importing a Model ................................................................................................................ 83
Importing a Model from External Metadata ....................................................................... 84
Importing a Model from a SQL File ..................................................................................... 87
Importing a Model from an ERX File ................................................................................... 89
Generating a Physical Data Model ...................................................................................... 90
Creating a New Physical Model.................................................................................... 91
Using the Compare and Merge Utility ................................................................................. 92
What Can the Compare/Merge Utility Do? ..................................................................... 92
Comparing Models and Submodels ................................................................................ 94
Page 1 ............................................................................................................................. 95
Page 2 ............................................................................................................................. 95
Page 3 ............................................................................................................................. 96
Page 4 - Select Specific Model Objects ...................................................................... 97
Page 5 - Results .............................................................................................................. 97
Forcing a Match ................................................................................................................. 98
Create a new diagram with one entity called Entity1 with a primary key of A. ........ 98
Updating an Offline DBMS ............................................................................................. 102
Updating a Model or Submodel .................................................................................... 102
Resolving and Reporting on Model Differences ........................................................... 103
Changing the Database Platform of a Model ................................................................... 105
Common Tasks .................................................................................................................... 106
Using Toolbar Tools ............................................................................................................ 107
Creating a Data Model Object ........................................................................................... 108
Moving Objects ................................................................................................................... 109
Moving Objects in the Data Model Window ............................................................. 109
Moving Data Model Objects ...................................................................................... 109
Moving Relationship Docking Points ......................................................................... 110
Moving Data Model Objects in the Data Model Explorer ....................................... 110
Moving Objects to Different Nodes .......................................................................... 110
Embarcadero Technologies 5
Moving Submodels ...................................................................................................... 110
Copying Objects.................................................................................................................. 112
Copying an Object in the Data Model Window ....................................................... 112
Copying Multiple Objects ........................................................................................... 113
Copying an Attribute ................................................................................................... 113
Copying an Object from the Data Model Explorer to the Data Model Window ... 113
Copying Objects Between Models and Submodels ................................................ 114
Resizing Objects .................................................................................................................. 116
Manually Resize Data Model Objects ........................................................................ 116
Automatically Resize Data Model Objects to Fit Text .............................................. 116
Changing Model Alignment, Distribution, and Layout .................................................... 117
Finding an Entity, Table or View ........................................................................................ 118
Locating an Object in the Data Model Window ............................................................... 119
Editing an Object ................................................................................................................ 120
Adding and Editing Object Comments ............................................................................ 121
Editing the Name of an Object .......................................................................................... 123
Deleting an Object .............................................................................................................. 124
Renaming an Object ........................................................................................................... 125
Searching for and Changing Object or Object Attribute Names ................................... 126
Creating and Editing Database Views ............................................................................... 128
Notes ................................................................................................................................ 129
Entity/Table tab ............................................................................................................... 130
Attribute/Column tab ...................................................................................................... 130
Column Alias dialog ........................................................................................................ 131
Where tab ......................................................................................................................... 131
Group By tab .................................................................................................................... 131
Having tab ........................................................................................................................ 131
DDL tab ............................................................................................................................ 131
SQL Validation dialog ..................................................................................................... 132
Options tab ...................................................................................................................... 132
Definition tab ................................................................................................................... 132
Notes tab .......................................................................................................................... 132
Where Used tab ............................................................................................................... 132
Dependencies tab ........................................................................................................... 132
PreSQL & PostSQL tab .................................................................................................... 132
Permissions tab ................................................................................................................ 132
Security Information tab .................................................................................................. 133
Attachment Bindings tab ................................................................................................ 133
Defining the Default View Settings for New Models ........................................................ 134
Customize the View Settings for a Specific Model ........................................................... 135
Creating and Editing Submodels ....................................................................................... 136
Edit Submodel tab........................................................................................................... 136
Attributes tab ................................................................................................................... 137
Definition tab ................................................................................................................... 137
Attachment Bindings tab ................................................................................................ 137
Embarcadero Technologies 6
Security Information tab .................................................................................................. 137
Notes ................................................................................................................................ 137
Synchronizing Submodels .................................................................................................. 139
Example 1 ..................................................................................................................... 139
Example 2 ..................................................................................................................... 139
Example 3 ..................................................................................................................... 139
Using the Submodel Synchronization Utility ..................................................................... 141
Page 1 ........................................................................................................................... 141
Page 2 ........................................................................................................................... 141
Page 3 ........................................................................................................................... 141
Page 4 ........................................................................................................................... 141
Notes ............................................................................................................................ 142
Copying a Database Object to a Submodel (Apply to Submodel)................................. 143
Establishing Database Security .......................................................................................... 144
Creating and Editing Database Users ............................................................................... 145
General page/tab ............................................................................................................ 145
System Privileges page/tab ............................................................................................ 146
Object Privileges page/tab ............................................................................................. 146
Dependencies page/tab ................................................................................................. 146
Definition page/tab ......................................................................................................... 146
DDL tab ............................................................................................................................ 146
Attachment Bindings tab ................................................................................................ 147
Notes ................................................................................................................................ 147
Creating and Editing Database Roles ............................................................................... 148
General page/tab ............................................................................................................ 148
System Privileges page/tab ............................................................................................ 149
Object Privileges page/tab ............................................................................................. 149
Dependencies page/tab ................................................................................................. 149
Definition page/tab ......................................................................................................... 149
DDL tab ............................................................................................................................ 150
Attachment Bindings tab ................................................................................................ 150
Notes ................................................................................................................................ 150
Associating Database Roles with New Database Users ................................................... 151
Associating Database Users with New Database Roles ................................................... 152
Changing Database Roles Associated with Existing Database Users ............................ 153
Changing Database Users Associated with Existing Database Roles ............................ 154
Granting and Revoking Permissions to Modify Database Objects ................................. 155
Comparing Models ............................................................................................................. 156
Customizing the Data Model ............................................................................................. 157
Setting Diagram Properties ................................................................................................ 158
Attachment Bindings tab ............................................................................................ 158
Setting Data Model Properties .......................................................................................... 159
Security Information tab .............................................................................................. 159
Attachment Bindings tab ............................................................................................ 159
PreSQL & PostSQL tab ................................................................................................ 160
Embarcadero Technologies 7
Name Handling tab ..................................................................................................... 160
Creating Entity Relational or Dimensional Models .......................................................... 161
What is a Dimensional Model? ................................................................................... 161
Dimensional Model Table Type Determination ........................................................ 161
Dimensional Model Table Types ................................................................................ 162
Dimensional Table Types Indepth ..................................................................................... 164
Fact ............................................................................................................................... 164
Dimension .................................................................................................................... 165
Snowflake ..................................................................................................................... 167
Bridge ........................................................................................................................... 168
Hierarchy Navigation ................................................................................................... 168
Undefined ..................................................................................................................... 168
Changing the Model Notation ........................................................................................... 169
Setting the Relationship Notation ..................................................................................... 170
IDEF1X versus IE Relationship Notation .................................................................... 170
IDEF1X Notation .......................................................................................................... 170
IE (James Martin) Notation ......................................................................................... 171
IE (Crow's Feet) Notation ............................................................................................ 172
Filtered ID (Hide Foreign Keys) Notation .................................................................. 173
Changing the Relationship Notation for all Diagram Models ................................. 174
Changing the Relationship Notation for a Selected Model .................................... 174
Manipulating Relationship Lines ........................................................................................ 175
Changing the Style of Relationship Lines .................................................................. 175
Create an N Bend ........................................................................................................ 176
Straightening an N Bend ............................................................................................ 177
Change the Disposition of Relationship Lines .......................................................... 177
Changing the Model Background ..................................................................................... 179
Change the Background and Outline Colors of Existing Models and Views ................. 180
Setting Default Diagram Colors and Fonts ....................................................................... 181
Overriding Color and Font Settings for a Specific Object ............................................... 182
Change Color and Font Settings for an Entity, Table, Attribute, Column or View 182
Change Entity/Table Background and Outline Colors............................................. 183
Change the Background and Outline Colors of Views in an Open Data Model ... 183
Changing the Color of Relationships ......................................................................... 184
Change Data Model Display Preferences ......................................................................... 185
Changing Entity/Table Display Preferences ..................................................................... 186
Customizing the Layout ...................................................................................................... 187
All tabs .......................................................................................................................... 187
Disconnected tab ......................................................................................................... 188
Circular tab ................................................................................................................... 188
Hierarchical tab ............................................................................................................ 188
Orthogonal tab ............................................................................................................ 189
Symmetric tab .............................................................................................................. 189
Tree tab ........................................................................................................................ 189
Creating and Editing Shapes ............................................................................................. 190
Embarcadero Technologies 8
Shape Text tab ............................................................................................................. 191
Colors and Fonts tab ................................................................................................... 191
Attachment Bindings tab ............................................................................................ 191
Locking Data Model Objects to a Drawing Shape ........................................................... 192
Adding and Editing Lines ................................................................................................... 193
Properties tab ............................................................................................................... 193
Attachment Bindings tab ............................................................................................ 193
Notes ............................................................................................................................ 193
Adding and Editing Title Blocks......................................................................................... 195
Adding Text Blocks ............................................................................................................. 196
Changing Data Model Layout ............................................................................................ 197
Redraw a Data Model Using Auto Layout ................................................................. 197
Notes ............................................................................................................................ 197
Enforcing Data Integrity Using Check Constraints ........................................................... 199
Checking Out a Concurrent License for Offline Usage .................................................... 200
Developing the Logical Model ........................................................................................... 201
Logical Design Concepts .................................................................................................... 202
Logical Design Documentation .......................................................................................... 203
Object Name Rules ............................................................................................................. 204
Normalization....................................................................................................................... 205
Creating and Editing Entities and Tables.......................................................................... 207
Creating and Editing Entities ............................................................................................. 208
All tabs .............................................................................................................................. 208
Attributes/Columns tab .................................................................................................. 209
Keys tab ............................................................................................................................ 209
Relationships tab ............................................................................................................. 209
Definition tab ................................................................................................................... 209
Note tab ........................................................................................................................... 209
Where Used tab ............................................................................................................... 209
User-Defined Mappings tab ........................................................................................... 210
Constraints tab ................................................................................................................. 210
Dependencies tab ........................................................................................................... 210
Permissions tab ................................................................................................................ 210
Naming Standards tab .................................................................................................... 210
Data Lineage tab ............................................................................................................. 211
Security Information tab .................................................................................................. 211
Attachment Bindings tab ................................................................................................ 211
Notes ................................................................................................................................ 211
Creating and Editing Tables ............................................................................................... 213
Columns tab ..................................................................................................................... 213
Dimensional tab ............................................................................................................... 213
DDL tab ............................................................................................................................ 214
Indexes tab ....................................................................................................................... 214
Foreign Keys tab .............................................................................................................. 214
Definition tab ................................................................................................................... 214
Embarcadero Technologies 9
Note tab ........................................................................................................................... 214
Where Used tab ............................................................................................................... 214
User-Defined Mappings tab ........................................................................................... 214
Storage tab ...................................................................................................................... 215
Dimensions tab ................................................................................................................ 215
Properties tab .................................................................................................................. 215
Partition Columns tab ...................................................................................................... 215
Distribute Columns tab ................................................................................................... 216
Distribution tab ................................................................................................................ 216
Organization tab .............................................................................................................. 216
Partitions tab .................................................................................................................... 216
Overflow tab..................................................................................................................... 216
Constraints tab ................................................................................................................. 216
Dependencies tab ........................................................................................................... 216
Capacity Planning tab ..................................................................................................... 217
Permissions tab ................................................................................................................ 217
PreSQL & Post SQL tab ................................................................................................... 217
Naming Standards tab .................................................................................................... 217
Compare Options tab ..................................................................................................... 217
Data Lineage tab ............................................................................................................. 217
Security Information tab .................................................................................................. 218
Attachment Bindings tab ................................................................................................ 218
Notes ................................................................................................................................ 218
Creating and Editing Attributes and Columns ................................................................. 220
Creating and Editing Attributes ......................................................................................... 221
Main page ........................................................................................................................ 221
Datatype tab .................................................................................................................... 222
Default tab........................................................................................................................ 223
Rule/Constraint tab ......................................................................................................... 223
Definition tab ................................................................................................................... 223
Notes tab .......................................................................................................................... 223
Where Used tab ............................................................................................................... 223
User-Defined Mappings tab ........................................................................................... 223
Reference Values tab ....................................................................................................... 224
Naming Standards tab .................................................................................................... 224
Compare Options tab ..................................................................................................... 224
Data Lineage tab ............................................................................................................. 224
Security Information tab .................................................................................................. 224
Attachment Bindings tab ................................................................................................ 224
Data Movement Rules tab .............................................................................................. 225
Notes ................................................................................................................................ 225
Creating and Editing Columns ........................................................................................... 227
Main page ........................................................................................................................ 227
Datatype tab .................................................................................................................... 228
Default tab........................................................................................................................ 232
Embarcadero Technologies 10
Definition tab ................................................................................................................... 233
Notes tab .......................................................................................................................... 233
Where Used tab ............................................................................................................... 233
User-Defined Mappings tab ........................................................................................... 233
Reference Values tab ....................................................................................................... 233
Naming Standards tab .................................................................................................... 233
Compare Options tab ..................................................................................................... 234
LOB Storage tab .............................................................................................................. 234
Data Lineage tab ............................................................................................................. 234
Security Information tab .................................................................................................. 234
Attachment Bindings tab ................................................................................................ 234
Data Movement Rules tab .............................................................................................. 234
Notes ................................................................................................................................ 235
Creating and Editing Keys .................................................................................................. 236
Create a Primary Key ....................................................................................................... 236
Create an Alternate Key or Inversion Entry ................................................................... 237
Create a Foreign Key/Relationship ................................................................................ 238
Specify FK Attribute Name and Datatype ..................................................................... 238
Associate Similar Objects Using User-Defined Mappings ............................................... 239
Create User-Defined Mappings ................................................................................. 240
Definition tab ............................................................................................................... 242
Attachment Bindings tab ............................................................................................ 242
Notes ............................................................................................................................ 242
Working with Universal Mappings ..................................................................................... 243
Creating Universal Mappings through the Compare/Merge Utility ........................ 244
Creating a Universal Mapping using the Universal Mapping Editor ....................... 247
Viewing Universal Mappings ....................................................................................... 249
Viewing and Editing Denormalization Mappings ..................................................... 250
Working with Relationships ................................................................................................ 253
Creating and Editing Relationships ................................................................................... 254
All tabs .............................................................................................................................. 254
Properties tab .................................................................................................................. 257
Phrases tab ....................................................................................................................... 259
Name tab .......................................................................................................................... 259
Trigger tab ....................................................................................................................... 260
Definition tab ................................................................................................................... 260
Compare Options tab ..................................................................................................... 260
Note tab ........................................................................................................................... 260
Rolename tab ................................................................................................................... 260
Attachment Bindings tab ................................................................................................ 260
Notes ................................................................................................................................ 261
Containment Relationships ................................................................................................ 262
Creating and Editing Recursive Relationships .................................................................. 263
Creating View Relationships ............................................................................................... 265
Creating Subtype Cluster Relationships ............................................................................ 266
Embarcadero Technologies 11
Subtype tab .................................................................................................................. 268
Attachment Bindings tab ............................................................................................ 268
Notes ............................................................................................................................ 269
Resolving Name Duplication in Parent and Child Entities (Unification) ......................... 270
Attribute Name Editing Options .................................................................................... 270
Examples of Duplicate Name Resolutions .................................................................... 271
Replace Native Attribute with Propagating Attribute .............................................. 271
Rolename Propagating Attribute ............................................................................... 271
Change Native Attribute Name to Allow Propagating Attribute Name................. 272
Unify Native Attribute with Propagating Attribute ................................................... 272
Validating the Model ........................................................................................................... 273
Validation Options tab ................................................................................................ 273
Object Selection tab .................................................................................................... 274
Notes ............................................................................................................................ 274
Customizing Datatype Mappings ...................................................................................... 275
Developing the Physical Model ......................................................................................... 277
Transforming Model Objects from Logical to Physical .................................................... 279
Physical Storage Considerations ........................................................................................ 281
Defining Table Storage ....................................................................................................... 282
GreenPlum Table Storage Options ............................................................................ 282
HiRDB Table Storage Options .................................................................................... 283
HiRDB LOB Column Storage ...................................................................................... 283
Hive Column Storage .................................................................................................. 283
IBM DB2 Common Server and IBM DB2 for LUW Table Storage Options ............ 284
IBM DB2 for OS/390 Table Storage Options ............................................................ 285
Informix Table Storage Options ................................................................................. 285
Interbase Table Storage Options ............................................................................... 286
Firebird Table Storage Options ................................................................................. 286
Microsoft SQL Server Table Storage Options ........................................................... 286
Teradata Table Storage Options ................................................................................ 287
Oracle 7 Table Storage Options ................................................................................ 287
Oracle 8.x, 9i, 10g, and 11g Table Storage Options ................................................ 289
Oracle LOB Segment Storage Options ..................................................................... 291
PostgreSQL Table Storage Options .......................................................................... 293
Sybase Table Storage Options ................................................................................... 293
Define Table Overflow Options.................................................................................. 294
Distributing Columns for GreenPlum ................................................................................ 297
Distributing Columns for IBM DB2 for LUW 9.x (and later versions) ............................... 299
Distributing Columns for Netezza ...................................................................................... 301
Organizing Columns for Netezza ....................................................................................... 303
Skewed Tables ..................................................................................................................... 304
Bucketing ............................................................................................................................. 305
Partitioning a Table ............................................................................................................. 307
Table Partition Options for Sybase ............................................................................ 307
Table Partition Options for Oracle 8.x, 9i, 10g, 11g and 12c ................................... 307
Embarcadero Technologies 12
Table Partition Editor for Oracle 8.x, 9i, 10g, 11g and 12c....................................... 309
Table Partition Options for IBM DB2 for OS/390 8.x, 9.x, and 10.x ......................... 311
Table Partition Editor for IBM DB2 for OS/390 8.x, 9.x, and 10.x ............................ 311
Table Partition Options for IBM DB2 for LUW 9.x and 10.x ..................................... 311
Table Partition Editor for IBM DB2 for LUW 9.x (and later versions) ....................... 312
Table Partition Columns for IBM DB2 for LUW 5.x, 6.x, 7.x, 8.x ............................... 313
Defining Index Storage ....................................................................................................... 314
GreenPlum Index Storage Options ............................................................................ 314
Hitachi HiRDB Index Storage Options ....................................................................... 314
IBM DB2 for OS/390 Index Storage Options ............................................................ 315
Informix Index Storage Options ................................................................................. 315
Interbase Index Storage Options ............................................................................... 315
Microsoft SQL Server Index Storage Options ........................................................... 315
Oracle Index Storage Options .................................................................................... 316
Postgre SQL Index Storage Options .......................................................................... 317
Sybase SQL Anywhere Index Storage Options ......................................................... 317
Sybase System 10, ASE Index Storage Options ........................................................ 317
Partitioning a Table Index ................................................................................................... 318
IBM DB2 for OS/390 Index Partitions Options .......................................................... 318
Oracle 8.x, 9i, 10g, 11g and 12c Index Partitions Options ....................................... 319
Index Partition Editor for Oracle 8.x, 9i, 10g, 11g and 12c Options ........................ 320
Customizing Table DDL ...................................................................................................... 323
Creating and Editing Indexes ............................................................................................. 324
Create an Index ............................................................................................................... 325
Edit an Index .................................................................................................................... 325
Index Editor Options ....................................................................................................... 325
Columns tab ..................................................................................................................... 327
Properties tab .................................................................................................................. 327
Options tab ...................................................................................................................... 329
Firebird Index Options ................................................................................................ 330
Hitachi HiRDB Index Options ..................................................................................... 330
IBM DB2 for AS/400, Common Server, and UDB Versions 5 through 9 Index
Options ......................................................................................................................... 330
IBM DB2 for OS/390 Index Options ........................................................................... 331
Informix Index Options ................................................................................................ 333
Interbase Index Options ............................................................................................. 334
Microsoft Access and SQL Server Index Options ..................................................... 334
MySQL Index Options ................................................................................................. 334
Teradata Index Options .............................................................................................. 335
Oracle 7 Index Options ............................................................................................... 336
Postgre SQL Index Options ........................................................................................ 336
Sybase Index Options ................................................................................................. 336
Storage tab ...................................................................................................................... 337
Partitions tab .................................................................................................................... 337
Compare Options tab ..................................................................................................... 338
Embarcadero Technologies 13
Attachment Bindings tab ................................................................................................ 338
Creating and Editing Database Dependent Objects ....................................................... 339
Collection Editor .................................................................................................................. 340
Creating and Editing Aliases .............................................................................................. 341
Name page/tab ............................................................................................................... 341
Reference page/tab ........................................................................................................ 341
Definition page/tab ......................................................................................................... 342
DDL page/tab .................................................................................................................. 342
Attachment Bindings tab ................................................................................................ 342
Creating and Editing Auxiliary Tables ............................................................................... 343
Add an Auxiliary Table .................................................................................................... 343
Name page/tab ............................................................................................................... 343
Base Table page/tab ....................................................................................................... 344
Storage page/tab ............................................................................................................ 344
Index Options page/tab ................................................................................................. 344
Definition page/tab ......................................................................................................... 346
DDL page/tab .................................................................................................................. 346
Attachment Bindings tab ................................................................................................ 346
Creating and Editing Buffer Pools ..................................................................................... 347
Create a Buffer Pool ........................................................................................................ 347
Name page/tab ............................................................................................................... 347
Nodes page/tab .............................................................................................................. 347
Definition page/tab ......................................................................................................... 348
DDL page/tab .................................................................................................................. 348
Attachment Bindings tab ................................................................................................ 348
Creating and Editing DataBases ........................................................................................ 349
Add a Database ............................................................................................................... 349
Name & Type page/tab .................................................................................................. 349
Option page/tab.............................................................................................................. 350
Definition page/tab ......................................................................................................... 350
DDL page/tab .................................................................................................................. 350
Attachment Bindings tab ................................................................................................ 350
Creating and Editing Generators ....................................................................................... 351
To Create a Generator .................................................................................................... 351
To Edit a Generator ......................................................................................................... 351
Name tab ...................................................................................................................... 351
Definition tab ............................................................................................................... 351
DDL tab ........................................................................................................................ 351
PreSQL & PostSQL tab ................................................................................................ 351
Attachment Bindings tab ............................................................................................ 352
Creating and Editing SQL Procedures .............................................................................. 353
Create a Scripted Procedure .............................................................................................. 355
SQL page/tab .................................................................................................................. 355
Description page/tab ...................................................................................................... 355
Permissions page/tab ...................................................................................................... 355
Embarcadero Technologies 14
Attachment Bindings tab ................................................................................................ 355
Apply a Scripted Procedure to a Submodel or Model ..................................................... 357
Creating and Editing PreSQL and PostSQL for the CREATE TABLE Statement ........... 358
Creating and Editing Procedures ....................................................................................... 359
Create Reusable Procedure ................................................................................................ 361
Create a Scripted User-Defined Procedure ...................................................................... 362
Create a Templated User-Defined Procedure .................................................................. 363
Bind a Reusable Procedure to a Table .............................................................................. 364
Create an SQL Procedure ................................................................................................... 365
Description tab ................................................................................................................ 365
Attachment Bindings tab ................................................................................................ 365
Permissions tab ................................................................................................................ 365
Notes ................................................................................................................................ 365
Export an SQL Procedure ................................................................................................... 367
Import an SQL Procedure ................................................................................................... 368
Creating and Editing Functions ......................................................................................... 369
Create a Stored SQL Function ....................................................................................... 369
Description tab ................................................................................................................ 369
Permissions tab ................................................................................................................ 369
Attachment Bindings tab ................................................................................................ 370
Notes ................................................................................................................................ 370
Creating and Editing Packages .......................................................................................... 371
Create a Package ............................................................................................................. 371
Header tab ....................................................................................................................... 371
Body tab ........................................................................................................................... 371
Definition tab ................................................................................................................... 371
Attachment Bindings tab ................................................................................................ 372
Permissions tab ................................................................................................................ 372
Creating and Editing Triggers ............................................................................................ 373
Trigger Example .......................................................................................................... 374
Create a Referential Integrity Trigger ............................................................................ 375
Create a Scripted User-Defined Trigger ........................................................................ 377
SQL tab ............................................................................................................................. 378
Description tab ................................................................................................................ 378
Attachment Bindings tab ................................................................................................ 378
Create a Templated User-Defined Trigger ................................................................... 378
Description page/tab ...................................................................................................... 379
Attachment Bindings tab ................................................................................................ 379
Create a Reusable User-Defined Trigger ...................................................................... 379
Creating and Editing Materialized Query Tables ............................................................. 380
Add a Materialized Query Table .................................................................................... 380
Name page/tab ............................................................................................................... 380
Location page/tab ........................................................................................................... 380
SQL page/tab .................................................................................................................. 381
Definition page/tab ......................................................................................................... 381
Embarcadero Technologies 15
DDL page/tab .................................................................................................................. 381
Attachment Bindings tab ................................................................................................ 381
Notes ................................................................................................................................ 381
Creating and Editing Materialized Views .......................................................................... 382
Name page/tab ............................................................................................................... 382
Refresh page/tab ............................................................................................................. 382
Query page/tab ............................................................................................................... 383
Transaction page/tab ...................................................................................................... 384
Extent page/tab ............................................................................................................... 384
Options page/tab ............................................................................................................ 385
Definition page/tab ......................................................................................................... 385
DDL page/tab .................................................................................................................. 385
PreSQL & PostSQL tab .................................................................................................... 385
Permissions tab ................................................................................................................ 386
Attachment Bindings tab ................................................................................................ 386
Requirements for the Fast Refresh Method .................................................................. 386
Creating and Editing Node Groups .................................................................................. 389
Create a Node Group ..................................................................................................... 389
Name page/tab ............................................................................................................... 389
Definition page/tab ......................................................................................................... 389
DDL page/tab .................................................................................................................. 389
Attachment Bindings tab ................................................................................................ 390
Creating and Editing Object Types ................................................................................... 391
Create an Object Type .................................................................................................... 392
Header and Body tab ...................................................................................................... 392
Description tab ................................................................................................................ 392
Attachment Bindings tab ................................................................................................ 392
Creating and Editing Rollback Segments ......................................................................... 393
Create or Edit a Rollback Segment ................................................................................ 393
Name tab .......................................................................................................................... 393
Storage tab ...................................................................................................................... 393
Definition tab ................................................................................................................... 394
DDL tab ............................................................................................................................ 394
Attachment Bindings tab ................................................................................................ 394
Creating and Editing Sequences ....................................................................................... 395
Create or edit a Sequence .............................................................................................. 395
Name page/tab ............................................................................................................... 395
Numbers Page/Tab ......................................................................................................... 395
Options page/tab ............................................................................................................ 395
Definition page/tab ......................................................................................................... 396
DDL page/tab .................................................................................................................. 396
PreSQL & PostSQL page/tab ......................................................................................... 396
Attachment Bindings page/ tab ..................................................................................... 396
Permissions page/tab ...................................................................................................... 396
Creating and Editing StoGroups ....................................................................................... 398
Embarcadero Technologies 16
Create a StoGroup .......................................................................................................... 398
Options page/tab ............................................................................................................ 398
Definition page/tab ......................................................................................................... 399
DDL page/tab .................................................................................................................. 399
Attachment Bindings tab ................................................................................................ 399
Creating and Editing Synonyms ......................................................................................... 400
Create a Synonym............................................................................................................ 400
Name page/tab ............................................................................................................... 400
Reference page/tab ........................................................................................................ 400
Definition page/tab ......................................................................................................... 401
DDL page/tab .................................................................................................................. 401
Attachment Bindings tab ................................................................................................ 401
Creating and Editing Tablespaces ..................................................................................... 402
Create a TableSpace ....................................................................................................... 402
Name & Type page/tab .................................................................................................. 402
Name page/tab ............................................................................................................... 403
Datafile page/tab ............................................................................................................ 403
Storage page/tab ............................................................................................................ 404
Options page/tab ............................................................................................................ 404
Options 1 page/tab ......................................................................................................... 404
Options 2 page/tab ......................................................................................................... 405
Definition page/tab ......................................................................................................... 405
DDL page/tab .................................................................................................................. 405
Attachment Bindings page/ tab ..................................................................................... 406
Creating and Editing Database Schemas ......................................................................... 407
Create a Database Schema ............................................................................................ 407
Object Privilege page/tab .............................................................................................. 407
Definition page/tab ......................................................................................................... 407
DDL page/tab .................................................................................................................. 407
Attachment Bindings tab ................................................................................................ 408
Upgrading Diagrams with Denormalization Mappings ................................................... 409
Optimizing Query Performance on the Physical Model (Denormalizing the Physical
Model) .................................................................................................................................. 412
Removing and Consolidating Child Columns ........................................................... 413
About Roll-Up Denormalization ................................................................................. 413
Create a New Roll-up Mapping .................................................................................. 414
Removing Unnecessary Parent Tables ....................................................................... 415
About Roll Down Denormalization ............................................................................. 415
Create a New Roll-Down Mapping ............................................................................ 415
Partitioning a Table and Duplicating Columns ......................................................... 416
About Horizontal Split Denormalization .................................................................... 416
Create a New Horizontal Split Mapping .................................................................... 417
Replacing a Table with New Tables That Share the Primary Key ............................ 417
About Vertical Split Denormalization ......................................................................... 417
Create a Vertical Split Mapping ................................................................................. 418
Embarcadero Technologies 17
Eliminating Joins by Copying Columns ..................................................................... 418
About Column Map Denormalization ........................................................................ 418
Create a New Column Map Mapping ........................................................................ 418
Removing Unnecessary Tables ................................................................................... 419
About Table Merge Denormalization ........................................................................ 419
Create a New Table Merge Mapping ........................................................................ 419
Synchronizing Physical and Logical Models ...................................................................... 420
Planning for and Predicting Database Growth ................................................................. 421
Planning for Table and Index Storage ....................................................................... 421
Predicting Table Growth ............................................................................................. 421
Predicting Database Growth ...................................................................................... 422
Reporting Database Growth Analysis ........................................................................ 423
Connecting to Database Sources and Targets ................................................................. 424
Configuring ODBC Data Source and Target Connections .............................................. 425
Using Native or Direct Database Connections ................................................................. 426
Troubleshooting Database Connections for 32 bits Version ........................................... 428
IBM DB2 Connectivity Checklist ................................................................................. 428
Informix Connectivity Checklist .................................................................................. 429
Interbase Connectivity Checklist ................................................................................ 429
Microsoft Access Connectivity Checklist ................................................................... 429
Microsoft SQL Server Connectivity Checklist ............................................................ 429
Oracle Connectivity Checklist ..................................................................................... 430
Sybase Connectivity Checklist .................................................................................... 430
Working with the Data Dictionary ...................................................................................... 431
Importing a Data Dictionary ............................................................................................... 433
Copying and Pasting Data Dictionary Objects ................................................................. 434
Attaching External Documents to the Data Model .......................................................... 435
Create and Edit Attachment Types ............................................................................ 435
Create and Edit Attachments ..................................................................................... 436
Bind an Attachment to an Object .............................................................................. 436
Bind an Attachment to a Specific Object .................................................................. 437
Override an Attachment Value ................................................................................... 437
Enforcing Security Using Data Security Types and Properties ........................................ 438
Generate Default Security Information ...................................................................... 438
Create and Edit a Data Security Type ........................................................................ 439
Create and Edit a Data Security Property .................................................................. 439
Enhancing Data Integrity Using Defaults .......................................................................... 440
Create and Edit Defaults ............................................................................................. 440
Promoting Data Integrity Through Rules .......................................................................... 441
Example ........................................................................................................................ 441
Create and Edit Data Dictionary Rules ...................................................................... 442
Defining Valid Attribute Data Using Reference Values .................................................... 444
Reference Value tab .................................................................................................... 444
Definition tab ............................................................................................................... 445
Attachment Bindings tab ............................................................................................ 445
Embarcadero Technologies 18
Binding Information tab .............................................................................................. 445
Enforcing Naming Standards Using Naming Standards Templates ............................... 446
Creating a Naming Standards Template ................................................................... 446
Name tab ...................................................................................................................... 447
Logical and Physical tabs ............................................................................................ 447
Mapping tab ................................................................................................................. 448
Order tab ...................................................................................................................... 449
General tab................................................................................................................... 449
Attachment Bindings tab ............................................................................................ 449
Binding Information tab .............................................................................................. 450
Track Versions of Naming Standards Templates ...................................................... 450
Ensuring Consistent Domain Definitions Using User Datatypes ..................................... 451
Create and Edit User Datatypes ................................................................................. 451
Reusing Attribute Definitions Using Domains .................................................................. 453
Create a Domain Folder .............................................................................................. 453
Create and Edit a Domain or Subdomain ................................................................. 454
Datatype tab ................................................................................................................ 454
Default tab .................................................................................................................... 455
Rule/Constraint tab ...................................................................................................... 455
Reference Values tab ................................................................................................... 455
Naming Standards tab ................................................................................................ 455
Definition tab ............................................................................................................... 455
Note tab ....................................................................................................................... 455
Override Controls tab ................................................................................................. 456
Attachment Bindings tab ............................................................................................ 456
Binding Information tab .............................................................................................. 457
Reusing Procedural Logic ................................................................................................... 458
Create and Edit Reusable Triggers ............................................................................ 458
Create and Edit Reusable Procedures ....................................................................... 459
Create and Edit Libraries ............................................................................................ 460
Library Example ........................................................................................................... 460
Call to Library Example ............................................................................................... 461
Determining Which Objects are Bound by Data Dictionary Objects ............................. 462
Changing Data Dictionary Object Bindings and Values .................................................. 463
Working with the Enterprise Data Dictionary ................................................................... 464
Documenting Data Extraction, Transformation, and Load .............................................. 465
Introduction to Data Lineage ............................................................................................. 466
Data Lineage Workflow ....................................................................................................... 468
Defining Source Systems .................................................................................................... 469
Creating a New Source ............................................................................................... 469
Importing External Source into Other Sources ......................................................... 470
Relating Source and Target Models .................................................................................. 472
Relating Source and Target Tables and Columns ............................................................ 473
Assigning Model Data Movement Properties .................................................................. 474
Creating and Editing Data Lineage Data Flows ............................................................... 475
Embarcadero Technologies 19
Create a Data Lineage Data Flow .................................................................................. 475
All tabs .............................................................................................................................. 476
Columns tab ..................................................................................................................... 477
Definition tab ................................................................................................................... 477
Data Movement Rules tab .............................................................................................. 477
Attachments tab .............................................................................................................. 477
Documenting Column/Attribute ETL ................................................................................ 478
Documenting Table/Entity Data ETL ................................................................................. 479
Saving and Using Quick Launch Settings .......................................................................... 480
Generating RTF and HTML Model Reports ...................................................................... 482
Generate a Report ............................................................................................................... 484
Page 1 ............................................................................................................................... 484
Page 2 ............................................................................................................................... 484
Page 3 for RTF Reports ................................................................................................... 485
Page 3 for HTML Reports ................................................................................................ 485
Exporting the Data Model .................................................................................................. 487
Exporting Metadata for a Particular Model ....................................................................... 488
Exporting Metadata for all Models and Submodels ........................................................ 489
Exporting a Data Model to XML ........................................................................................ 490
Generating a Document Type Definition (DTD) ............................................................... 491
XML Schema Generation .................................................................................................... 492
Generating a Customized XML Schema ........................................................................... 493
Generating a Script File or Database ................................................................................ 511
Page 1 ............................................................................................................................... 511
Generate Script File or Database ............................................................................... 511
Generate Objects with a Database Connection ....................................................... 511
Wizard Quick Launch ................................................................................................... 512
Page 2 ............................................................................................................................... 512
Select or Create SQL Server (2000-2014) Database .................................................. 512
Object Selection and Generation Options ................................................................ 513
Page 3 ............................................................................................................................... 514
Summary ....................................................................................................................... 514
Wizard Quick Launch Options .................................................................................... 514
MongoDB JSON Generation ............................................................................................. 515
Page 1 ............................................................................................................................... 515
Generate Script File ..................................................................................................... 515
Generate Objects with a Database Connection ....................................................... 516
Wizard Quick Launch ................................................................................................... 516
Page 2 ............................................................................................................................... 516
Object Selection and Generation Options ................................................................ 516
Summary ........................................................................................................................... 517
Wizard Quick Launch Options .................................................................................... 517
Creating SQL Procedures to Run Before and After Generating a Physical Model View518
Creating SQL Procedures to Run Before and After Generating a Table ........................ 519
Creating SQL to Run Before and After Generating a Physical Database ....................... 520
Embarcadero Technologies 20
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
Page is loading ...
/
