Vertica by the Hour, Red Hat
OpenText | 12.0.4-11Linux/Unix, Red Hat Enterprise Linux 7.5 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Good Analytical Database
What do you like best about the product?
Vertica offers you a very good set of tools to perform analysis on the data.The processing power and the flexibility is one the major points why Vertica is best in class.
What do you dislike about the product?
Historically Vertica has been supported in Enterprise mode, which comes with a lot of limitations. This is being fixed with the introduction of EON mode on public cloud and private infrastructure but the change has been slow. Although we are getting there.
What problems is the product solving and how is that benefiting you?
Ingest and analyze large amount of data. Interface with BI tools to create visualizations of the data and show the value of the solution offered by my company to our customers.
- Leave a Comment |
- Mark review as helpful
Nice DW solution although not the best
What do you like best about the product?
It is a pretty stable Datawarehouse solution and really manageable in some aspects as many other similar solutions it allows for scale of thousands and thousands of records
What do you dislike about the product?
It has a lot of flaws like sometimes queries would take ages if you are not constantly purging your tables (in case you do a lot of deletes over that table) something I haven't experienced in other solutions like Redshift
What problems is the product solving and how is that benefiting you?
A data warehouse of a large-scale reporting data warehouse that provided a centralized data solution for many data consumer applications and principal storage of fact processed information
it was amazing
What do you like best about the product?
Vertica is known for its versatility, speed, and investigation capacities. It is intended to deal with a lot of information and perform complex questions continuously. Vertica likewise has a columnar stockpiling design, which takes into consideration quicker information recovery and pressure.
Vertica upholds a large number of information types, including organized, semi-organized, and unstructured information. It likewise offers worked in AI capacities, permitting clients to perform progressed examination and prescient demonstrating straightforwardly in the data set.
Moreover, Vertica has an easy to understand interface and gives progressed investigation works, for example, geospatial examination, text search, and time-series investigation. In general, Vertica is a strong data set administration framework that is great for information driven associations hoping to dissect a lot of information rapidly and productively.
Vertica upholds a large number of information types, including organized, semi-organized, and unstructured information. It likewise offers worked in AI capacities, permitting clients to perform progressed examination and prescient demonstrating straightforwardly in the data set.
Moreover, Vertica has an easy to understand interface and gives progressed investigation works, for example, geospatial examination, text search, and time-series investigation. In general, Vertica is a strong data set administration framework that is great for information driven associations hoping to dissect a lot of information rapidly and productively.
What do you dislike about the product?
One possible test with Vertica is that it might require particular abilities and information to set up and keep up with. Vertica is a complicated framework that requires cautious preparation and enhancement to accomplish ideal execution. Associations might have to put resources into preparing or recruit particular assets to actually deal with the information base.
Another thought is that Vertica may not be the most ideal decision for associations that don't have huge informational collections or don't demand constant information examination. While Vertica is intended to deal with a lot of information, more modest informational indexes may not legitimize the interest in a particular data set administration framework.
At long last, similar to any innovation, Vertica isn't safe to possible bugs or execution issues. Clients might experience issues with information exactness or inquiry execution, which can require endlessly investigating endeavors to determine.
Generally, while Vertica offers many advantages, clients ought to painstakingly consider their association's particular requirements and assets prior to choosing this data set administration framework.
Another thought is that Vertica may not be the most ideal decision for associations that don't have huge informational collections or don't demand constant information examination. While Vertica is intended to deal with a lot of information, more modest informational indexes may not legitimize the interest in a particular data set administration framework.
At long last, similar to any innovation, Vertica isn't safe to possible bugs or execution issues. Clients might experience issues with information exactness or inquiry execution, which can require endlessly investigating endeavors to determine.
Generally, while Vertica offers many advantages, clients ought to painstakingly consider their association's particular requirements and assets prior to choosing this data set administration framework.
What problems is the product solving and how is that benefiting you?
Business Insight and Examination: Vertica is frequently utilized for information warehousing, business knowledge, and investigation. Its capacity to deal with enormous volumes of organized and unstructured information rapidly and productively makes it an ideal stage for these utilization cases.
Ongoing Information Handling: Vertica's columnar stockpiling design and appropriated engineering go with it an amazing decision for constant information handling, for example, handling and dissecting information produced by IoT gadgets or continuous information streams.
AI: Vertica incorporates worked in AI abilities that empower clients to perform progressed examination and prescient demonstrating straightforwardly inside the data set.
Information Science: Vertica can be utilized for information science undertakings like exploratory information examination, information perception, and factual investigation.
Ongoing Information Handling: Vertica's columnar stockpiling design and appropriated engineering go with it an amazing decision for constant information handling, for example, handling and dissecting information produced by IoT gadgets or continuous information streams.
AI: Vertica incorporates worked in AI abilities that empower clients to perform progressed examination and prescient demonstrating straightforwardly inside the data set.
Information Science: Vertica can be utilized for information science undertakings like exploratory information examination, information perception, and factual investigation.
Use of vertica as a date warehouse
What do you like best about the product?
Very useful functions in vertica and lots of ways to optimize queries. The documentation of vertica is very extensive. Being a columnar database, it's very effective in analytical uses.
What do you dislike about the product?
Sometimes performs poorly because of some builtin features like non existence of nvarchar or varchar2 datatype, no qualify function etc
What problems is the product solving and how is that benefiting you?
Replication of temenos 24 banking application
Vertica is a columnar database management system designed for large-scale data analytics
What do you like best about the product?
if you are having very large data volumes and high-speed data ingestion need for your data lake vertica is best solution.
Vertica uses advanced compression techniques to reduce the amount of storage space needed for data, improving overall efficiency
Vertica uses advanced compression techniques to reduce the amount of storage space needed for data, improving overall efficiency
What do you dislike about the product?
Vertica is optimized for large-scale data analytics, but may not be suitable for smaller data sets or use cases that do not require high performance.
What problems is the product solving and how is that benefiting you?
Vertica is designed to provide fast query performance, even for complex analytics, by using columnar storage and in-memory processing.
All our datalake usecases was solved using vertica.
All our datalake usecases was solved using vertica.
Excellent
What do you like best about the product?
Everything about vertica
It's a very good loved it very much
It's a very good loved it very much
What do you dislike about the product?
Nothing is there to dislike
I mean it's good
I mean it's good
What problems is the product solving and how is that benefiting you?
Big data processing problem it's solving
Speed up with this
What do you like best about the product?
Can perform any type of analytics, in our use-case we use Time Series, Pattern Matching by ingesting data gathering from different data sources available performing parallel processing within a short span of time as it is quick. Either get the work done on-premise or on cloud or a mixture of both would do too. Being in the BigData industry, it supports even Parquet and ORC data formats too which is a small but a useful advantage too.
What do you dislike about the product?
A little difficult to setup when shifting from physical on-prem to cloud infra. Apart from that the Vertica Accelerator if available on other Cloud platforms would be nice as it is only limited to AWS, where organizations using other platforms would not be able to take advantage of it.
What problems is the product solving and how is that benefiting you?
A Data Warehousing solution that mitigates the problem of slow processing with large data, helps in modeling data, driving organizations to carry out good decisions regarding the business at a low cost.
Flexible and scalable
What do you like best about the product?
its ability to process large amounts of data quickly and efficiently, making it an ideal solution for organizations that need to process data in real-time. It provides robust security features, including encryption, access controls, and auditing, to ensure that data is protected and secure.
What do you dislike about the product?
It is complex to install and maintain, which can make it challenging without extensive technical expertise. Vertica can be a relatively expensive solution, especially for organizations with limited budgets.
What problems is the product solving and how is that benefiting you?
Vertica's real-time analytics capabilities can lead to improved business outcomes, such as better-informed decisions, improved operational efficiency, and reduced costs.
Finally an Analytic Database management tool for Enterprise Segment
What do you like best about the product?
The best part about this enterprise Analytical Database management tool is the speed. We literally have more than a thousand million rows of data kept there and it is still the fastest tool I came across. Also, we migrtated from the On-Premise to On-Cloud version of it. Also it supports multiple languages which makes it easy for accessing the data.
What do you dislike about the product?
The only thing I dislike about this tool was the lack of support in migration from On Premise to On Cloud. We had to take help from External consulting team due to the lack of trainings and tutorials available.
What problems is the product solving and how is that benefiting you?
We are keeping the whole customer order data in this tool to analyze the purchasing patterns and devising our Incentive compensation and marketing strategies accordingly. We are also using this for statistical analysis and pattern matching.
Vertica is a very good tool
What do you like best about the product?
Vertica is world's best database management system
What do you dislike about the product?
Nothing is wrong in vertica , no negative
What problems is the product solving and how is that benefiting you?
Vertica works very nice for ETL scripts
showing 1 - 10