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."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"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 paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"Teradata's best feature is its speed with historical data."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"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."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"We don't get good discounts in Pakistan."
"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."
"The user interface needs to be improved."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"The following could be better: licensing, architecture openness, integration with other tools."
"There is some improvement required on OLTP level and some analytical function is missing."
"I would like to see an improved Knowledge Base on the web."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"The current operational approach needs improvement."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
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.