We just raised a $30M Series A: Read our story

Compare Oracle Database vs. Vertica

Cancel
You must select at least 2 products to compare!
Oracle Database Logo
15,420 views|9,255 comparisons
Vertica Logo
9,589 views|6,802 comparisons
Featured Review
Find out what your peers are saying about Microsoft, Oracle, IBM and others in Relational Databases. Updated: November 2021.
554,676 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The stability has been good so far. It's reliable.""It's very reliable.""Especially with VMs, the solution can scale well.""The pricing is very competitive. Oracle is still the number one database company. From the technical aspects, Oracle Database is the best solution for small, medium, and big industries.""Oracle Database is fast and easy to use.""It's fast compared to other databases.""The solution in my experience has been stable.""It is easy to set up on their engineered systems."

More Oracle Database Pros »

"I have found the solution to be scalable.""It has improved my organization's functionality and performance.""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.""Speed and resiliency are probably the best parts of this product.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""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."

More Vertica Pros »

Cons
"There are SQL plan flips that are happening with version 12c. We would basically like to have the next version wherein we don't see such plan flips because they create performance issues. There are quite a lot of features that I would like to see, but this is the main one for now.""They need to work on non-relational data a bit more. If Oracle Database can support non-relational data streaming, it would be great.""I would like to see more integration with other databases and the cloud as well as Microsoft's Office 365.""They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality.""The licensing could be cheaper and clearer.""The installation of the product could be designed to be simpler.""The initial setup is a bit complex.""Oracle Database could improve by providing access and integration with containers."

More Oracle Database Cons »

"I have found that coding support could be simplified.""They could improve on customer service.""Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.""Support is an area where it could get better.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible.""It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."

More Vertica Cons »

Pricing and Cost Advice
"It is very expensive. Oracle licenses are expensive.""The price of the solution could be reduced.""Oracle is also very expensive.""It was purchased by our client. It might have been a one-time payment. It doesn't seem to be very expensive.""Licensing is on a yearly basis.""Our licensing costs are between $40,000 and $50,000 per year. Those are the costs that cover maintenance and licensing.""We have been paying for an annual enterprise license Oracle Database.""The pricing should be cheaper."

More Oracle Database Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""The price could be cheaper and it is best to negotiate the price.""It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.""The pricing could improve, it is a little expensive.""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."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
554,676 professionals have used our research since 2012.
Questions from the Community
Top Answer: DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
Top Answer: The performance and reliability are the best features of the Oracle Database.
Top Answer: This is quite an expensive product. It's not cheap. We pay a yearly licensing fee to Oracle.
Top Answer: 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… more »
Top Answer: The pricing could improve, it is a little expensive.
Top Answer: Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible. I know that's… more »
Ranking
2nd
Views
15,420
Comparisons
9,255
Reviews
105
Average Words per Review
408
Rating
8.5
3rd
out of 30 in Data Warehouse
Views
9,589
Comparisons
6,802
Reviews
7
Average Words per Review
501
Rating
9.4
Comparisons
Also Known As
Oracle 12c, RDBMS
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn More
Overview

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities for breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in two editions to fit your business needs and budget: Enterprise Edition and Standard Edition 2.

For more information on Oracle RDBMS, visit Oracle.com

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Oracle Database
Learn more about Vertica
Sample Customers
Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Financial Services Firm16%
Computer Software Company15%
Government9%
Comms Service Provider7%
VISITORS READING REVIEWS
Computer Software Company31%
Comms Service Provider18%
Financial Services Firm11%
Government6%
REVIEWERS
Computer Software Company21%
Media Company18%
Marketing Services Firm15%
Comms Service Provider12%
VISITORS READING REVIEWS
Computer Software Company32%
Comms Service Provider19%
Financial Services Firm7%
Media Company5%
Company Size
REVIEWERS
Small Business22%
Midsize Enterprise22%
Large Enterprise56%
REVIEWERS
Small Business31%
Midsize Enterprise25%
Large Enterprise44%
Find out what your peers are saying about Microsoft, Oracle, IBM and others in Relational Databases. Updated: November 2021.
554,676 professionals have used our research since 2012.

Oracle Database is ranked 2nd in Relational Databases with 109 reviews while Vertica is ranked 3rd in Data Warehouse with 10 reviews. Oracle Database is rated 8.4, while Vertica is rated 9.4. The top reviewer of Oracle Database writes "Gets the job done, doesn't fail, and suitable for massively scalable applications". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Oracle Database is most compared with SAP HANA, IBM Db2 Database, SQL Server, MySQL and MariaDB, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Oracle Exadata.

We monitor all Relational Databases 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.