4.2 Creating a Data Model

Once you have defined a data source, you can proceed to create queries and data models. Data models are logical abstractions of database schemas, similar to Entity-Relation Models. In Style Intelligence, a full data model includes the following four components:

Physical view, comprising database tables, fields, and joins

Logical model, a logical mapping to meaningful business units

Virtual private models, data-level security for controlled access

OLAP overlay hierarchical model, a mapping to dimensions/measures

A basic data model includes just the physical view and the logical model. The following example demonstrates how to create these essential components. For full information on all aspects of data models, see Relational Databases in Data Modeling.

<< 4.1 Defining a Data Source © 1996-2013 InetSoft Technology Corporation (v11.4) 4.2.1 Creating the Physical View >>