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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"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 can automatically reinstall and reconfigure in case of a shutdown."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Teradata's pretty fast."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"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."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"The SQL Assistant is very basic. This tool can be improved for usability."
"I would like to see more integration with many different types of data."
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.