May 15, 2010

Further clarifying in-database MPP SAS

My recent post about SAS’ MPP/in-database efforts was based on a discussion in a shared ride to the airport, and was correspondingly rough. SAS’ Shannon Heath was kind enough to write in with clarifications, and to allow me to post same. With permission, I’ve also made trivial grammar edits.

  • Regarding Netezza, SAS Scoring Accelerator for Netezza currently supports Netezza Performance Data Server 4.6.  Support for Netezza TwinFin is slated for July 2010.
  • Regarding the AsterData nCluster, I can understand your confusion on the distinction between Limited Availability (LA) and General Availability (GA). To help clarify, Limited Availability means that the technology is available for pre-qualified customers who are also active SAS Enterprise Miner users. In those cases, the product has been through QA and is available for purchase by those limited pre-qualified customers, and support for a limited number of customer sites is available. When the product becomes Generally Available, all qualifying customers are able to take advantage.
  • Regarding your question of general parallelism/in-database capability, SAS currently is taking advantage of two technologies to provide scalability and performance. The first, SAS In-Database, takes the processing to where the data resides and parallelizes the analytical computations by leveraging the MPP architecture. The second technology, SAS Grid Manager, parallelizes computational steps or subparts of a process across different nodes and bring the results back together.
  • To further expand upon Michelle’s answer to your question “What’s the big deal about in-database data mining scoring anyway?”, hopefully these additional bullets will help:
    • Manually converting the model scoring logic into SQL is difficult and time consuming in several instances. It would result in long hours and higher costs and would require testing and revalidation of the code. It will also restrict modelers to basic linear regression models. Automated model scoring (using SAS Scoring Accelerator) will allow modelers to use complex models like decision trees, neural networks, etc. (i.e. leverage full capabilities of SAS Enterprise Miner). (Note: Since I was comparing specialized in-database scoring to the in-database alternative of writing it all in SQL, this is actually the only one of the three bullets that address my question. 🙂 )
    • Scoring is typically done on a periodic basis – either daily, weekly, monthly or on an event driven basis and many of our customers are scoring large numbers of models against enormous tables. Conventional scoring of SAS models requires connecting to the database server to extract rows to SAS for scoring. The scores are commonly bulk loaded back to the database. 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. SAS Scoring Accelerator reduces the unnecessary data movement and replication for analytic (i.e. model deployment) processing.
    • SAS Scoring Accelerator allows the scoring process to be linearly scalable, completely leveraging the power of the parallel shared-nothing architecture of the database or data warehouse in question.


4 Responses to “Further clarifying in-database MPP SAS”

  1. Clarifying the state of MPP in-database SAS | DBMS2 -- DataBase Management System Services on May 15th, 2010 7:00 am

    […] In response to this post, SAS wrote in with further clarification about in-database and/or MPP SAS. Categories: Analytic technologies, Aster Data, Data warehouse appliances, MapReduce, Netezza, […]

  2. More on Sybase IQ, including Version 15.2 | DBMS2 -- DataBase Management System Services on May 28th, 2010 12:50 am

    […] 16 reminds us that in-database data mining is quite competitive with what SAS has actually delivered with its DBMS partners, even if it doesn’t have the nice architectural approach of Aster or Netezza. (I.e., Sybase […]

  3. Analytic computing systems, aka analytic platforms | DBMS 2 : DataBase Management System Services on March 4th, 2011 5:47 am

    […] currently supported? The obvious choices  are C++ (if that’s the style of execution engine); SAS, R, or other statistical languages; and anything that is commonly associated with MapReduce (Java, […]

  4. Introduction to Continuuity | DBMS 2 : DataBase Management System Services on November 2nd, 2012 6:48 pm

    […] Continuuity’s (current?) application focus is on “closed-loop” customer intelligence apps — I presume in human real-time —  much as might be the case for WibiData (to which Continuuity views itself as potentially complementary rather than competitive). This could include rescoring of predictive models (but of course not remodeling). While we didn’t get into much detail, Todd’s views of the demands there didn’t sound inconsistent with, for example, what might be suggested by SAS. […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.