SAS^® In-Database

Customer requirements for understanding and acting on critical business issues – such as fraud detection, credit risk, price optimization, warranty analysis and customer retention – demand efficient handling and utilization of data integration, reporting and analytic components. The scope of analytic computations and the volume and complexity of data and data sources are growing at an unprecedented pace. Enterprises need flexibility to manage the analytical life cycle – from discovery to the execution of large numbers of new and existing analytic models that are designed to address functional and industry-specific business issues in a secure, reliable and scalable manner.

SAS has always believed that analytic workloads are distinctly different from transactional processing. We have been working with relational database management system (RDBMS) vendors for years to help mature their ability to handle mixed workloads. Relational database vendors have slowly gained healthy adoption at the data warehouse layer as their products begin to handle mixed workloads (i.e., analytic queries/workflows and transactional queries), high availability and right-time "refresh" rates.

The goal of this initiative is to offer our customers innovative solutions, delivering better answers faster. SAS will continue to support customers who want to keep up with the development and deployment of analytic functions/workflows outside of the RDBMS. Customers who need to further leverage their investments in mixed-workload RDBMS platforms will benefit from our road map to integrate and run SAS analytic processes within the relational database.

Currently, the best practice for analytic solutions is to build analytic/subject-focused data warehouses. For performance and flexibility, this is often the best choice. However, this sometimes creates challenges, such as:

• Time constraints in moving large volumes of relevant data.
• Management and provisioning of data.
• Proliferation and governance of data.