17 years helping Australian businesses
choose better software
Vertica
What Is Vertica?
Trusted by AT&T, Cerner, Uber, The Trade Desk, and many others, Vertica is the unified analytics warehouse that helps you to capitalize on three major opportunities by unifying HDFS data and object storage data lakes to capitalize on investments and maximize business value; all deployment options to prevent vendor lock-in; and data scientists and business analysts so that they can use their preferred tools while operationalizing Machine Learning at scale for real-time predictive analytics.
Who Uses Vertica?
Any data-driven organization requiring higher performance at scale to address their emerging analytical use cases - from fraud detection to predictive maintenance to customer behavior analytics, more
Not sure about Vertica?
Compare with a popular alternative
Vertica
Other great alternatives to Vertica
Reviews of Vertica
Database Management tool
Pros:
One of the best SQL database management tool. A good solution to store and manage data.
Cons:
I have nothing particular to say against this tool.
Vertica - Fastest MPP database to build data warehouses !
Comments: MPP database to build good enterprise data warehouse.
Pros:
The best MPP database one can get to build analytical data warehouses . The columnar database architecture helps to query the data from the databases very quickly and efficiently . The dimension modeling made easy with Vertica.
Cons:
The GUI of the Vertica interface definitely needs improvement. The node manage can also be done better to perform snowflake architecture querying.
Alternatives Considered:
Smart database management tool
Pros:
The robustness we get by using Vertica over other database management tools is a real game changer. We get stream of high volume data and the data needs to be processed at a rapid rate to keep up with the processes in the pipeline. Here, Vertica delivers on the expectations.
Cons:
While Vertica is robust, there are data size limitations. After a certain threshold, the software breaks! Although we are able to work around and make the floorplans such that this doesn't hamper live processes, but the data size limitations can kick-in.
Alternatives Considered:
Best Analytical Database I have ever used
Comments: I'm using vertical as a analytical dB for twitter sentiment analysis. I have used Flume to get twitter data and use R to move the data from Hadoop to vertica DB and do analytical function and project the data in tableau.
Pros:
Analytical features that is available with this DB. Ease of use with Text User Interface and UI. Deployment is very fast and easy to do. Integration support with almost all top ingress and egress platform like. Apache Kafka, Flume, Hadoop etc. Very efficient and easy to deploy multinode cluster.
Cons:
Nothing I can think of, I was having node health issue alert even when the node was online. I need to upgrade to latest version and hope that issue has been addressed.
light weight platform that works very well
Comments: We were looking for an analytics platform that can work concurrently with hadoop clusters that was focused on performance and could also be inter-changeably used as a data processing engine.
Pros:
It is light weight and nimble but at the same time is good on performance - the fact that it is column store without the real need for indexing makes it easier to get started and then the storage requirement is also much smaller thanks to coding schemas and algorithms.
Cons:
for me, the biggest issue was the fact that it really affects performance when we try to run many large concurrent queries - I wish there was a solution to this. In addition, initial cost of investment to get started on Vertica may discourage SMB's.
