SAS Brings High Performance Analytics to Database Appliances

By Michael Feldman

April 19, 2011

In early April the SAS Institute (SAS) announced it had integrated its most advanced analytics software into database appliances from EMC Greenplum and Teradata Corporation. The new offerings marry high performance computing to “big data” and are designed to enable users to perform deep analysis on huge datasets hosted on purpose-built, parallel computing platforms.

Today SAS is considered the undisputed leader in advanced analytics — that according to IDC who, in 2009, pegged the company with a 34.7 percent market share in this category. A subset of business analytics, advanced analytics uses compute-intensive data mining and statistical software techniques to extract complex relationships from databases. For SAS, it’s a half a billion dollar business.

Competitors include IBM’s SPSS and lesser-used offerings from Microsoft, TIBCO, Oracle and others. Revolution Analytics, which recently developed an enterprise-capable version of R for statistical analysis, has only 100 or so deployments at this point, but its leverage of the popular open-source R language introduces a new model for advanced analytics users.

At the simplest level, advanced analytics allow you to develop models and then use them to ask “What if?” questions about your data. For example, developing a statistical model that associates buying behavior with customer profiles can then be applied to future behavior of customers. The application of that model is refered to as “scoring” and is the basis for predictive analytics.

That type of analysis is worlds away from traditional business intelligence, which is more about asking simple questions about data in one or two dimensions (e.g., How many shoes of Brand X do we have in stock?). That kind of analysis is fairly straightforward using a traditional database, needing only a small pipe to get the data in and out and a software component on the client to manage the interface.

“Business intelligence got shanghaied during the 1980s to just mean query and reporting,” says SAS CTO Keith Collins. “We are talking about much more than that.”

According to Collins, the high performance analytics SAS has in mind will be a “game changer” for the industry. He says it will do so by addressing both sides of the problem: the increasing size of enterprise datasets — terabytes, scaling to petabytes — and the need to get actionable intelligence from them in a timely manner. Traditionally, the compute- and data-intensive nature of advanced analytics tools has relegated their use to dataset samples, which not only requires extra time and effort, but also introduces inaccuracies associated with working on incomplete data.

The obvious solution is to put the compute next to the data, in this case, on the high performance data platforms themselves, thus eliminating the need to sample. And since these appliances are essentially HPC clusters (with added storage and software needed to house large databases), the CPUs and memory can be used to run the analytics natively. The data prep, model creation and scoring as well as the actual analytics are performed on the appliance servers, and in parallel fashion.

Conveniently, this can be done within the existing SAS language environment. Customers with legacy code can apply those applications to this new high performance environment with the trivial specification of HP (high performance) at the time of invocation. All of this is made possible by the invention of relatively inexpensive database appliances, which, like the HPC industry in general, has moved from SMP architectures to distributed clustered platforms employing commodity parts, Linux, and x86 CPUs.

In the case of Teradata and Greenplum, the basic appliance hardware is very similar, both based on dual-socket 2.93 GHz Westmere Xeon CPUs and outfitted with 48 GB of memory per node. The Teradata platform uses a proprietary system interconnect called BYNET, while the Greenplum machines rely on standard 10Gig Ethernet.

Storage-wise, the Teradata platform sports 1 and 2 TB SATA drives, and can scale from 45 TB on a single server instance up to 186 PB on 4,096 nodes. Alternatively, the company offers a performance version that uses SSD technology and tops out at 24 TB of total capacity.

Greenplum also has capacity and performance models of its appliance, employing both hard drives and SSDs accordingly. In this case, though, the spinning drives are Serial Attached SCSI. In Greenplum’s high capacity configuration, its appliance scales from 31 TB in a quarter rack up to 744 TB in six full racks.

In early April, SAS demonstrated the power of high performance analytics at its Global Forum meeting. In the first case, two racks (16 nodes) of Greenplum’s Data Computing Appliance (DCA) were used to run a logistic regression of bank loan defaults across a database with a billion records, applying just a few variables. The regression was able to complete in less than 80 seconds (as compared to 20 hours for an unspecified serial implementation). Another demonstration, this time on a 24-node Teradata platform, used 1,800 variables applied to 50 million observations. In this case, the analysis finished in 42 seconds.

Not everyone will require this integrated model for high performance, but every use case for advanced analytics is fair game. This includes everything from fraud detection, loan analysis, customer preference tracking, and financial risk scoring, to improving manufacturing yields. The San Antonio Spurs basketball team has even used the technology to “optimize player performance.”

Collins says the early adopters for its high performance analytics offerings will be in the insurance and financial sectors, where the value obtained is easily transferred to the bottom line. Although he wouldn’t name names, SAS already has some number of companies under trial with the technology. General availability for the product on both the Greenplum and Teradata platforms is scheduled for the fourth quarter of 2011.

Subscribe to HPCwire's Weekly Update!

Be the most informed person in the room! Stay ahead of the tech trends with industry updates delivered to you every week!

2024 Winter Classic: Meet Team Morehouse

April 17, 2024

Morehouse College? The university is well-known for their long list of illustrious graduates, the rigor of their academics, and the quality of the instruction. They were one of the first schools to sign up for the Winter Read more…

MLCommons Launches New AI Safety Benchmark Initiative

April 16, 2024

MLCommons, organizer of the popular MLPerf benchmarking exercises (training and inference), is starting a new effort to benchmark AI Safety, one of the most pressing needs and hurdles to widespread AI adoption. The sudde Read more…

Quantinuum Reports 99.9% 2-Qubit Gate Fidelity, Caps Eventful 2 Months

April 16, 2024

March and April have been good months for Quantinuum, which today released a blog announcing the ion trap quantum computer specialist has achieved a 99.9% (three nines) two-qubit gate fidelity on its H1 system. The lates Read more…

Mystery Solved: Intel’s Former HPC Chief Now Running Software Engineering Group 

April 15, 2024

Last year, Jeff McVeigh, Intel's readily available leader of the high-performance computing group, suddenly went silent, with no interviews granted or appearances at press conferences.  It led to questions -- what's Read more…

Exciting Updates From Stanford HAI’s Seventh Annual AI Index Report

April 15, 2024

As the AI revolution marches on, it is vital to continually reassess how this technology is reshaping our world. To that end, researchers at Stanford’s Institute for Human-Centered AI (HAI) put out a yearly report to t Read more…

Crossing the Quantum Threshold: The Path to 10,000 Qubits

April 15, 2024

Editor’s Note: Why do qubit count and quality matter? What’s the difference between physical qubits and logical qubits? Quantum computer vendors toss these terms and numbers around as indicators of the strengths of t Read more…

MLCommons Launches New AI Safety Benchmark Initiative

April 16, 2024

MLCommons, organizer of the popular MLPerf benchmarking exercises (training and inference), is starting a new effort to benchmark AI Safety, one of the most pre Read more…

Exciting Updates From Stanford HAI’s Seventh Annual AI Index Report

April 15, 2024

As the AI revolution marches on, it is vital to continually reassess how this technology is reshaping our world. To that end, researchers at Stanford’s Instit Read more…

Intel’s Vision Advantage: Chips Are Available Off-the-Shelf

April 11, 2024

The chip market is facing a crisis: chip development is now concentrated in the hands of the few. A confluence of events this week reminded us how few chips Read more…

The VC View: Quantonation’s Deep Dive into Funding Quantum Start-ups

April 11, 2024

Yesterday Quantonation — which promotes itself as a one-of-a-kind venture capital (VC) company specializing in quantum science and deep physics  — announce Read more…

Nvidia’s GTC Is the New Intel IDF

April 9, 2024

After many years, Nvidia's GPU Technology Conference (GTC) was back in person and has become the conference for those who care about semiconductors and AI. I Read more…

Google Announces Homegrown ARM-based CPUs 

April 9, 2024

Google sprang a surprise at the ongoing Google Next Cloud conference by introducing its own ARM-based CPU called Axion, which will be offered to customers in it Read more…

Computational Chemistry Needs To Be Sustainable, Too

April 8, 2024

A diverse group of computational chemists is encouraging the research community to embrace a sustainable software ecosystem. That's the message behind a recent Read more…

Hyperion Research: Eleven HPC Predictions for 2024

April 4, 2024

HPCwire is happy to announce a new series with Hyperion Research  - a fact-based market research firm focusing on the HPC market. In addition to providing mark Read more…

Nvidia H100: Are 550,000 GPUs Enough for This Year?

August 17, 2023

The GPU Squeeze continues to place a premium on Nvidia H100 GPUs. In a recent Financial Times article, Nvidia reports that it expects to ship 550,000 of its lat Read more…

Synopsys Eats Ansys: Does HPC Get Indigestion?

February 8, 2024

Recently, it was announced that Synopsys is buying HPC tool developer Ansys. Started in Pittsburgh, Pa., in 1970 as Swanson Analysis Systems, Inc. (SASI) by John Swanson (and eventually renamed), Ansys serves the CAE (Computer Aided Engineering)/multiphysics engineering simulation market. Read more…

Intel’s Server and PC Chip Development Will Blur After 2025

January 15, 2024

Intel's dealing with much more than chip rivals breathing down its neck; it is simultaneously integrating a bevy of new technologies such as chiplets, artificia Read more…

Choosing the Right GPU for LLM Inference and Training

December 11, 2023

Accelerating the training and inference processes of deep learning models is crucial for unleashing their true potential and NVIDIA GPUs have emerged as a game- Read more…

Baidu Exits Quantum, Closely Following Alibaba’s Earlier Move

January 5, 2024

Reuters reported this week that Baidu, China’s giant e-commerce and services provider, is exiting the quantum computing development arena. Reuters reported � Read more…

Comparing NVIDIA A100 and NVIDIA L40S: Which GPU is Ideal for AI and Graphics-Intensive Workloads?

October 30, 2023

With long lead times for the NVIDIA H100 and A100 GPUs, many organizations are looking at the new NVIDIA L40S GPU, which it’s a new GPU optimized for AI and g Read more…

Shutterstock 1179408610

Google Addresses the Mysteries of Its Hypercomputer 

December 28, 2023

When Google launched its Hypercomputer earlier this month (December 2023), the first reaction was, "Say what?" It turns out that the Hypercomputer is Google's t Read more…

AMD MI3000A

How AMD May Get Across the CUDA Moat

October 5, 2023

When discussing GenAI, the term "GPU" almost always enters the conversation and the topic often moves toward performance and access. Interestingly, the word "GPU" is assumed to mean "Nvidia" products. (As an aside, the popular Nvidia hardware used in GenAI are not technically... Read more…

Leading Solution Providers

Contributors

Shutterstock 1606064203

Meta’s Zuckerberg Puts Its AI Future in the Hands of 600,000 GPUs

January 25, 2024

In under two minutes, Meta's CEO, Mark Zuckerberg, laid out the company's AI plans, which included a plan to build an artificial intelligence system with the eq Read more…

DoD Takes a Long View of Quantum Computing

December 19, 2023

Given the large sums tied to expensive weapon systems – think $100-million-plus per F-35 fighter – it’s easy to forget the U.S. Department of Defense is a Read more…

China Is All In on a RISC-V Future

January 8, 2024

The state of RISC-V in China was discussed in a recent report released by the Jamestown Foundation, a Washington, D.C.-based think tank. The report, entitled "E Read more…

Shutterstock 1285747942

AMD’s Horsepower-packed MI300X GPU Beats Nvidia’s Upcoming H200

December 7, 2023

AMD and Nvidia are locked in an AI performance battle – much like the gaming GPU performance clash the companies have waged for decades. AMD has claimed it Read more…

Nvidia’s New Blackwell GPU Can Train AI Models with Trillions of Parameters

March 18, 2024

Nvidia's latest and fastest GPU, codenamed Blackwell, is here and will underpin the company's AI plans this year. The chip offers performance improvements from Read more…

Eyes on the Quantum Prize – D-Wave Says its Time is Now

January 30, 2024

Early quantum computing pioneer D-Wave again asserted – that at least for D-Wave – the commercial quantum era has begun. Speaking at its first in-person Ana Read more…

GenAI Having Major Impact on Data Culture, Survey Says

February 21, 2024

While 2023 was the year of GenAI, the adoption rates for GenAI did not match expectations. Most organizations are continuing to invest in GenAI but are yet to Read more…

Intel’s Xeon General Manager Talks about Server Chips 

January 2, 2024

Intel is talking data-center growth and is done digging graves for its dead enterprise products, including GPUs, storage, and networking products, which fell to Read more…

  • arrow
  • Click Here for More Headlines
  • arrow
HPCwire