When
using conventional processing to access data inside a DBMS, SAS Enterprise
Miner asks the
SAS/ACCESS engine for all rows of the table being processed.
The
SAS/ACCESS engine generates an SQL SELECT * statement that is
passed to the database. That SELECT statement fetches all the rows
in the table, and the
SAS/ACCESS engine returns them to SAS Enterprise
Miner. As the number of rows in the table grows over time, network
latency grows because the amount of data that is fetched from the
database to the SAS scoring process increases.
The SAS Scoring Accelerator
embeds the robustness of SAS Enterprise Miner scoring models directly
in the highly scalable database. By using the SAS In-Database technology
and the SAS Scoring Accelerator, the scoring process is done inside
the database and thus does not require the transfer of data.
The SAS Scoring Accelerator
takes the models that are developed by SAS Enterprise Miner and translates
them into scoring functions that can be deployed inside the database.
After the scoring functions are published, the functions extend the
database’s SQL language and can be used in SQL statements like
other database functions.
The SAS Scoring Accelerator consists of two components:
-
the Score
Code Export node in SAS Enterprise Miner. This extension exports the
model scoring logic (including metadata about the required input and
output variables) from SAS Enterprise Miner.
-
the publishing client
that includes a scoring publishing macro. This macro translates the
scoring model into files that are used inside the database to run
the scoring model. The publishing client then uses the
SAS/ACCESS
Interface to the database to publish the files to the database.