Tabla de Contenidos
Acerca de Power*Architect
Acerca de esta Guía
Licencias y Distribución de Power*Architect
Licencia Power*Architect
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
