Overview: 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
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.2. For system requirements, visit the Install Center at http://support.sas.com/documentation/installcenter.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.