SAS FedSQL is a SAS proprietary
implementation of ANSI SQL:1999 core standard. It provides support
for new data types and other ANSI 1999 core compliance features and
proprietary extensions. FedSQL provides a scalable, threaded, high-performance
way to access, manage, and share relational data in multiple data
sources. When possible, FedSQL queries are optimized with multi-threaded
algorithms in order to resolve large-scale operations.
For applications, FedSQL
provides a common SQL syntax across all data sources. That is, FedSQL
is a vendor-neutral SQL dialect that accesses data from various data
sources without having to submit queries in the SQL dialect that is
specific to the data source. In addition, a single FedSQL query can
target data in several data sources and return a single result set.