PSQL User Manual

Jan Pernica


Table of Contents

Preface
1. PSQL Installation
Requirements
Installation
Registration in the UML Suite
2. Running GUI PSQL
From UML Suite
From command-line
3. Using PSQL
Import XMI file
Import XMI file of the phase
Import XMI file of the package
Symbols in the table tree
Setting the table column order
Creating and modifying indexes
Saving of imported XMI file
Create script generation
Alter script generation
4. Physical modeling in the UML
Entities
Columns
Primary keys
Foreign Keys
Primitive types
User-defined types
Structured types
Column names
Mandatory columns
CHECK
DEFAULT
Relationships
1:1
1:N
Composition
M:N
Associative relationship
N-ary associations
Generalisation
Deployment parameters
5. Reverse engineering
From database
From PSQL into XMI
From PSQL into XMI using original graphical layout
6. Customise generation
Adding new database engine
Customise existing templates
A. Informix specials
B. PSQL XML
C. PSQL DTD
D. Setting of common JDBC drivers

List of Figures

3.1. Column ordering example
3.2. SQL Script generation
5.1. Reverse engineering
5.2. Database connection dialog

List of Tables

3.1. Used symbols
A.1. Generaion of INTERVAL and DATETIME in Informix (v1)
A.2. Generaion of INTERVAL and DATETIME in Informix (v2)
D.1. JDBC drivers