O'Reilly logo

Data Preparation for Analytics Using SAS by Gerhard Svolba

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required