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

Infobright DB vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Infobright DB
Ranking in Data Warehouse
27th
Average Rating
7.6
Number of Reviews
10
Ranking in other categories
Relational Databases Tools (33rd)
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 Infobright DB is 0.4%, up from 0.1% 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

SD
If you need a real big data solution, look for a distributed solution that actually has a proven track record.
This version of Infobright has zero support for distributed scalability. The internal smart grid employed for each table has a major flaw in that the data size cannot be expunged until 2GB of data is reached at the column-level. This is a major flaw, making usage in a big-data scenario impossible. This means that you can delete as many records from a database table as you want. However, unless the 2GB aggregate size threshold was reached for some of the columns in the table, no reduction in disk space usage will occur. Only the data from the columns that reached 2GB will actually decrease. Other columns below 2GB in size do not leave the disk. I spent countless hours trying to find some workaround for this. I have nightmares of my e-mail inbox full of unsolvable questions about data size reduction from our field engineers.
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 has very amazing smart grid query feature for very fast aggregate queries across millions of rows"
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. ​"
"I like the projection feature, which increases query 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."
"The initial setup was straightforward."
"The most valuable feature is Vertica's performance and the ease of using the database."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
 

Cons

"Only the data from the columns that reached 2GB will actually decrease. Other columns below 2GB in size do not leave the disk."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Suboptimal projection design causes queries to not scale linearly."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"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."
"The documentation of Vertica is an area with shortcomings where improvements are required."
 

Pricing and Cost Advice

"Our pricing was based on server instances and it was actually very cheap compared to Oracle. I guess you get what you pay for."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"Vertica is an expensive tool."
"The solution is free and we pay for the storage."
"Read the fine print carefully."
"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."
"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."
"From a cost perspective, the software is less than most of its competitors."
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
No data available
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

Ask a question
Earn 20 points
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.
 

Comparisons

 

Also Known As

Infobright
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

REZ-1, SonicWALL, IntegriChain, Fuseforward International Inc., Polystar, Live Rail, Mavenir Systems, JDSU Partners, Bango
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Infobright DB vs. Vertica and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.