You are here: Visual LANSA Logical Modeler > 1. Introduction to Data Modeling > 1.5 Overview of the LANSA Logical Modeler > 1.5.7 Building a Physical Database

1.5.7 Building a Physical Database

Once created, a model can be built into a physical database. The build process takes all of the element, entity and relationship information and creates fields and tables in the LANSA Repository. In addition, it creates logical views, access routes and validation rules as the result of relationships defined within the model.

Building a model consists of three phases for each entity.

Building Elements

Entity elements are implemented as fields in the LANSA Repository. They also become fields in the files that are generated from entity definitions.

Building Entities

Data and Variant entities are implemented as database tables in the LANSA Repository. Conceptual entities are implemented as fields only.

Entities that are implemented as tables will contain fields that have been created from the element definitions. In addition, fields may be created and attached to the file for elements that are inherited as the result of relationships with other entities.

Note that External entities are not implemented in the LANSA Repository, as they represent files that already exist.

Building Relationships

As well as relationships influencing the fields that are created for a database table, they are also implemented as referential integrity validation rules, logical views and access routes in the LANSA Repository.


For more details, refer to 10. Building a Model.