How the SAS Scoring Accelerator for Netezza Works
Using
SAS Enterprise Miner, you can generate SAS DATA step code that contains
scoring functions. The SAS Scoring Accelerator for Netezza takes the
scoring model code, the associated property file that contains model
inputs and outputs, and a catalog of user-defined formats, and deploys,
or publishes, them to the Netezza data warehouse. Inside the Netezza
data warehouse, one or more scoring functions are created and registered
for use in SQL queries. Figure 1.1 illustrates this process.
Process Flow Diagram
1Install the components that are necessary for in-database
processing in the Netezza data warehouse.
For
more information, see Overview of Deployed Components for In-Database Processing.
2Use SAS Enterprise Miner to create a scoring model,
and use the Score Code Export node to export files that are used to
create the scoring functions to a score output directory.
For more information,
see Exporting the Scoring Model Files from SAS Enterprise Miner.
3Start SAS 9.2 and run the SAS publishing macros.
For more information,
see Publishing the Scoring Model Files.
4After the scoring functions are created, they are available
to use in any SQL expression in the same way that Netezza built-in
functions are used.
For more information,
see Scoring Functions Inside the Netezza Data Warehouse.