SAS^® Scalable Performance Data Server^®

In the Spotlight SAS Scalable Performance Data Server Fact Sheet •   Product Overview •   Key Benefits •   Complete Features List •   Technical Requirements

What is SAS Scalable Performance Data Server? SAS Scalable Performance Data Server is optimized to deliver subsets of information that need to be harvested from large stores of enterprise data, quickly and on demand.

Why is SAS Scalable Performance Data Server important? The capabilities of the SAS Scalable Performance Data Server ensure that business intelligence and analytic applications maintain consistent performance and that extraction, transformation and loading processes do not exceed the time available as the amount of your enterprise data continues to grow.

For whom is SAS Scalable Performance Data Server designed? SAS Scalable Performance Data Server is designed for IT managers who are interested in significantly speeding up their business intelligence and analytic applications or shortening extraction, transformation and loading times for their data warehouses, irrespective of the amount of data held across the enterprise.

Key Benefits Significantly speed up the gathering of subset information. SAS Scalable Performance Data Server uses parallel storage technologies and hardware to reduce overhead that is incurred with transactional systems. Optimize performance for business intelligence and analytic applications. By separating the transactional data store from the business intelligence and analytic application data stores, each can be tuned for appropriate task requirements. You get better performance for reporting and analyses while reducing the load on operational systems. Reduce extraction, transformation and loading (ETL) times. An integrated ETL process moves data from transactional systems to the SAS Scalable Performance Data Server, leveraging parallel storage and efficient indexing. This reduces extraction, transformation and load times, allowing data and indexes to be refreshed rapidly, irrespective of data size. Key Features Partitioning and parallel processing. SAS Scalable Performance Data Server speeds the processing of large amounts of data by partitioning the data across multiple disks and I/O channels. It includes parallel Group By enhancements that leverage parallel CPU and I/O paths for certain kinds of summarizations. A WHERE clause planner evaluates the effectiveness of different strategies for query processing and determines the least resource-intensive option. Indexing technology to reduce storage and accelerate queries. A hybrid indexing scheme combines the best features of B-tree and bitmap indexes. The server analyzes each table and determines the best indexing option for each segment of data. You can also concurrently create or refresh multiple indexes that belong to the same table, even while data is loaded. Multiple indexes can be built with a single read of a data table, greatly speeding index creation time. Optimized query performance. SQL Planner optimizations improve performance for the types of queries most often found in business intelligence and analytic applications. SAS Scalable Performance Data Server also improves sorting performance by sorting only appropriate subsets and by creating large single sort bins, reducing the total number of bins needed. Sophisticated management and security. SAS Scalable Performance Data Server includes time-based partitioning, which facilitates loading and removing data from very large tables. 64-bit support enables SAS to allocate and address more than two gigabytes of memory at a time. Security features enable administrators to control read, write and modification access to tables, rows, columns and cells on a per-user or per-group basis. Audit logs enable IT to tune and comply with regulatory obligations. For a complete list of key benefits and features, refer to the SAS Scalable Performance Data Server fact sheet .