Products & Solutions / Foundation Tools

SAS® Scalable Performance Data Server®

A data storage system optimized to deliver data subsets quickly and on demand

SAS® Scalable Performance Data Server® delivers subsets of information harvested from large stores of enterprise data, quickly and on demand. The solution ensures that business intelligence and analytic applications maintain consistent performance and that extraction, transformation and loading (ETL) processes do not exceed the time windows that are available.

Benefits

  • Significantly speed up the gathering of subset information.
  • Optimize the performance for reporting and analytic applications.
  • Reduce data integration processing times, irrespective of data size.

Read more

Features

  • Partitioning and parallel processing
  • Unique indexing technology
  • Query optimization
  • SQL Pass-Through support
  • Management and security

Read more

How SAS® Is Different

  • Data storage system that is optimized to quickly load and retrieve subsets of data. Large-scale analytic and reporting applications will benefit from the swift access to de­tail data stored in this server.
  • Speeds the processing of large amounts of data by partitioning the data across multiple disks and I/O channels. This enables parallelization of many SAS I/O functions over multiple data partitions.

Benefits

  • Significantly speed up the gathering of subset information. Most reporting and analytic applications require only a subset of enterprise data. SAS Scalable Performance Data Server uses parallel storage technologies and hardware to reduce overhead, such as the two-phase commit, which is incurred with transactional systems. This significantly shortens search and delivery times.
  • Optimize the performance for reporting and analytic applications. By separating the transactional data store from the reporting and analytic application data stores, each can be tuned for the appropriate task requirements. You get better performance for reporting and analyses while reducing the load on operational systems.
  • Reduce data integration processing times, irrespective of data size. An integrated extraction, transformation and loading process moves data from transactional systems to the SAS Scalable Performance Data Server, using parallel storage and efficient indexing. This reduces processing time, allowing data and indexes to be refreshed rapidly, regardless of data size. The use of integrated metadata ensures data consistency and reduces the time spent maintaining vast quantities of data.

Features

Partitioning and parallel processing
  • Partitions across multiple CPUs, I/O channels and disks.
  • Supports the dynamic clustering of tables with identical structures.
  • Uses parallel CPUs and I/O for summarizations.
  • Supports the use of table aliases.
  • Integrates into the SAS SQL engine.
  • Provides multithreaded WHERE clause processing.
  • Evaluates subsetting criteria using WHERE clause planning.
  • Supports full table scans where no indexes are defined.
  • Launches multiple threads to process different portions of a table simultaneously.
  • Evaluates strategies for query processing to determine the least resource-intensive option via WHERE planner costing feature.
  • Uses memory lookups in phase two of a star join instead of index points to a table enhances performance.
Unique indexing technology
  • Combines the best features of B-tree indexes and bitmap indexes by using a hybrid bitmap index.
  • Analyzes each table and determines the best indexing option.
  • Builds and updates multiple indexes with a single read of a data table.
  • Maintains a table of statistics about indexes.
  • Offers a new SQL reset option that increases the maximum number of hash joins that are available.
Query optimization
  • Provides star schema optimization and parallel and optimized join methods for data models other than star schemas.
  • Uses transparent restructuring and recoding of nested SQL code to create temporary tables on the fly for accelerated processing.
  • Performs fast sorting on BY statements.
  • Sorts on subsets of data identified with a WHERE clause or KEEP list. 
  • Creates single sort bins larger than 2GB to reduce the number of bins needed to complete the sort.
  • Provides star join optimizations for use in more unique query instances.
SQL Pass-Through support
  • Sends server-specific SQL statements directly to the server for execution.
  • Triggers multiple, independent SQL statements for parallel execution.
  • Offers the option of using a SAS library (LIBNAME statement).
Management and security
  • Handles large numbers of users and increasing amounts of data.
  • Offers dynamic cluster tables for enhanced manageability and scalability of large tables.
  • Allocates and addresses more than 2GB of memory at a time by using 64-bit, wide-mode support.
  • Provides a sophisticated security implementation that gives administrators read, write and modification access to tables on a per-user or per-group basis.
  • Ensures data integrity and consistency throughout the business intelligence and analytic application life cycle via the SAS common metadata framework.
  • Offers a central point of control and administration via the SAS Management Console.
  • Allows user names to begin with either a character or a number.
  • Provides row-level security using WHERE constraints.

System Requirements

Host Platforms/Server Tier
  • HP/UX on Itanium: 11iv3 (11.31)
  • IBM AIX R64 on POWER architecture 7.1
  • IBM z/OS: V1R11 and higher
  • Linux x64 (64-bit): Novell SuSE 11 SP1; Red Hat Enterprise Linux 6.1; Oracle Linux 6.1
  • Microsoft Windows on x64 (64-bit):
    Desktop: Windows 7* x64 SP1; Windows 8** x64
    Server: Windows Server 2008 x64 SP2 Family; Windows Server 2008 R2 SP1 Family; Windows Server 2012 Family
  • Solaris on SPARC: Version 10 Update 9
  • Solaris on x64 (x64-86): Version 10 Update 9; Version 11
Client Tier
  • Microsoft Windows (64-bit): Windows 7* x64 SP1; Windows 8** x64

Please consult your local SAS sales representative if you have questions about your platform requirements. Also, for more detailed information, please visit our support site at http://support.sas.com/resources/sysreq/.

Required Software
  • Base SAS®

Please contact your SAS representative with any additional questions about technical requirements.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.