Administrador de Base de Datos

EA supports a range of features for the administration of databases, including the modeling of database structures, importing database structures from an existing database and the generation of DDL for the rapid creation of databases from a model.

Create Logical Data Models
With Enterprise Architect the Database Administrator can build database diagrams using the built-in UML Data Modeling Profile. This supports the definition of primary and foreign keys, cardinality, validation, triggers, constraints and indexes.

Generate Schema
By using Enterprise Architect's DDL generation function the Database Administrator can create a DDL script for creation of the database table structure from the model. EA currently supports JET-based databases, DB2, InterBase, MySQL, SQL SERVER, PostgreSQL, Sybase Adaptive Server Anywhere and Oracle 9i and 10g.

Reverse Engineer Database
Using an ODBC data connection the Database Administrator can import a database structure from an existing database to create a model of the database. Generating the model directly from the database allows the DBA to quickly document their work and create a diagrammatic account of a complex database through the graphical benefits of UML.

Vea:
• Esquema de Base de Datos
• Creando un Diagrama de Modelo de Datos
• Creando una Tabla
• Configurando las propiedades de una Tabla
• Creando Columnas
• Creando Claves Primarias
• Creando Claves Foráneas
• Creando Índices y Disparadores
• Generar DDL para una Tabla
• Generar DDL para un Paquete
• Conversión de datos para una Tabla
• Conversión de tipo de datos para un Paquete
• Personalizando tipo de datos para DBMS
• Importando un esquema de Base de Datos desde un ODBC