Developing a new application that includes a database¶
A large-scale application is being developed. This application uses a database whose architecture plays a strategic role in the development that is underway.
- Model your database at conceptual or logical level using the modeling services provided by SQL Designer.
- Generate the SQL database script from the table model using the “Generator: SQL Script” command.
- Transform the table model into a data model using the “Transformation: Table Model to Data Model” command.
- Generate the persistent model’s Java classes and the associated Hibernate mapping files using the “Hibernate & Java Generation” command.
You have just produced your application’s Java data model, your database’s SQL script and the Hibernate mapping files used to ensure object / relational mapping between the Java objects and the database.