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

Oracle Database Appliance vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Oracle Database Appliance
Ranking in Data Warehouse
8th
Average Rating
8.0
Reviews Sentiment
6.1
Number of Reviews
43
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Data Warehouse
4th
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (7th)
 

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of Oracle Database Appliance is 5.4%, down from 6.5% compared to the previous year. The mindshare of Vertica is 9.3%, up from 9.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

AdnanNaseem - PeerSpot reviewer
Offers built-in utilities and tools that simplify management
Oracle often releases updated versions of Database Appliance with improvements. However, I think Oracle should focus on further automating database management and IT-related tasks, such as backups. They've made progress with daily database stat automation, which is a good feature. Moreover, every product benefits from new functionality over time. I would like to see a centralized terminal where we can easily manage the database and its components with drag-and-drop functionality instead of relying solely on commands. So, I would like to see a centralized dashboard. Other areas of improvement include customer service and support, and scalability.
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

"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The solution's function we use to benefit the customers is database verification."
"The performance due to the all-flash of ODA is very nice."
"The database is solid."
"Oracle Database Appliance provides high stability."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The initial setup was straightforward."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The most valuable feature of Vertica is the unmatchable database performance."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Allows us to take volumes and process them at a very high speed."
"I have found the solution to be scalable."
 

Cons

"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"The setup is a bit complex."
"The tool's setup can be easier."
"They could incorporate a more secure and internet-centric management system for the platform."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"The product's technical support services need improvement."
"It needs integration with multiple clouds."
"I believe the installation process could be streamlined."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"I have found that coding support could be simplified."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"We faced some challenges when trying to use the temporary tables feature."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
 

Pricing and Cost Advice

"The solution's pricing is very high."
"The product is costly."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"The price of the solution should be less expensive. However, they will increase the price more."
"The price should be lower."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."
"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."
"From a cost perspective, the software is less than most of its competitors."
"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."
"The solution is free and we pay for the storage."
"The pricing for this solution is very reasonable compared to other vendors."
"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."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
29%
Computer Software Company
11%
Government
8%
Manufacturing Company
8%
Computer Software Company
18%
Financial Services Firm
18%
Manufacturing Company
8%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
Oracle solutions are a bit overpriced, especially for small or medium businesses. I would prefer a slightly lower price point.
What needs improvement with Oracle Database Appliance?
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP data...
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 compete with other databases.
 

Also Known As

X5-2
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Learn More

 

Overview

 

Sample Customers

LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Oracle Database Appliance vs. Vertica and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.