Vertica by the Hour, Amazon Linux
OpenText | 24.4.0-0Linux/Unix, Amazon Linux 2023 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Vertica Database is Easy to understand AS RDBMS
What do you like best about the product?
Since it is columnar database, its different from RDBMS and its saving data as column fashion, so while reading data instead of reading row, it will read column and it will be faster while giving less IO on Disk
What do you dislike about the product?
lack of HIgh concurrency, Vertica can improve in with its concurrency transaction.
What problems is the product solving and how is that benefiting you?
since its transaction happen in memory, its way faster than RDBMS DB.
Recommendations to others considering the product:
Since Vertica is the in memory columnar Database, read transaction for milion data fetch will be faster than Other RDBMS DB, mostly people will use this DB for productbase business.
- Leave a Comment |
- Mark review as helpful
My Views on Vertica
What do you like best about the product?
Performance and data reliability along with ease of architecture
What do you dislike about the product?
while using on premise, extending or limiting to size and maintaining cleanups was bit hectic
What problems is the product solving and how is that benefiting you?
analysis and data to information.
aggregates, snowflake architecture
aggregates, snowflake architecture
Recommendations to others considering the product:
If someone wants high performance and much more analytical functions then one should go for vertica
Complete Value for money
What do you like best about the product?
Supports a super fast information retrieval.
What do you dislike about the product?
The GUI is a bit old fashioned. Can be implemented in a good manner.
What problems is the product solving and how is that benefiting you?
Analysis and monitoring of applications.
Fast and Easy to Use
What do you like best about the product?
Query Execution Speed, Best Database for Transaction System
What do you dislike about the product?
Can't Write Store Procedure and Function
What problems is the product solving and how is that benefiting you?
Store huge amount of transactional data in shorts of time. Best benefits is projection
Recommendations to others considering the product:
Add PL/SQL functionality
Database is very optimized easy to use and integrate
What do you like best about the product?
sql queries runs very fast and it will give you very quick results when you are dealing with huge amount of data
What do you dislike about the product?
it does not support stored procedures so we have to write explicit functions in code
What problems is the product solving and how is that benefiting you?
pulling and doing calculations on big amount of data is the very big benefit we are getting
Vertica the high performance DB
What do you like best about the product?
It's performance, scalability and it's ease of use.Its reduced data storage is another great feature. It is IO optimized DB
What do you dislike about the product?
Pricing, supporting procedure would be a good option.Deletion is slower in vertica
What problems is the product solving and how is that benefiting you?
It helped in our huge volume and query performance issue which was a pain in traditional DB
Recommendations to others considering the product:
Please go ahead with vertica as it is one of the best DB for analytics.A POC will help in judging it's advantages
If you have bulk Data to process and heavy processing load then vertica is a good choice.
What do you like best about the product?
we have machine learning and NLP work, I like the most about is I can do much Regular expression and Data cleaning directly in Vertica. We can create our own function which is most helpful thing.
What do you dislike about the product?
For simple crud operation with some joins query could be faster.
What problems is the product solving and how is that benefiting you?
Regular expression at Vertica level I personally used the most for my profesional work. And our team is using it work various machine learning work.
Recommendations to others considering the product:
If you are looking for ETL solution then give a chance to Vertica. Performance is good and maximize performance for work related to big data.
Vertica review
What do you like best about the product?
Columnar access to database. Fetch records fastly then row based
What do you dislike about the product?
Only accessible on servers. Would like to see it in UI.
What problems is the product solving and how is that benefiting you?
Dat files to vertica database and then access to SAS
Vertica as a Analytical DB
What do you like best about the product?
Aggregation works better then traditional rdbms.
What do you dislike about the product?
Architecture is changing frequently. They need to stick to ine perticular architecture.
What problems is the product solving and how is that benefiting you?
Data warehouse and analytical reporting
Recommendations to others considering the product:
If you are very much sure about your use cases and will have very clean data set.
You can proceed with using Vertica
You can proceed with using Vertica
Vertica review
What do you like best about the product?
It's extremely helpful for fast querying on the reporting side involving TBs of data. We had migrated same data to newer streaming dbs which did not perform as well for the large data. It's easy to learn and implement - uncluttered and simple ! System tables are easy to read to understand underlying workings.
What do you dislike about the product?
Tuning is developer centric. Which means performance heavily depends on the developers decisions and knowledge. Conditional Updates not possible for alrge datasets - db crashes
What problems is the product solving and how is that benefiting you?
Sub second performance benchmark are met and nice integration with dashboards
Recommendations to others considering the product:
Awesome for sub second performance for huge datasets.
showing 141 - 150