Database Modeling with Microsoft® Visio for Enterprise Architects
Regular price
32.750 KD
inc. VAT
Couldn't load pickup availability
Table of contents
- Cover
- Copyright Pageiv
- Contentsv
- Part 1: Overview of Database Modeling and the Database Modeling Tool1
- Chapter 1. Introduction3
- 1.1 Why Read This Book?4
- 1.2 What Can You Do with Visio for Enterprise Architects?5
- 1.3 What Can You Do with the Database Modeling Solution?6
- 1.4 How Can You Best Use This Book?14
- 1.5 Format Conventions16
- Chapter 2. Database Modeling19
- 2.1 Four Information Levels20
- 2.2 Designing Databases at the Logical level21
- 2.3 Designing Databases at the Conceptual Level25
- 2.4 The Database Life Cycle27
- Chapter 3. Getting Started31
- 3.1 Product Editions and Versions32
- 3.2 Installation32
- 3.3 The Visio Interface35
- 3.4 Using Help43
- 3.5 Pagination and Layers44
- 3.6 Simple Examples of Forward Engineering48
- Part 2: The Conceptual Modeling Solution (ORM)63
- Chapter 4. Object Types, Predicates, and Basic Constraints65
- 4.1 Object Types66
- 4.2 Fact Types74
- 4.3 Adding Basic Constraints in the Fact Editor79
- 4.4 Populating Fact Types with Examples82
- 4.5 Saving a Model83
- 4.6 Verbalization and Hyphenation84
- 4.7 Objectifying an Association (Nesting)85
- 4.8 Model Error Checks87
- 4.9 Derived Fact Types88
- 4.10 Data Types89
- Chapter 5. ORM Constraints97
- 5.1 Value Constraints98
- 5.2 Internal and External Uniqueness Constraints99
- 5.3 Simple and Disjunctive Mandatory Constraints102
- 5.4 Constraint Editing and Deletion104
- 5.5 Set-Comparison Constraints105
- 5.6 Subtyping109
- 5.7 Frequency Constraints112
- 5.8 Ring Constraints114
- 5.9 Indexes118
- 5.10 Constraint Layers119
- Chapter 6. Configuring, Manipulating, and Reusing ORM Models121
- 6.1 Configuring ORM Preferences122
- 6.2 Showing Relationships for Object Types123
- 6.3 Redisplaying Model Elements125
- 6.4 Cloning Model Elements126
- 6.5 Cutting and Pasting Model Elements128
- 6.6 Referencing Model Elements129
- Chapter 7. Mapping ORM Models to Logical Database Models133
- 7.1 Forward Engineering ORM Source Models134
- 7.2 Refining the Logical Model138
- 7.3 Migrating Changes back to ORM Source Models139
- 7.4 Controlling Logical Name Generation142
- 7.5 Constraint Code151
- 7.6 Subtype Mapping156
- Chapter 8. Reverse Engineering and Importing to ORM165
- 8.1 Reverse Engineering to ORM166
- 8.2 Displaying the ORM Model Graphically172
- 8.3 Refining the ORM Schema174
- 8.4 Importing VisioModeler and ERX Files175
- Chapter 9. Conceptual Model Reports177
- 9.1 Conceptual Model Reports„Overview178
- 9.2 Object Type Reports179
- 9.3 Constraint Type Reports190
- 9.4 Fact Type Reports192
- 9.5 Supertype Reports195
- 9.6 Copying Diagrams and Text197
- Part 3: The Logical Modeling Solution (ER and Relational)201
- Chapter 10. Creating a Basic Logical Database Model203
- 10.1 The Database Model Diagram Solution204
- 10.2 Notation Options204
- 10.3 Creating a Database Model Diagram208
- 10.4 Adding Attributes to an Entity212
- 10.5 Adding Basic Constraints216
- 10.6 Basic Model Housekeeping222
- 10.7 Projects and ER Source Models223
- Chapter 11. Generating a Physical Database Schema231
- 11.1 Physical Schemas and Database Drivers232
- 11.2 Creating a Basic DDL Script232
- 11.3 Database Driver Options238
- 11.4 Generating Schemas via an ODBC Connection244
- 11.5 The ODBC Driver Setup Pane251
- Chapter 12. Editing Logical Models: Intermediate Aspects255
- 12.1 The Database Properties Dialog256
- 12.2 Table Properties256
- 12.3 Column Properties257
- 12.4 Foreign Key Relationships261
- 12.5 Category Relationships264
- 12.6 Show Related Tables265
- 12.7 Views266
- 12.8 Pagination270
- 12.9 Verbalization271
- 12.10 Model Error Check271
- 12.11 Driver, Document, and Modeling Options272
- Chapter 13. Editing Logical Models: Advanced Aspects281
- 13.1 Copying Model Elements282
- 13.2 Cloning Model Elements284
- 13.3 Database Properties: Definition and Notes285
- 13.4 Check Clauses285
- 13.5 Indexes286
- 13.6 Triggers287
- 13.7 Stored Procedures289
- 13.8 Raw DDL289
- 13.9 User Defined Functions290
- 13.10 User Defined Types291
- 13.11 Extended Properties292
- 13.12 The Object-Relational Stencil294
- Chapter 14. Reverse Engineering Physical Schemas to Logical Models297
- 14.1 Using the Reverse Engineer Wizard298
- 14.2 Reviewing the Result301
- 14.3 Handling Errors and Warnings305
- 14.4 Other Reverse Engineering Options305
- Chapter 15. Logical Database Model Reports307
- 15.1 New Report Wizard308
- 15.2 Statistical Report309
- 15.3 Table Report310
- 15.4 Data Types Report322
- Part 4: Managing Database Projects327
- Chapter 16. Change Propagation and Round-Trip Engineering329
- 16.1 Overview of Change Propagation330
- 16.2 Mapping ORM Changes to Logical Models330
- 16.3 Migrating Logical Model Changes to ORM Models334
- 16.4 Updating Physical Schemas with Logical Model Changes336
- 16.5 Refreshing Logical Models with Physical Schema Changes340
- 16.6 Three-Way Synchronization343
- 16.7 Code Synchronization and Transfer349
- 16.8 Data Migration354
- 16.9 DDL Script vs. Automated Update357
- Chapter 17. Other Features and Best Practices361
- 17.1 Model Reviews and Presentations362
- 17.2 Librarianship380
- 17.3 Distributing Your Database Models384
- Glossary and ORM Notation389
- Further Resources401
- Index411
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions.
· Explains how to model databases with Microsoft® Visio for Enterprise Architects (VEA), focusing on tool features.
· Provides a platform-independent introduction to data modeling using both Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.
· Additional ORM models, course notes, and add-ins available online.
· Explains how to model databases with Microsoft® Visio for Enterprise Architects (VEA), focusing on tool features.
· Provides a platform-independent introduction to data modeling using both Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.
· Additional ORM models, course notes, and add-ins available online.