What Is SAS® In-Database Processing?

SAS In-Database technologies use a massively parallel processing (MPP) database architecture for faster execution of key data management and analytic development and deployment tasks. Relevant tasks are moved closer to the data, and computations are run inside the database to avoid time-consuming data movement and conversion.

What Can SAS® In-Database Do for Me?

  • Ensure data governance. Reduce – or even eliminate – the need to replicate or move large amounts of data between a data warehouse and the analytical environment or data marts.
  • Increase IT efficiency and decrease costs. Use your existing infrastructure and resources, which protects your investments and increases operational efficiency, thus yielding a faster time to value and reducing your cost of ownership.
  • Improve model-scoring performance. Eliminate the need to move data between modeling environments and the database for analytic scoring, so you can deploy predictive models – and get results – more quickly.
  • Enhance your analytic teams' productivity. Faster preparation and deployment of analytic models frees resources for new projects or to focus on high-value business problems.

How Is SAS® In-Database Different?

  • In-database options for data management, analytics and business intelligence. SAS leads the industry in offering in-database options for data management, analytics and business intelligence capabilities to provide our customers with faster insights and maximum value.
  • Support for third-party data warehouses and databases. SAS supports in-database analytics on a wide range of third-party data warehouses and databases, including Teradata, EMC Greenplum, IBM DB2, IBM Netezza, Oracle and Aster Data.
  • Streamlined model registration and validation. SAS Model Manager, an analytic model management and deployment environment, is fully integrated with SAS Scoring Accelerator to streamline registration and validation of SAS models inside the database. The solution tracks and monitors model performance so you can decide quickly whether to update, retire or create new models.