Various Features to support Database Modeling

DBMode offers various features to support Database Modeling. For example,

  • Original Properties dialog for Table
  • MS-Excel documents
  • Table list view
  • Model Checker
  • Define and use Domains
  • CRUD matrix
  • and much more...

[Properties Dialog for Table]

You can use Properties dialog which is highly tuned for Database Tables(Classes with stereotype <<table>>).
By using this dialog, you can edit Table name and various properties effectively.
Columns, Primary Keys, Unique constraints, Indexes, Check constraints and Foreign Keys are editable in this dialog.

[MS-Excel Documents]

You can auto-generate documents of all Tables in MS-Excel format.
The document contains Table list and details of each Table.
You can select '.xls' format or '.xlsx' format as you like.

[Table List View]

You can see Tables as list view. The list contains all Tables in your model.
In this list view, you can add or delete Tables, sort Tables, add groups to organize Tables, etc. You can also launch most of DBMode features from this list.

[Model Checker]

Model Checker is a feature that checks Name, Alias, Columns, Keys, Constraints, etc. for each Table. Inconsistencies in Tables will be reported.

Rules of checking

DBMode supports 3 kinds of checking. They are Input data check, Logical data check and Consistency check.

  • Input data check : missing Table name, duplicate name or alias of Tables, missing name of Columns, Keys and Constraints, etc.
  • Logical data check : no defined Columns for Tables, existence of Columns which related to Keys or Constraints, etc.
  • Consistency check : Consistency between Primary keys and Foreign keys, etc.

[Define and Use Domains]

You can define Domains (Definition of columns that can be used in common between tables) and assign them to Tables.
In DBMode, each Domain contains series of Column name/alias/data type (Data Type, Length, Precision and Scale), Not NULL, Default value and Comments.
You can assign Domains to Tables. Domains behave similar to Columns. You can assign a Domain to multiple Tables.
When you change value(s) in Domain, all Tables which use the Domain will be automatically updated.

Domains in DBMode can contain multiple Columns. (Composite Domain)
Composite Domain can be used for the structured data. For example, you can use it for address (Zip code, state, city, etc.)

Domain Matrix

Domain Matrix can unitarily manage relationships between domains and tables.

[CRUD Matrix]

You can manage 4 types of operations (CRUD) for Tables in matrix view. CRUD stands for Create, Read, Update and Delete. They are 4 main operations for Tables.

In CRUD matrix, operations for Tables are shown as Create (Insert), Read (Select), Update and Delete.
CRUD matrix is viewed in matrix form. Columns represent Tables, and rows represent other types of elements. By updating each cell, you can show operations between Table and element.

When you save the CRUD matrix, each cell is saved as UML Dependency between Table and element.
CRUD operations are shown as their stereotypes.