Database Modeling with Microsoft® Visio for Enterprise Architects

Database Modeling with Microsoft® Visio for Enterprise Architects

by Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
Released September 2003
Publisher(s): Morgan Kaufmann
ISBN: 9780080491035

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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.

Table of contents

  1. Front Cover
  2. Database Modeling with Microsoft® Visio for Enterprise Architects
  3. Copyright Page
  4. Contents (1/2)
  5. Contents (2/2)
  6. Part 1: Overview of Database Modeling and the Database Modeling Tool
    1. Chapter 1. Introduction
      1. 1.1 Why Read This Book?
      2. 1.2 What Can You Do with Visio for Enterprise Architects?
      3. 1.3 What Can You Do with the Database Modeling Solution? (1/2)
      4. 1.3 What Can You Do with the Database Modeling Solution? (2/2)
      5. 1.4 How Can You Best Use This Book?
      6. 1.5 Format Conventions
    2. Chapter 2. Database Modeling
      1. 2.1 Four Information Levels
      2. 2.2 Designing Databases at the Logical level
      3. 2.3 Designing Databases at the Conceptual Level
      4. 2.4 The Database Life Cycle
    3. Chapter 3. Getting Started
      1. 3.1 Product Editions and Versions
      2. 3.2 Installation
      3. 3.3 The Visio Interface (1/2)
      4. 3.3 The Visio Interface (2/2)
      5. 3.4 Using Help
      6. 3.5 Pagination and Layers
      7. 3.6 Simple Examples of Forward Engineering (1/3)
      8. 3.6 Simple Examples of Forward Engineering (2/3)
      9. 3.6 Simple Examples of Forward Engineering (3/3)
  7. Part 2: The Conceptual Modeling Solution (ORM)
    1. Chapter 4. Object Types, Predicates, and Basic Constraints
      1. 4.1 Object Types (1/2)
      2. 4.1 Object Types (2/2)
      3. 4.2 Fact Types
      4. 4.3 Adding Basic Constraints in the Fact Editor
      5. 4.4 Populating Fact Types with Examples
      6. 4.5 Saving a Model
      7. 4.6 Verbalization and Hyphenation
      8. 4.7 Objectifying an Association (Nesting)
      9. 4.8 Model Error Checks
      10. 4.9 Derived Fact Types
      11. 4.10 Data Types (1/2)
      12. 4.10 Data Types (2/2)
    2. Chapter 5. ORM Constraints
      1. 5.1 Value Constraints
      2. 5.2 Internal and External Uniqueness Constraints
      3. 5.3 Simple and Disjunctive Mandatory Constraints
      4. 5.4 Constraint Editing and Deletion
      5. 5.5 Set-Comparison Constraints
      6. 5.6 Subtyping
      7. 5.7 Frequency Constraints
      8. 5.8 Ring Constraints
      9. 5.9 Indexes
      10. 5.10 Constraint Layers
    3. Chapter 6. Configuring, Manipulating, and Reusing ORM Models
      1. 6.1 Configuring ORM Preferences
      2. 6.2 Showing Relationships for Object Types
      3. 6.3 Redisplaying Model Elements
      4. 6.4 Cloning Model Elements
      5. 6.5 Cutting and Pasting Model Elements
      6. 6.6 Referencing Model Elements
    4. Chapter 7. Mapping ORM Models to Logical Database Models
      1. 7.1 Forward Engineering ORM Source Models
      2. 7.2 Refining the Logical Model
      3. 7.3 Migrating Changes back to ORM Source Models
      4. 7.4 Controlling Logical Name Generation (1/2)
      5. 7.4 Controlling Logical Name Generation (2/2)
      6. 7.5 Constraint Code
      7. 7.6 Subtype Mapping (1/2)
      8. 7.6 Subtype Mapping (2/2)
    5. Chapter 8. Reverse Engineering and Importing to ORM
      1. 8.1 Reverse Engineering to ORM (1/2)
      2. 8.1 Reverse Engineering to ORM (2/2)
      3. 8.2 Displaying the ORM Model Graphically
      4. 8.3 Refining the ORM Schema
      5. 8.4 Importing VisioModeler and ERX Files
    6. Chapter 9. Conceptual Model Reports
      1. 9.1 Conceptual Model Reports—Overview
      2. 9.2 Object Type Reports (1/3)
      3. 9.2 Object Type Reports (2/3)
      4. 9.2 Object Type Reports (3/3)
      5. 9.3 Constraint Type Reports
      6. 9.4 Fact Type Reports
      7. 9.5 Supertype Reports
      8. 9.6 Copying Diagrams and Text
  8. Part 3: The Logical Modeling Solution (ER and Relational)
    1. Chapter 10. Creating a Basic Logical Database Model
      1. 10.1 The Database Model Diagram Solution
      2. 10.2 Notation Options
      3. 10.3 Creating a Database Model Diagram
      4. 10.4 Adding Attributes to an Entity
      5. 10.5 Adding Basic Constraints (1/2)
      6. 10.5 Adding Basic Constraints (2/2)
      7. 10.6 Basic Model Housekeeping
      8. 10.7 Projects and ER Source Models (1/2)
      9. 10.7 Projects and ER Source Models (2/2)
    2. Chapter 11. Generating a Physical Database Schema
      1. 11.1 Physical Schemas and Database Drivers
      2. 11.2 Creating a Basic DDL Script
      3. 11.3 Database Driver Options (1/2)
      4. 11.3 Database Driver Options (2/2)
      5. 11.4 Generating Schemas via an ODBC Connection (1/2)
      6. 11.4 Generating Schemas via an ODBC Connection (2/2)
      7. 11.5 The ODBC Driver Setup Pane
    3. Chapter 12. Editing Logical Models: Intermediate Aspects
      1. 12.1 The Database Properties Dialog
      2. 12.2 Table Properties
      3. 12.3 Column Properties
      4. 12.4 Foreign Key Relationships
      5. 12.5 Category Relationships
      6. 12.6 Show Related Tables
      7. 12.7 Views
      8. 12.8 Pagination
      9. 12.9 Verbalization
      10. 12.10 Model Error Check
      11. 12.11 Driver, Document, and Modeling Options (1/2)
      12. 12.11 Driver, Document, and Modeling Options (2/2)
    4. Chapter 13. Editing Logical Models: Advanced Aspects
      1. 13.1 Copying Model Elements
      2. 13.2 Cloning Model Elements
      3. 13.3 Database Properties: Definition and Notes
      4. 13.4 Check Clauses
      5. 13.5 Indexes
      6. 13.6 Triggers
      7. 13.7 Stored Procedures
      8. 13.8 Raw DDL
      9. 13.9 User Defined Functions
      10. 13.10 User Defined Types
      11. 13.11 Extended Properties
      12. 13.12 The Object-Relational Stencil
    5. Chapter 14. Reverse Engineering Physical Schemas to Logical Models
      1. 14.1 Using the Reverse Engineer Wizard
      2. 14.2 Reviewing the Result
      3. 14.3 Handling Errors and Warnings
      4. 14.4 Other Reverse Engineering Options
    6. Chapter 15. Logical Database Model Reports
      1. 15.1 New Report Wizard
      2. 15.2 Statistical Report
      3. 15.3 Table Report (1/3)
      4. 15.3 Table Report (2/3)
      5. 15.3 Table Report (3/3)
      6. 15.4 Data Types Report
  9. Part 4: Managing Database Projects
    1. Chapter 16. Change Propagation and Round-Trip Engineering
      1. 16.1 Overview of Change Propagation
      2. 16.2 Mapping ORM Changes to Logical Models
      3. 16.3 Migrating Logical Model Changes to ORM Models
      4. 16.4 Updating Physical Schemas with Logical Model Changes
      5. 16.5 Refreshing Logical Models with Physical Schema Changes
      6. 16.6 Three-Way Synchronization (1/2)
      7. 16.6 Three-Way Synchronization (2/2)
      8. 16.7 Code Synchronization and Transfer
      9. 16.8 Data Migration
      10. 16.9 DDL Script vs. Automated Update
  10. Chapter 17. Other Features and Best Practices
    1. 17.1 Model Reviews and Presentations (1/4)
    2. 17.1 Model Reviews and Presentations (2/4)
    3. 17.1 Model Reviews and Presentations (3/4)
    4. 17.1 Model Reviews and Presentations (4/4)
    5. 17.2 Librarianship
    6. 17.3 Distributing Your Database Models
  11. Glossary and ORM Notation (1/3)
  12. Glossary and ORM Notation (2/3)
  13. Glossary and ORM Notation (3/3)
  14. Further Resources (1/2)
  15. Further Resources (2/2)
  16. Index (1/4)
  17. Index (2/4)
  18. Index (3/4)
  19. Index (4/4)

Product information

  • Title: Database Modeling with Microsoft® Visio for Enterprise Architects
  • Author(s): Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
  • Release date: September 2003
  • Publisher(s): Morgan Kaufmann
  • ISBN: 9780080491035