Table of Content

DB Visual ARCHITECT 4.0 Designers Guide

Chapter 1 - Working with DB Visual ARCHITECT

Introduction
Key Benefits
Database Configuration

Database Configuration for Java Project

Configuring Multiple Database Settings
Specifying JDBC Driver File
Supporting Automatic Download of JDBC Driver

Database Configuration for .Net Project

Configuring Multiple Database Settings
Specifying .NET Driver File and Adapter File
Supporting Automatic Download of .NET Driver and Adapter File

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

Adding Class

Adding ORM-Persistable Class
Modifying Class Specification

Adding Attribute

Modifying Attribute Specification

Adding Association

Modifying Association Specification

Adding Operation

Modifying Operation Specification

Adding ORM Implementation Class

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

Adding Entity

Modifying Entity Specification

Adding Column

Modifying Column Specification

Adding Relationship

Modifying Relationship Specification

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 Java Classes by Class View

Reverse Engineering Relational Database

Using Reverse Database Facility

Step 1: Select Language
Step 2: Database Configuration
Step 3: Selecting Tables

Using ORM Pane

Reverse Engineering Database by Database View

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

Using Table per Class Hierarchy Strategy
Using Table per Subclass Strategy
Using Mixed Strategies

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 Identifying Relationship
Mapping Non-identifying 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

Creating ORM-Persistable Class and Mapping Entity to the ORM Diagram
Creating Associated ORM-Persistable Class to the ORM Diagram
Creating Mapping Entity to the ORM Diagram

Showing Attribute Mapping
Supporting Real-time Synchronization

Forming a Class Diagram
Modifying ORM-Persistable Class
Modifying Entity

Switching the View of Mapping