Vertica by the Hour, Amazon Linux
OpenTextExternal reviews
210 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Very fast and scalable analytical RDBMS.
What do you like best about the product?
Vertica is fast analytical distributed DBMS. This kind of architecture, which enables parallel processing, gives scalability through concurrent loading and querying data while also ensuring data availability in case of node failure. Also, it uses advanced encoding and compression structures which ensure saving storage space - significant feature in the world of data warehouse.
Personally, I consider that the best feature Vertica provide is it's completeness , which gives the user many possibilities through in-database developed funcionallities, and integration with other systems and tools, the different ones regarding loading data as well as the ones using data for analytics.
Personally, I consider that the best feature Vertica provide is it's completeness , which gives the user many possibilities through in-database developed funcionallities, and integration with other systems and tools, the different ones regarding loading data as well as the ones using data for analytics.
What do you dislike about the product?
Regarding of memory consumption during query execution, Vertica requires substantial amount of prior techical knowledge to write memory-optimized queries. This includes knowledge about Vertica specifics, i.e. projections, encoding, resource pools. On the other side, when one improves his technical expertise, Vertica is by far the best choice of analytical database.
What problems is the product solving and how is that benefiting you?
Vertica helped us solved the problem of loading vast amounts of data through ETL tools because it enabled us to create concurrent loading streams thanks to it's distributed architecture.
Also, Vertica in a very easy manner, enables integration not only with ETL tools, but also with visualization or tools regarding streaming data.
Also, Vertica in a very easy manner, enables integration not only with ETL tools, but also with visualization or tools regarding streaming data.
Recommendations to others considering the product:
Vertica is excellent when company has huge amounts of data, concurrent loading streams and extended needs for data visualisation and reporting. When learning more about tehnical concept and structures, one sees all the more possibilities this DBMS offers for the support of various bussiness cases.
Great product!
What do you like best about the product?
Administration and Management, flexible scalability, variety of data types.
What do you dislike about the product?
Nothing comes to mind. It looks very good overall.
What problems is the product solving and how is that benefiting you?
It addresses pretty much all; structured and no-structured data. It has high scalability and all kind of connectors.
Recommendations to others considering the product:
Great product!
Vertica for enterprise data warehouse
What do you like best about the product?
Super fast when queries are optimized. Excellent support.
What do you dislike about the product?
You must take care for lot of details for optimized use.
What problems is the product solving and how is that benefiting you?
We integrated data from various transaction systems and Vertica made it possible on very efficient way. It has very good integration with Informatica Power center as etl tool and with IBM Cognos and Tableau as reporting tools.
Vertica has excellent support and you can always find lot of resources on their web site.
I would recommend for data warehouse database if you have lot of data and many parallel users. It has very good user management for managing database resources across users in organisation. It also allows integration with active directory.
It has lot of embedded analytic functions but if it is needed you can build your own functions using Python or other programming languages.
It is scalable so if your data grows you can easily extent storage and processing power.
Vertica has excellent support and you can always find lot of resources on their web site.
I would recommend for data warehouse database if you have lot of data and many parallel users. It has very good user management for managing database resources across users in organisation. It also allows integration with active directory.
It has lot of embedded analytic functions but if it is needed you can build your own functions using Python or other programming languages.
It is scalable so if your data grows you can easily extent storage and processing power.
Recommendations to others considering the product:
Vertica is one of best analytics databases.
Vertica Big Data
What do you like best about the product?
Vertica is a analytical database 100% ANSI SQL that performs very well for large tables. Data load is incredibly fast and it is very easy to operate.
What do you dislike about the product?
Updates are slow because columnar architecture, but you can replace with delete-insert.
What problems is the product solving and how is that benefiting you?
We use Vertica as traditional Data Warehouse and Big Data experiences.
Great performance, reasonable cost and low maintenance.
What do you like best about the product?
I like the fact that is mostly low maintenance with great performance with a good set of features.
What do you dislike about the product?
At times the designer generated incremental design causes issues.
What problems is the product solving and how is that benefiting you?
We use Vertica for all the reporting and analytics needs. We also use it for some large application queries and it performs reasonably well under a lot of different scenarios.
Recommendations to others considering the product:
Definitely give it a try if you are looking for a good data warehouse that can scale with your business needs. I highly recommend the product.
Best columnar database in the market
What do you like best about the product?
I haven't seen any other database in the marketplace that can beat the performance of Vertica
What do you dislike about the product?
Currently it takes a lots of time to re balance the cluster, when you add or remove a node.
What problems is the product solving and how is that benefiting you?
Big data analytics; That results in better customer satisfaction.
Recommendations to others considering the product:
If you are looking for more scalable version, then use EON mode.
Vertica Rocks
What do you like best about the product?
The ability to optimize for load and query performance.
The community support is unparalleled.
The community support is unparalleled.
What do you dislike about the product?
The default optimizations are mostly useless and don't seem to 'know' the underlying data.
What problems is the product solving and how is that benefiting you?
Speed and scale - plain and simple
I am solving the problem of database as a service for an enterprise application.
I am solving the problem of database as a service for an enterprise application.
Recommendations to others considering the product:
If you are serious about big data, use Vertica
Powerful, efficient, fast SQL Database
What do you like best about the product?
Using and querying Vertica was extremely simple, and easy to learn. Vertica allowed me to visualize datasets in new and interesting ways and, if necessary, apply statistical calculations to my datasets. Vertica allowed our company to scale billions of rows of data easily as well which gave our company the technical infrastructure necessary to grow.
What do you dislike about the product?
Environments to query Vertica required a bit of extra setup and configuration, it was not as turnkey as other SQL databases, and sometimes connections would get lost; however, shelling into Vertica was just as effective if outputting datasets was the core goal.
What problems is the product solving and how is that benefiting you?
Vertica stored almost all the data that our company collected for its clients. I worked with Vertica to obtain any sort of records about my clients and whatever activity we collected for them and used that data for any number of purposes from implementation, QA, and reporting.
Recommendations to others considering the product:
If you will be rebuilding Vertica datasets at any regular cadence, ensure ETL processes are ironclad as data rebuilds across large sets of data can cause significant shifts which can take a long time to complete.
Powerful technology, Query speed
What do you like best about the product?
Query speed, Vertica analyze and respond in a record time New features that have been developed, such as Machine Learning and branching
We initially chose Vertica because of its superior performance and query speed, but we now realize there is so much more we can do. Vertica’s machine learning capabilities will help us analyze network performance, predict capacity constraints, and ensure the best quality service to our customers
We initially chose Vertica because of its superior performance and query speed, but we now realize there is so much more we can do. Vertica’s machine learning capabilities will help us analyze network performance, predict capacity constraints, and ensure the best quality service to our customers
What do you dislike about the product?
So far we have no inconvniniece with the product, this means there is nothing to dislike about
What problems is the product solving and how is that benefiting you?
Vertica delivers drastically improved performance for regulatory compliance and enables an eighty-five percent reduction in fraudrelated costs vs last year
Recommendations to others considering the product:
Ask for a demo (POC) and evaluate the improvements and speed
Scalable, high-speed database on commodity hardware
What do you like best about the product?
The ability to grow a database in either compute or storage with commodity hardware is very valuable. No other database comes to mind for speed of inserts or selects at this scale.
What do you dislike about the product?
The documentation has improved over the years but there is less information than some competitors. There aren't as many users of this database products compared to others so the community is somewhat lacking.
What problems is the product solving and how is that benefiting you?
Vertica solves the problem of storing petabytes worth of data while actually being able to join across datasets in a timely manner. This allows for discoveries that couldn't be made otherwise.
showing 111 - 120