Data Preparation for Analytics Using SAS

Chapter 6

Data Models

 

6.1 Introduction

6.2 Relational Model and Entity Relationship Diagrams

6.3 Logical versus Physical Data Model

6.4 Star Schema

6.5 Normalization and De-normalization

 

6.1  Introduction

The source systems, which we discussed in Chapter 5 – The Origin of Data, and which we will use to access data, store the data in a certain data model. Except in the case of a flat table, where we have only a single table to import, in most situations we will incorporate a number of tables. These tables have a certain relationship to each other, which is described by a data model.

We will consider the possible data models that are frequently encountered, namely the flat table, the relational model, and the star schema. We will go into ...