Data Modeling Toolbox
The Data Modeling Toolbox provides a basic set of elements for database modeling and database design, in conjunction with the UML Data Modeling Profile.
Data Modeling Toolbox page
|
|
|
|
In the data model, a:
- Table defines a database table
- View represents a database view
- Procedure represents database (or Stored) procedures
- Sequence represents a database Sequence
- Function represents a database Function
- Database Connection helps you to configure a connection to the database you are modeling, for testing, import and export of schema, and comparison of differences between database and model using the Database Builder
When you drop this icon onto the diagram the system prompts you to indicate whether to create the connection for an Access database, a Firebird database or an ODBC database
For the first two options, when you click on the OK button the system prompts you to select the file to create the connection to
If you select the 'ODBC database' option, the 'Select Data Source' dialog displays; click on the 'Machine Data Source' tab and select the data source (project on a database)
After you have defined the data source, when you double-click on the element the Database Builder view opens for the current database model
- SQL Query is an Artifact element that provides a convenient mechanism for storing an SQL Statement in the repository, for repeated execution on live database(s)
|
Tables
Database Views
Database Procedures
Database Sequences
Database Functions
The Database Builder
Database SQL Queries
|
Notes
- To add an element to the currently-open diagram, click on the appropriate icon and drag it into position on the diagram; set an element name and other properties as prompted
- To add a relationship, click on the appropriate icon, then click on the start element in the diagram and drag to the end element
Learn more
