When using conventional
processing to access data inside an Aster
nCluster database, 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 Aster
nCluster 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 Aster
nCluster
database to the SAS scoring process increases.
The SAS Scoring Accelerator
for Aster
nCluster embeds the
robustness of SAS Enterprise Miner scoring models directly in the
highly scalable Aster
nCluster
database. When you use the SAS In-Database technology and the SAS
Scoring Accelerator for Aster
nCluster, the scoring processing is done inside the database, and
thus does not require the transfer of data.
The SAS
Scoring Accelerator for Aster
nCluster takes the models that are developed by SAS Enterprise Miner
and translates them into scoring files that can be deployed inside
Aster
nCluster. After the scoring
files are published, a SAS SQL/Map Reduce (SQL/MR) function executes
the scoring model.