SAS/ACCESS Software for Relational Databases: Reference

The SAS/ACCESS Teradata Client

Historically, NCR supplied customers a comprehensive, high-end package: proprietary hardware and an operating system to support the Teradata DBMS. For example, porting Teradata to UNIX, NCR enhanced a UNIX version for Teradata and supplied NCR hardware to support the operating system, providing dedicated connections between the symmetric multiprocessing (SMP) machines.

Because Teradata customers run many processors at the same time for queries of the database, users enjoy excellent DBMS server performance. Such high-level performance challenges client software: a single pipeline, the network connection, must deliver data from a sophisticated, parallel processing server to the client machine.

SAS/ACCESS for Teradata is client software that is optimized to read and process Teradata data. The emphasis of the software is read performance of Teradata rows to support the client's use of SAS as an analysis tool for information that the server stores in Teradata DBMS tables.

For this reason, the Chapter provides information throughout on how to optimize DBMS read operations. SAS/ACCESS also supports creating and updating Teradata tables. However, SAS/ACCESS performance for loads of very large tables does not yet match the performance of FASTLOAD, a native Teradata tool.

Chapter Contents
Previous
Next
Top of Page