Prev | Next |
Opening the Database Builder
When you first open the Database Builder, it searches the entire project for all Packages that have the stereotype <<Data Model>> and loads the corresponding data models as root nodes into the tree. A grayed-out icon indicates that the details of the data model are not loaded.
This figure shows the Database Builder with a single unloaded data model called 'Orders (postgres)'.
Using the Database Builder
You can start working in the Database Builder in one of these two ways:
Task |
Action |
See also |
---|---|---|
Create a new data model |
Once you have opened the Database Builder view, right-click in the empty space of the tree and select 'New Data Model' to invoke the Model Wizard (Start Page 'Create from Pattern' tab). |
Create a Data Model from a Model Pattern |
Load an existing Data Model |
Once the Database Builder view is opened, load any of the defined data models by either:
|
Data Model Properties
In earlier versions of Enterprise Architect (prior to the introduction of the Database Builder) it was necessary for the data modeler to manually set properties on database objects before some tasks were allowed. For example, Enterprise Architect would not allow the definition of a Table column without the Table first being assigned a DBMS. This was because the DBMS controls the list of available datatypes.
To improve efficiency and the user experience, the Database Builder defines defaults for a number of properties at the data model level and then applies these default values automatically whenever new objects are created.
Properties
Option |
Description |
---|---|
DBMS |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: Defines the DBMS of the current data model Extra Information:
|
DefaultOwner |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: Defines the default Owner for the current data model Extra Information:
|
DefaultConnection |
Defined against: The data model's <<Database>> Package Defined as: Tagged Value Details: (Optional) the name of the default connection Extra Information:
|
Notes
- If a data model is selected in the Browser window when the Database Builder is opened, that model's details will be automatically loaded