Data in the SAS Intelligence Platform

Third-Party Data Storage

Data can be stored in a wide range of third-party databases, including the following:

relational databases such as Oracle, Sybase, DB2, SQL Server, and Teradata
hierarchical databases such as IBM Information Management System (IMS)
Computer Associates Integrated Database Management System (CA-IDMS), which is a network model database system

SAS/ACCESS interfaces provide fast, efficient loading of data to and from these facilities. With these interfaces, SAS software can work directly from the data sources without making a copy.

Several of the SAS/ACCESS engines use an input/output (I/O) subsystem that enables applications to read entire blocks of data instead of reading just one record at a time. This feature reduces I/O bottlenecks and enables procedures to read data as fast as they can process it. The SAS/ACCESS engines for the following products support this functionality:

Oracle
Sybase
DB2 (UNIX and PC)
ODBC
SQL Server
Teradata

These engines, as well as the DB2 engine on z/OS, can also access database management system (DBMS) data in parallel by using multiple threads to the parallel DBMS server. Coupling the threaded SAS procedures with these SAS/ACCESS engines provides even greater gains in performance.

Top of Page