Creating an SQL conceptual model

Introduction

The SQL Designer module provides services for modeling databases at the conceptual (data model) and logical (table model) levels.

The term conceptual model refers here to a UML class model that has been annotated ready for the generation of SQL script files. This model also serves as the data model for the Hibernate Designer module.

Creating an SQL conceptual model

They are two methods for obtaining an SQL persistence model:

Manually creating a new model

The SQL Designer module comes with a set of commands for use when building a class model annotated for the generation of SQL script files.

List of commands:

Transforming an existing class model

An existing UML class model can be transformed into an SQL persistence model. To do this, simply select the package containing the classes that you want to make persistent and then check the “Persistent” tickbox in the SQL tab.

If you uncheck this tickbox, then an SQL model will be transformed into a class model.

The “Persistent” property