Introduction to the SPD Engine

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 loads
  • parallel index creation
  • 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.