The SPD Engine
is designed for high-performance data delivery. It enables rapid access
to SAS data for processing by the application. The SPD Engine delivers
data to applications rapidly because it organizes the data into a
streamlined file format that takes advantage of multiple CPUs to perform
parallel input/output functions.
The SPD Engine
uses
threads to read blocks of data very
rapidly and in parallel. The software tasks are performed in conjunction
with an operating system that enables threads to execute on any of
the computer's available CPUs. Although threaded I/O is an important
part of the SPD Engine functionality, the real power of the SPD Engine
comes from the way that the software structures SAS data. The SPD
Engine organizes data into a new file format that includes partitioning
of the data. This data structure permits threads, running in parallel,
to perform I/O tasks efficiently.
Although it is not intended
to replace the default Base SAS engine, the SPD Engine is a high-speed
alternative for processing very large data sets. It reads and writes
data sets that contain millions of observations. For example, this
includes data sets that expand beyond the 2-gigabyte size limit imposed
by some operating systems and data sets that SAS analytic software
and procedures must process faster.
The SPD Engine performance
is boosted in the following ways:
-
support for gigabytes of data
-
scalability on symmetric multiprocessor
(SMP) computers
-
parallel WHERE selections
-
-
-
parallel I/O data delivery to applications
-
automatic sorting on BY statements
The SPD Engine runs
on UNIX, Windows,
z/OS (zFS file system only), and OpenVMS on HP Integrity
Servers (ODS-5 file systems only).
Note: Be sure to visit the Scalability
and Performance focus area at
http://support.sas.com/rnd/scalability
for more information about scalability
in SAS 9.3. For system requirements, visit the Install Center at
http://support.sas.com/documentation/installcenter
.