Download the Data Warehouse Buyer's Guide including reviews and more. Updated: November 2022
SQL-MapReduce is a framework created by Teradata Aster to allow developers to write powerful and highly expressive SQL-MapReduce functions in languages such as Java, C#, Python, C++, and R and push them into the discovery platform for high performance analytics. Analysts can then invoke SQL-MapReduce functions using standard SQL or R through Aster Database, the first discovery platform that allows applications to be fully embedded within the database engine to enable ultra-fast, deep analysis of massive data sets.
Volvo, eBay, P&G, Verizon, 7Eleven, ABN Amro, Alior Bank, BBVA, Cabela's, Dell, DHL, Gortz, Homebase, IHG
There are two very useful features.
One is the fast data input for more or less any online data. It performs rather well. Two, it also has a lot of tools for data engineering or data manipulation that are compatible.
The solution offers an easy setup.
It's stable and reliable.
The solution like scales just fine.
Some of our clients are looking for on-premise installations as well. Although we don't have any, some of our prospects are also asking, and we are not sure if that part is easily doable or is as effective. We haven't tried on-premises, so we don't know how good it is. We are not confident about proposing on-premise to them, since we are more familiar with the cloud. Maybe some documentation on how on-prem works or what other things to look for in on-premise deployment would be helpful. We'd love to see more tutorials.
Our company does data science and AI machine learning algorithms on the data that is deciding on the Teradata, so that's the value we add. From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing.
I've been using the solution for four or five years.
The solution is very stable, and the performance is good. It's reliable. There are no bugs or glitches. It doesn't crash or freeze.
Our clients do not have very large data sets. So far, the environment has scaled fine, however, once the volumes grow, we will have to see whether we are facing any problems or not. Right now, we don't see any problems. We just haven't tried to scale massively.
We haven't needed much technical support. That said, some of my colleagues have been able to contact them and get service as and when required. It's all right.
Positive
On cloud, it is very easy to set up.
It's moderately priced. It's not cheap. I'd rate it 2.5 out of five in terms of affordability.
I am not knowledgeable about the other vendors to make a meaningful comparison. I haven't really taken the time to evaluate other options.
The solution is most suitable for medium to large-scale businesses.
I'd rate the solution seven out of ten.
I would recommend the solution to others.
