We performed a comparison between SingleStore and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon, Microsoft, MongoDB and others in Database as a Service."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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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 ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The paramount advantage is the exceptional speed."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"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."
"It would help to make scaling easier with a reduced cost. "
"I would like to see an improved Knowledge Base on the web."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"The user interface needs to be improved."
"It could use some more advanced analytics relating to structured and semi-structured data."
"The SQL Assistant is very basic. This tool can be improved for usability."
"The setup is not straightforward."
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.