SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 140 / 271

Permanent Table Space
In SPD Server, large production, inventory, and sales data storage areas work best using
permanent table space. A rolling five-year sales data table by division and company is an
example of an SPD Server structure that is best suited to permanently allocated space on
the enterprise computers. Organizations can rely on large quantities of production,
inventory, or sales data that is updated on a day-to-day, or even shift-to-shift basis. These
data repositories require permanent, secure processing space that only can be accessed by
a select group of key users. Allocating permanent space for the data ensures that sufficient
disk space required for the combination and manipulation of large amounts of data from
multiple large warehouse tables is always available.
For example, an organization might call such a tightly controlled, permanently defined area
the "production" data space. Data analysts in organizations typically manipulate
production-type data to produce smaller, more focused reports. Analyst reports often
benchmark specific areas of performance or interest. Regular analyst reports are frequently
distributed across the organization. The distributed analyst reports, while not as critical as
the production, inventory, or sales data, should also use permanently defined data spaces
that are separate from the permanent production reporting table spaces. In such instances,
134
Chapter 12 • Setting Up SPD Server Libname Parameter Files