4.4 Logical Model

A physical view can only be exposed to end users through a logical model.

A logical model presents a business-oriented, easy-to-understand view of a single underlying physical view. The logical model organizes data from the physical view into logical entities that correspond to business world objects, rather than to the underlying physical tables. Each entity contains one or more attributes that map to database table columns from the physical view. Logical models can also extend existing database fields using formula (expression) attributes.

The mapping of tables and fields into entities and attributes is not a simple regrouping. Rather, the logical model denormalizes or adds redundancy to the data, in order to maximize simplicity for designers and end users.

<< 4.3.4 Extending a Physical View © 1996-2013 InetSoft Technology Corporation (v11.4) 4.4.1 Creating a Logical Model >>