DB Visual ARCHITECT 4.0 Designer's Guide

The software and documentation are furnished under the DB Visual ARCHITECT license agreement and may be used only in accordance with the terms of the agreement.

Copyright Information
Copyright © 1999-2007 by Visual Paradigm. All rights reserved.

The material made available by Visual Paradigm in this document is protected under the laws and various international laws and treaties. No portion of this document or the material contained on it may be reproduced in any form or by any means without prior written permission from Visual Paradigm.

Every effort has been made to ensure the accuracy of this document. However, Visual Paradigm makes no warranties with respect to this documentation and disclaims any implied warranties of merchantability and fitness for a particular purpose. The information in this document is subject to change without notice.

All examples with names, company names, or companies that appear in this document are imaginary and do not refer to, or portray, in name or substance, any actual names, companies, entities, or institutions. Any resemblance to any real person, company, entity, or institution is purely coincidental.

Trademark Information

DB Visual ARCHITECT is registered trademark of Visual Paradigm.
Sun, Sun ONE, Java, Java2, J2EE and EJB, NetBeans are all registered trademarks of Sun Microsystems, Inc.
Eclipse is registered trademark of Eclipse.
JBuilder is registered trademark of Borland Corporation.
IntelliJ and IntelliJ IDEA are registered trademarks of JetBrains.
Microsoft, Windows, Windows NT, Visio, and the Windows logo are trademarks or registered trademarks of Microsoft Corporation.
Oracle is a registered trademark, and JDeveloper is a trademark or registered trademark of Oracle Corporation.
BEA is registered trademarks of BEA Systems, Inc.
BEA WebLogic Workshop is trademark of BEA Systems, Inc.
Rational Rose is registered trademark of International Business Machines Corporation.
WinZip is a registered trademark of WinZip Computing, Inc.
Other trademarks or service marks referenced herein are property of their respective owners.

DB Visual ARCHITECT License Agreement

THE USE OF THE SOFTWARE LICENSED TO YOU IS SUBJECT TO THE TERMS AND CONDITIONS OF THIS SOFTWARE LICENSE AGREEMENT. BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE, YOU ACKNOWLEDGE THAT YOU HAVE READ THIS AGREEMENT, UNDERSTAND IT, AND AGREE TO BE BOUNDED BY ALL OF THE TERMS AND CONDITIONS OF THIS SOFTWARE LICENSE AGREEMENT.

1. Limited License Grant. Visual Paradigm grants to you ("the Licensee") a personal, non-exclusive, non-transferable, limited, perpetual, revocable license to install and use Visual Paradigm Products ("the Software" or "the Product"). The Licensee must not re-distribute the Software in whole or in part, either separately or included with a product.
2. Restrictions. The Software is confidential copyrighted information of Visual Paradigm, and Visual Paradigm and/or its licensors retain title to all copies. The Licensee shall not modify, adapt, decompile, disassemble, decrypt, extract, or otherwise reverse engineer the Software. Software may not be leased, rented, transferred, distributed, assigned, or sublicensed, in whole or in part. The Software contains valuable trade secrets. The Licensee promises not to extract any information or concepts from it as part of an effort to compete with the licensor, nor to assist anyone else in such an effort. The Licensee agrees not to remove, modify, delete or destroy any proprietary right notices of Visual Paradigm and its licensors, including copyright notices, in the Software.
3. Disclaimer of Warranty. The software and documentation are provided "AS IS," WITH NO WARRANTIES WHATSOEVER. ALL EXPRESS OR IMPLIED REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. THE ENTIRE RISK AS TO SATISFACTORY QUALITY, PERFORMANCE, ACCURACY AND EFFORT IS WITH THE LICENSEE. THERE IS NO WARRANTY THE DOCUMENTATION, Visual Paradigm's EFFORTS OR THE LICENSED SOFTWARE WILL FULFILL ANY OF LICENSEE'S PARTICULAR PURPOSES OR NEEDS. IF THESE WARRANTIES ARE UNENFORCEABLE UNDER APPLICABLE LAW, THEN Visual Paradigm DISCLAIMS SUCH WARRANTIES TO THE MAXIMUM EXTENT PERMITTED BY SUCH APPLICABLE LAW.
4. Limitation of Liability. Visual Paradigm AND ITS LICENSORS SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY THE LICENSEE OR ANY THIRD PARTY AS A RESULT OF USING OR DISTRIBUTING SOFTWARE. IN NO EVENT WILL Visual Paradigm OR ITS LICENSORS BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, EXEMPLARY, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE, EVEN IF Visual Paradigm HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
5. Termination. The Licensee may terminate this License at any time by destroying all copies of Software. Visual Paradigm will not be obligated to refund any License Fees, if any, paid by the Licensee for such termination. This License will terminate immediately without notice from Visual Paradigm if the Licensee fails to comply with any provision of this License. Upon such termination, the Licensee must destroy all copies of the Software. Visual Paradigm reserves all rights to terminate this License.

SPECIFIC DISCLAIMER FOR HIGH-RISK ACTIVITIES. The SOFTWARE is not designed or intended for use in high-risk activities including, without restricting the generality of the foregoing, on-line control of aircraft, air traffic, aircraft navigation or aircraft communications; or in the design, construction, operation or maintenance of any nuclear facility. Visual Paradigm disclaims any express or implied warranty of fitness for such purposes or any other purposes.

NOTICE. The Product is not intended for personal, family or household use; rather, it is intended exclusively for professional use. Its utilization requires skills that differ from those needed to use consumer software products such as word processing or spreadsheet software.

GOVERNMENT RIGHTS. If the Software is licensed by or on behalf of a unit or agency of any government, the Licensee agrees that the Software is "commercial computer software", "commercial computer software documentation" or similar terms and that, in the absence of a written agreement to the contrary, the Licensee's rights with respect to the Software are limited by the terms of this Agreement.

Acknowledgements

This Product includes software developed by the Apache Software Foundation (http://www.apache.org). Copyright © 1999 The Apache Software Foundation. All rights reserved.

Table of Contents

Chapter 1 - Working with DB Visual ARCHITECT

Introduction
Key Benefits
Database Configuration

Database Configuration for Java Project
Database Configuration for .Net Project

Supported Database, JDBC Drivers and .NET Drivers
Supporting Multiple Database

Assigning Data Types from Multiple Database
Displaying Data Type based on Default Database

Chapter 2 - Using Wizard

Introduction
Generating Code from Database
Generating Code and Database from ERD
Generating Code and Database from Class Diagram

Chapter 3 - Designing Object Model with UML Class Diagram

Introduction
Creating Object Model with Class Diagram

Drawing a Class Diagram
Synchronizing from Data Model to Object Model

Defining Package for Classes
Specifying Stereotypes
Specifying Inheritance Strategy
Specifying Collection Type
Defining ORM Qualifier
Customizing SQL

Chapter 4 - Designing Data Model by Entity Relationship Diagram

Introduction
Creating Data Model by Entity Relationship Diagram

Drawing an Entity Relationship Diagram
Synchronizing from Object Model to Data Model

Specifying Primary Key
Specifying Index Column
Using the ID Generator
Defining Discriminator

Defining Discriminator Column for Entity
Defining Discriminator Value for Class

Creating an Array Table

Defining an Array Table
Defining an Array Type for Attribute in Class

Creating a Partial Table

Splitting Table
Converting to a Partial Table

Copying SQL Statements from Tables

Copying SQL Statements from Specified Scope

Chapter 5 - Reverse Engineering Classes and Databases

Introduction
Reverse Engineering Classes

Reverse Engineering Java Classes to Object Model
Reverse Engineering Hibernate Model to Object Model
Using ORM Pane

Reverse Engineering Relational Database

Using Reverse Database Facility
Using ORM Pane

Chapter 6 - Mapping Object Model to Data Model and vice versa

Introduction
Mapping Object Model to Data Model

Mapping Classes to Entities
Mapping Attributes to Columns
Mapping Data Type
Mapping Primary Key
Mapping Association
Mapping Aggregation
Mapping Composite Aggregation
Mapping Multiplicity
Mapping Many-to-Many Association
Mapping Inheritance/Generalization
Mapping Collection of Objects to Array Table
Mapping Object Model Terminology

Mapping Data Model to Object Model

Mapping Entities to Classes
Mapping Columns to Attributes
Mapping Data Type
Mapping Primary Key
Mapping Relationship
Mapping Cardinality
Mapping Many-to-Many Relationship
Mapping Array Table to Collection of Objects
Mapping Data Model Terminology

Showing Mapping by ORM Diagram

Creating an ORM Diagram from Existing Diagrams
Drawing an ORM Diagram
Showing Attribute Mapping
Supporting Real-time Synchronization
Switching the View of Mapping

Visual Paradigm International Limited Website: www.visual-paradigm.com E-mail: support@visual-paradigm.com