Try our new research platform with insights from 80,000+ expert users

MySQL vs Teradata vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

Open Source Databases
Data Warehouse
Data Warehouse
 

Featured Reviews

Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
RajeshKumar25 - PeerSpot reviewer
Harnessing advanced parallelism for top performance while embracing cloud trends
Teradata is primarily used for data warehousing across all customers. My clients have built-in applications that use Teradata, and their use varies from customer to customer, depending on the industry and database size. The primary function is as an OLAP analytical ecosystem Scalability is…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is pretty simple to use and I don't have anything really bad to say about it."
"It has a lot of features. The RDBMS, consistency, and multi-user features are valuable."
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"The tool is open-source and there is no cost involved in its use."
"The initial setup is easy."
"The product is flexible and easy to use."
"One of the best features is this solution is easy to use."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"It is a stable solution. Stability-wise, I rate the solution a nine out of ten."
"The product is reliable."
"Teradata's most valuable feature is that it's easy to use."
"It has increased the speed of reporting."
"The most valuable feature is the ease of uploading data from multiple sources."
"The most valuable feature of Teradata is the quick processing of large data."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"I like writing preformance queries for preprocessing on AWS Cloud."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Its projections and encoding are excellent tools for tuning large volumes."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"I like the projection feature, which increases query performance."
"The product's initial setup phase is extremely simple."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
 

Cons

"The documentation is pretty weak and should be improved."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres."
"I would like to have features that allow us to jump between the cloud and our on-premises system."
"MySQL has some unique exchange problems when it comes to migration projects."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"I would like to see an improved Knowledge Base on the web."
"Teradata's UI could be more user-friendly."
"​Their level of technical support is adequate. It could be better.​"
"Azure Synapse SQL has evolved from a solely dedicated support tool to a data lake. It can store data from multiple systems, not just traditional database management systems. On the other hand, Teradata has limitations in loading flat files or unstructured data directly into its warehouse. In Azure Synapse SQL, we can implement machine learning using Python scripts. Additionally, Azure Synapse SQL offers advanced analytical capabilities compared to Teradata. Teradata is also expensive."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve the integration and some of the features in the cloud version."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"We faced some challenges when trying to use the temporary tables feature."
 

Pricing and Cost Advice

"There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."
"The tool is open source."
"​Enterprise editions and support are definitely needed for the heavy users who need direct support. ​"
"It has a community version."
"There is no licensing fee."
"The price of the solution is good because we have a good partner."
"It's an open-source database management system that can be used free of charge."
"I am not paying, but I am not sure about the exact licensing requirements."
"​When looking into implementing this product, pricing is the main issue followed by technical expertise​."
"In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace."
"Teradata is not cheap, but you get what you pay for."
"In the past, it turned out that other solutions, in order to provide the full range of abilities that the Teradata platform provides plus the migration costs, would end up costing more than Teradata does."
"Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
"Make sure you have the in-house skills to design and support the solution, as relying on external sources is extremely costly and tends to lock you into specific platforms, tools, and paradigms."
"The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space."
"It comes at a notably high cost for what it offers."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"The price could be cheaper and it is best to negotiate the price."
"Vertica is an expensive tool."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"The price of Vertica is less expensive than some competitors, such as Teradata."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
857,162 professionals have used our research since 2012.
 

Comparison Review

it_user232068 - PeerSpot reviewer
Aug 5, 2015
Netezza vs. Teradata
Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
11%
Manufacturing Company
7%
Government
6%
Financial Services Firm
26%
Computer Software Company
11%
Manufacturing Company
7%
Healthcare Company
7%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If y...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid version...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when ...
Comparing Teradata and Oracle Database, which product do you think is better and why?
I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may d...
Which companies use Teradata and who is it most suitable for?
Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if ...
Is Teradata a difficult solution to work with?
Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if ...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
 

Comparisons

 

Also Known As

No data available
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Netflix
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Firebird, PostgreSQL, Oracle and others in Open Source Databases. Updated: May 2025.
857,162 professionals have used our research since 2012.