Combining SAS BI Analytics & Teradata ADW

The key to getting more power out of your database is to move key components of BI, analytics and data integration processes from the server or desktop to inside the database. This shortens the process to extract intelligence and simplifies data quality control and infrastructure administration.

SAS

SAS has a strong innovative backgound in data transfer, parallel processing and grid computing, new technologies aimed at managing complex computations and to increase the performance and scalability of high-volume data processing.

In most organisations, data volumes are doubling every 15 to 18 months. That reflects the increase in complexity in which organizations are now operating, and in turn, supports the need to be able to rapdily prepare, process and streamline analytics.

Teradata

Teradatas Active Database is the most effificent technology in supporting this process. And now SAS, is also leveraging Teradata database technology to reduce data movement and streamline analytic processes. Their solution is to embed core data transformation, analytic and business intelligence (BI) applications into the enterprise data warehouse engine. By colocating these advanced capabilities within the database environment, data movement is reduced and the computational power in the database engine can be harnessed for analytical exploration and action.

Databases were not initially designed to perform processing hungry analytical queries in the same environment as transactional queries. With todays technological advancedments, databases have become more scalable and parallelized. More like “data grid appliances” that can handle distributed computations across systems. This reconfiguration better supports the heavy CPU demand required for running analyses alongside data transformations.

The benefits of the configuration include:

• Faster response times to business queries
• Reduce costs associated with performing data analyses
• Reduced forcus on the mechanics of accessing and analyzing data, and more on the business

Analytic solutions [claims fraud, risk management, customer up-sell, demand forecasting and parts optimization] deliver faster and more accurate responses direct to the business, reducing the burden on IT.

"Less data movement = faster analytics, and faster analytics = faster delivery of real-time BI throughout an enterprise".

Next: BI Vendor and Market Updates

Back To Top