Chapter 4 Building an Information Liquidity Model

Defining Databases in an ILM

A database represents a data store. It is based on a relational model and stored in one or several Physical Data Models. Data connection links indicate how to move the data it contains using replication processes.

A database belongs to a package and can be associated with one or more Physical Data Models (PDM) to describe it contents.

Some commands in the contextual menu of the database can help you build a PDM, if you do not already have one:

Reverse Engineer Database: Allows you to generate a PDM from an existing database schema. You first need to fill ODBC connection information to proceed to the reverse, then the reverse automatically creates and attaches the PDM to the database
All database generation features are also available

A database has the following symbol in the diagram:

Opening the associated Physical Data Model
You can also open the Physical Data Model associated with the database by right-clicking the database symbol in the diagram, and selecting Open Model. If several PDMs are associated, a Model Selection dialog box is displayed to let you select the model to open.

A database can have internal and external shortcuts.