Chapter 14. Database Design & Engineering

• 1. Introduction
  • Database design & management with Visual Paradigm
  • Database configuration
  • Supported database, JDBC drivers and .NET drivers
• 2. Database Designer’s Guide
  • How to draw an ERD
  • Conceptual, logical and Physical data model
  • Using entity domain
  • Using column domain
  • Applying default schema on ERD
  • Using auto column
  • Entering sample table records for entities
  • Modeling database view
  • Modeling stored procedures in ERD
  • Modeling database triggers in ERD
  • Working with unique constraint
  • Defining ID Generator for primary key generation
  • Applying inheritance strategies
  • Using discriminator column
  • Using Array table
  • Using Partial table
  • Mapping object model to data model
  • Mapping data model to object model
  • Synchronizing object model and data model
• 3. Database Management Guide
  • How to reverse engineer ERD from database
  • How to reverse engineer ERD from DDL
  • How to generate database from ERD
  • Patching ERD changes to database
  • Copying SQL statements from entities in ERD
• 4. Programmer’s Guide
  • What is Object Relational Mapping (ORM)?
  • How to generate ORM code from database
  • How to generate ORM code from Class Diagram
  • PersistentManager and Transaction
  • Using ORM Qualifier
  • Using ORM Criteria