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

Image

Detail

See also

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)

Database Functions Database SQL Queries Database Views The Database Builder Database Sequences Database Procedures Table

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