O'Reilly logo

SAS 9.4 Intelligence Platform: Overview, Second Edition, 2nd Edition by

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 3
Data in the SAS Intelligence
Platform
Overview of Data Storage Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Default SAS Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Third-Party Data Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Hadoop Data Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Parallel Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Parallel Storage Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Options for Implementing Parallel Storage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
How Parallel Storage Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Multidimensional Databases (Cubes) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
How Data Sources Are Managed in the Metadata . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Creation of Metadata Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Information Maps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
SAS Business Data Network . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
SAS Lineage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Overview of Data Storage Options
In a SAS Intelligence Platform deployment, you can use one or more of these data
storage options:
default SAS storage in the form of SAS tables
third-party relational, hierarchical, and network model database tables
parallel storage from the SAS Scalable Performance Data Engine (SPD Engine) and
the SAS Scalable Performance Data Server (SPD Server)
multidimensional databases (cubes)
All four data sources provide input to reporting applications. The first three sources are
also used as input for these data structures:
cubes, which are created with either SAS Data Integration Studio or SAS OLAP
Cube Studio
data marts and data warehouses, which are created with SAS Data Integration Studio
You can use these storage options in any combination to meet your unique business
requirements.
17

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