We performed a comparison between SingleStore and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), Microsoft, MongoDB and others in Database as a Service."The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"It's very mature from a technology perspective."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"The functionality of the solution is excellent."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"It is a stable program."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"We don't get good discounts in Pakistan."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The SQL Assistant is very basic. This tool can be improved for usability."
"The increasing volumes of data demand more and more performance."
"I would like to see an improved Knowledge Base on the web."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata can improve the way it handles big data and unstructured data."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
SingleStore is ranked 6th in Database as a Service with 7 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. SingleStore is rated 8.8, while Teradata is rated 8.2. The top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". SingleStore is most compared with SQL Server, MySQL, Oracle Database, CockroachDB and Vertica, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery.
We monitor all Database as a Service reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.