Database Modeling with Microsoft Visio for Enterprise Architects
- 5h 57m
- Bill MacLean, Ken Evans, Patrick Hallock, Terry Halpin
- Elsevier Science and Technology Books, Inc.
- 2003
Database Modeling with Microsoft Visio for Enterprise Architects explains how to use the database modeling solution in VEA, providing information unavailable anywhere else. Although primarily focused on tool features, the book also provides an introduction to data modeling using Object-Role Modeling (ORM), a conceptual approach to data modeling that is gaining increased adoption in industry. This book also includes practical, tool-agnostic advice on managing database projects. Written by four top ORM veterans, including one of the creators of VEA, this book provides unsurpassed insight and guidance to the deep functionality of this solution.
- 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 ORM and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects
About the Authors
Dr. Terry Halpin is a professor at Northface University and is the world’s foremost authority on ORM. He has led database research teams at several companies, including Visio Corporation and Microsoft Corporation, where he worked on the conceptual and logical database modeling technology in Microsoft Visio for Enterprise Architects. His publications include over 100 technical papers and five books.
Ken Evans has taught and applied ORM in English and French for 10 years. His know-how in data and process modeling and complex systems management comes from over 30 years in industry, including international jobs with IBM, EDS, Honeywell Controls, and Plessey and clients among the Fortune 500.
Patrick Hallock, M.S., is the founder of InConcept, a consulting firm, and teaches object modeling throughout the United States. He has been in the industry for 30 years, focusing on database design, with an emphasis on ORM.
Bill MacLean, CPA, is an independent consultant and teacher who has worked with relational databases for over 15 years, and consulted in database design for the last 9. He believes that the purpose of a data model is to turn business requirements into buildable specifications.
In this Book
-
Introduction
-
Database Modeling
-
Getting Started
-
Object Types, Predicates, and Basic Constraints
-
ORM Constraints
-
Configuring, Manipulating, and Reusing ORM Models
-
Mapping ORM Models to Logical Database Models
-
Reverse Engineering and Importing to ORM
-
Conceptual Model Reports
-
Creating a Basic Logical Database Model
-
Generating a Physical Database Schema
-
Editing Logical Models—Intermediate Aspects
-
Editing Logical Models—Advanced Aspects
-
Reverse Engineering Physical Schemas to Logical Models
-
Logical Database Model Reports
-
Change Propagation and Round Trip Engineering
-
Other Features and Best Practices
