Aster Data expands SQL for map/reduce
June 21, 2010 —
Aster Data has built a business out of map/reduce, and the release today of a thousand new SQL query building blocks—what it calls "functions"—is designed to give business users access to map/reduce computed analytics.
Whereas open-source big data solution Hadoop, for instance, is based entirely on its own implementation of map/reduce, as well as a set of homegrown query structuring frameworks like Pig and Hive, Aster Data wants to use SQL right from the start. Sharmila Shahani-Mulligan, executive vice president of marketing at Aster Data, said that this is a significant advantage over Hadoop.
“Hadoop lends itself more to batch-type processing. Most of our customers are running analytics on a daily basis with the expectation of results returned every few minutes," she said. "It's not real-time, but it's near real-time.
"The second advantage is SQL map/reduce. We are literally targeting the business analyst with SQL using full map/reduce underneath.”
Map/reduce is the framework for processing huge amounts of data, and it is the basis of the Apache Hadoop project, as well as of Big Table, which runs Google's search engine. Using map/reduce, huge stores of data can be processed, and the results can be combined into a cohesive set of information.
Stephanie McReynolds, director of product marketing at Aster Data, said the new sets of query-building tools aren't limited to business users. “We introduced many new business analyst-ready functions," she said. "[These] functions address particular business issues, like path analysis for website traffic.
"We also have a series of packages for power users. These are for people building their own SQL map/reduce applications. They want to use Java or C functions to get ahead. These are smaller building blocks."
Shahani-Mulligan said that Aster Data's analytics can be tweaked and queried by business users, a major advantage over Hadoop. She said that many business users already know SQL, which cannot be said of Hive or Pig. She said that with Hadoop, developers likely need to be called in to implement any analytics batches that need to be run, but with Aster Data, the business users can do that themselves.
“With almost any of our [customers] you talk to, one of the big appeals has been that their existing business analysts can work with functions and don't have to use a new language," said Shahani-Mulligan. "This is why we came out with SQL map/reduce. Some of them also have Hadoop, but it requires you to do constant programming in map/reduce versus having a simple-to-use interface."
Related Search Term(s): Aster Data, SQL
Share this link: http://sdt.bz/34432
Most Read Latest News Blog Resources
Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs
|
|
LEADTOOLS HTML5 add-on modules released
Including New HTML5 Zero Footprint Viewer, JavaScript Libraries and RESTful Web Services for Document and Medical SDKs
|
|
How to speed up your Cukes
Using a five-step process derived from Six Sigma, Cucumber tests can go much faster
|
|
WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products
|
SmartBear rolls out new quality solution: API Complete
Software gives organizations ability to write test scripts and monitor APIs by bridging the DevOps divide
|
|
Android is the focus of two new design tools
Anywhere Software and Xamarin provide ways for developers to create and test their applications on PCs
|
|
WhiteSource offers open-source license management as a service
Software gives companies insight into the open-source components in products
|
|
Top five devices you can integrate with your applications
A five-fingered list of common, household items with which you can talk to (via software, of course)
|
Slick...but who needs it?
compilr.com is a well-designed site and the folks behind it seem to have their heart in the right place. But...who needs it?
|
|
How to be a better software developer
Want to be a better developer? You won't get there by mastering an interesting language or learning a new set of APIs.
|
|
Wooing Galatea
Do yourself a favor and check out Galatea 2.2, a wonderful book by novelist Richard Powers.
|
|
The world as story
An artificial-intelligence system at Carnegie Mellon seeks to understand the world by making statements about it.
|
Five SCM Best Practices
Two-thirds of all software projects fail, according to the Standish Group’s CHAOS study. Improper usage of software configuration management...
|
|
|
Best Practices for Branching and Merging Patterns
Development teams often create a branching pattern, usually drawn out on a white board or in a Visio document, that is used as a model to...
|
|
Automated Error Reporting
We invite you to read a short e-zine that tells you all about automated error reporting for .NET applications. This 8-page e-zine is packed...
|
|
The End of Application Redeploys
Imagine that every time you wanted to write, send or receive an email, you needed to restart your computer. How much time would this take, a...
|