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 Oracle, Sybase, DB2 (on UNIX and PC), ODBC,
SQL Server, and Teradata support this functionality. 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.
SAS In-Database enables high-performance computing for
complex, high-volume analytics. This technology enables certain Base
SAS and
SAS/STAT procedures to run aggregations and analytics inside
the database. In-database technology minimizes the movement of data
across the network, while enabling more sophisticated queries and
producing results more quickly. This technology is available through
the use of the
SAS/ACCESS, SAS Scoring Accelerator, and SAS Analytics
Accelerator products. The supported databases include the following: