Tabla de Contenidos

1. Introducción

Acerca de Power*Architect
Acerca de esta Guía
Licencias y Distribución de Power*Architect
Licencia Power*Architect

2. Comenzando a trabajar

Acerca de los Modelos de Datos
Acerca del Análisis de la Estructura de Datos
Copiando y Transformando los Datos
Acerca de las funcionalidades avanzadas
Acerca de las Preferencias de Sistema
Comprendiendo el interfaz de usuario de Power*Architect
Acerca del Arbol de Base de Datos
Acerca del Area de Trabajo
Ejemplo - Creando un Modelo de Datos
Configurando Bases de Datos
Diseñando una Base de Datos
Ingeniería Directa
Comparando Modelos de Datos

3. Creating a Data Model ............................................................................................. 12

Working with Tables ........................................................................................... 12

Creating New Tables ................................................................................... 12

Modifying Tables ........................................................................................ 13

Working with Columns ........................................................................................ 13

Creating New Columns ................................................................................ 13

Modifying Columns ..................................................................................... 15

Moving Columns ......................................................................................... 16

Working with Primary Keys .................................................................................. 16

Working with Relationships .................................................................................. 17

About Identifying and Non-Identifying Relationships ....................................... 17

Creating Relationships .................................................................................. 17

Modifying a Relationship .............................................................................. 18

Working with Indices ........................................................................................... 21

Creating an Index ........................................................................................ 21

Modifying an Index ..................................................................................... 24

Deleting an Index ........................................................................................ 24

Working with Diagram Objects in the Playpen ......................................................... 24

Using Undo and Redo .................................................................................. 24

Selecting Multiple Objects in the Playpen ........................................................ 25

Deleting Diagram Objects in the Playpen ......................................................... 25

Rearranging Diagram Objects in the Playpen .................................................. 25

Automatically Arranging Tables in the Playpen ............................................... 25

Straightening Diagram Lines in the Playpen ................................................... 26

Using the Playpen Zoom Options ................................................................... 26

Finding and Replacing Playpen Objects ........................................................... 26

Printing or Exporting a Data Model Diagram .................................................. 27

4. Setting up Database Support ...................................................................................... 28

Supported Database ............................................................................................. 28

Setting up Database Types .................................................................................... 28

Adding a New Database Type ....................................................................... 29

Power*Architect User Guide

v

Defining the JDBC Driver ............................................................................ 31

Setting up Database Connections ............................................................................ 32

Creating a New Database Connection ............................................................. 32

Adding or Removing Database Connections for a Project .................................. 34

Modifying or Deleting Database Connections ................................................. 34

5. Setting Preferences ................................................................................................... 36

Defining Project Settings ...................................................................................... 36

Setting User Preferences ....................................................................................... 37

6. Reverse Engineering a Data Model ............................................................................. 40

7. Forward Engineering a Data Model ............................................................................. 42

8. Analyzing Data Structures ......................................................................................... 45

Comparing Data Models ....................................................................................... 45

Data Model Comparison with English Descriptions ................................................. 46

Data Model Comparison in SQL Script ................................................................... 46

Profiling Data ..................................................................................................... 46

Setting the Profile Mode ............................................................................... 47

Creating a Profile ........................................................................................ 47

Viewing Profile Details ................................................................................ 48

Using Profile Graph View ............................................................................ 48

Using Profile Table View ............................................................................. 49

Deleting Profiles ......................................................................................... 50

Saving Your Profile Results in a PDF ............................................................. 50

Creating a Visual Mapping Report ......................................................................... 50

Exporting Column Mappings ................................................................................. 50

9. Copying and Transforming Data ................................................................................. 51

Copying Data Across Database Platforms ................................................................ 51

Using Kettle Jobs ................................................................................................ 52

Before Creating a Kettle Job ......................................................................... 52

Creating a Kettle Job ................................................................................... 52

10. SQLRunner ........................................................................................................... 55

Output (Results) Window ..................................................................................... 56

Output Formats ................................................................................................... 56

11. Troubleshooting ..................................................................................................... 58

12. Glossary ............................................................................................................... 59

13. Appendices ........................................................................................................... 61

Appendix A: GNU GPL Version 3 ......................................................................... 61

Appendix B: Third Party Licenses .......................................................................... 70

The FAMFAMFAM Silk Icon Set .................................................................. 70

The Apache Software Foundation ................................................................... 70

JGoodies Karsten Lentzsch ........................................................................... 74

PostgreSQL JDBC Driver ............................................................................. 74

iText ......................................................................................................... 75

JFree ......................................................................................................... 81

Darwin Systems .......................................................................................... 84

JUnit ......................................................................................................... 84

Pentaho Data Integration ............................................................................... 84

The Eclipse Foundation ................................................................................ 85

Sun Microsystems ....................................................................................... 85