Information and Data Modeling
Enterprise Architect allows you to capture conceptual, logical and physical data models with one tool in the same model repository. You can import schemas from existing databases or automatically generate database scripts from your modeled schema, providing end-to-end traceability from concept to implementation.
Built-in data modeling profile
Enterprise Architect's built-in Data Modeling profile extends the UML to provide an intuitive mapping from the database concepts of tables and relationships onto the UML concepts of classes and associations. These extensions model database keys, triggers, constraints, RI and other relational database features. Enterprise Architect also supports Entity-Relationship (ER) notation.
When designing or documenting databases, Enterprise Architect will help to:
- Create a Data Model diagram to visualize your database schema
- Create tables and views
- Create columns, primary keys, foreign keys
- Create stored procedures
- Create indexes, sequences, functions and triggers
- Generate DDL for a table or an entire package
- Convert datatypes for a table, package or entire DBMS
- Import a database schema from an ODBC data source.
Click to enlarge
Database engineering support for major DBMS products
Enterprise Architect models and generates database schemas for numerous DBMS products:
- DB2
- Firebird
- Microsoft Access
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL